-
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..
-
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?
-
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..