Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

hive-testbench Unsupported SubQuery Expression

hive-testbench Unsupported SubQuery Expression

Explorer

Hi All,

 

Few queries under https://github.com/hortonworks/hive-testbench are resulting in "Unsupported SubQuery Expression" error. 

 

I am using HDP 3.1.5, Hive 3.1.0, Tez 0.9.1, NO LLAP. 

 

0: jdbc:hive2://visa-dn01-hs.cluster.com:2181> source query1.sql;
20/09/22 05:54:41 [main]: WARN conf.HiveConf: HiveConf of name hive.stats.fetch.partition.stats does not exist
20/09/22 05:54:41 [main]: WARN conf.HiveConf: HiveConf of name hive.heapsize does not exist
Error: Error while compiling statement: FAILED: SemanticException Line 0:-1 Unsupported SubQuery Expression 'ctr_store_sk': Only SubQuery expressions that are top level conjuncts are allowed (state=42000,code=40000)
0: jdbc:hive2://visa-dn01-hs.cluster.com:2181> source query10.sql;
20/09/22 05:54:48 [main]: WARN conf.HiveConf: HiveConf of name hive.stats.fetch.partition.stats does not exist
20/09/22 05:54:48 [main]: WARN conf.HiveConf: HiveConf of name hive.heapsize does not exist
Error: Error while compiling statement: FAILED: SemanticException [Error 10249]: Line 28:4 Unsupported SubQuery Expression '3': Only 1 SubQuery expression is supported. (state=42000,code=10249)

Don't have an account?
Coming from Hortonworks? Activate your account here