[IMPALA-1007] Cannot read metadata of a decimal partitioned table if a partition has data

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: Impala 1.4
• Fix Version/s: Impala 1.4
• Labels: decimal
• Assignee: Nong Li
• Reporter: Ishaan Joshi
• Created: 20/May/14 23:00
• Updated: 20/Dec/15 00:05
• Resolved: 01/Jun/14 02:48

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