[
https://issues.apache.org/jira/browse/IMPALA-5645?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Alexander Behm resolved IMPALA-5645.
------------------------------------
Resolution: Duplicate
> AnalysisException when join on clause contains subquery
> -------------------------------------------------------
>
> Key: IMPALA-5645
> URL: https://issues.apache.org/jira/browse/IMPALA-5645
> Project: IMPALA
> Issue Type: Bug
> Components: Frontend
> Affects Versions: Impala 2.9.0
> Reporter: yyzzjj
> Priority: Minor
> Labels: sql-language
>
> throw null exception
> SELECT a.sku_id FROM ( SELECT spu_id, sku_id FROM promo_sku_price_history mj
> INNER JOIN [ broadcast ] cates_whrite c ON mj.cate3_id = c.cate3_id and ts
> IN ( SELECT ts FROM prom_mid_table_ts WHERE if_self IN (0, 1))) a
> which report parse SQL error
> next SQL can work：
> SELECT a.sku_id FROM ( SELECT spu_id, sku_id FROM promo_sku_price_history mj
> INNER JOIN [ broadcast ] cates_whrite c ON mj.cate3_id = c.cate3_id where ts
> IN ( SELECT ts FROM prom_mid_table_ts WHERE if_self IN (0, 1))) a
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
