Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-4495

IN operator does not work

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Blocker
    • Resolution: Fixed
    • 1.6.0
    • None
    • SQL Parser
    • None

    Description

      I noticed that using the IN operator with a sub structure has stopped working:

      select s.client_ip.ip from dfs.asa.`/processed/venuepoint/transactions` as s where s.client_ip.ip in ("unknown") limit 2;
      Error: PARSE ERROR: Encountered "\"" at line 1, column 103.
      Was expecting one of:
      ...
      SQL Query select s.client_ip.ip from dfs.asa.`/processed/venuepoint/transactions` as s where s.client_ip.ip in ("2.69.200.113","unknown") limit 2
      ^
      (the hat should point at the _ip part of the where clause)

      I will report this in Jira and mark it as a blocker.

      The IN works with nothing here using the latest 1.6-SNAPSHOT

      Attachments

        Activity

          People

            Unassigned Unassigned
            acmeguy Stefán Baxter
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: