You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Daniel Barclay (Drill) (JIRA)" <ji...@apache.org> on 2015/06/24 22:47:04 UTC
[jira] [Updated] (DRILL-3357) Error when adding 2 columns together
[ https://issues.apache.org/jira/browse/DRILL-3357?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Daniel Barclay (Drill) updated DRILL-3357:
------------------------------------------
Assignee: Jinfeng Ni (was: Daniel Barclay (Drill))
> 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
>
> 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)