Apache Drill Hbase Query - Audit Columns

Question

How can I write queries to extract data on condition based on audit columns like TimeRange, etc.

I am actually looking to filter data based on timestamp i.e. basically extracting data for a specific version

Answer 1

As per Write Drill query output to csv (or some other format)

use dfs.tmp; 
alter session set `store.format`='csv';
create table dfs.tmp.my_output as select * from cp.`employee.json`;