Phoenix Data Sources

Comment edited by Mark S :


Changes (1)

...
| MapReduce2 \\ | 2.7.1.2.4 \\ |
| YARN \\ | 2.7.1.2.4 \\ |
| HBase | 1.1.2.2.4 | |See Also:  [HDP 2.4.0 Release Notes|http://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.4.0/bk_HDP_RelNotes/content/ch_relnotes_v240.html]
{info}

Full Content

I used the above information to configure a Phoenix DataSource for a Wildfly 10 instance and I thought I would share my results.

  • Phoenix User Group Post
  • Phoenix User Group Raw Post
wildfly-10.0.0.Final/modules/org/apache/phoenix/main/module.xml
<?xml version="1.0" ?>

<module xmlns="urn:jboss:module:1.1" name="org.apache.phoenix">

  <resources>
    <resource-root path="phoenix-4.4.0.2.4.0.0-169-client.jar">
      <filter>
        <exclude-set>
          <path name="javax" />
          <path name="org/xml" />
          <path name="org/w3c/dom" />
          <path name="org/w3c/sax" />
          <path name="javax/xml/parsers" />
          <path name="com/sun/org/apache/xerces/internal/jaxp" />
          <path name="org/apache/xerces/jaxp" />
          <path name="com/sun/jersey/core/impl/provider/xml" />
        </exclude-set>
      </filter>
    </resource-root>
  </resources>

  <dependencies>
    <module name="javax.api"/>
    <module name="sun.jdk"/>
    <module name="org.apache.log4j"/>
    <module name="javax.transaction.api"/>
    <module name="org.apache.commons.logging"/>
  </dependencies>
</module>
Widlfly Datasource Snippet
<datasource jndi-name="java:jboss/datasources/PhoenixDS" pool-name="PhoenixDS" enabled="true" use-java-context="true">
  <connection-url>jdbc:phoenix:server01:/hbase-unsecure</connection-url>
  <connection-property name="phoenix.connection.autoCommit">
    true
  </connection-property>
  <driver>phoenix</driver>
  <validation>
    <check-valid-connection-sql>SELECT 1 FROM SYSTEM.CATALOG LIMIT 1</check-valid-connection-sql>
  </validation>
</datasource>
Environment
Name Version
Phoenix
4.4
Wildfly
10.0.0.Final
Ambari
2.2.1.0
HDFS
2.7.1.2.4
MapReduce2
2.7.1.2.4
YARN
2.7.1.2.4
HBase
1.1.2.2.4
See Also:  HDP 2.4.0 Release Notes
Stop watching space | Change email notification preferences
View Online | Reply To This