[jira] [Updated] (PHOENIX-971) Query server

["Nick Dimiduk (JIRA)" <ji...@apache.org>]

     [ 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)