You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Hive QA (JIRA)" <ji...@apache.org> on 2013/12/11 07:23:07 UTC
[jira] [Commented] (HIVE-4293) Predicates following UDTF operator
are removed by PPD
[ https://issues.apache.org/jira/browse/HIVE-4293?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13845125#comment-13845125 ]
Hive QA commented on HIVE-4293:
-------------------------------
{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/12618164/HIVE-4293.7.patch.txt
{color:red}ERROR:{color} -1 due to 3 failed/errored test(s), 4763 tests executed
*Failed tests:*
{noformat}
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_lateral_view_ppd
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_ppd_udtf
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_subquery_notin_having
{noformat}
Test results: http://bigtop01.cloudera.org:8080/job/PreCommit-HIVE-Build/607/testReport
Console output: http://bigtop01.cloudera.org:8080/job/PreCommit-HIVE-Build/607/console
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: 12618164
> Predicates following UDTF operator are removed by PPD
> -----------------------------------------------------
>
> Key: HIVE-4293
> URL: https://issues.apache.org/jira/browse/HIVE-4293
> Project: Hive
> Issue Type: Bug
> Components: Query Processor
> Reporter: Navis
> Assignee: Navis
> Attachments: D9933.6.patch, HIVE-4293.7.patch.txt, HIVE-4293.D9933.1.patch, HIVE-4293.D9933.2.patch, HIVE-4293.D9933.3.patch, HIVE-4293.D9933.4.patch, HIVE-4293.D9933.5.patch
>
>
> For example,
> {noformat}
> explain SELECT value from (
> select explode(array(key, value)) as (value) from (
> select * FROM src WHERE key > 200
> ) A
> ) B WHERE value > 300
> ;
> {noformat}
> Makes plan like this, removing last predicates
> {noformat}
> TableScan
> alias: src
> Filter Operator
> predicate:
> expr: (key > 200.0)
> type: boolean
> Select Operator
> expressions:
> expr: array(key,value)
> type: array<string>
> outputColumnNames: _col0
> UDTF Operator
> function name: explode
> Select Operator
> expressions:
> expr: col
> type: string
> outputColumnNames: _col0
> File Output Operator
> compressed: false
> GlobalTableId: 0
> table:
> input format: org.apache.hadoop.mapred.TextInputFormat
> output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.1.4#6159)