[ https://issues.apache.org/jira/browse/DRILL-4495?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Parth Chandra closed DRILL-4495. -------------------------------- Resolution: Fixed > IN operator does not work > ------------------------- > > Key: DRILL-4495 > URL: https://issues.apache.org/jira/browse/DRILL-4495 > Project: Apache Drill > Issue Type: Bug > Components: SQL Parser > Affects Versions: 1.6.0 > Reporter: Stefán Baxter > Priority: Blocker > > 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 -- This message was sent by Atlassian JIRA (v6.3.4#6332)