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)