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

Gunther Hagleitner commented on HIVE-2693:
------------------------------------------

Ordering: The stripTrailingZeros() does not change the value of the BigDecimal 
and therefore doesn't change the serialized output. I don't think this is the 
culprit. The order of the output depends on what hadoop does in the 
shuffle/sort phase. My guess is that since you changed the input the results 
that mapred came up with where different. Hadoop doesn't guarantee stable sort 
afaik.

Where clause: Yes, it's one and the same problem. We end up comparing 3.14 with 
3.140000...1243... Still debugging but it seems we're going through double on 
the way to BigDecimal which changes the number.
                
> Add DECIMAL data type
> ---------------------
>
>                 Key: HIVE-2693
>                 URL: https://issues.apache.org/jira/browse/HIVE-2693
>             Project: Hive
>          Issue Type: New Feature
>          Components: Query Processor, Types
>    Affects Versions: 0.10.0
>            Reporter: Carl Steinbach
>            Assignee: Prasad Mujumdar
>         Attachments: 2693_7.patch, 2693_8.patch, 2693_fix_all_tests1.patch, 
> HIVE-2693-10.patch, HIVE-2693-11.patch, HIVE-2693-12-SortableSerDe.patch, 
> HIVE-2693-13.patch, HIVE-2693-1.patch.txt, HIVE-2693-all.patch, 
> HIVE-2693-fix.patch, HIVE-2693.patch, HIVE-2693-take3.patch, 
> HIVE-2693-take4.patch
>
>
> Add support for the DECIMAL data type. HIVE-2272 (TIMESTAMP) provides a nice 
> template for how to do this.

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

Reply via email to