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!

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog