[ https://issues.apache.org/jira/browse/HIVE-7654?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14096581#comment-14096581 ]
Hive QA commented on HIVE-7654: ------------------------------- {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/12661538/HIVE-7654.1.patch {color:red}ERROR:{color} -1 due to 3 failed/errored test(s), 5893 tests executed *Failed tests:* {noformat} org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_extrapolate_part_stats org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver_dynpart_sort_opt_vectorization org.apache.hive.jdbc.TestJdbcDriver2.testDatabaseMetaData {noformat} Test results: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/300/testReport Console output: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/300/console Test logs: http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-TRUNK-Build-300/ 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: 3 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12661538 > A method to extrapolate columnStats for partitions of a table > ------------------------------------------------------------- > > Key: HIVE-7654 > URL: https://issues.apache.org/jira/browse/HIVE-7654 > Project: Hive > Issue Type: New Feature > Reporter: pengcheng xiong > Assignee: pengcheng xiong > Priority: Minor > Attachments: Extrapolate the Column Status.docx, HIVE-7654.0.patch, > HIVE-7654.1.patch > > > In a PARTITIONED table, there are many partitions. For example, > create table if not exists loc_orc ( > state string, > locid int, > zip bigint > ) partitioned by(year string) stored as orc; > We assume there are 4 partitions, partition(year='2000'), > partition(year='2001'), partition(year='2002') and partition(year='2003'). > We can use the following command to compute statistics for columns > state,locid of partition(year='2001') > analyze table loc_orc partition(year='2001') compute statistics for columns > state,locid; > We need to know the “aggregated” column status for the whole table loc_orc. > However, we may not have the column status for some partitions, e.g., > partition(year='2002') and also we may not have the column status for some > columns, e.g., zip bigint for partition(year='2001') > We propose a method to extrapolate the missing column status for the > partitions. -- This message was sent by Atlassian JIRA (v6.2#6252)