[DRILL-2338] DECIMAL 38 when stored as a required datatype results in wrong data

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.8.0
• Fix Version/s: 0.8.0
• Component/s: Storage - Parquet
• Assignee: Mehant Baid
• Reporter: Ramana Inukonda Nagaraj
• Created: 27/Feb/15 19:55
• Updated: 05/Mar/15 20:30
• Resolved: 02/Mar/15 20:29

Description

Writing out a decimal 38 column by casting a literal results in a different value being written out.

0: jdbc:drill:> create table mehant_bug as select cast('1.2' as decimal(38,2)) from cp.`employee.json` limit 1;

0: jdbc:drill:> select * from mehant_bug;
+------------+
|   EXPR$0   |
+------------+
| 12000000.00 |
+------------+
1 row selected (0.08 seconds)

[root@perfnode167 impala_parquet]# parquet-tools-1.5.1-SNAPSHOT/parquet-schema ../mehant_bug/0_0_0.parquet
message root {
required fixed_len_byte_array(16) EXPR$0 (DECIMAL(38,2));
}

If the column is stored as optional we do not have this issue.

Issue Links

• duplicates: DRILL-2300 problems reading DECIMAL from parquet file