Error while connecting to Hive Data Source
nabanitapaul1 Oct 24, 2016 3:10 AMSo I am trying to connect to a hive data source which has Kerberos Authentication. I followed the following steps:
- I followed the steps mentioned in Connect to a Hadoop Source using Hive2 to set up the Hive Driver.
- The hive driver hive12 successfully shows in the drivers list when I select import-> teiid source model as seen below:
- Next I followed the solution given in Re: Hi All, can anyone shed some light on how to connect to hadoop using kerberos authentication? to set up Kerberos security domain in standalone.xml:
- I set up Hive data source by editing standalone.xml as mentioned in Re: Hi All, can anyone shed some light on how to connect to hadoop using kerberos authentication? solution 2nd part as follows:
- After restarting the EAP server, I select import-> Teiid Connection Source Model and select the hivetest as datasource.
- However, I face an error while deploying VDB:
- I increase the deployment timeout to 999 which is maximum that is allowed. But still face the same erros. The server log is as follows:
12:32:22,177 INFO [org.jboss.as.repository] (management-handler-thread - 16) JBAS014900: Content added at location C:\Users\cpaulna\EAP-6.4.0\standalone\data\content\4c\783b75fa2c78d8fdf2d1f6110461e5e37601fd\content
12:32:22,180 INFO [org.jboss.as.server.deployment] (MSC service thread 1-2) JBAS015876: Starting deployment of "importVDB-vdb.xml" (runtime-name: "importVDB-vdb.xml")
12:32:22,207 INFO [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-5) TEIID40118 VDB importVDB.1 added to the repository
12:32:22,207 INFO [org.teiid.RUNTIME] (MSC service thread 1-5) TEIID50029 VDB importVDB.1 model "importVDBSrcModel" metadata is currently being loaded. Start Time: 10/24/16 12:32 PM
12:32:22,218 WARN [org.teiid.RUNTIME] (teiid-async-threads - 3) TEIID50036 VDB importVDB.1 model "importVDBSrcModel" metadata failed to load. Reason:TEIID31097 Metadata load requires a connection factory: TEIID30481 Failed to find the Connection Factory with JNDI name java:/hivetest. Please check the name or deploy the Connection Factory with specified name.: org.teiid.translator.TranslatorException: TEIID31097 Metadata load requires a connection factory
at org.teiid.query.metadata.NativeMetadataRepository.loadMetadata(NativeMetadataRepository.java:57) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.metadata.ChainingMetadataRepository.loadMetadata(ChainingMetadataRepository.java:55) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.jboss.VDBService$6.run(VDBService.java:395) [teiid-jboss-integration-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.jboss.VDBService$7.run(VDBService.java:446) [teiid-jboss-integration-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_102]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_102]
at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_102]
at org.jboss.threads.JBossThread.run(JBossThread.java:122)
12:32:22,234 INFO [org.jboss.as.server] (management-handler-thread - 16) JBAS015859: Deployed "importVDB-vdb.xml" (runtime-name : "importVDB-vdb.xml")
12:32:27,390 INFO [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-5) TEIID40120 VDB importVDB.1 will be removed from the repository
12:32:27,390 INFO [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-5) TEIID40119 VDB importVDB.1 removed from the repository
12:32:27,391 INFO [org.teiid.RUNTIME] (MSC service thread 1-5) TEIID50026 VDB "importVDB.1[importVDBSrcModel{importVDBSrcModel=importVDBSrcModel, hive, java:/hivetest}]" undeployed.
12:32:27,392 INFO [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-5) TEIID40120 VDB importVDB.1 will be removed from the repository
12:32:27,394 INFO [org.jboss.as.server.deployment] (MSC service thread 1-5) JBAS015877: Stopped deployment importVDB-vdb.xml (runtime-name: importVDB-vdb.xml) in 4ms
12:32:27,426 INFO [org.jboss.as.repository] (management-handler-thread - 14) JBAS014901: Content removed from location C:\Users\cpaulna\EAP-6.4.0\standalone\data\content\4c\783b75fa2c78d8fdf2d1f6110461e5e37601fd\content
12:32:27,426 INFO [org.jboss.as.server] (management-handler-thread - 14) JBAS015858: Undeployed "importVDB-vdb.xml" (runtime-name: "importVDB-vdb.xml")
Please help me understand where is the issue and possible solution to this.
Thanks in advance!