Hi Team, I reach out to you for a specific problem regarding UNION ALL. There is one UNION ALL statement which combines 2 queries. The individual queries are taking 8 secs and 1 sec respectively. But UNION ALL takes 30 secs. PARQUET_SCAN_ROW_GROUP takes the maximum time. Apache drill version is 1.17.
Please help to suggest how to improve this UNION ALL performance. We are using parquet file. Thanks, Sreeparna Bhabani