Using Drill 1.2, which will be released soon, and the HBase storage plugin you can optimize scans of HBase tables and leverage HBase ordered byte encoding features if your data is encoded in big endian. See the Querying Big Endian-Encoded Data and Leveraging HBase Ordered Byte Encoding on http://drill.apache.org/docs/querying-hbase/.
Kristine Hahn Sr. Technical Writer 415-497-8107 @krishahn skype:krishahn 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
