[ 
https://issues.apache.org/jira/browse/HAWQ-1055?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Shivram Mani updated HAWQ-1055:
-------------------------------
    Comment: was deleted

(was: If there are no modifier information (precision,scale) specified for the 
numeric type in both hive/hawq, we will default to (10,0) as this is the 
default for Hive since 0.13.
If Hive has a precision specified without any modifier info in HAWQ for the 
same column, Hive's precision should be used.
The following cases will be handled according to the 

|| HAWQ Type || Hive Type || Behavior || Example ||
| numeric(precision, scale) | decimal(precision,scale) | As long as HAWQ has a 
higher scale/precision than defined in Hive, we should be fine | |
| numeric(precision) | decimal(precision) | Hawq and Hive restricts scale to 0 
| 9 |
| 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