- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
get counts of rows meeting different filter criteria from hive
- Labels:
-
Apache Hive
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Created ‎01-20-2020 03:17 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@ChineduLB What is your exact Query? You can write count Queries SQL for Hive table.
In general you can refer below articles:
https://www.qubole.com/blog/5-tips-for-efficient-hive-queries/
Thanks,
Tamil Selvan K
Created ‎01-20-2020 03:17 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@ChineduLB What is your exact Query? You can write count Queries SQL for Hive table.
In general you can refer below articles:
https://www.qubole.com/blog/5-tips-for-efficient-hive-queries/
Thanks,
Tamil Selvan K
