topic Re: Problem with MINUS in Installing and Upgrading

Problem with MINUS

Anonymous — Sat, 16 Nov 2024 14:34:27 GMT

HI, I use TOS 2.1.1 - java
I?m trying for to create a minus.
There are 2 tables: A and B.
|A.NOME | B.NOME | A-B SQL |
|-----------+-----------+------------|
|(null) |MARIO | (null) | 1° case
|ROSSI | ROSSI | ________|
|A.NOME|B.NOME | A-B SQL |
|---------+---------+-----------|
|MARIO | (null) | MARIO | 2° case
|ROSSI | ROSSI | ________|
|A.NOME |B.NOME | A-B SQL |
|-----------+----------+------------|
|(null) | (null) | (empty) | 3° case
|ROSSI | ROSSI | ________|
|A.NOME|B.NOME| A-B SQL |
|---------+--------+-----------|
|ROSSI | (null) | (empty) | 4° case
| | ROSSI | _______ |
How can I have the same result using TOS?
I have tried with 2 tOracle inpmut and 1 tMap, but the results are different from SQL.
Thanks a lot

Re: Problem with MINUS

Anonymous — Thu, 09 Aug 2007 09:18:33 GMT

The tMinus can be 'simulated' with an left outer join and a filter on the part that is not matched. Click on the inner join rejects button, on the output table.
I?ve resolved the problem reading this posts:
http://www.talendforge.org/forum/viewtopic.php?pid=3887#p3887
http://www.talendforge.org/bugs/view.php?id=424
ciao ciao

Re: Problem with MINUS

Anonymous — Fri, 10 Aug 2007 11:26:32 GMT

With 2 tables there aren?t any problems, but with more table the results are wrongs!!
Hi, I use TOS 2.1.1 Java version,
and I try to reproduce a MINUS with 3 tables in TOS.
This is the oracle select:
select msg from log
minus
select msg from log2
minus
select cognome from paziente
I use 3 tOracleInput and 1 tMap.
I tried to 'simulated' the minus with an left outer join and a filter on the part that is not matched, but the result is wrong!!
There are my tables:
TABLE LOG
ciao
aaaa
CIAO
A1
TABLE LOG2
(null)
CIAO
CIAO2
TABLE PAZIETE
A1
(null)
rossi
The result of this MINUS in Oracle is:
-------------
ciao
aaaa
------------
Any idea?
Thanks to all

Re: Problem with MINUS

Anonymous — Fri, 10 Aug 2007 13:06:46 GMT

Hello eng,
This MINUS problem is quite difficult to handle in TOS.
We have planned to develop all those DB functions in dedicated components.
In the interval, I think that the best thing to do is to put your request directly in your tOracleInput.
Regards,
Michaël.

Re: Problem with MINUS

Anonymous — Fri, 10 Aug 2007 14:19:17 GMT

Hello Michaël!
Thanks for answer!
I find a ?little? solution. I?ve think to split the minus in more parts.
(A-B-C) = (A-B)-C
It runs
Do you have some idea about the release plan ?
When version 2.1.2 will be released?
Thank you
Regards,
Marco

Re: Problem with MINUS

Anonymous — Fri, 10 Aug 2007 15:48:30 GMT

2.1.2 will be released next week.
About a release with tMinus, I really can't say anything yet.
Michaël.