[ 
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)

Reply via email to