Products | Versions |
---|---|
TIBCO Data Virtualization | All supported versions |
Introspection of Impala data source in TIBCO Data Virtualization(TDV) fails with the following error message:
ADD Failed: java.sql.SQLException: [Simba][JDBC](10360) Column name not found: TABLE_MD. java.sql.SQLException: [Simba][JDBC](10360) Column name not found: TABLE_MD. at com.cloudera.exceptions.ExceptionConverter.toSQLException(Unknown Source) at com.cloudera.jdbc.common.SForwardResultSet.findColumn(Unknown Source) at com.cloudera.jdbc.common.SForwardResultSet.getString(Unknown Source) at com.compositesw.cdms.ds.jdbc.JdbcIntrospector2.getDbmdStringResult(JdbcIntrospector2.java:1709) at com.compositesw.cdms.ds.jdbc.JdbcIntrospector2.getSchemaFromDbmdGetColumns(JdbcIntrospector2.java:1887) at com.compositesw.cdms.ds.impala.ImpalaIntrospector2.introspectColumns(ImpalaIntrospector2.java:341) at com.compositesw.cdms.ds.impala.ImpalaIntrospector2.introspectTable(ImpalaIntrospector2.java:296) at com.compositesw.cdms.ds.impala.ImpalaIntrospector2.introspectResource(ImpalaIntrospector2.java:204) at com.compositesw.cdms.datasource.introspect.AbstractIntrospector2.introspectResourcesNoBatch(AbstractIntrospector2.java:592) at com.compositesw.cdms.datasource.introspect.AbstractIntrospector2.introspectTables(AbstractIntrospector2.java:521) at com.compositesw.cdms.datasource.introspect.Introspector2Wrapper.introspectTables(Introspector2Wrapper.java:571) at com.compositesw.cdms.datasource.introspect.AbstractIntrospector2.introspectResources(AbstractIntrospector2.java:425) at com.compositesw.cdms.datasource.introspect.IntrospectionDriver.processResourceBatchToAddInternal(IntrospectionDriver.java:905) at com.compositesw.cdms.datasource.introspect.IntrospectionDriver.access$300(IntrospectionDriver.java:65) at com.compositesw.cdms.datasource.introspect.IntrospectionDriver$1.call(IntrospectionDriver.java:776) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source)
Screenshot for reference:
To resolve this issue, perform the following steps:
(1) For backup purpose, make a copy of the "impala.capabilities" file located at [TDV_server]\apps\dlm\cis_ds_impala\conf in a separate location.
Please note, if building a custom adapter, changes are still expected to be made to the impala.capabilities file..
(2) For the original impala.capabilities file present under [TDV_server]\apps\dlm\cis_ds_impala\conf, remove / comment the below line and save the file.
#introspect.column.table_schem: TABLE_MD
Please note, if performed an in-place upgrade, the versioned capability files would exist and changes are expected to be made to that capability file. For example, if TDV upgrade was performed from 8.2 to 8.3, above changes need to be made to the versioned 8.3 capability file which would be named as impala-080300001.capabilities.
(3) Restart TDV Server for the changes to take effect.
(4) Re-login to Studio and re-run the introspection for the Impala data source.