[
https://issues.apache.org/jira/browse/HIVE-19601?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
slim bouguerra updated HIVE-19601:
----------------------------------
Summary: Unsupported Post join function 'IS NOT DISTINCT FROM' (was:
Unsupported Post join function)
> Unsupported Post join function 'IS NOT DISTINCT FROM'
> ------------------------------------------------------
>
> Key: HIVE-19601
> URL: https://issues.apache.org/jira/browse/HIVE-19601
> Project: Hive
> Issue Type: Sub-task
> Reporter: slim bouguerra
> Priority: Major
>
> h1. As part of trying to use the Calcite rule {code}
> org.apache.calcite.rel.rules.AggregateExpandDistinctAggregatesRule#JOIN {code}
> i got the following Calcite plan
> {code}
> 2018-05-17T09:26:02,781 DEBUG [80d6d405-ed78-4f60-bd93-b3e08e424f73 main]
> translator.PlanModifierForASTConv: Final plan after modifier
> HiveProject(_c0=[$1], _c1=[$2])
> HiveProject(zone=[$0], $f1=[$1], $f2=[$3])
> HiveJoin(condition=[IS NOT DISTINCT FROM($0, $2)], joinType=[inner],
> algorithm=[none], cost=[not available])
> HiveProject(zone=[$0], $f1=[$1])
> HiveAggregate(group=[{0}], agg#0=[count($1)])
> HiveProject(zone=[$0], interval_marker=[$1])
> HiveAggregate(group=[{0, 1}])
> HiveProject(zone=[$3], interval_marker=[$1])
> HiveTableScan(table=[[druid_test_dst.test_base_table]],
> table:alias=[test_base_table])
> HiveProject(zone=[$0], $f1=[$1])
> HiveAggregate(group=[{0}], agg#0=[count($1)])
> HiveProject(zone=[$0], dim=[$1])
> HiveAggregate(group=[{0, 1}])
> HiveProject(zone=[$3], dim=[$4])
> HiveTableScan(table=[[druid_test_dst.test_base_table]],
> table:alias=[test_base_table])
> {code}
> I run into this issue
> {code}
> 2018-05-17T09:26:02,876 ERROR [80d6d405-ed78-4f60-bd93-b3e08e424f73 main]
> parse.CalcitePlanner: CBO failed, skipping CBO.
> org.apache.hadoop.hive.ql.parse.SemanticException: Line 0:-1 Invalid function
> 'IS NOT DISTINCT FROM'
> at
> org.apache.hadoop.hive.ql.parse.TypeCheckProcFactory$DefaultExprProcessor.getXpathOrFuncExprNodeDesc(TypeCheckProcFactory.java:1069)
> ~[hive-exec-3.1.0-SNAPSHOT.jar:3.1.0-SNAPSHOT]
> at
> org.apache.hadoop.hive.ql.parse.TypeCheckProcFactory$DefaultExprProcessor.process(TypeCheckProcFactory.java:1464)
> ~[hive-exec-3.1.0-SNAPSHOT.jar:3.1.0-SNAPSHOT]
> at
> org.apache.hadoop.hive.ql.lib.DefaultRuleDispatcher.dispatch(DefaultRuleDispatcher.java:90)
> ~[hive-exec-3.1.0-SNAPSHOT.jar:3.1.0-SNAPSHOT]
> at
> org.apache.hadoop.hive.ql.lib.DefaultGraphWalker.dispatchAndReturn(DefaultGraphWalker.java:105)
> ~[hive-exec-3.1.0-SNAPSHOT.jar:3.1.0-SNAPSHOT]
> {code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
