Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-5645

AnalysisException when join on clause contains subquery

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Minor
    • Resolution: Duplicate
    • Impala 2.9.0
    • None
    • Frontend
    • ghx-label-5

    Description

      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

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              zzjj yyzzjj
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: