We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


NULL value found in a column used by a subquery — Vertica Forum

NULL value found in a column used by a subquery

cidcid Vertica Customer
in General Discussion

Hi,

I have a CREATE TABLE AS SELECT statement. The statement fails with the error:
Caused by: com.vertica.support.exceptions.FeatureNotSupportedException: [Vertica]VJDBC ERROR: NULL value found in a column used by a subquery

If I run the SELECT itself, it runs without problems returning results. I don't know which columns cause the error. There are some checks for null on certain columns.

Any ideas how to debug this issue?

Thanks.

Answers

  • Bryan_HBryan_H Vertica Employee Administrator

    We would probably need the full query to debug the issue as well as Vertica version to check for query parser issues.
    My guess is that the query is parsed differently depending on whether it is standalone or part of CREATE DDL. The EXPLAIN for each SQL may show a difference in parsing that results in a subquery logic similar to the issue from the other thread.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...