[jira] [Comment Edited] (HAWQ-1055) Fractional part is being dropped for decimal/numeric column with no modifiers in HiveORC profile
[ https://issues.apache.org/jira/browse/HAWQ-1055?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15508496#comment-15508496 ] Shivram Mani edited comment on HAWQ-1055 at 9/23/16 8:52 PM: - 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,18> while HAWQ permits upto max (131072) for precision and upto 16383 for scale | was (Author: shivram): 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)
[jira] [Comment Edited] (HAWQ-1055) Fractional part is being dropped for decimal/numeric column with no modifiers in HiveORC profile
[ https://issues.apache.org/jira/browse/HAWQ-1055?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15508500#comment-15508500 ] Shivram Mani edited comment on HAWQ-1055 at 9/23/16 8:52 PM: - If HAWQ doesn't define precision,scale info for the column, we will assume <38,18> as that is the maximum permitted value in Hive was (Author: shivram): If HAWQ doesn't define precision,scale info for the column, we will assume <38,38> as that is the maximum permitted value in Hive > 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)
[jira] [Comment Edited] (HAWQ-1055) Fractional part is being dropped for decimal/numeric column with no modifiers in HiveORC profile
[ https://issues.apache.org/jira/browse/HAWQ-1055?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15505162#comment-15505162 ] Shivram Mani edited comment on HAWQ-1055 at 9/20/16 12:40 AM: -- 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. was (Author: shivram): If there are no modifier information (scale/precision) 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. > 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: Goden Yao >Priority: Critical > Fix For: 2.0.1.0-incubating > > -- This message was sent by Atlassian JIRA (v6.3.4#6332)
