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

Wrong results returned performing outer join on two LZO compressed text tables

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • Impala 0.7
    • Impala 0.7
    • None

    Description

      It appears the second column is getting truncated. This doesn't happen when performing other join types:

      impala-shell -i localhost -q "use functional_text_lzo; select j.*, d.* from JoinTbl j full outer join DimTbl d on (j.test_id=d.id) where j.test_id=1001
      1001	e1	94611	5000	1001	Name1	94611
      
      impala-shell -i localhost -q "use functional_seq_snap; select j.*, d.* from JoinTbl j full outer join DimTbl d on (j.test_id=d.id) where j.test_id=1001
      1001	Name1	94611	5000	1001	Name1	94611
      

      Attachments

        Activity

          People

            nong_impala_60e1 Nong Li
            lskuff Lenni Kuff
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: