[jira] [Commented] (HIVE-11548) HCatLoader should support predicate pushdown.

["Hive QA (JIRA)" <ji...@apache.org>]

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

Hive QA commented on HIVE-11548:
--------------------------------



{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/12750373/HIVE-11548.1.patch

{color:red}ERROR:{color} -1 due to 133 failed/errored test(s), 9356 tests executed
*Failed tests:*
{noformat}
org.apache.hive.hcatalog.hbase.TestPigHBaseStorageHandler.org.apache.hive.hcatalog.hbase.TestPigHBaseStorageHandler
org.apache.hive.hcatalog.mapreduce.TestHCatHiveCompatibility.testPartedRead
org.apache.hive.hcatalog.mapreduce.TestHCatHiveCompatibility.testUnpartedReadWrite
org.apache.hive.hcatalog.mapreduce.TestHCatHiveThriftCompatibility.testDynamicCols
org.apache.hive.hcatalog.mapreduce.TestSequenceFileReadWrite.testSequenceTableWriteRead
org.apache.hive.hcatalog.mapreduce.TestSequenceFileReadWrite.testSequenceTableWriteReadMR
org.apache.hive.hcatalog.mapreduce.TestSequenceFileReadWrite.testTextTableWriteRead
org.apache.hive.hcatalog.mapreduce.TestSequenceFileReadWrite.testTextTableWriteReadMR
org.apache.hive.hcatalog.pig.TestE2EScenarios.testReadOrcAndRCFromPig
org.apache.hive.hcatalog.pig.TestHCatLoader.testConvertBooleanToInt[0]
org.apache.hive.hcatalog.pig.TestHCatLoader.testConvertBooleanToInt[1]
org.apache.hive.hcatalog.pig.TestHCatLoader.testConvertBooleanToInt[2]
org.apache.hive.hcatalog.pig.TestHCatLoader.testConvertBooleanToInt[3]
org.apache.hive.hcatalog.pig.TestHCatLoader.testConvertBooleanToInt[4]
org.apache.hive.hcatalog.pig.TestHCatLoader.testConvertBooleanToInt[5]
org.apache.hive.hcatalog.pig.TestHCatLoader.testProjectionsBasic[0]
org.apache.hive.hcatalog.pig.TestHCatLoader.testProjectionsBasic[1]
org.apache.hive.hcatalog.pig.TestHCatLoader.testProjectionsBasic[2]
org.apache.hive.hcatalog.pig.TestHCatLoader.testProjectionsBasic[3]
org.apache.hive.hcatalog.pig.TestHCatLoader.testProjectionsBasic[5]
org.apache.hive.hcatalog.pig.TestHCatLoader.testReadDataBasic[0]
org.apache.hive.hcatalog.pig.TestHCatLoader.testReadDataBasic[1]
org.apache.hive.hcatalog.pig.TestHCatLoader.testReadDataBasic[2]
org.apache.hive.hcatalog.pig.TestHCatLoader.testReadDataBasic[3]
org.apache.hive.hcatalog.pig.TestHCatLoader.testReadDataBasic[5]
org.apache.hive.hcatalog.pig.TestHCatLoader.testReadDataPrimitiveTypes[0]
org.apache.hive.hcatalog.pig.TestHCatLoader.testReadDataPrimitiveTypes[1]
org.apache.hive.hcatalog.pig.TestHCatLoader.testReadDataPrimitiveTypes[2]
org.apache.hive.hcatalog.pig.TestHCatLoader.testReadDataPrimitiveTypes[3]
org.apache.hive.hcatalog.pig.TestHCatLoader.testReadDataPrimitiveTypes[4]
org.apache.hive.hcatalog.pig.TestHCatLoader.testReadDataPrimitiveTypes[5]
org.apache.hive.hcatalog.pig.TestHCatLoader.testReadPartitionedBasic[0]
org.apache.hive.hcatalog.pig.TestHCatLoader.testReadPartitionedBasic[1]
org.apache.hive.hcatalog.pig.TestHCatLoader.testReadPartitionedBasic[2]
org.apache.hive.hcatalog.pig.TestHCatLoader.testReadPartitionedBasic[3]
org.apache.hive.hcatalog.pig.TestHCatLoader.testReadPartitionedBasic[5]
org.apache.hive.hcatalog.pig.TestHCatLoaderComplexSchema.testMapNullKey[0]
org.apache.hive.hcatalog.pig.TestHCatLoaderComplexSchema.testMapNullKey[1]
org.apache.hive.hcatalog.pig.TestHCatLoaderComplexSchema.testMapNullKey[2]
org.apache.hive.hcatalog.pig.TestHCatLoaderComplexSchema.testMapNullKey[3]
org.apache.hive.hcatalog.pig.TestHCatLoaderComplexSchema.testMapWithComplexData[0]
org.apache.hive.hcatalog.pig.TestHCatLoaderComplexSchema.testMapWithComplexData[1]
org.apache.hive.hcatalog.pig.TestHCatLoaderComplexSchema.testMapWithComplexData[2]
org.apache.hive.hcatalog.pig.TestHCatLoaderComplexSchema.testMapWithComplexData[3]
org.apache.hive.hcatalog.pig.TestHCatLoaderComplexSchema.testMapWithComplexData[5]
org.apache.hive.hcatalog.pig.TestHCatLoaderComplexSchema.testSyntheticComplexSchema[0]
org.apache.hive.hcatalog.pig.TestHCatLoaderComplexSchema.testSyntheticComplexSchema[1]
org.apache.hive.hcatalog.pig.TestHCatLoaderComplexSchema.testSyntheticComplexSchema[2]
org.apache.hive.hcatalog.pig.TestHCatLoaderComplexSchema.testSyntheticComplexSchema[3]
org.apache.hive.hcatalog.pig.TestHCatLoaderComplexSchema.testSyntheticComplexSchema[5]
org.apache.hive.hcatalog.pig.TestHCatLoaderComplexSchema.testTupleInBagInTupleInBag[0]
org.apache.hive.hcatalog.pig.TestHCatLoaderComplexSchema.testTupleInBagInTupleInBag[1]
org.apache.hive.hcatalog.pig.TestHCatLoaderComplexSchema.testTupleInBagInTupleInBag[2]
org.apache.hive.hcatalog.pig.TestHCatLoaderComplexSchema.testTupleInBagInTupleInBag[3]
org.apache.hive.hcatalog.pig.TestHCatLoaderComplexSchema.testTupleInBagInTupleInBag[5]
org.apache.hive.hcatalog.pig.TestHCatLoaderEncryption.testReadDataFromEncryptedHiveTableByPig[0]
org.apache.hive.hcatalog.pig.TestHCatLoaderEncryption.testReadDataFromEncryptedHiveTableByPig[1]
org.apache.hive.hcatalog.pig.TestHCatLoaderEncryption.testReadDataFromEncryptedHiveTableByPig[2]
org.apache.hive.hcatalog.pig.TestHCatLoaderEncryption.testReadDataFromEncryptedHiveTableByPig[3]
org.apache.hive.hcatalog.pig.TestHCatLoaderEncryption.testReadDataFromEncryptedHiveTableByPig[4]
org.apache.hive.hcatalog.pig.TestHCatLoaderEncryption.testReadDataFromEncryptedHiveTableByPig[5]
org.apache.hive.hcatalog.pig.TestHCatLoaderStorer.testReadWrite
org.apache.hive.hcatalog.pig.TestHCatLoaderStorer.testSmallTinyInt
org.apache.hive.hcatalog.pig.TestHCatStorer.testDateCharTypes[0]
org.apache.hive.hcatalog.pig.TestHCatStorer.testDateCharTypes[1]
org.apache.hive.hcatalog.pig.TestHCatStorer.testDateCharTypes[2]
org.apache.hive.hcatalog.pig.TestHCatStorer.testDateCharTypes[3]
org.apache.hive.hcatalog.pig.TestHCatStorer.testPartColsInData[0]
org.apache.hive.hcatalog.pig.TestHCatStorer.testPartColsInData[1]
org.apache.hive.hcatalog.pig.TestHCatStorer.testPartColsInData[2]
org.apache.hive.hcatalog.pig.TestHCatStorer.testPartColsInData[3]
org.apache.hive.hcatalog.pig.TestHCatStorer.testPartColsInData[5]
org.apache.hive.hcatalog.pig.TestHCatStorer.testStoreFuncAllSimpleTypes[0]
org.apache.hive.hcatalog.pig.TestHCatStorer.testStoreFuncAllSimpleTypes[1]
org.apache.hive.hcatalog.pig.TestHCatStorer.testStoreFuncAllSimpleTypes[2]
org.apache.hive.hcatalog.pig.TestHCatStorer.testStoreFuncAllSimpleTypes[3]
org.apache.hive.hcatalog.pig.TestHCatStorer.testStoreFuncAllSimpleTypes[5]
org.apache.hive.hcatalog.pig.TestHCatStorer.testStoreInPartiitonedTbl[0]
org.apache.hive.hcatalog.pig.TestHCatStorer.testStoreInPartiitonedTbl[1]
org.apache.hive.hcatalog.pig.TestHCatStorer.testStoreInPartiitonedTbl[2]
org.apache.hive.hcatalog.pig.TestHCatStorer.testStoreInPartiitonedTbl[3]
org.apache.hive.hcatalog.pig.TestHCatStorer.testStoreInPartiitonedTbl[5]
org.apache.hive.hcatalog.pig.TestHCatStorer.testWriteChar[0]
org.apache.hive.hcatalog.pig.TestHCatStorer.testWriteChar[1]
org.apache.hive.hcatalog.pig.TestHCatStorer.testWriteChar[2]
org.apache.hive.hcatalog.pig.TestHCatStorer.testWriteChar[3]
org.apache.hive.hcatalog.pig.TestHCatStorer.testWriteChar[5]
org.apache.hive.hcatalog.pig.TestHCatStorer.testWriteDate2[0]
org.apache.hive.hcatalog.pig.TestHCatStorer.testWriteDate2[1]
org.apache.hive.hcatalog.pig.TestHCatStorer.testWriteDate2[2]
org.apache.hive.hcatalog.pig.TestHCatStorer.testWriteDate2[3]
org.apache.hive.hcatalog.pig.TestHCatStorer.testWriteDate2[5]
org.apache.hive.hcatalog.pig.TestHCatStorer.testWriteDate3[0]
org.apache.hive.hcatalog.pig.TestHCatStorer.testWriteDate3[1]
org.apache.hive.hcatalog.pig.TestHCatStorer.testWriteDate3[2]
org.apache.hive.hcatalog.pig.TestHCatStorer.testWriteDate3[3]
org.apache.hive.hcatalog.pig.TestHCatStorer.testWriteDate3[5]
org.apache.hive.hcatalog.pig.TestHCatStorer.testWriteDate[0]
org.apache.hive.hcatalog.pig.TestHCatStorer.testWriteDate[1]
org.apache.hive.hcatalog.pig.TestHCatStorer.testWriteDate[2]
org.apache.hive.hcatalog.pig.TestHCatStorer.testWriteDate[3]
org.apache.hive.hcatalog.pig.TestHCatStorer.testWriteDate[5]
org.apache.hive.hcatalog.pig.TestHCatStorer.testWriteDecimalXY[0]
org.apache.hive.hcatalog.pig.TestHCatStorer.testWriteDecimalXY[1]
org.apache.hive.hcatalog.pig.TestHCatStorer.testWriteDecimalXY[2]
org.apache.hive.hcatalog.pig.TestHCatStorer.testWriteDecimalXY[3]
org.apache.hive.hcatalog.pig.TestHCatStorer.testWriteDecimalX[0]
org.apache.hive.hcatalog.pig.TestHCatStorer.testWriteDecimalX[1]
org.apache.hive.hcatalog.pig.TestHCatStorer.testWriteDecimalX[2]
org.apache.hive.hcatalog.pig.TestHCatStorer.testWriteDecimalX[3]
org.apache.hive.hcatalog.pig.TestHCatStorer.testWriteDecimalX[5]
org.apache.hive.hcatalog.pig.TestHCatStorer.testWriteDecimal[0]
org.apache.hive.hcatalog.pig.TestHCatStorer.testWriteDecimal[1]
org.apache.hive.hcatalog.pig.TestHCatStorer.testWriteDecimal[2]
org.apache.hive.hcatalog.pig.TestHCatStorer.testWriteDecimal[3]
org.apache.hive.hcatalog.pig.TestHCatStorer.testWriteDecimal[5]
org.apache.hive.hcatalog.pig.TestHCatStorer.testWriteSmallint[0]
org.apache.hive.hcatalog.pig.TestHCatStorer.testWriteSmallint[1]
org.apache.hive.hcatalog.pig.TestHCatStorer.testWriteSmallint[2]
org.apache.hive.hcatalog.pig.TestHCatStorer.testWriteSmallint[3]
org.apache.hive.hcatalog.pig.TestHCatStorer.testWriteTimestamp[0]
org.apache.hive.hcatalog.pig.TestHCatStorer.testWriteTimestamp[1]
org.apache.hive.hcatalog.pig.TestHCatStorer.testWriteTimestamp[2]
org.apache.hive.hcatalog.pig.TestHCatStorer.testWriteTimestamp[3]
org.apache.hive.hcatalog.pig.TestHCatStorer.testWriteTinyint[0]
org.apache.hive.hcatalog.pig.TestHCatStorer.testWriteTinyint[1]
org.apache.hive.hcatalog.pig.TestHCatStorer.testWriteTinyint[2]
org.apache.hive.hcatalog.pig.TestHCatStorer.testWriteTinyint[3]
org.apache.hive.hcatalog.pig.TestHCatStorer.testWriteVarchar[0]
org.apache.hive.hcatalog.pig.TestHCatStorer.testWriteVarchar[1]
org.apache.hive.hcatalog.pig.TestHCatStorer.testWriteVarchar[2]
org.apache.hive.hcatalog.pig.TestHCatStorer.testWriteVarchar[3]
org.apache.hive.hcatalog.pig.TestHCatStorer.testWriteVarchar[5]
{noformat}

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

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

This message is automatically generated.

ATTACHMENT ID: 12750373 - PreCommit-HIVE-TRUNK-Build

> HCatLoader should support predicate pushdown.
> ---------------------------------------------
>
>                 Key: HIVE-11548
>                 URL: https://issues.apache.org/jira/browse/HIVE-11548
>             Project: Hive
>          Issue Type: New Feature
>          Components: HCatalog
>            Reporter: Mithun Radhakrishnan
>            Assignee: Mithun Radhakrishnan
>         Attachments: HIVE-11548.1.patch
>
>
> When one uses {{HCatInputFormat}}/{{HCatLoader}} to read from file-formats that support predicate pushdown (such as ORC, with {{hive.optimize.index.filter=true}}), one sees that the predicates aren't actually pushed down into the storage layer.
> The forthcoming patch should allow for filter-pushdown, if any of the partitions being scanned with {{HCatLoader}} support the functionality. The patch should technically allow the same for users of {{HCatInputFormat}}, but I don't currently have a neat interface to build a compound predicate-expression. Will add this separately, if required.



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