Hi Jorge
When you get good results using embedded Drill are you running it on the
same machines where you have created your cluster?
James
On 2022/01/16 14:34, Jorge Alvarado wrote:
hi Drill community,
I was wondering if you can help again on my discovery of Drill.
I had been successfully querying multiple source such as SQL Server, MySQl, AWS
S3, even SAP HANA.
When I used the embedded run, it worked like a charm.
Then I tried to configure a small cluster with 2 drillbits and 1 zookeeper
(same cloud region, same VNet, same subnet)
Then I've noticed the queries are taking quite a long time (~30 secs)
And looking further into the querying profile I see the most part is spent on
the query planning,
which doesn't make much sense to me as the sources haven't changed, and the
queries are very simple (SELECT * FROM xxx)
Is there something I can do to "optimize" the planner? I cannot find a good
setting to update.
Thanks again for the support
Jorge
