Use HBase exclusively for data that requires, dominantly, random access to
individual records or small ranges of sequentially related records.
For everything else, including tables you primarily require building
reports regularly on, you're better off using Kudu+Impala with appropriate
partitioning. Checkout
https://kudu.apache.org/docs/schema_design.html for
a good reference on this.
Queries that perform large scans (hundreds of thousands of rows+ for ex.)
including full table scans are not the type of workload HBase is designed
for.