Hello Dears, I have some issue with sub-query joining with tELTOracleMap. Say, that I have the below query Select * from customer c, (select customerid from product) p where c.recid = p.customerid I know that it's simple and there is no need to use sub-query in it, but it's only simple example.
Hi eng-heba, Actually, ELT components automatically generates the corresponding SQL through setting, so it cannot generate sub query. You can use t<DB> xxx to write the sub query directly. Best regards Sabrina
-- Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Hi everyone, I try to use a component tELTOracleMap but i have this message error. I need to help. the connection with my DBB is work because i developp a job with tOracleInput, tmap and tOracleOuput. my loads is working well, but my probleme i have much data to load so it takes many time. i'll be happy if someone can help me Exception in component tELTOracleOutput_1 java.sql.SQLException: The Network Adapter could not establish the connection at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70) at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:131) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:197) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:525) at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:413) at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:508) at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:203) at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:33) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:510) at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at delivery.test_0_1.Test.tELTOracleMap_1Process(Test.java:386) at delivery.test_0_1.Test.runJobInTOS(Test.java:674)
Hi Team, I am trying to use ELT components to join to Hive tables using tELTHiveMap and load into another Hive table using tELTHiveOutput. When I run the job, the job just goes on without giving any error/warning. There are no errors or warnings in the job. Just to test if there is any connectivity issue, I changed the output table name and gave a table name which is not present in the DB. The moment I do this the job fails with the error. This means there is no connection issue whatsoever. Also the join query which is generated in tELTHiveMap looks correct. I ran the query through command line and it runs absolutely fine. Appreciate your response. Please note: I am using Talend Open Studio for BIGDATA version 6.0.1. Thanks!