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

Filters with OR is not pushed down correctly

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Critical
    • Resolution: Unresolved
    • 3.1.0, 3.1.1
    • None
    • Hive, HiveServer2, llap
    • 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

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

            Dates

              Created:
              Updated: