[DRILL-1287] Queries using "where" filter followed by "IN" operator over JSON data fails

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.5.0
• Component/s: Storage - JSON
• Assignee: DrillCommitter
• Reporter: Rahul Kumar Challapalli
• Created: 12/Aug/14 09:22
• Updated: 01/May/15 22:47
• Resolved: 30/Aug/14 01:07

Description

git.commit.id.abbrev=98b208e

Below is the simplified query which is producing the issue

select
  o.o_orderkey
from
  orders o
where
  o.o_orderkey in (
    select
      l_orderkey
    from
      lineitem
  );

Query failed: Failure while running fragment. Unexpected project expression or reference [afdf541d-56c2-4f4e-a107-8a0ab6169ba2]

This issue is affecting TPCH queries 16 and 18. I attached the complete TPCH queries, data files and the error log