The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

vsql returns error on using with statement

hananshanans
edited March 2019 in General Discussion

query starts like :

with campaigns as (QUERY1),
campaign_sample as (QUERY2)
QUERY3

running vsql on the query gets:

vsql:generate_data.sql:54: ERROR 4566:  Relation "campaign_sample" does not exist

running the same sql file from intellij datagrip works (not from the vsql command line)

Comments

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file