Hi Marcus,
I am glad that you are exploring Drill! Per RDBMS storage plugin documentation
[1], join pushdown is supported. So the scenario you described is likely a bug;
can you open a ticket [2] with the details on how to reproduce the issue?
Thank you,
Sudheesh
[1]
Hi all,
I started to teste Drill and I'm very excited about the possibilities.
By now I'm trying to map ours databases running on Oracle 11g. After try
some queries I realized that the amount of time Drill takes to complete is
bigger than a general sql client takes. Looking the execution plan I
I have JSON data with with a nested list and am using FLATTEN to extract
two of three list elements as:
~~~
SELECT id, FLATTEN(data)[0] AS dttm, FLATTEN(data)[1] AS result FROM ...
~~~
This works, but each FLATTEN seems to slow the query down dramatically,
3x slower with the second flatten.
