The following query works in Oracle, but I get an error in Vertica:
Code: Select all
dbadmin=> SELECT sd1.id,
dbadmin-> sd1.effective_time,
dbadmin-> sd1.active,
dbadmin-> sd1.module_id,
dbadmin-> (SELECT sd2.term
dbadmin(> FROM file_description sd2
dbadmin(> WHERE sd1.concept_id = sd1.module_id) module_description
dbadmin-> FROM file_description sd1;
ERROR 2784: Correlated subquery could not be flattened as a join