Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-22154

Filters with OR is not pushed down correctly

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Critical
    • Resolution: Unresolved
    • Affects Version/s: 3.1.0, 3.1.1
    • Fix Version/s: None
    • Component/s: Hive, HiveServer2, llap
    • Labels:
      None

      Description

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

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              takkarharsh Harsh Takkar
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated: