Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Fixed
-
1.0.0
-
None
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-..
Attachments
Issue Links
- duplicates
-
DRILL-3263 Read smallint and tinyint data from hive as integer until these types are well supported throughout Drill
- Resolved
- is duplicated by
-
DRILL-3263 Read smallint and tinyint data from hive as integer until these types are well supported throughout Drill
- Resolved
- relates to
-
DRILL-2470 [umbrella] Implement SMALLINT and maybe TINYINT
- Open
-
DRILL-2687 TINYINT/SMALLINT's clean not-implemented-yet messages are missing or late for views
- Closed
This bug is a duplicate of
DRILL-3263