[ 
https://issues.apache.org/jira/browse/PHOENIX-971?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Nick Dimiduk updated PHOENIX-971:
---------------------------------
    Attachment: PHOENIX-971.00.patch

Here's a simple patch for Phoenix that adds a query server and thin client via 
Apache Calcite. Most of the good work has been happening over on the Calcite 
side (thanks [~julianhyde]!). This patch is building from a Calcite snapshot 
based on a couple outstanding patches on [my 
branch|https://github.com/ndimiduk/incubator-calcite/tree/avatica-to-prod].

The server is launched using bin/queryserver.py, which depends on having 
HBASE_CONF_PATH in the environment to find hbase-site.xml. You can then use 
bin/sqlline-thin.py to connect using the thin driver. The same arguments should 
work as with the regular one, the difference being that instead of a zookeeper 
quorum, you point it at the query server host and port (i.e., 
http://localhost:8765). It will add any missing connection components based on 
defaults.

Also note that select * from WEB_STATS example table does not work right now 
due to a known Date datatype handling bug, CALCITE-660. Other common column 
types are working.

[~jamestaylor] [~gabriel.reid] please have a look, in particular at my 
additions to the maven structure and new .py scripts.

> Query server
> ------------
>
>                 Key: PHOENIX-971
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-971
>             Project: Phoenix
>          Issue Type: New Feature
>            Reporter: Andrew Purtell
>            Assignee: Nick Dimiduk
>             Fix For: 5.0.0
>
>         Attachments: PHOENIX-971.00.patch, image-2.png
>
>
> Host the JDBC driver in a query server process that can be deployed as a 
> middle tier between lighter weight clients and Phoenix+HBase. This would 
> serve a similar optional role in Phoenix deployments as the 
> [HiveServer2|https://cwiki.apache.org/confluence/display/Hive/Setting+Up+HiveServer2]
>  does in Hive deploys.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to