[HIVE-18891] I am trying to write a basic query in hive and it is giving me error

• Type: Bug
• Status: Resolved
• Priority: Trivial
• Resolution: Fixed
• Affects Version/s: 1.2.1
• Assignee: Unassigned
• Reporter: Amit Chauhan
• Created: 07/Mar/18 06:18
• Updated: 01/May/18 05:37
• Resolved: 01/May/18 05:37

Description

Query : 

explain select * from Table1 WHERE COALESCE(Col1, 'abc') in ( SELect col2 FROM Table2) or col2 LIKE 'abc';
FAILED: SemanticException [Error 10249]: Line 1:97 Unsupported SubQuery Expression ''abc'': Only SubQuery expressions that are top level conjuncts are allowed.

 

 if i am running query in standalone like the 2 ways mentioned below they are running:

hive> explain select * from Table1 WHERE COALESCE(Col1, 'abc') in ( SELect col2 FROM Table2)
OK

hive> explain select * from Table1 WHERE col2 LIKE 'abc';
OK

can you please help why the query with both conditions is not running. 

 

hiver version is :

hive> !hive --version;
Hive 1.2.1000.2.5.6.0-40