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

Wrong results when DECIMAL is used as a partition key on an HDFS table

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Blocker
    • Resolution: Fixed
    • Impala 1.4
    • Impala 1.4
    • None

    Description

      We get wrong results when we query an HDFS table that has a DECIMAL partition key.

      To reproduce:
      create external table test(id int, dec decimal(5,4)) partitioned by(decimal_col DECIMAL(5,4)) row format delimited fields terminated by ',';
      insert into test partition(decimal_col=4.34) values (1, 3.14);
      select * from test;
      Query: select * from test
      ---------------------

      id dec decimal_col

      ---------------------

      1 3.1400 43400.0000

      ---------------------

      Attachments

        Activity

          People

            nong_impala_60e1 Nong Li
            dtsirogiannis Dimitris Tsirogiannis
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: