[
https://issues.apache.org/jira/browse/HIVE-16968?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Dmitry Tolpeko updated HIVE-16968:
----------------------------------
Component/s: (was: hpl/sql)
> MAPJOIN hint error
> ------------------
>
> Key: HIVE-16968
> URL: https://issues.apache.org/jira/browse/HIVE-16968
> Project: Hive
> Issue Type: Bug
> Affects Versions: 1.1.0
> Reporter: xujie
>
> set hive.auto.convert.join=false;
> set hive.ignore.mapjoin.hint=false;
> WITH TEMP_CUST_BAL
> AS
> (
> SELECT /*+ MAPJOIN(C) */ FROM FACT_RPSM.F_AGT_INFO_ALL B0
> LEFT JOIN FACT_RPSM.F_AGT_INFO_BAL_AVG A ON B0.JIZH_ID = a.JIZH_ID
> AND A.DT='20170625'
> LEFT JOIN BASE.B_IF_PROD_DIM C
> ON B0.PROD_ID = C.PROD_ID
> AND C.DT='20170625'
> WHERE B0.DT='20170625'
> GROUP BY B0.CUST_ID;
> -------------------------------------------------
> Your query has the following error(s):
> Invalid OperationHandle: OperationHandle [opType=EXECUTE_STATEMENT,
> getHandleIdentifier()=7300a9f1-d6cf-418b-aa59-59a7688fa74e]
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
