hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hive QA (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-15519) Hive Decimal Type column scale is returning as zero
Date Wed, 28 Dec 2016 11:12:58 GMT

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

Hive QA commented on HIVE-15519:
--------------------------------



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

{color:red}ERROR:{color} -1 due to no test(s) being added or modified.

{color:red}ERROR:{color} -1 due to 6 failed/errored test(s), 10884 tests executed
*Failed tests:*
{noformat}
TestDerbyConnector - did not produce a TEST-*.xml file (likely timed out) (batchId=233)
TestSparkCliDriver - did not produce a TEST-*.xml file (likely timed out) (batchId=109)
	[groupby_grouping_id2.q,input17.q,bucketmapjoin12.q,ppd_gby_join.q,auto_join10.q,ptf_rcfile.q,vectorized_rcfile_columnar.q,vector_elt.q,ppd_join5.q,ppd_join.q,join_filters_overlap.q,join_cond_pushdown_1.q,timestamp_3.q,load_dyn_part6.q,stats_noscan_2.q]
org.apache.hadoop.hive.cli.TestMiniLlapCliDriver.testCliDriver[orc_ppd_basic] (batchId=134)
org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver[explainanalyze_2] (batchId=93)
org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver[explainanalyze_4] (batchId=93)
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[vector_count_distinct] (batchId=105)
{noformat}

Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/2735/testReport
Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/2735/console
Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-2735/

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

This message is automatically generated.

ATTACHMENT ID: 12844904 - PreCommit-HIVE-Build

> Hive Decimal Type column scale is returning as zero
> ---------------------------------------------------
>
>                 Key: HIVE-15519
>                 URL: https://issues.apache.org/jira/browse/HIVE-15519
>             Project: Hive
>          Issue Type: Bug
>          Components: Hive, JDBC
>            Reporter: Bharat Viswanadham
>            Assignee: Rui Li
>            Priority: Critical
>         Attachments: HIVE-15519.1.patch, data_type_test(1).txt
>
>
> Hive decimal type column precision is returning as zero, even though column has precision
set.
> Example: col67 decimal(18,2) precison is returning as zero for that column.
> Tried with below program.
> {code}
>    System.out.println("Opening connection");   Class.forName("org.apache.hive.jdbc.HiveDriver");
>    Connection con = DriverManager.getConnection("jdbc:hive2://x.x.x.x:10000/default");
>   DatabaseMetaData dbMeta = con.getMetaData();
>    ResultSet rs = dbMeta.getColumns(null, "DEFAULT", "data_type_test",null);
>  while (rs.next()) {
> if (rs.getString("COLUMN_NAME").equalsIgnoreCase("col48") || rs.getString("COLUMN_NAME").equalsIgnoreCase("col67")
|| rs.getString("COLUMN_NAME").equalsIgnoreCase("col68") || rs.getString("COLUMN_NAME").equalsIgnoreCase("col122")){
>      System.out.println(rs.getString("COLUMN_NAME") + "\t" + rs.getString("COLUMN_SIZE")
+ "\t" + rs.getInt("DECIMAL_DIGITS"));
>     }
>    }
>    rs.close();
>    con.close();
>   } catch (Exception e) {
>    e.printStackTrace();
>    ;
>   }
> {code}
> Default fetch size is 50. if any column no is under 50 with decimal type, precision is
returning properly, when the column no is greater than 50, precision is returning as zero.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message