From the Drill Slack Channel:
Is it normal that my first query on drill is allways sooo slow? It always get
timeout or requires 40+ seconds. Successive queries take 1 or less seconds.
¿Why? I am querying a very small parquet file stored in S3.
8:43 AM
Take a look at this. First two queries.
8:43 AM
01/10/2020 13:42:04 anonymous
SELECT N_NAME as COUNTRY FROM minio_jupyter.`nation.parquet` WHERE N_REGIONKEY
= 2
Succeeded 5.421 sec 0eff029cf8dc
01/10/2020 13:37:27 anonymous
SELECT N_NAME as COUNTRY FROM minio_jupyter.`nation.parquet` WHERE N_REGIONKEY
= 2
Succeeded 33.508 sec 0eff029cf8dc
8:45 AM
In the first query, planning took 27.08 seconds
