[jira] [Created] (DRILL-2250) Parquet reader hit ExecutionSetupException when reading decimal columns created using CTAS from another parquet files

["Jinfeng Ni (JIRA)" <ji...@apache.org>]

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)