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

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 <10,0> 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)

Reply via email to