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

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.0.0
• Fix Version/s: Future
• Component/s: Storage - Hive
• Assignee: Unassigned
• Reporter: Krystal
• Created: 01/Jun/15 19:09
• Updated: 08/Oct/15 17:54
• Resolved: 08/Oct/15 17:54

Description

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-..

Issue Links

• duplicates: DRILL-3263 Read smallint and tinyint data from hive as integer until these types are well supported throughout Drill
• is duplicated by: DRILL-3263 Read smallint and tinyint data from hive as integer until these types are well supported throughout Drill
• relates to: DRILL-2470 [umbrella] Implement SMALLINT and maybe TINYINT
• relates to: DRILL-2687 TINYINT/SMALLINT's clean not-implemented-yet messages are missing or late for views