Re: Query the HBase data in Drill

2021-08-25 Thread Charles Givre
Hi Luoc, There actually is a pending PR which we should merge before we do any additional work to the HBase plugin which is DRILL-7985 [1]. This PR introduces a new framework for pushdowns which will make it a lot easier to implement pushdowns for the various storage plugins. I would

Re: Query the HBase data in Drill

2021-08-25 Thread luoc
Thanks for the feedback. Apache HBase and Apache Phoenix are an important part of my work. And then, I'm not sure anyone have started the `HBase to EVF` for Drill, but this improvement is valuable. In particular, I found a big improvement over the Phoenix 4.x and HBase 1.x series when I

Re: Query the HBase data in Drill

2021-08-24 Thread Ted Dunning
I know somebody who is querying a very large table and has trouble with pushdown. They are looking for values indexed by primary key with a query like "select * from table where key in s". If s has a very small number of values, this turns into primary key access, but if there are more than just

Re: Query the HBase data in Drill

2021-08-24 Thread Christian Pfarr
Hi Luoc, i would like to have better filter pushdown to hbase. We see that hbase works fine with "like" Filters but for example Tableau creates very strange queries. In that case drill loads most of the rows and has to filter it by itself wich leads to poor performance. Because of that we try

Query the HBase data in Drill

2021-08-24 Thread luoc
Hello Guys, Will you use Drill to query Apache HBase? If so, what new feature would you like to see in HBase storage plugin? In addition, Drill supported the Apache Cassandra since 1.19. Absolutely… Could you tell me what your most common storage plugin (or data format) are? Thanks for your