[
https://issues.apache.org/jira/browse/HIVE-15408?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16915998#comment-16915998
]
Hive QA commented on HIVE-15408:
--------------------------------
Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12978595/HIVE-15408.01.patch
{color:green}SUCCESS:{color} +1 due to 1 test(s) being added or modified.
{color:red}ERROR:{color} -1 due to 47 failed/errored test(s), 16714 tests
executed
*Failed tests:*
{noformat}
TestDataSourceProviderFactory - did not produce a TEST-*.xml file (likely timed
out) (batchId=233)
TestObjectStore - did not produce a TEST-*.xml file (likely timed out)
(batchId=233)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[acid_subquery]
(batchId=43)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[acid_view_delete]
(batchId=37)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[annotate_stats_filter]
(batchId=9)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[create_transactional_full_acid]
(batchId=83)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[explain_ast] (batchId=96)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[explain_locks]
(batchId=48)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[filter_cond_pushdown_HIVE_15647]
(batchId=90)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[join44] (batchId=12)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[masking_disablecbo_3]
(batchId=40)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[masking_disablecbo_4]
(batchId=7)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[sample8] (batchId=32)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[semijoin2] (batchId=60)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[subquery_exists_explain_rewrite]
(batchId=51)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[subquery_in_explain_rewrite]
(batchId=4)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[subquery_multiinsert]
(batchId=92)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[subquery_unqual_corr_expr]
(batchId=9)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_empty_where]
(batchId=26)
org.apache.hadoop.hive.cli.TestMiniLlapCliDriver.testCliDriver[llap_nullscan]
(batchId=155)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[lvj_mapjoin]
(batchId=166)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[mergejoin_3way]
(batchId=173)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[optimize_nullscan]
(batchId=184)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vector_mapjoin_complex_values]
(batchId=178)
org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.testCliDriver[spark_dynamic_partition_pruning_4]
(batchId=195)
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[optimize_nullscan]
(batchId=150)
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[sample8]
(batchId=126)
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[subquery_multiinsert]
(batchId=151)
org.apache.hadoop.hive.ql.TestMetaStoreLimitPartitionRequest.testQueryWithInWithFallbackToORM
(batchId=246)
org.apache.hadoop.hive.ql.TestMetaStoreLimitPartitionRequest.testQueryWithInWithFallbackToORMTooManyPartitions
(batchId=246)
org.apache.hadoop.hive.ql.TestMetaStoreLimitPartitionRequest.testQueryWithInWithFallbackToORMTooManyPartitions2
(batchId=246)
org.apache.hadoop.hive.ql.TestTxnCommands.testDeleteIn (batchId=351)
org.apache.hadoop.hive.ql.TestTxnCommands2.testDeleteIn (batchId=332)
org.apache.hadoop.hive.ql.TestTxnCommands2WithSplitUpdateAndVectorization.testDeleteIn
(batchId=346)
org.apache.hadoop.hive.ql.TestTxnCommandsWithSplitUpdateAndVectorization.testDeleteIn
(batchId=333)
org.apache.hadoop.hive.ql.lockmgr.TestDbTxnManager2.testLocksInSubquery
(batchId=350)
org.apache.hadoop.hive.ql.parse.TestIUD.testDeleteWithWhere (batchId=327)
org.apache.hadoop.hive.ql.parse.TestIUD.testStandardInsertIntoTable
(batchId=327)
org.apache.hadoop.hive.ql.parse.TestIUD.testUpdateWithWhereMultiSet
(batchId=327)
org.apache.hadoop.hive.ql.parse.TestIUD.testUpdateWithWhereSingleSet
(batchId=327)
org.apache.hadoop.hive.ql.parse.TestIUD.testUpdateWithWhereSingleSetExpr
(batchId=327)
org.apache.hadoop.hive.ql.parse.TestParseDriver.testParse (batchId=325)
org.apache.hadoop.hive.ql.parse.TestQBSubQuery.testExtractConjuncts
(batchId=327)
org.apache.hadoop.hive.ql.parse.TestQBSubQuery.testExtractSubQueries
(batchId=327)
org.apache.hadoop.hive.ql.parse.TestQBSubQuery.testRewriteOuterQueryWhere
(batchId=327)
org.apache.hadoop.hive.ql.parse.TestQBSubQuery.testRewriteOuterQueryWhere2
(batchId=327)
org.apache.hadoop.hive.ql.plan.TestViewEntity.testViewInSubQueryWithWhereClauseRbo
(batchId=349)
{noformat}
Test results:
https://builds.apache.org/job/PreCommit-HIVE-Build/18398/testReport
Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/18398/console
Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-18398/
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: 47 tests failed
{noformat}
This message is automatically generated.
ATTACHMENT ID: 12978595 - PreCommit-HIVE-Build
> Support auto-casting non-boolean where condition into boolean
> -------------------------------------------------------------
>
> Key: HIVE-15408
> URL: https://issues.apache.org/jira/browse/HIVE-15408
> Project: Hive
> Issue Type: Bug
> Reporter: Zoltan Haindrich
> Assignee: Zoltan Haindrich
> Priority: Minor
> Attachments: HIVE-15408.01.patch
>
>
> Hive should support
> {code}
> select 1 where 1
> {code}
> currently it throws an execption (at least with mr)...complaining about
> Integer / Boolean casting difficulties.
> Current behaviour is a bit inconsistent; because using tez / vectorization
> this is supported.
> related tickets:
> HIVE-15089
> HIVE-1478
> HIVE-13659
--
This message was sent by Atlassian Jira
(v8.3.2#803003)
