CODEWITHSUNDEEP
hadoophive
Harish
Harish

Reputation: 613

Select Count(*) Not working in Hive

When i tried to select count(*) from table in hive . the job is stuck as shown in the screenshot. Please advise. Did I miss the setting somewhere. But I am able to select based on where conditon.

enter image description here

Upvotes: 0

Views: 5490

Answers (1)

surajs1n
surajs1n

Reputation: 1583

First, set use of stats for small queries to false.

set hive.compute.query.using.stats=false

Then, run select count(*) from table code, it should work.

Upvotes: 3

Related Questions