[ 
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.

Reply via email to