hortonworks/hive-testbench

FAILED: SemanticException [Error 10249]: Line 20:16 Unsupported SubQuery Expression 'cr_order_number': Only 1 SubQuery expression is supported.

gdchaochao opened this issue · 2 comments

gdchaochao commented

query10, query16..
FAILED: SemanticException [Error 10249]: Line 20:16 Unsupported SubQuery Expression 'cr_order_number': Only 1 SubQuery expression is supported.

WookieGao commented

same prob with sample-queries-tpcds/query6.sql

any solutions?

gdchaochao commented

@WookieGao
for hive:
set hive.mapred.mode=nonstrict; set hive.strict.checks.cartesian.product=false;
for spark
set spark.sql.crossJoin.enabled=true;
it work for me