INNER JOIN DEFAULT.ZSJ_DIM_NY as null

25 views
Skip to first unread message

Kaine

unread,
Mar 16, 2015, 7:18:07 PM3/16/15
to kylin...@googlegroups.com
为什么table会被as成null，多个表同时join的话就会出错
INSERT OVERWRITE TABLE kylin_intermediate_ZSJ_19700101000000_2922789940817071255_96c192af_6191_4a13_b827_02c9d5eb1a7d SELECT
FACT_TABLE.QKDYDM
,FACT_TABLE.NY
FROM DEFAULT.ZSJ_FACT_YT as FACT_TABLE 
INNER JOIN DEFAULT.ZSJ_DIM_NY as null
ON FACT_TABLE.NY = null.YEARMONTH
INNER JOIN DEFAULT.ZSJ_DIM_ORG as null
ON FACT_TABLE.QKDYDM = null.YTDM
Reply all
Reply to author
Forward
0 new messages