[DRILL-5711] Incorrect operator profiles for queries on json files

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.11.0
• Component/s: Storage - JSON
• Assignee: Unassigned
• Reporter: Prasad Nagaraj Subramanya
• Created: 09/Aug/17 20:26
• Updated: 20/Sep/17 20:10

Description

1) Join query on two json files

select ps.ps_suppkey from dfs.`testData/json/part.josn` as p, dfs.`testData/json/partsupp.json` as ps where p.p_partkey = ps.ps_partkey;

2) Check the query profile. It has the following issues -
a) JSON_SUB_SCAN type incorrectly ordered
b) Missing SCREEN type

Attached
1) Two json files
2) Snapshot of query profile and operator profile

Commit id - 9d1d815737528251a7500621cc976b57e7f3be59