I have a table with a few thousand rows in a small dev cluster and I am running a count on a ORC table and Tez is enabled.
The count takes a really really really long time or times out.
@Geoffrey Shelton Okot it is also taking the same time. I run query select count(ayx) from test_table. It took 17 Sec. and while i run select count(1) from test_table, the time remains same.
Could you please explore more about hive query fast processing.
This is an old thread, but for anyone looking at it, count(1) is the same query as count(*), so there are no performance benefits to using one over the other.