question get counts of rows meeting different filter criteria from hive in Support Questions

get counts of rows meeting different filter criteria from hive

ChineduLB — Sun, 19 Jan 2020 13:43:48 GMT

What is the most efficient way to get count of records meeting different search criteria from a Hive table.

1. count all records where column-a = Null

2. count all records where column-b in [1, 3, 5]

3. count all records where column-c = 'xxx'

etc.

there are a couple hundred of these counts, in groups of 3 or 4.

tsk — Mon, 20 Jan 2020 11:17:34 GMT

@ChineduLB What is your exact Query? You can write count Queries SQL for Hive table.

In general you can refer below articles:

Thanks,
Tamil Selvan K