drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Prasad Nagaraj Subramanya (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-5719) Join query on a non existing column in a json file runs infinitely
Date Sun, 13 Aug 2017 17:21:00 GMT
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)

Mime
View raw message