Hi YiyiHu, This sounds like a bug. Drill should be terminating the scans once we've returned enough data. It sounds like maybe there is an issue scan termination for HBase. Can you share some more details of your setup and configuration so we can try to determine what is wrong and open a JIRA as necessary?
thanks, Jacques -- Jacques Nadeau CTO and Co-Founder, Dremio On Sat, Sep 12, 2015 at 12:50 AM, YiyiHu <[email protected]> wrote: > 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
