hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dmitry Tolpeko (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-16968) MAPJOIN hint error
Date Tue, 29 Aug 2017 17:42:00 GMT

     [ 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)

Mime
View raw message