drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jacques Nadeau (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (DRILL-3357) Error when adding 2 columns together
Date Wed, 01 Jul 2015 01:05:04 GMT

     [ https://issues.apache.org/jira/browse/DRILL-3357?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Jacques Nadeau resolved DRILL-3357.
-----------------------------------
    Resolution: Fixed

> 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: Jinfeng Ni
>            Priority: Critical
>             Fix For: 1.1.0
>
>
> 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)

Mime
View raw message