hive-dev 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-8062) Stats collection for columns fails on a partitioned table with null values in partitioning column
Date Fri, 12 Sep 2014 16:12:34 GMT

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

Hive QA commented on HIVE-8062:
-------------------------------



{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/12668275/HIVE-8062.patch

{color:red}ERROR:{color} -1 due to 2 failed/errored test(s), 6197 tests executed
*Failed tests:*
{noformat}
org.apache.hadoop.hive.ql.parse.TestParse.testParse_union
org.apache.hive.service.TestHS2ImpersonationWithRemoteMS.testImpersonation
{noformat}

Test results: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/761/testReport
Console output: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/761/console
Test logs: http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-TRUNK-Build-761/

Messages:
{noformat}
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: 2 tests failed
{noformat}

This message is automatically generated.

ATTACHMENT ID: 12668275

> Stats collection for columns fails on a partitioned table with null values in partitioning
column
> -------------------------------------------------------------------------------------------------
>
>                 Key: HIVE-8062
>                 URL: https://issues.apache.org/jira/browse/HIVE-8062
>             Project: Hive
>          Issue Type: Bug
>          Components: Statistics
>    Affects Versions: 0.14.0
>            Reporter: Deepesh Khandelwal
>            Assignee: Ashutosh Chauhan
>         Attachments: HIVE-8062.patch
>
>
> Steps to reproduce:
> 1. Create a data file abc.txt with the following contents:
> {noformat}
> a,1
> b,
> {noformat}
> 2. Use the Hive CLI to create and load the partitioned table:
> {noformat}
> hive> create table abc(a string, b int);
> OK
> Time taken: 0.272 seconds
> hive> load data local inpath 'abc.txt' into table abc;
> Loading data to table default.abc
> Table default.abc stats: [numFiles=1, numRows=0, totalSize=7, rawDataSize=0]
> OK
> Time taken: 0.463 seconds
> hive> create table abc1(a string) partitioned by (b int);
> OK
> Time taken: 0.098 seconds
> hive> set hive.exec.dynamic.partition.mode=nonstrict;
> hive> insert overwrite table abc1 partition (b) select a, b from abc;
> Query ID = hrt_qa_20140911210909_1200fae7-1e18-4e0d-b74f-040453c27cff
> Total jobs = 1
> Launching Job 1 out of 1
> Status: Running (application id: Executing on YARN cluster with App id application_1410457588978_0063)
> Map 1: -/-	Reducer 2: 0/1
> Map 1: 0/1	Reducer 2: 0/1
> Map 1: 0(+1)/1	Reducer 2: 0/1
> Map 1: 1/1	Reducer 2: 0(+1)/1
> Map 1: 1/1	Reducer 2: 0/1
> Map 1: 1/1	Reducer 2: 1/1
> Status: Finished successfully
> Loading data to table default.abc1 partition (b=null)
> 	Loading partition {b=__HIVE_DEFAULT_PARTITION__}
> Partition default.abc1{b=__HIVE_DEFAULT_PARTITION__} stats: [numFiles=1, numRows=2, totalSize=7,
rawDataSize=5]
> OK
> Time taken: 7.49 seconds
> {noformat}
> 3. Now run the analyze statistics command for columns:
> {noformat}
> hive> analyze table abc1 partition (b) compute statistics for columns;
> Query ID = hrt_qa_20140911211010_440bdb4a-6a0d-496b-9d2e-5fc84db3d0ee
> Total jobs = 1
> Launching Job 1 out of 1
> Status: Running (application id: Executing on YARN cluster with App id application_1410457588978_0063)
> Map 1: 0(+1)/1	Reducer 2: 0/1
> Map 1: 1/1	Reducer 2: 0(+1)/1
> Map 1: 1/1	Reducer 2: 1/1
> Status: Finished successfully
> FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.ColumnStatsTask
> {noformat}
> The analyze statistics for columns fails.



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

Mime
View raw message