How about a comparison to the current integration work with SparkSQL? Wouldn't a shorter path to a sql REPL loop be finishing that work?
On Sep 28, 2017 01:53, "Yung-An He" <[email protected]> wrote: > 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 <[email protected]>: > > > 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 <[email protected]> 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. > > > > > >
