Vertica does not enforce PK while loading to enable fast data loads. you have to manually check for PK violations. Use this functions to check for violations. https://my.vertica.com/docs/7.2.x/HTML/index.htm#Authoring/SQLReferenceManual/Functions/VerticaFunctions/ANALYZE_CONSTRAINTS.htm?Highlight=an...

I think this dbvis tool takes :: to be a variable and pops up a window. When i "continue", it gives an error. So annoying!

[SELECT - 0 row(s), 0.009 secs] [Error Code: 4856, SQL State: 42601] [Vertica][VJDBC](4856) ERROR: Syntax error at or near "$1"

This problem occurs when I run the code in DBVisualizer. ON VSQL it runs fine.

I would like to initialize a column to NULL in select statement.

E.g.

Select
column1,
NULL :: timestamp as test_column,
NULL :: int as s_no,
column 2
from tablename;

Error: Syntax error at or near "$1"

How should I overcome this?

I have a tab delimited file and one of columns has data ending with \, which I believe is cause the data to be rejected.
1234 lodestone&text=\LOHDstohn\ Agency

How should I overcome this?

Name
ABC,12
Present"X"

Lets say I have these 2 data in the column. If I Enclosed it by ' " ' then my second record is rejected. If I don't do anything (file is csv) then my first record gets rejected.

I have a column in my data which has both , as well as ".

E.g. Abc,"xyz"

so I'm not able to load.

Enclosed by '"' isn't helping. How can I overcome this?