please check, if set hive.map.aggr=true or not. Please change the table to ORC format and try to run only subquery. I hope, results should come fast. Please check, if table can be bucketed on emp_type or not. try to implement SMB join.
... View more
Hi Guil, What is the benefit of running Hive QLs in spark-shell. Can't I change the hive.execution.engine to spark and do the querying? thanks
... View more
