Krystal created DRILL-3234: ------------------------------ Summary: 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
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)