0 Replies Latest reply on Jan 17, 2019 3:48 AM by gulfam galib

    Hive-Jdbc connection on teiid with wildfly

    gulfam galib Newbie

      Hey ,

                i am using these set of jars for hive-jdbc connection ...

       

      commons-codec-1.4.jar                                                                           

      hadoop-core-1.0.3-mapr-6.0.1.jar                                                                

      hive-common-2.1.1-mapr-1803.jar                                                                 

      hive-exec-2.1.1-mapr-1803.jar                                                                   

      hive-jdbc-2.1.1-mapr-1803.jar                                                                   

      hive-metastore-2.1.1-mapr-1803.jar                                                              

      hive-serde-2.1.1-mapr-1803.jar                                                                  

      hive-service-2.1.1-mapr-1803.jar                                                               

      httpclient-4.4.jar                                                                              

      httpcore-4.4.jar                                                                                

      libfb303-0.9.3.jar                                                                              

      libthrift-0.9.3.jar

       

      and while i am trying

      /subsystem=datasources/data-source=ds_name:test-connection-in-pool()

      i am getting failed status and inside server log from console i got the below error...

       

      17:05:46,509 WARN  [org.jboss.jca.core.connectionmanager.pool.strategy.OnePool] (management-handler-thread - 3)  IJ000604: Throwable while attempting to get a new connection: null: javax.resource.ResourceException: IJ031084: Unable to create connection

      at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createLocalManagedConnection(LocalManagedConnectionFactory.java:345)

      at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:352)

      at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:287)

      at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreConcurrentLinkedDequeManagedConnectionPool.createConnectionEventListener(SemaphoreConcurrentLinkedDequeManagedConnectionPool.java:1327)

      at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreConcurrentLinkedDequeManagedConnectionPool.getConnection(SemaphoreConcurrentLinkedDequeManagedConnectionPool.java:499)

      at org.jboss.jca.core.connectionmanager.pool.AbstractPool.internalTestConnection(AbstractPool.java:1067)

      at org.jboss.jca.core.connectionmanager.pool.strategy.OnePool.testConnection(OnePool.java:93)

      at org.jboss.as.connector.subsystems.common.pool.PoolOperations$TestConnectionInPool.invokeCommandOn(PoolOperations.java:240)

      at org.jboss.as.connector.subsystems.common.pool.PoolOperations$1.execute(PoolOperations.java:97)

      at org.jboss.as.controller.AbstractOperationContext.executeStep(AbstractOperationContext.java:980)

      at org.jboss.as.controller.AbstractOperationContext.processStages(AbstractOperationContext.java:726)

      at org.jboss.as.controller.AbstractOperationContext.executeOperation(AbstractOperationContext.java:450)

      at org.jboss.as.controller.OperationContextImpl.executeOperation(OperationContextImpl.java:1402)

      at org.jboss.as.controller.ModelControllerImpl.internalExecute(ModelControllerImpl.java:418)

      at org.jboss.as.controller.ModelControllerImpl.lambda$execute$1(ModelControllerImpl.java:243)

      at org.wildfly.security.auth.server.SecurityIdentity.runAs(SecurityIdentity.java:263)

      at org.wildfly.security.auth.server.SecurityIdentity.runAs(SecurityIdentity.java:229)

      at org.jboss.as.controller.ModelControllerImpl.execute(ModelControllerImpl.java:243)

      at org.jboss.as.controller.remote.ModelControllerClientOperationHandler$ExecuteRequestHandler.doExecute(ModelControllerClientOperationHandler.java:217)

      at org.jboss.as.controller.remote.ModelControllerClientOperationHandler$ExecuteRequestHandler.access$400(ModelControllerClientOperationHandler.java:137)

      at org.jboss.as.controller.remote.ModelControllerClientOperationHandler$ExecuteRequestHandler$1$1.run(ModelControllerClientOperationHandler.java:161)

      at org.jboss.as.controller.remote.ModelControllerClientOperationHandler$ExecuteRequestHandler$1$1.run(ModelControllerClientOperationHandler.java:157)

      at org.wildfly.security.auth.server.SecurityIdentity.runAs(SecurityIdentity.java:287)

      at org.wildfly.security.auth.server.SecurityIdentity.runAs(SecurityIdentity.java:244)

      at org.jboss.as.controller.AccessAuditContext.doAs(AccessAuditContext.java:254)

      at org.jboss.as.controller.AccessAuditContext.doAs(AccessAuditContext.java:225)

      at org.jboss.as.controller.remote.ModelControllerClientOperationHandler$ExecuteRequestHandler$1.execute(ModelControllerClientOperationHandler.java:157)

      at org.jboss.as.protocol.mgmt.ManagementRequestContextImpl$1.doExecute(ManagementRequestContextImpl.java:70)

      at org.jboss.as.protocol.mgmt.ManagementRequestContextImpl$AsyncTaskRunner.run(ManagementRequestContextImpl.java:160)

      at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)

      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

      at java.lang.Thread.run(Thread.java:748)

      at org.jboss.threads.JBossThread.run(JBossThread.java:320)

      Caused by: java.lang.NoClassDefFoundError: org/apache/hadoop/conf/Configuration

      at org.apache.hive.jdbc.HiveConnection.createUnderlyingTransport(HiveConnection.java:419)

      at org.apache.hive.jdbc.HiveConnection.createBinaryTransport(HiveConnection.java:439)

      at org.apache.hive.jdbc.HiveConnection.openTransport(HiveConnection.java:226)

      at org.apache.hive.jdbc.HiveConnection.<init>(HiveConnection.java:183)

      at org.apache.hive.jdbc.HiveDriver.connect(HiveDriver.java:107)

      at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createLocalManagedConnection(LocalManagedConnectionFactory.java:321)

      ... 32 more

      Caused by: java.lang.ClassNotFoundException: org.apache.hadoop.conf.Configuration from [Module "org.apache.hadoop.hive12" from local module loader @7cdbc5d3 (finder: local module finder @3aa9e816 (roots: C:\Users\gali\Desktop\teiid-10.2.0\modules,C:\Users\gali\Desktop\teiid-10.2.0\modules\system\layers\dv,C:\Users\gali\Desktop\teiid-10.2.0\modules\system\layers\base))]

      at org.jboss.modules.ModuleClassLoader.findClass(ModuleClassLoader.java:198)

      at org.jboss.modules.ConcurrentClassLoader.performLoadClassUnchecked(ConcurrentClassLoader.java:412)

      at org.jboss.modules.ConcurrentClassLoader.performLoadClass(ConcurrentClassLoader.java:400)

      at org.jboss.modules.ConcurrentClassLoader.loadClass(ConcurrentClassLoader.java:116)

      ... 38 more

       

      I am unable to solve this issue , Maybe i am missing something. Any help from your side should be helpful.

       

      Regards,

      Gulfam Galib