I am not able to retrieve schema from Teradata tables.
The connection is successful but when I select any of the table it says "Failed" on the status. When I clicked next , I get the error as
Error encountered when retrieving schema.
[Teradata Database] [TeraJDBC 15.10.00.33] [Error 2646] [SQLState HY000] No more spool space in <MYUSERID>.
I am using talend real time big data platform 6.4.1
It seems to be a spool error from Teradata DB for the specific user id.
Could you please query any table from the Teradata DB though Teradata SQL Assistant Utility using same user id which you are trying to use in Talend? Most probably it will also throw error due to lack of spool space. In that case, please get assistance from Teradata DBAs to increase the spool space.
If the answer has helped you, could you please mark the topic as resolved?
No, there is no issue with Teradata.
I am able to query the table and do all the operations from Teradata Studio. Also I am able to read the data from talend
The issue is with retrieve schema feature of Talend.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables