You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Rafael Mourao (JIRA)" <ji...@apache.org> on 2018/06/08 17:23:00 UTC
[jira] [Updated] (HIVE-19832) Query fails when disabling PPD
optimization
[ https://issues.apache.org/jira/browse/HIVE-19832?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rafael Mourao updated HIVE-19832:
---------------------------------
Environment: (was: :0 jdbc:hive2://> CREATE TABLE t (x INT) PARTITIONED BY (y INT);
0: jdbc:hive2://> SELECT * FROM t;
0: jdbc:hive2://> SELECT * FROM t WHERE y IS NOT NULL;
+------+------+--+
| t.x | t.y |
+------+------+--+
+------+------+--+
0: jdbc:hive2://> SET hive.optimize.ppd=false;
0: jdbc:hive2://> SELECT * FROM t WHERE y IS NOT NULL;
Error: Error while compiling statement: FAILED: SemanticException [Error 10041]: No partition predicate found for Alias "t" Table "t" (state=42000,code=10041))
> Query fails when disabling PPD optimization
> -------------------------------------------
>
> Key: HIVE-19832
> URL: https://issues.apache.org/jira/browse/HIVE-19832
> Project: Hive
> Issue Type: Bug
> Components: Logical Optimizer
> Affects Versions: 1.1.0
> Reporter: Rafael Mourao
> Priority: Minor
>
> Query fails when disabling PPD optimization (necessary until https://issues.apache.org/jira/browse/HIVE-19652 is solved):
>
> :0 jdbc:hive2://> CREATE TABLE t (x INT) PARTITIONED BY (y INT);
> 0: jdbc:hive2://> SELECT * FROM t;
> 0: jdbc:hive2://> SELECT * FROM t WHERE y IS NOT NULL;
> +------+------+--+
> | t.x | t.y |
> +------+------+--+
> +------+------+--+
> 0: jdbc:hive2://> SET hive.optimize.ppd=false;
> 0: jdbc:hive2://> SELECT * FROM t WHERE y IS NOT NULL;
> Error: Error while compiling statement: FAILED: SemanticException [Error 10041]: No partition predicate found for Alias "t" Table "t" (state=42000,code=10041)
>
> Current version: 1.1.0-cdh5.11.1
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)