Diksha created HIVE-27844:
-----------------------------

             Summary: Multi destination queries giving error for Not in 
operators
                 Key: HIVE-27844
                 URL: https://issues.apache.org/jira/browse/HIVE-27844
             Project: Hive
          Issue Type: Bug
            Reporter: Diksha


When a filter operator is added to resolve the Not in bug for when cbo is 
disabled, multi insert queries like :

from t3 b
         * INSERT OVERWRITE TABLE t4
         * select *
         * where b.age not in
         * (select a.age
         * from t3 a
         * )
         * order by age
         * INSERT OVERWRITE TABLE t5
         * select *
         * where b.age in
         * (select c.age
         * from t3 c
         * );

give a runtime error. 

 

 



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to