1 Reply Latest reply on Sep 18, 2015 6:04 PM by rareddy

While creating source model from JDBC source, in our case, Teradata, No columns are imported from tables

mayur7789 Sep 18, 2015 9:04 AM

We should be able to see all columns of tables that we have selected in Import Database Objects wizard. From guides menu i clicked on Create source model for JDBC source

Everytime we try to import Teradata Database ONLY, otherwise it works for Impala Database. For Teradata, issue happens always.

Please find the screenshot of issue we are facing.

Very Urgent

1. Re: While creating source model from JDBC source, in our case, Teradata, No columns are imported from tables

rareddy Sep 18, 2015 10:58 AM (in response to mayur7789)

Look at the log (there is tab with errors), and post the contents of it. You can also check if any other client tool like SquirreL will exhibit the same issue in not showing the column information from Teradata.

Ramesh..
Actions
2. Re: While creating source model from JDBC source, in our case, Teradata, No columns are imported from tables

whiteklay Sep 18, 2015 4:38 PM (in response to rareddy)

Teiid Log says: "The table must reference one or more columns, there are none"

Then, I downloaded latest Squirrel SQL client configured it with same JDBC driver. I got following errors:
java.sql.SQLException: [Teradata Database] [TeraJDBC 15.10.00.07] [Error 5315] [SQLState HY000] The user does not have SELECT access to DBC.UDTInfo.TypeName.
        at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDatabaseSQLException(ErrorFactory.java:308)
        at com.teradata.jdbc.jdbc_4.statemachine.ReceiveInitSubState.action(ReceiveInitSubState.java:103)
        at com.teradata.jdbc.jdbc_4.statemachine.StatementReceiveState.subStateMachine(StatementReceiveState.java:309)
        at com.teradata.jdbc.jdbc_4.statemachine.StatementReceiveState.action(StatementReceiveState.java:198)
        at com.teradata.jdbc.jdbc_4.statemachine.StatementController.runBody(StatementController.java:125)
        at com.teradata.jdbc.jdbc_4.statemachine.StatementController.run(StatementController.java:116)
        at com.teradata.jdbc.jdbc_4.TDStatement.executeStatement(TDStatement.java:387)
        at com.teradata.jdbc.jdbc_4.TDStatement.executeStatement(TDStatement.java:329)
        at com.teradata.jdbc.jdbc_4.TDStatement.doNonPrepExecuteQuery(TDStatement.java:317)
        at com.teradata.jdbc.jdbc_4.TDStatement.executeQuery(TDStatement.java:1106)
        at com.teradata.jdbc.TeraDatabaseMetaData.getColumns(TeraDatabaseMetaData.java:3389)
        at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getColumns(SQLDatabaseMetaData.java:1704)
        at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getColumns(SQLDatabaseMetaData.java:1719)
        at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.table.ColumnsTab.createDataSet(ColumnsTab.java:69)
        at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.BaseDataSetTab$1.run(BaseDataSetTab.java:130)
        at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
        at java.lang.Thread.run(Thread.java:745)

On Teradata devlopers forum similar question asked by some guy as "Why do the columns not show up when you click the columns tab for a table..seems like the driver doesnt support the getcolumns() method at all ???"

Answer by Teradata guy : "The Teradata JDBC Driver supports the DatabaseMetaData.getColumns method."
Ref.: Using SQuirrel SQL Client with Teradata | Teradata Developer Exchange

What does this means? Is this something Teiid interface translator has to modify at its end or we should wait to get compatible metadata calls from Teradata JDBC driver? Or something else..
What am i doing wrong?
Actions
3. Re: While creating source model from JDBC source, in our case, Teradata, No columns are imported from tables

rareddy Sep 18, 2015 6:04 PM (in response to whiteklay)

Is this system table of some sort you are trying access? What happens if you do not try to expand and proceed with the import. If that does not work, try removing the selection of that table and import.

Ramesh..
Actions