Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
SQL Error  [0A000]: [Vertica]VJDBC ERROR: operator <> is not supported
edited August 2020 in General Discussion
I'm getting an error
"SQL Error  [0A000]: [Vertica]VJDBC ERROR: Correlated subquery in expression with operator <> is not supported" When I try to execute this statement on Vertenter code hereica, but I can used this stetement on the SQL Server.
SELECT test.ID ,test.Nameenter code here
FROM test inner join test2 f on f.ID = test.ID
WHERE (test.Status IN ('PASS', 'COMPLETED'))
AND ( test.PLANID = 0 or test.ProjectID <> (select a.ProjectID from test a where test.PLANID = a.ID ))
Could anyone suggest me the correct statement?
Leave a Comment
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.
BTW, you're missing parenthesis.
I tried to use "NOT IN", but it return the same error about "NOT IN" is not supported.
Whoops, sorry. Should've paid attention to what your query was trying to do.
Correlated sub-queries (i.e queries that requires data from the outer query) are not supported with
Consider this example: