Zoomdata Version

Managing Apache Phoenix Connectors

Zoomdata is able to connect to Apache Phoenix v4.7 and Phoenix Query Server v4.7 out of the box. Apache Phoenix v4.5 requires a separate download. To connect to Apache Phoenix 4.4, contact Support for more information about how to obtain the connector.

What does Apache phoenix support?

The table below lists information on the features that are supported by Apache Phoenix.

Supports Distinct Count? Yes
Supports Live Mode/ Playback? No
Supports Group-by Time? Yes
Supports Multi Group-by Charts? Yes
Supports Histogram? Yes
Supports Box Plot? No
Custom SQL Capable? No
Supports Last Value? No
Supports Partition? No
Table format? Tables, Collections

Configuring your Connectors

    • For Apache Phoenix 4.7, specify the JDBC URL in following format:
      jdbc:phoneix:zk_quorum:zk_port:zk_hbase_path
      where:
      • zk_quorum is a comma separated list of the ZooKeeper Servers
      • zk_port is the ZooKeeper port
      • zk_hbase_path is the path used by Hbase to stop information about the instance
    • For Phoenix Query Server, specify the JDBC URL in following format:
      jdbc:phoenix:thin:url=scheme://server-hostname:port
      where:
      • scheme is a transport protocol for communication with the server
      • server-hostname is the name of the host offering the service
      • port is the port number on which the host is listening

Chart Settings for Apache Phoenix

On the Charts page, you can:

  1. Edit Global Default Settings
  2. Select the Standard and, if available, Custom chart styles to be used with the data source
  3. Set default parameters (group, sub-group, colors, sorting, and so on) for each chart style

Learn more about how to customize a chart .

Select Finish to save your changes. Once your data connection has been established, it is listed under the My Data Sources section of the page.

Was this topic helpful?