Rafael Mourao created HIVE-19832:
------------------------------------
Summary: 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
Environment: :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)
Reporter: Rafael Mourao
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)
