Hi, I' m new to drill. I have tried queries on HBASE like: SELECT＊FROM <table> WHERE <condition> LIMIT N, N is set to a small number (10 ~ 100). Total number of records in HBASE is roughly 80,000,000. Even drill has obtained the requested N rows, the query keeps on running.It seems that hbase scanning is not finished. However, the results will be returned eventually, but at the cost of scanning a lot of data.
This is very common in both Drill Shell and Drill JDBC. What is the possible solution of this ? Thanks a lot ! Yiyi
