hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rafael Mourao (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-19832) Query fails when disabling PPD optimization
Date Tue, 12 Jun 2018 17:47:00 GMT

     [ https://issues.apache.org/jira/browse/HIVE-19832?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Rafael Mourao updated HIVE-19832:
---------------------------------
    Priority: Major  (was: Minor)

> 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: Major
>
> 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 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)

Mime
View raw message