Count on particular partitions for particular month in hive

Question

I have a have a hive table which is partitioned with the table_date.I want to get the count of individual partition for the particular day for the particular month and particular year.

When I run the following query I am getting a count for an entire month but I want it as individual day.

select count(*) from table where month(table_date)=1 and year(table _date)=2016

Answer 1

If it is partitioned on date, I would expect this to work:

select table_date, count(*)
from table
where table_date >= '2016-01-01' and table_date < '2016-02-01'
group by table_date;

Answer 2

select table_date, count(*)
from table
where table_date between '2016-01-01' and '2016-02-01'
group by table_date;