Good articles regards to tune Hive performance: Hive_performance_tune Tez_Performance_Tune . ExplainPlan
This is too broad question to answer, here are my thoughts:
1.Check is your HiveJob is getting started running in Resource manager(not in queue waiting for resources i.e Accepted state..etc)
2.Check in HDFS how many files are there in the table pointed directory, too many small files will result poor performance. and you need to consolidate all small files into big one's then run the query again.
3.Try running hive console in debug mode to see where the job is taking time to execute.
4.Check is there any skew's in the data and create table stating all these skewed columns in the table properties.