You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Prasad Nagaraj Subramanya (JIRA)" <ji...@apache.org> on 2017/08/13 17:21:00 UTC

[jira] [Created] (DRILL-5719) Join query on a non existing column in a json file runs infinitely

Prasad Nagaraj Subramanya created DRILL-5719:
------------------------------------------------

             Summary: Join query on a non existing column in a json file runs infinitely
                 Key: DRILL-5719
                 URL: https://issues.apache.org/jira/browse/DRILL-5719
             Project: Apache Drill
          Issue Type: Bug
          Components: Storage - JSON
    Affects Versions: 1.11.0
            Reporter: Prasad Nagaraj Subramanya


1) Join query on two json files
{code}
select t.partkey, t1.ps_partkey from dfs.`testData/part.json` as t RIGHT JOIN dfs.`testData/partsupp.json` as t1 ON t.partkey = t1.ps_partkey;
{code}
The part_json file has no key by name partkey.

Attached part.json & partsupp.json files



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)