hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "xujie (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-16968) MAPJOIN hint error
Date Tue, 27 Jun 2017 01:12:00 GMT
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)

Mime
View raw message