topic Re: Using subquery in Talend Studio

Using subquery

Anonymous — Mon, 29 Apr 2013 14:23:55 GMT

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.

Re: Using subquery

Anonymous — Tue, 30 Apr 2013 10:05:47 GMT

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

Re: Using subquery

_AnonymousUser — Mon, 15 Jul 2013 11:10:45 GMT

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?

Re: Using subquery

Anonymous — Tue, 16 Jul 2013 09:06:29 GMT

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

Re: Using subquery

_AnonymousUser — Fri, 23 Aug 2013 14:49:08 GMT

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)

Re: Using subquery

Anonymous — Mon, 26 Aug 2013 03:46:45 GMT

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-connection.
Best regards
Sabrina

Re: Using subquery

Anonymous — Tue, 06 Oct 2015 09:40:45 GMT

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!

Re: Using subquery

Anonymous — Thu, 08 Oct 2015 12:46:00 GMT

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