Skip to main content
Question

How to drop the projection in this error case??

  • September 18, 2020
  • 5 replies
  • 9 views

HyeontaeJu
Forum|alt.badge.img+2

The error message is this.
"SQL Error [4455] [55006]: [Vertica]VJDBC ROLLBACK: Projection products_image_DBD_1_rep_wshop_prod_srch2 cannot be dropped because K-safety would be violated
[Vertica][VJDBC]Detail: Current K-safety value = 1"

5 replies

HyeontaeJu
Forum|alt.badge.img+2
  • Author
  • Participating Frequently
  • September 18, 2020

@Hibiki Unfortunately.. In this case, the projection_basename and projection_name is same,,,
Look at this screen shot plz

How to solve this problem? T T


HyeontaeJu
Forum|alt.badge.img+2
  • Author
  • Participating Frequently
  • September 18, 2020

@Hibiki
Yes,, this is text view screen shot

and this is DDL

CREATE PROJECTION products_image_DBD_1_rep_wshop_prod_srch2 /+createtype(D)/
(
product_id ENCODING AUTO
)
AS
SELECT product_id
FROM [schema].products_image
ORDER BY product_id
UNSEGMENTED ALL NODES;

select refresh('newbiz_product_dev.products_image');


HyeontaeJu
Forum|alt.badge.img+2
  • Author
  • Participating Frequently
  • September 18, 2020

@Hibiki
Yeah, I'm trying to drop by specifying the schema name, and I can see the above error message , T _ T
something different thing you and I is I'm trying to refresh the table.


HyeontaeJu
Forum|alt.badge.img+2
  • Author
  • Participating Frequently
  • September 18, 2020

@Hibiki
My version is version
|
-----------------------------------|
Vertica Analytic Database v10.0.0-2|
and DDL send to you


HyeontaeJu
Forum|alt.badge.img+2
  • Author
  • Participating Frequently
  • September 18, 2020

@Hibiki
Oh.. that is working thank you.
Even if you are late, leave a comment if the reason is revealed