[jira] [Created] (DRILL-3357) Error when adding 2 columns together

["Kathy Qiu (JIRA)" <ji...@apache.org>]

Kathy Qiu created DRILL-3357:
--------------------------------

             Summary: Error when adding 2 columns together
                 Key: DRILL-3357
                 URL: https://issues.apache.org/jira/browse/DRILL-3357
             Project: Apache Drill
          Issue Type: Bug
          Components: Functions - Drill
    Affects Versions: 1.0.0
         Environment: Cloudera 5.4.0 AWS cluster 
            Reporter: Kathy Qiu
            Assignee: Daniel Barclay (Drill)
            Priority: Critical


I created a Parquet table from a PSV file (onln_report_def.tbl) using these commands in Drill:

use dfs.tmp;

alter session set `store.format`='parquet';

create table onln_report_def2_PQ(
report_type_id,                  
platform_id,                    
combinedcapblt_id,          
evt_type_id,          
rslt_type_id,               
category_id,                
evt_multiplier,              
success_multiplier,          
failure_multiplier,          
policy_multiplier,           
evt_rslt_description)
as select columns[0], columns[1], columns[2], columns[3], columns[4], 
columns[5], columns[6], columns[7], columns[8], columns[9], columns[10] 
from dfs.`home/kathy/onln_report_def.tbl`;

Then I used this command to try to select a column called "SumOf2" containing the sum of report_type_id and platform_id:

select (report_type_id+platform_id) as SumOf2 from onln_report_def2_PQ;

This is the error that resulted:

 Error: SYSTEM ERROR: org.apache.drill.exec.exception.SchemaChangeException: Failure while trying to materialize incoming schema.  Errors:

Error in expression at index -1.  Error: Missing function implementation: [castTINYINT(VARCHAR-OPTIONAL)].  Full expression: --UNKNOWN EXPRESSION--.
Error in expression at index -1.  Error: Missing function implementation: [castTINYINT(VARCHAR-OPTIONAL)].  Full expression: --UNKNOWN EXPRESSION--..
Fragment 0:0

Thanks in advance.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)