[
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. 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
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
Commit id - 9d1d815737528251a7500621cc976b57e7f3be59
> 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. 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
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
