You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hop.apache.org by "Hymmen (via GitHub)" <gi...@apache.org> on 2024/04/22 09:13:12 UTC

[I] [Bug]: Database Join and Database Lookup do not change the row names if duplicate (hop)

Hymmen opened a new issue, #3849:
URL: https://github.com/apache/hop/issues/3849

   ### Apache Hop version?
   
   2.8
   
   ### Java version?
   
   openjdk version "17.0.10" 2024-01-16
   
   ### Operating system
   
   Windows
   
   ### What happened?
   
   If a row enters one of the transforms “Database Join” and ”Database Lookup” which contains some of the same field names as are added by the transform than “show output fields” shows the duplicate fields with “_1” as field names, but the passed-on row is without the changed names, so that when you try to use the _1 name, you get something like the following error:
   Eigene Ergebnisse?.0 - ERROR: Unexpected error
   Eigene Ergebnisse?.0 - ERROR: org.apache.hop.core.exception.HopException: 
   Eigene Ergebnisse?.0 - Fields 'LOESCHPROFIL_VERSION_1' used in the condition are not found in input from previous transforms
   Eigene Ergebnisse?.0 - 
   Eigene Ergebnisse?.0 - 	at org.apache.hop.pipeline.transforms.filterrows.FilterRows.checkNonExistingFields(FilterRows.java:197)
   Eigene Ergebnisse?.0 - 	at org.apache.hop.pipeline.transforms.filterrows.FilterRows.processRow(FilterRows.java:80)
   Eigene Ergebnisse?.0 - 	at org.apache.hop.pipeline.transform.RunThread.run(RunThread.java:55)
   Eigene Ergebnisse?.0 - 	at java.base/java.lang.Thread.run(Thread.java:829)
   
   The names with _1 are, in this case, selectable in “Filter Rows”, but not usable.
   
   
   ### Issue Priority
   
   Priority: 3
   
   ### Issue Component
   
   Component: Transforms


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: issues-unsubscribe@hop.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

Re: [I] [Bug]: Database Join and Database Lookup do not change the field names if duplicate (hop)

Posted by "Hymmen (via GitHub)" <gi...@apache.org>.
Hymmen commented on issue #3849:
URL: https://github.com/apache/hop/issues/3849#issuecomment-2072315029

   The error occurs in an imported PDI transformation. If I create a minimal test version in Hop the error does not appear. The two transforms are the same in the hpl files. I cannot identify yet, why the big pipeline fails with this error and and the small pipeline works.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: issues-unsubscribe@hop.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

Re: [I] [Bug]: Database Join and Database Lookup do not change the field names if duplicate (hop)

Posted by "arif-basri (via GitHub)" <gi...@apache.org>.
arif-basri commented on issue #3849:
URL: https://github.com/apache/hop/issues/3849#issuecomment-4241175269

   I've raised more detailed ticket related to this problem, hope to get resolved as soon as it is impacting my migration effort from Pentaho PDI to Apache HOP.
   
   [https://github.com/apache/hop/issues/6995](url)


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: issues-unsubscribe@hop.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

Re: [I] [Bug]: Database Join and Database Lookup do not change the field names if duplicate (hop)

Posted by "maria-lim (via GitHub)" <gi...@apache.org>.
maria-lim commented on issue #3849:
URL: https://github.com/apache/hop/issues/3849#issuecomment-3006764885

   I encounter the same issue for the pipeline imported from PDI.
   
   I tried to build the pipeline from scratch in HOP, and the issue persists.
   
   Is there a fix for this bug yet?


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: issues-unsubscribe@hop.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

Re: [I] [Bug]: Database Join and Database Lookup do not change the field names if duplicate (hop)

Posted by "hansva (via GitHub)" <gi...@apache.org>.
hansva closed issue #3849: [Bug]: Database Join and Database Lookup do not change the field names if duplicate
URL: https://github.com/apache/hop/issues/3849


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: issues-unsubscribe@hop.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org