[
https://issues.apache.org/jira/browse/DRILL-3234?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Venki Korukanti updated DRILL-3234:
-----------------------------------
Fix Version/s: (was: 1.2.0)
Future
> 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
> Assignee: Venki Korukanti
> 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)
