HIVE: decimal datatype is treated like a string ------------------------------------------------ Key: TEIID-4435 URL: https://issues.jboss.org/browse/TEIID-4435 Project: Teiid Issue Type: Bug Components: Misc. Connectors Affects Versions: 8.12.3 Environment: Connecting through HIVE Reporter: Ivan Chan Assignee: Steven Hawkins Fix For: 9.1, 9.0.4 Teiid maps Decimal column (DECIMAL(9,4)) to "java.lang.String" when using org.teiid.translator.hive.HiveExecutionFactory. I would expect it to map to "java.math.BigDecimal" or something else. Here is my table: CREATE TABLE tableWithAllTypes(column_bigint BIGINT, column_boolean BOOLEAN, column_char CHAR(1), column_decimal DECIMAL(9,4), column_double DOUBLE, column_float FLOAT, column_int INT, column_smallint SMALLINT, column_string STRING, column_timestamp TIMESTAMP, column_tinyint TINYINT, column_varchar VARCHAR(64)) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',';