[jira] Commented: (HIVE-65) Implict conversion from integer to long broken for Dynamic Serde tables

["Ashish Thusoo (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HIVE-65?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12648230#action_12648230 ] 

Ashish Thusoo commented on HIVE-65:
-----------------------------------

Test case is as follows:

CREATE TABLE implicit_test1(a BIGINT, b STRING) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe' WITH SERDEPROPERTIES('serialization.format'= 'org.apache.hadoop.hive.serde2.thrift.TCTLSeparatedProtocol') STORED AS TEXTFILE;


SELECT implicit_test1.*
FROM implicit_test1
WHERE implicit_test1.a <> 0;


Fails to do implicit conversion in the predicate implicit_test1.a <> 0 

> Implict conversion from integer to long broken for Dynamic Serde tables
> -----------------------------------------------------------------------
>
>                 Key: HIVE-65
>                 URL: https://issues.apache.org/jira/browse/HIVE-65
>             Project: Hadoop Hive
>          Issue Type: Bug
>            Reporter: Ashish Thusoo
>            Assignee: Ashish Thusoo
>
> For a dynamic serde table that has a bigint column, implict conversion from int to bigint seems to be broken. I have not verified this for other tables.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.