[ https://issues.apache.org/jira/browse/DRILL-5711?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Prasad Nagaraj Subramanya updated DRILL-5711: --------------------------------------------- Description: 1) Join query on two json files {code} 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; {code} 2) Check the query profile 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 was: 1) Join query on two json files {code} 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; {code} 2) Check the query profile a) JSON_SUB_SCAN type incorrectly ordered b) Missing SCREEN type Attached 1) Two json files 2) Snapshot of query profile and operator profile > Incorrect operator profiles for queries on json files > ----------------------------------------------------- > > Key: DRILL-5711 > URL: https://issues.apache.org/jira/browse/DRILL-5711 > Project: Apache Drill > Issue Type: Bug > Components: Storage - JSON > Affects Versions: 1.11.0 > Reporter: Prasad Nagaraj Subramanya > Attachments: OperatorProfiles.png, part.json, partsupp.json, > QueryProfile.png > > > 1) Join query on two json files > {code} > 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; > {code} > 2) Check the query profile > 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 -- This message was sent by Atlassian JIRA (v6.4.14#64029)