[
https://issues.apache.org/jira/browse/HIVE-15989?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15876722#comment-15876722
]
Sergey Shelukhin commented on HIVE-15989:
-----------------------------------------
Is ORC file column decimal, double, or something else? You should use a
matching type. So many 3-s won't fit into decimal(38,38), so I wonder if it's
some other type.
Also, to rule out the tools/JDBC/... enforcing some arbitrary limit, if you
save query results via "insert overwrite directory", does it still happen?
[~prasanth_j] is there some convenient way to dump a record/records from ORC
file without going thru Hive.
> Incorrect rounding in decimal data types
> ----------------------------------------
>
> Key: HIVE-15989
> URL: https://issues.apache.org/jira/browse/HIVE-15989
> Project: Hive
> Issue Type: Bug
> Components: Database/Schema
> Reporter: Nikesh
> Priority: Critical
>
> I have a numeric field in a file in my data lake and created a hive external
> table pointing to this field. The field value is
> 0.3333333333333333333333333333333333333333 but when I fetched this record
> using the query it display only 0.3333333333333333. I tried using DECIMAL and
> DOUBLE data types but nothing worked.is this a bug or am I not using the
> exact data type for this?
> Thanks,
> NIkesh
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
