NULL value found in a column used by a subquery

cidcid Vertica Customer


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?



  • Options
    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
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file