Uploaded image for project: 'Tajo'
  1. Tajo
  2. TAJO-625

HiveQLAnalyzer can't support complex join conditions.

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Won't Fix
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: SQL Parser
    • Labels:
      None

      Description

      Current HiveQLAnalyzer can't pass one of join unit cases. The test query is as follows:

      select s_acctbal, s_name, n_name, p_partkey, p_mfgr, s_address, s_phone, s_comment, ps_supplycost
        from region join nation on n_regionkey = r_regionkey and r_name = 'EUROPE'
        join supplier on s_nationekey = n_nationkey
        join partsupp on s_suppkey = ps_ps_suppkey
        join part on p_partkey = ps_partkey and p_type like '%BRASS' and p_size = 15
      

        Attachments

          Activity

            People

            • Assignee:
              blrunner JaeHwa Jung
              Reporter:
              blrunner JaeHwa Jung
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: