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

Left outer join with partitioned large table and small table returns empty result.

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.9.0
    • Component/s: None
    • Labels:
      None

      Description

      Left outer join with a small table and a large partitioned table which not matched any partition path returns empty result .

      If there is no partitioned path with l_orderkey = 1000 in the lineitem_large, the following query should return all records which lineitem_small table has but return empty record.

      select a.l_orderkey as key1, b.l_orderkey as key2 
      from lineitem_small as a 
      left outer join lineitem_large as b
      on a.l_partkey = b.l_partkey and b.l_orderkey = 1000
      

        Attachments

          Activity

            People

            • Assignee:
              hjkim Hyoungjun Kim
              Reporter:
              hjkim Hyoungjun Kim
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: