[ https://issues.apache.org/jira/browse/HAWQ-1055?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15508496#comment-15508496 ]
Shivram Mani commented on HAWQ-1055: ------------------------------------ The following table shows how Hive decimal fields will be handled in HAWQ: || HAWQ Type || Hive Type || Behavior | | numeric(precision, scale) | decimal(precision,scale) | As long as HAWQ has a higher scale/precision than defined in Hive, would be fine. If precision/scale is lower in HAWQ compared to Hive, will be reported as an error | | numeric(precision) | decimal(precision) | Hawq and Hive restricts scale to 0 | | numeric | decimal | Hive defaults to <38,38> while HAWQ permits upto max (131072) for precision and upto 16383 for scale | > Fractional part is being dropped for decimal/numeric column with no modifiers > in HiveORC profile > ------------------------------------------------------------------------------------------------ > > Key: HAWQ-1055 > URL: https://issues.apache.org/jira/browse/HAWQ-1055 > Project: Apache HAWQ > Issue Type: Bug > Components: PXF > Reporter: Oleksandr Diachenko > Assignee: Shivram Mani > Priority: Critical > Fix For: 2.0.1.0-incubating > > -- This message was sent by Atlassian JIRA (v6.3.4#6332)