[
https://issues.apache.org/jira/browse/HIVE-22661?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17000207#comment-17000207
]
Hive QA commented on HIVE-22661:
--------------------------------
Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12989199/HIVE-22661.0.patch
{color:green}SUCCESS:{color} +1 due to 1 test(s) being added or modified.
{color:red}ERROR:{color} -1 due to 20 failed/errored test(s), 17781 tests
executed
*Failed tests:*
{noformat}
org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver[hybridgrace_hashjoin_2]
(batchId=112)
org.apache.hadoop.hive.ql.TestTxnCommands3.testDeleteEventPruningOff
(batchId=352)
org.apache.hadoop.hive.ql.TestTxnCommands3.testDeleteEventPruningOn
(batchId=352)
org.apache.hadoop.hive.ql.TestTxnExIm.testImport (batchId=337)
org.apache.hadoop.hive.ql.TestTxnExIm.testImportNoTarget (batchId=337)
org.apache.hadoop.hive.ql.TestTxnExIm.testImportVectorized (batchId=337)
org.apache.hadoop.hive.ql.TestTxnLoadData.loadDataUpdate (batchId=313)
org.apache.hadoop.hive.ql.TestTxnLoadData.loadDataUpdateVectorized (batchId=313)
org.apache.hadoop.hive.ql.TestTxnNoBuckets.testNoBuckets (batchId=337)
org.apache.hadoop.hive.ql.TestTxnNoBuckets.testNonAcidToAcidVectorzied
(batchId=337)
org.apache.hadoop.hive.ql.TestTxnNoBuckets.testToAcidConversion02 (batchId=337)
org.apache.hadoop.hive.ql.TestTxnNoBuckets.testToAcidConversionMultiBucket
(batchId=337)
org.apache.hadoop.hive.ql.TestTxnNoBucketsVectorized.testNoBuckets (batchId=337)
org.apache.hadoop.hive.ql.TestTxnNoBucketsVectorized.testNonAcidToAcidVectorzied
(batchId=337)
org.apache.hadoop.hive.ql.TestTxnNoBucketsVectorized.testToAcidConversion02
(batchId=337)
org.apache.hadoop.hive.ql.TestTxnNoBucketsVectorized.testToAcidConversionMultiBucket
(batchId=337)
org.apache.hive.hcatalog.streaming.TestStreaming.testNoBuckets (batchId=221)
org.apache.hive.jdbc.TestJdbcDriver2.testGetQueryLogForReplCommands
(batchId=287)
org.apache.hive.streaming.TestStreaming.testAutoRollTransactionBatch
(batchId=363)
org.apache.hive.streaming.TestStreaming.testNoBuckets (batchId=363)
{noformat}
Test results:
https://builds.apache.org/job/PreCommit-HIVE-Build/19986/testReport
Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/19986/console
Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-19986/
Messages:
{noformat}
Executing org.apache.hive.ptest.execution.TestCheckPhase
Executing org.apache.hive.ptest.execution.PrepPhase
Executing org.apache.hive.ptest.execution.YetusPhase
Executing org.apache.hive.ptest.execution.ExecutionPhase
Executing org.apache.hive.ptest.execution.ReportingPhase
Tests exited with: TestsFailedException: 20 tests failed
{noformat}
This message is automatically generated.
ATTACHMENT ID: 12989199 - PreCommit-HIVE-Build
> Compaction fails on non bucketed table with data loaded inpath
> --------------------------------------------------------------
>
> Key: HIVE-22661
> URL: https://issues.apache.org/jira/browse/HIVE-22661
> Project: Hive
> Issue Type: Bug
> Reporter: Ádám Szita
> Assignee: Ádám Szita
> Priority: Major
> Attachments: HIVE-22661.0.patch
>
>
> Compaction cannot handle situations where:
> * data was ingested with {{LOAD DATA INPATH}}
> * this ingest method is run multiple times, and
> ** with different number of files getting created in the delta directories
> Therefore, for file/dir structures such as:
> {code:java}
> /warehouse/tablespace/managed/hive/comp3/delta_0000001_0000001_0000
> /warehouse/tablespace/managed/hive/comp3/delta_0000001_0000001_0000/000000_0
> /warehouse/tablespace/managed/hive/comp3/delta_0000001_0000001_0000/000001_0
> /warehouse/tablespace/managed/hive/comp3/delta_0000002_0000002_0000
> /warehouse/tablespace/managed/hive/comp3/delta_0000002_0000002_0000/000000_0
> /warehouse/tablespace/managed/hive/comp3/delta_0000002_0000002_0000/000001_0
> /warehouse/tablespace/managed/hive/comp3/delta_0000002_0000002_0000/000002_0
> {code}
> Although the table is not bucketed, bucket is calculated from the (raw)
> files' names. Compaction in the above case will fail on delta1-1 not having
> data for 'bucket' 2.
> Steps to repro using small dataset:
> {code:java}
> set tez.grouping.min-size=8;
> set tez.grouping.max-size=8;
> set mapreduce.input.fileinputformat.split.minsize=8;
> set mapreduce.input.fileinputformat.split.minsize=8;
> create external table comp0 (a string);
> insert into comp0 values ("qwertyuiopasdfghjklzxcvbnm");
> insert into comp0 values ("qwertyuiopasdfghjklzxcvbnm");
> create external table comp1 stored as orc as select * from comp0;
> insert into comp0 values ("qwertyuiopasdfghjklzxcvbnm");
> create external table comp2 stored as orc as select * from comp0;
> create table comp3 (a string);
> load data inpath '/warehouse/tablespace/external/hive/comp1' into table comp3;
> load data inpath '/warehouse/tablespace/external/hive/comp2' into table
> comp3;{code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
