Hello,
Release: 1.18
Evaluating Drill for a large Business Reporting project.Using drill-embedded to
query Parquet data hosted in s3.Query execution on small objects/tables (<200K)
takes about 9 sec.Looking at query execution statistics, about 7-8 seconds are
spent on query planning alone.Enabled the metastore (Iceberg), ANALYZED and
REFRESH METADATA for the table.Browing the metadata store directory shows the
table's metadata files (parquet format), andquering INFORMATION_SCHEMA works as
expected.
However, query execution remains slow and running EXPLAIN still takes 7-8
seconds.
Any tips will be greatly appreciated.
- Jonathan