Ivan Chan created TEIID-2916: -------------------------------- Summary: HIVE2: Teiid didn't translate the SQL correctly for numeric field Key: TEIID-2916 URL: https://issues.jboss.org/browse/TEIID-2916 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 8.7 Environment: HIVE2 with Teiid Reporter: Ivan Chan Assignee: Steven Hawkins Teiid didn't translate the SQL correctly for numeric field. It uses identifier "decimal" in the SQL which is not supported by the driver. Original Query: select "store_sales", "store_state", "store_country" from "Impala"."sales_new" where "store_sales" between 1.5 and 10 limit 1000 After Translation (Teiid): SELECT g_0.store_sales AS c_0, g_0.store_state AS c_ 1, g_0.store_country AS c_2 FROM sales_new g_0 WHERE cast(g_0.store_sales AS decimal) >= 1.5 AND cast(g_0.store_sales AS decimal) <= 10 LIMIT 1000 "decimal" is not supported identifier in HIVE driver: Encountered: IDENTIFIER Expected: BIGINT, BOOLEAN, DATE, DATETIME, REAL, FLOAT, INTEGER, SMALLINT, STRING, TIMESTAMP, TINYINT -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira