Details
-
Bug
-
Status: Open
-
Major
-
Resolution: Unresolved
-
1.11.0
-
None
-
None
Description
1) Join query on two json files
Column exists
select t.p_partkey, t1.ps_partkey from dfs.`testData/part.json` as t RIGHT JOIN dfs.`testData/partsupp.json` as t1 ON t.p_partkey = t1.ps_partkey;
Columns doesnt exist (The part_json file has no key by name partkey)
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;
part.json & partsupp.json - tpch sf1 dataset
Time taken when-
1) column exists in the file - 20secs
2) column doesnt exist in the file - 15mins