Jinfeng Ni created DRILL-2250: --------------------------------- Summary: Parquet reader hit ExecutionSetupException when reading decimal columns created using CTAS from another parquet files Key: DRILL-2250 URL: https://issues.apache.org/jira/browse/DRILL-2250 Project: Apache Drill Issue Type: Bug Components: Storage - Parquet, Storage - Writer Reporter: Jinfeng Ni Assignee: Steven Phillips
Not sure if this is related to DRILL-2249, since the error seems to be different. On today's master commit: select commit_id from sys.version; +------------+ | commit_id | +------------+ | 4ed0a8d68ec5ef344fb54ff7c9d857f7f3f153aa | +------------+ If I create a parquet file containing decimal types, using the following CTAS {code} create table my_dec_table as select cast(l_quantity as decimal(10,2)) dec1, cast(l_discount as decimal(10,2)) dec2, cast(l_tax as decimal(10,2)) as dec3 from cp.`tpch/lineitem.parquet` ; +------------+---------------------------+ | Fragment | Number of records written | +------------+---------------------------+ | 0_0 | 60175 | +------------+---------------------------+ 1 row selected (1.71 seconds) {code} Then, if I want to query this new parquet file with : {code} select * from my_dec_table; RemoteRpcException: Failure while running fragment., org.apache.drill.exec.vector.Decimal18Vector cannot be cast to org.apache.drill.exec.vector.BigIntVector [ de164ae4-2d2b-4257-bafb-3ca5165678f9 on 10.250.0.8:31010 ] [ de164ae4-2d2b-4257-bafb-3ca5165678f9 on 10.250.0.8:31010 ] select dec1, dec2, dec3 from my_dec_table; Query failed: RemoteRpcException: Failure while running fragment., org.apache.drill.exec.vector.Decimal18Vector cannot be cast to org.apache.drill.exec.vector.BigIntVector [ 0f5b41c3-1ab3-43b4-9742-cea622d3f476 on 10.250.0.8:31010 ] [ 0f5b41c3-1ab3-43b4-9742-cea622d3f476 on 10.250.0.8:31010 ] {code} parquet-tools shows the following schema information for the generated parquet file: {code} message root { required int64 dec1 (DECIMAL(10,2)); required int64 dec2 (DECIMAL(10,2)); required int64 dec3 (DECIMAL(10,2)); } {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)