[teiid-issues] [JBoss JIRA] (TEIID-2916) HIVE2: Teiid didn't translate the SQL correctly for numeric field

[Ramesh Reddy (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-2916?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ramesh Reddy resolved TEIID-2916.
---------------------------------

        Labels: Teiid alpha1  (was: Teiid)
    Resolution: Done


Removed support for data type "decimal", "blob", "object" so that the CAST will not be used with decimal data type if numeric field needs conversion. "double" will be used instead.
                
> 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: Sub-task
>          Components: Misc. Connectors
>    Affects Versions: 8.6
>         Environment: HIVE2 with Teiid
>            Reporter: Ivan Chan
>            Assignee: Ramesh Reddy
>              Labels: Teiid, alpha1
>             Fix For: 8.7.1, 8.8
>
>
> 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