[
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