[jira] [Commented] (HIVE-22154) Filters with OR is not pushed down correctly

["Harsh Takkar (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HIVE-22154?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16917683#comment-16917683 ] 

Harsh Takkar commented on HIVE-22154:
-------------------------------------

* Filters are not properly handled in hwc code : [https://github.com/hortonworks/hive-warehouse-connector/issues/25]
 * Fixed by us in hwc
 * [https://github.com/hortonworks/hive-warehouse-connector/pull/26]
 * [https://github.com/hortonworks-spark/spark-llap/pull/274]

> Filters with OR is not pushed down correctly
> --------------------------------------------
>
>                 Key: HIVE-22154
>                 URL: https://issues.apache.org/jira/browse/HIVE-22154
>             Project: Hive
>          Issue Type: Bug
>          Components: Hive, HiveServer2, llap
>    Affects Versions: 3.1.0, 3.1.1
>            Reporter: Harsh Takkar
>            Priority: Critical
>
> As a user if we add multiple filters with "or" operator on spark dataframe it should be enclosed properly with correct brackets but in the current version of hwc multiple filters are not enclosed with proper brackets
> for e.g.
> df = df.fiter("condition1 or condition2")
> df = df.filter("condition3 and condition4")
> the resultant query created is as follows
> *(condition1) or (condition2) and (condition3) and (condition4)*
> ideally it should be as follows
> *((condition1) or (condition2)) and ((condition3) and (condition4))*



--
This message was sent by Atlassian Jira
(v8.3.2#803003)