Got NullPointerException when i was trying to load hive server2 vdb

[kulbhushanc]

Hi,

connection from hive2 is made successfully, but when i am trying to deploy VDB i got this exception:-

18:16:21,735 INFO  [org.teiid.RUNTIME] (MSC service thread 1-1)  TEIID50029 VDB

SvcSourceVdb_TESTDSHIVESERVER220170424181619108.1 model "TESTDSHIVESERVER2201704

24181619108" metadata is currently being loaded. Start Time: 4/24/17 6:16 PM

18:16:21,873 INFO  [org.jboss.as.server] (management-handler-thread - 3)  WFLYSR

V0010: Deployed "SvcSourceVdb_TESTDSHIVESERVER220170424181619108-vdb.xml" (runti

me-name : "SvcSourceVdb_TESTDSHIVESERVER220170424181619108-vdb.xml")

18:16:22,350 INFO  [org.teiid.CONNECTOR] (Worker0_async-teiid-threads0)  TEIID11

002 Failed to report the JDBC driver and connection information

18:16:24,435 WARN  [org.teiid.RUNTIME] (Worker0_async-teiid-threads0)  TEIID5003

6 VDB SvcSourceVdb_TESTDSHIVESERVER220170424181619108.1 model "TESTDSHIVESERVER2

20170424181619108" metadata failed to load. Reason:java.lang.NullPointerExceptio

n: java.lang.NullPointerException

        at org.teiid.translator.hive.HiveMetadataProcessor.getRuntimeType(HiveMe

tadataProcessor.java:89)

        at org.teiid.translator.hive.HiveMetadataProcessor.addTable(HiveMetadata

Processor.java:147)

        at org.teiid.translator.hive.HiveMetadataProcessor.getConnectorMetadata(

HiveMetadataProcessor.java:73)

        at org.teiid.translator.jdbc.JDBCExecutionFactory.getMetadata(JDBCExecut

ionFactory.java:306)

        at org.teiid.translator.jdbc.JDBCExecutionFactory.getMetadata(JDBCExecut

ionFactory.java:69)

        at org.teiid.query.metadata.NativeMetadataRepository.getMetadata(NativeM

etadataRepository.java:96)

        at org.teiid.query.metadata.NativeMetadataRepository.loadMetadata(Native

MetadataRepository.java:62)

        at org.teiid.query.metadata.ChainingMetadataRepository.loadMetadata(Chai

ningMetadataRepository.java:55)

        at org.teiid.jboss.VDBService$6.run(VDBService.java:360)

        at org.teiid.jboss.VDBService$7.run(VDBService.java:411)

        at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkCon

text.java:282)

        at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.ru

n(ThreadReuseExecutor.java:119)

        at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseE

xecutor.java:210)

        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.

java:1142)

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor

.java:617)

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

And here is my vdb,

<vdb name="SvcSourceVdb_hiveds" version="1">

    <description>VDB for: SvcSourceVdb_hiveds, Version: 1</description>

    <connection-type>BY_VERSION</connection-type>

    <model name="hiveds" type="PHYSICAL" visible="true">

        <property name="importer.tableTypes" value="TABLE"></property>

        <source name="hiveds" translator-name="hive" connection-jndi-name="java:/hiveds"></source>

    </model>

</vdb>

what can i do?

thanks,
kulbhushan

[shawkins]

I believe we've seen this before, but I can't find a reference.  The Teiid logic here is issuing "describe table", but for one of the columns a null type name is being reported.  What version of hive and the hive driver are you using?

[kulbhushanc]

When i connect with another database it is working fine i thought that there was some issue in database... thanks for your update.

[shawkins]

Were any of the tables empty?

[kulbhushanc]

Yes, The database has some empty tables

[rareddy]

You should exclude these tables from the import.

[shawkins]

I'll capture this as a known issue on the doc page.