Hive Functions slow too much my query

[#1]

Hello  I'm new to the community and to cloudera/big data in general, 

I am having issues with hive performance I have for example a table of 600 records and when I use a select * it runs in .05 seconds but if I use for example a count(*) or any function it runs in like 17 seconds, do any have any tip or trick to check performance or what parameter to check/modify in order to improve this execution time?

My enviroment are CDH 6.1.0 withHive 2.1.1-cdh6.1.0

Thank you in advance 

Ulises Rangel

[#2]

Hi Ulises,

This is expected.

When you do select *  without any complex aggregation / function hive can directly read the data from hdfs / files

But in case of count it need to do computation which involve creating job and doing the required aggregation which will take time.

[#3]

Thanks for the reply 

I know is a normal thing to happend but is there anything I could check in order to know if there is something wrong with my configuration?  or maybe a job trace, I am a newbie in this topics

[#4 · Accepted solution]

Yes, there are lot of places to check but without knowing what are you looking for you will be lost.

You can start with what you see on screen / console where you run the query.

In beeline you see tez job summary which has lot of details to look at.

example of one of the tuning guide is below

https://community.cloudera.com/t5/Community-Articles/Demystify-Apache-Tez-Memory-Tuning-Step-by-Step...

Update: I see you are using cdh6 which does not have tez.

You can refer below link for cdh
https://docs.cloudera.com/documentation/enterprise/6/6.1/topics/admin_hive_tuning.html#concept_u51_l...

[#5]

Thanks  I will start from there