[jira] [Closed] (DRILL-3234) Drill fails to implicit cast hive tinyint and smallint data as int

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

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

Krystal closed DRILL-3234.
--------------------------
    Resolution: Fixed

This bug is a duplicate of DRILL-3263

> Drill fails to implicit cast hive tinyint and smallint data as int
> ------------------------------------------------------------------
>
>                 Key: DRILL-3234
>                 URL: https://issues.apache.org/jira/browse/DRILL-3234
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Storage - Hive
>    Affects Versions: 1.0.0
>            Reporter: Krystal
>             Fix For: Future
>
>
> I have the following hive table:
>  describe `hive.default`.voter_hive;
> +----------------+------------+--------------+
> |  COLUMN_NAME   | DATA_TYPE  | IS_NULLABLE  |
> +----------------+------------+--------------+
> | voter_id       | SMALLINT   | YES          |
> | name           | VARCHAR    | YES          |
> | age            | TINYINT    | YES          |
> | registration   | VARCHAR    | YES          |
> | contributions  | DECIMAL    | YES          |
> | voterzone      | INTEGER    | YES          |
> | create_time    | TIMESTAMP  | YES          |
> +----------------+------------+--------------+
> If just include the voter_id and age fields in the select, then the query works fine.  However if I include them in the where clause, the query would fail. For example:
> select voter_id, name, age from voter_hive where age < 30;
> 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: [castINT(TINYINT-OPTIONAL)].  Full expression: --UNKNOWN EXPRESSION--..



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