Reply
Cloudera Employee
Posts: 241
Registered: ‎07-29-2015

Re: Impala join query running slow

Oh and in case anyone else reads this and wants to know if they're hitting a similar issue, you can tell that the sort will be slow because it's using a lot of memory - 47.86GB. It takes a while to sort that much data.

Explorer
Posts: 10
Registered: ‎04-02-2017

Re: Impala join query running slow

[ Edited ]

Column a.t_date is a string field, not a timestamp field. The two tables are Parquet file format.

 

By adding more nodes into the cluster, more Impala Daemon are running, can we aspect the performance for such query will be improve?

Announcements