NULL value found in a column used by a subquery
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?