[teiid-issues] [JBoss JIRA] (TEIID-4435) HIVE: decimal datatype is treated like a string

[Steven Hawkins (JIRA)]

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

Steven Hawkins resolved TEIID-4435.
-----------------------------------
    Fix Version/s: 9.1
                   9.0.4
       Resolution: Done


The issue is that the type name is being reported with the precision/scale, which the importer wasn't looking for.

A workaround, and potentially better solution, is to use the import.useDatabaseMetaData option to use the standard JDBC metadata for the import now that the client has matured.

> 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 ',';



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)