[
https://issues.apache.org/jira/browse/HIVE-1271?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12879962#action_12879962
]
HBase Review Board commented on HIVE-1271:
------------------------------------------
Message from: "Carl Steinbach" <c...@cloudera.com>
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
http://review.hbase.org/r/200/
-----------------------------------------------------------
Review request for Hive Developers.
Summary
-------
Review for
https://issues.apache.org/jira/secure/attachment/12440030/HIVE-1271-1.patch
This addresses bug HIVE-1271.
http://issues.apache.org/jira/browse/HIVE-1271
Diffs
-----
serde/src/java/org/apache/hadoop/hive/serde2/typeinfo/ListTypeInfo.java
cb2fa57
serde/src/java/org/apache/hadoop/hive/serde2/typeinfo/MapTypeInfo.java
a426e74
serde/src/java/org/apache/hadoop/hive/serde2/typeinfo/PrimitiveTypeInfo.java
3d1c68e
serde/src/java/org/apache/hadoop/hive/serde2/typeinfo/StructTypeInfo.java
87179aa
serde/src/java/org/apache/hadoop/hive/serde2/typeinfo/TypeInfo.java 0344718
serde/src/java/org/apache/hadoop/hive/serde2/typeinfo/package-info.java
PRE-CREATION
Diff: http://review.hbase.org/r/200/diff
Testing
-------
Thanks,
Carl
> Case sensitiveness of type information specified when using custom reducer
> causes type mismatch
> -----------------------------------------------------------------------------------------------
>
> Key: HIVE-1271
> URL: https://issues.apache.org/jira/browse/HIVE-1271
> Project: Hadoop Hive
> Issue Type: Bug
> Components: Query Processor
> Affects Versions: 0.5.0
> Reporter: Dilip Joseph
> Assignee: Arvind Prabhakar
> Fix For: 0.6.0
>
> Attachments: HIVE-1271-1.patch, HIVE-1271.patch
>
>
> Type information specified while using a custom reduce script is converted
> to lower case, and causes type mismatch during query semantic analysis . The
> following REDUCE query where field name = "userId" failed.
> hive> CREATE TABLE SS (
> > a INT,
> > b INT,
> > vals ARRAY<STRUCT<userId:INT, y:STRING>>
> > );
> OK
> hive> FROM (select * from srcTable DISTRIBUTE BY id SORT BY id) s
> > INSERT OVERWRITE TABLE SS
> > REDUCE *
> > USING 'myreduce.py'
> > AS
> > (a INT,
> > b INT,
> > vals ARRAY<STRUCT<userId:INT, y:STRING>>
> > )
> > ;
> FAILED: Error in semantic analysis: line 2:27 Cannot insert into
> target table because column number/types are different SS: Cannot
> convert column 2 from array<struct<userId:int,y:string>> to
> array<struct<userid:int,y:string>>.
> The same query worked fine after changing "userId" to "userid".
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
