2 Replies Latest reply on Jun 5, 2015 10:16 AM by rareddy

    Unable to connect to Apache HBase Phoenix from Teiid Designer

    bonnysinha
    bonnysinha Jun 5, 2015 9:27 AM

      Hi,

       

      We have a target to virtualize a table in hbase phoenix using jboss developer studio. We have used the following software stack:

      On Windows 7

      1. JBoss Developer Studio 8.1.0GA

      2. Teiid Designer 9.0.2 on JBDS

      3. Teiid 8.10

      4. EAP 6.4.0 GA

       

      On  RHEL 6.5 Linux:

      1. Hadoop 2.2.0 as a single node cluster

      2. HBase 0.98

      3. Phoenix 4.2.0

       

      We followed instructions available on the documentation and from readme files in the modules folder. The issue is that we are facing an error (Result set is closed).

       

      Note: We are able to run sql queries on phoenix and we have executed sql from java using JDBC Connection. Attached is the modules.xml and server.log.

       

      Kindly help.

       

      Regards,

      Bonny.

        • 1. Re: Unable to connect to Apache HBase Phoenix from Teiid Designer
          rareddy
          rareddy Jun 5, 2015 9:47 AM (in response to bonnysinha)

          I think this may be root cause from log

           

          12:39:42,471 ERROR [org.apache.hadoop.util.Shell] (teiid-async-threads - 1)  Failed to locate the winutils binary in the hadoop binary path: java.io.IOException: Could not locate executable null\bin\winutils.exe in the Hadoop binaries.
  at org.apache.hadoop.util.Shell.getQualifiedBinPath(Shell.java:278) [phoenix-4.1.0-client-hadoop2.jar:4.1.0]
  at org.apache.hadoop.util.Shell.getWinUtilsPath(Shell.java:300) [phoenix-4.1.0-client-hadoop2.jar:4.1.0]
  at org.apache.hadoop.util.Shell.<clinit>(Shell.java:293) [phoenix-4.1.0-client-hadoop2.jar:4.1.0]
  at org.apache.hadoop.util.StringUtils.<clinit>(StringUtils.java:76) [phoenix-4.1.0-client-hadoop2.jar:4.1.0]
  at org.apache.hadoop.conf.Configuration.getStrings(Configuration.java:1514) [phoenix-4.1.0-client-hadoop2.jar:4.1.0]
  at org.apache.hadoop.hbase.zookeeper.ZKConfig.makeZKProps(ZKConfig.java:113) [phoenix-4.1.0-client-hadoop2.jar:4.1.0]
  at org.apache.hadoop.hbase.zookeeper.ZKConfig.getZKQuorumServersString(ZKConfig.java:265) [phoenix-4.1.0-client-hadoop2.jar:4.1.0]
  at org.apache.hadoop.hbase.zookeeper.ZooKeeperWatcher.<init>(ZooKeeperWatcher.java:159) [phoenix-4.1.0-client-hadoop2.jar:4.1.0]
  at org.apache.hadoop.hbase.zookeeper.ZooKeeperWatcher.<init>(ZooKeeperWatcher.java:134) [phoenix-4.1.0-client-hadoop2.jar:4.1.0]
            • Actions