[jira] [Commented] (HIVE-5564) Need to accomodate table decimal columns that were defined prior to HIVE-3976

["Hive QA (JIRA)" <ji...@apache.org>]

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

Hive QA commented on HIVE-5564:
-------------------------------



{color:red}Overall{color}: -1 at least one tests failed

Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12610951/HIVE-5564.1.patch

{color:red}ERROR:{color} -1 due to 23 failed/errored test(s), 4545 tests executed
*Failed tests:*
{noformat}
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_decimal_1
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_decimal_2
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_decimal_3
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_decimal_4
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_decimal_5
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_decimal_6
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_decimal_precision
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_decimal_udf
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_join_cond_pushdown_1
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_join_cond_pushdown_2
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_literal_decimal
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_ptf_decimal
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_serde_regex
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_udf7
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_udf_pmod
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_windowing_multipartitioning
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_windowing_navfn
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_windowing_ntile
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_windowing_rank
org.apache.hadoop.hive.jdbc.TestJdbcDriver.testDataTypes
org.apache.hadoop.hive.serde2.binarysortable.TestBinarySortableSerDe.testBinarySortableSerDe
org.apache.hadoop.hive.serde2.lazybinary.TestLazyBinarySerDe.testLazyBinarySerDe
org.apache.hive.jdbc.TestJdbcDriver2.testDataTypes
{noformat}

Test results: http://bigtop01.cloudera.org:8080/job/PreCommit-HIVE-Build/84/testReport
Console output: http://bigtop01.cloudera.org:8080/job/PreCommit-HIVE-Build/84/console

Messages:
{noformat}
Executing org.apache.hive.ptest.execution.PrepPhase
Executing org.apache.hive.ptest.execution.ExecutionPhase
Executing org.apache.hive.ptest.execution.ReportingPhase
Tests failed with: TestsFailedException: 23 tests failed
{noformat}

This message is automatically generated.

> Need to accomodate table decimal columns that were defined prior to HIVE-3976
> -----------------------------------------------------------------------------
>
>                 Key: HIVE-5564
>                 URL: https://issues.apache.org/jira/browse/HIVE-5564
>             Project: Hive
>          Issue Type: Task
>          Components: Types
>    Affects Versions: 0.13.0
>            Reporter: Xuefu Zhang
>            Assignee: Xuefu Zhang
>             Fix For: 0.13.0
>
>         Attachments: HIVE-5564.1.patch, HIVE-5564.patch
>
>
> With HIVE-3976, decimal columns are stored with precision/scale, such as decimal(17,5), as the type name. However, such columns defined in hive prior to HIVE-3976 have a name as "decimal". Those columns need to continue to work with a precision/scale as (10,0), per the functional doc. With patch in HIVE-3976, we may get the following error message in such case:
> {code}
> 0: jdbc:hive2://localhost:10000> desc dec;
> Error: Error while processing statement: FAILED: RuntimeException Decimal type is specified without length: decimal:int (state=42000,code=40000)
> {code}
> This issue will be addressed in this JIRA as a follow-up task.



--
This message was sent by Atlassian JIRA
(v6.1#6144)