Thanks for comments and suggestions, I add a section about the comparison of our solution and Phoenix in the proposal. And Here is the link: https://drive.google.com/file/d/0Bw6_ESGWcwIqVVgybW5OaE43bzg/view
Below are some differences between HBaseQL and Phoenix: 1. In some scenarios, users could not and would not restart the HBase when installing third-party tools. 2. In Phoenix, when creating a table, it will create a real HBase table. And it would also drop HBase table when executing DROP TABLE. In HBaseQL, no matter what the above situation is, it will not create or delete native HBase tables. 3. If you want to map an existing HBase table to Phoenix, then you have to create a View in the Phoenix and that View will be read-only. We can only see the data as well as we can not modify or insert new data through Phoenix. In HBaseQL, when you create a table, it means mapping an existing HBase table instead of creating a new one. And you can not only see the data but also modify or insert new data. 4. HBaseQL is designed to make HBase handy for users that are already familiar with SQL syntax and does not affect the raw data. Based on this, it only supports single table query to avoid excessive consumption of resources. 2017-09-28 11:14 GMT+08:00 Chia-Ping Tsai <chia7...@apache.org>: > Could you share the comparison of your solution and Phoenix? I feel you > will contribute a significant improvement (and a chunk of code) to hbase, > so we must understand what benefit HBaseQL can bring to hbase. > > > On 2017-09-27 22:27, Yung-An He <mathst...@gmail.com> wrote: > > Hi folks, > > > > Currently, HBase hasn’t support SQL syntax yet. Many users who are > familiar > > with SQL syntax can only query data from HBase via Hive, Impala, Phoenix > or > > other tools that support SQL syntax. However, some tools are too > > complicated to install and need to restart the HBase cluster. > Additionally, > > there may be side effects that affect raw data. If HBase has a native SQL > > querying module which is easy to install without restarting the cluster > as > > well as not affecting the original data, it would be extremely helpful > and > > handy for users that are already familiar with SQL syntax. > > > > In HareDB, we have implemented HareQL, and hope that we can contribute > some > > piece as a module to HBase. See attached document for more details. > > >
