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

Cannot read metadata of a decimal partitioned table if a partition has data

    XMLWordPrintableJSON

Details

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

    Description

      I came across this while trying to extend partition functional tests.

      [localhost:21000] > create table foo (i int) partitioned by (d Decimal);
      Query: create table foo (i int) partitioned by (d Decimal)
      
      Returned 0 row(s) in 0.09s
      [localhost:21000] > describe foo;
      Query: describe foo
      +------+--------------+---------+
      | name | type         | comment |
      +------+--------------+---------+
      | i    | int          |         |
      | d    | decimal(9,0) |         |
      +------+--------------+---------+
      Returned 2 row(s) in 1.23s
      [localhost:21000] > insert into table foo partition(d=1) select 1;
      Query: insert into table foo partition(d=1) select 1
      Inserted 1 rows in 0.43s
      [localhost:21000] > describe foo;
      Query: describe foo
      ERROR: AnalysisException: Failed to load metadata for table: default.foo
      CAUSED BY: TableLoadingException: Failed to load metadata for table: foo
      CAUSED BY: InvalidStorageDescriptorException: DATE/DATETIME/TIMESTAMP/DECIMAL literals not supported: 1
      CAUSED BY: AnalysisException: DATE/DATETIME/TIMESTAMP/DECIMAL literals not supported: 1
      

      Attachments

        Activity

          People

            nong_impala_60e1 Nong Li
            ishaan Ishaan Joshi
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: