Support the standard SQL TABLESAMPLE clause by implementing a filter that uses a skip next hint based on the region boundaries of the table to only return n rows per region.
When TABLESAMPLE clause is used, Phoenix will sample (N) percent of the the hbase table with only O(M) run time complexity. (N is size of table, M is size of stats)
Syntax of using table sampling:
select * from PERSON TABLESAMPLE(45);
select count( * ) from PERSON TABLESAMPLE (49) LIMIT 2