# EXT\_MERGE\_JOIN cannot perform Full Outer Join?

**URL:** https://forum.cloverdx.com/t/ext-merge-join-cannot-perform-full-outer-join/295
**Category:** CloverDX Platform
**Created:** [March 24, 2008, 12:00am UTC](https://forum.cloverdx.com/t/ext-merge-join-cannot-perform-full-outer-join/295 "2008-03-24T00:00:00Z")
**Posts on this page:** 7
**Page:** 1

<div class="post-metadata">

### Author: ![achan](https://avatars.discourse-cdn.com/v4/letter/a/7cd45c/32.png) [@achan](https://forum.cloverdx.com/u/achan)
#### Post date: [March 24, 2008, 12:00am UTC](https://forum.cloverdx.com/t/ext-merge-join-cannot-perform-full-outer-join/295/1 "2008-03-24T00:00:00Z")

</div>

graph file looks like this:

```auto

<?xml version="1.0" encoding="UTF-8"?>
<Graph name="Test" description="POC" revision="1.0">
<Global>
  <Metadata fileURL="output.fmt" id="OutMetadata"/>
  <Metadata fileURL="data1.fmt" id="InMetadata1"/>
  <Metadata fileURL="data2.fmt" id="InMetadata2"/>
</Global>
<Phase number="0">
  <Node id="INPUT1" type="DATA_READER" fileURL="data1" quoteStrings="true"/>
  <Node id="INPUT2" type="DATA_READER" fileURL="data2" quoteStrings="true"/>
  <Node id="SORT_INPUT1" type="EXT_SORT" sortKey="REFERENCE"/>
  <Node id="SORT_INPUT2" type="EXT_SORT" sortKey="REFERENCE"/>
  <Node id="JOIN" type="EXT_MERGE_JOIN" joinKey="REFERENCE" joinType="fullOuter" transformClass="myPackage.ReformatJoinTest"/>
  <Node id="OUTPUT" type="DELIMITED_DATA_WRITER" append="false" fileURL="output.txt"/>

  <Edge id="INEDGE1" fromNode="INPUT1:0" toNode="SORT_INPUT1:0" metadata="InMetadata1"/>
  <Edge id="INEDGE2" fromNode="INPUT2:0" toNode="SORT_INPUT2:0" metadata="InMetadata2"/>
  <Edge fromNode="SORT_INPUT1:0" id="INNEREDGE1" metadata="InMetadata1" toNode="JOIN:0"/>
  <Edge fromNode="SORT_INPUT2:0" id="INNEREDGE2" metadata="InMetadata2" toNode="JOIN:1"/>
  <Edge fromNode="JOIN:0" id="OUTEDGE" metadata="OutMetadata" toNode="OUTPUT:0"/>
</Phase>
</Graph>

```

data1 file:  
"000000010272 ",“WASILLA”,“AK”,99654  
"000000010273 ",“WASILLA”,“AK”,99654

data2 file:  
"000000010274 ",“address1”  
"000000010273 ",“address2”

output.txt result:  
"000000010272 ",“WASILLA”,“AK”,99654,  
"000000010273 ",“WASILLA”,“AK”,99654,“address2”

looks like it’s doing a left-outer join instead of performing a full-outer join??

any help is greatly appreciated 🙂

Thanks!

al

---

<div class="post-metadata">

### Author: ![avackova](https://avatars.discourse-cdn.com/v4/letter/a/65b543/32.png) [@avackova](https://forum.cloverdx.com/u/avackova)
#### Post date: [March 25, 2008, 1:21pm UTC](https://forum.cloverdx.com/t/ext-merge-join-cannot-perform-full-outer-join/295/2 "2008-03-25T13:21:46Z")

</div>

Hello,  
it’s really bug. I’ve found where is the problem and I’m fixing it.

---

<div class="post-metadata">

### Author: ![achan](https://avatars.discourse-cdn.com/v4/letter/a/7cd45c/32.png) [@achan](https://forum.cloverdx.com/u/achan)
#### Post date: [March 27, 2008, 3:52pm UTC](https://forum.cloverdx.com/t/ext-merge-join-cannot-perform-full-outer-join/295/3 "2008-03-27T15:52:24Z")

</div>

Hi Agata,

Do you have an estimated date of when this bug will be fixed? Please let me know what I need to do after you fix it…

Thanks,  
al

---

<div class="post-metadata">

### Author: ![avackova](https://avatars.discourse-cdn.com/v4/letter/a/65b543/32.png) [@avackova](https://forum.cloverdx.com/u/avackova)
#### Post date: [March 28, 2008, 8:22am UTC](https://forum.cloverdx.com/t/ext-merge-join-cannot-perform-full-outer-join/295/4 "2008-03-28T08:22:50Z")

</div>

Hi,  
fix is available in SVN branch 2.4 (svn://svn.berlios.de/svnroot/repos/clov … .component) and will be in nearest patch release.

---

<div class="post-metadata">

### Author: ![achan](https://avatars.discourse-cdn.com/v4/letter/a/7cd45c/32.png) [@achan](https://forum.cloverdx.com/u/achan)
#### Post date: [March 28, 2008, 4:13pm UTC](https://forum.cloverdx.com/t/ext-merge-join-cannot-perform-full-outer-join/295/5 "2008-03-28T16:13:25Z")

</div>

Hi Agata,

I could not built (using ant) from the SVN you gave me… Could you send me the JAR file instead?

Do you have a date on the next patch release? if it’s in the near future, I can wait for that too…

Thanks so much for your help 🙂

al

---

<div class="post-metadata">

### Author: ![avackova](https://avatars.discourse-cdn.com/v4/letter/a/65b543/32.png) [@avackova](https://forum.cloverdx.com/u/avackova)
#### Post date: [March 31, 2008, 8:08am UTC](https://forum.cloverdx.com/t/ext-merge-join-cannot-perform-full-outer-join/295/6 "2008-03-31T08:08:40Z")

</div>

Hi,  
patch will be released today or tomorrow 🙂 , so I’ll not send you the jar file.

---

<div class="post-metadata">

### Author: ![achan](https://avatars.discourse-cdn.com/v4/letter/a/7cd45c/32.png) [@achan](https://forum.cloverdx.com/u/achan)
#### Post date: [April 11, 2008, 9:10pm UTC](https://forum.cloverdx.com/t/ext-merge-join-cannot-perform-full-outer-join/295/7 "2008-04-11T21:10:20Z")

</div>

Hi Agata,

After downloading CloverETL rel 2.4.3, I am still not getting the correct result for full-outer join…

Using the same example,

data1 file:  
"000000010272 ",“WASILLA”,“AK”,99654  
"000000010273 ",“SACRAMENTO”,“CA”,95825

data2 file:  
"000000010274 ",“address1”  
"000000010273 ",“address2”

the output.txt is:  
"000000010273 ",“SACRAMENTO”,“CA”,95825,“address2”  
"000000010274 ",“SACRAMENTO”,“CA”,95825,“address1”

However, for full-outer join, the correct result should be:

"000000010272 ",“WASILLA”,“AK”,99654,  
"000000010273 ",“SACRAMENTO”,“CA”,95825,“address2”  
"000000010274 ",“address1”

right?? Please advice…

Thanks,  
albert