Hive JOIN中同时遇到左右别名；没有任何不平等条款

星火连营

我正在使用以下查询：
Select
S.MDSE_ITEM_I,
S.CO_LOC_I,
MAX(S.SLS_D) as MAX_SLS_D,
MIN(S.SLS_D) as MIN_SLS_D,
sum(S.SLS_UNIT_Q) as SLS_UNIT_Q,
MIN(PRSMN_VAL_STRT_D) as PRSMN_VAL_STRT_D,
MIN(PRSMN_VAL_END_D) as PRSMN_VAL_END_D,
MIN(RC.FRST_RCPT_D) as FRST_RCPT_D,
MIN(RC.CURR_ACTV_FRST_OH_D) as CURR_ACTV_FRST_OH_D,
MIN(H.GREG_D) as  OH_GREG_D
from
eefe_lstr4.SLS_TBL as S
left outer join
eefe_lstr4.PRS_TBL P
   on S.MDSE_ITEM_I = P.MDSE_ITEM_I
   and S.CO_LOC_I = P.CO_LOC_I
   and S.SLS_D between PRSMN_VAL_STRT_D and PRSMN_VAL_END_D
left outer join
eefe_lstr4.OROW_RCPT RC
   on RC.MDSE_ITEM_I =S.MDSE_ITEM_I
   and RC.CO_LOC_I =  S.CO_LOC_I
left outer join
eefe_lstr4.OH H
   on H.MDSE_ITEM_I =S.MDSE_ITEM_I
   and H.CO_LOC_I = S.CO_LOC_I
group by
S.MDSE_ITEM_I,
S.CO_LOC_I;
我收到错误消息：

+ I: ^/ V1 H3 B; y失败：SemanticException行0：-1在JOIN’PRSMN_VAL_END_D’中同时遇到左右别名% H6 f* n# c- p8 {, ]" U  l7 M

搜索表明，当查询中有不相等子句时，就会出现此错误。但是，即使在出现此错误的情况下，我也没有使用任何不等式子句（=在我的查询（just=和between）中）。

解决方案:


            尝试将不等式条件从on子句移到where条件。
Select S.MDSE_ITEM_I,S.CO_LOC_I,
   MAX(S.SLS_D) as MAX_SLS_D,
   MIN(S.SLS_D) as MIN_SLS_D,
   sum(S.SLS_UNIT_Q) as SLS_UNIT_Q,
   MIN(PRSMN_VAL_STRT_D) as PRSMN_VAL_STRT_D,
   MIN(PRSMN_VAL_END_D) as PRSMN_VAL_END_D,
   MIN(RC.FRST_RCPT_D) as FRST_RCPT_D,
   MIN(RC.CURR_ACTV_FRST_OH_D) as CURR_ACTV_FRST_OH_D,
   MIN(H.GREG_D) as  OH_GREG_D
from eefe_lstr4.SLS_TBL as S
      left outer join eefe_lstr4.PRS_TBL P on S.MDSE_ITEM_I = P.MDSE_ITEM_I and S.CO_LOC_I = P.CO_LOC_I
      left outer join eefe_lstr4.OROW_RCPT RC on RC.MDSE_ITEM_I =S.MDSE_ITEM_I and RC.CO_LOC_I =  S.CO_LOC_I
      left outer join eefe_lstr4.OH H on H.MDSE_ITEM_I =S.MDSE_ITEM_I and H.CO_LOC_I = S.CO_LOC_I
where(S.SLS_D between PRSMN_VAL_STRT_D and PRSMN_VAL_END_D)
group by S.MDSE_ITEM_I, S.CO_LOC_I;

Hive JOIN中同时遇到左右别名；没有任何不平等条款

星火连营 LV1