Have a list of about 100+ SQL Count Queries to run against a Hive Data Table,
Looking for the most efficient way to run these queries.
Queries are accessed at runtime as a list of queries stored in another Hive Table, generated by a different process.
Queries like these each with a different where clause, where clauses are complex:
1. Select count(1) as count1 from MyTable where (... complex where clause here...)
2. Select Count(1) as Count1 from MyTable where (... where clause here ...)
3. etc..
Environment:
Cloudera CDH 6.2
... View more
