xujie created HIVE-16968:
----------------------------
Summary: MAPJOIN hint error
Key: HIVE-16968
URL: https://issues.apache.org/jira/browse/HIVE-16968
Project: Hive
Issue Type: Bug
Components: hpl/sql
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)
