Using subquery

One Star

Using subquery

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.
One Star

Re: Using subquery

Hi
It will be better while extracting itself you use the subquery instead of using in the Map component
One Star

Re: Using subquery

Hi,
i need to use complex subqueries so i use TELTOracleMap for each sub query but it does n't work
so please can anyone tell me how to implement oracle subqueries in talend?
Moderator

Re: Using subquery

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.
One Star

Re: Using subquery

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)
Moderator

Re: Using subquery

Hi Mdiabbs,
java.sql.SQLException: The Network Adapter could not establish the connection

I suspect it is network issue not the JDBC or ODBC driver.
Please see the related article stackoverflow.com/questions/7324125/oracle-io-exception-the-network-adapter-could-not-establish-the-....
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.
One Star

Re: Using subquery

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!
One Star

Re: Using subquery

Waiting for response Team! Appreciate if you can revert at the earliest. Thanks!