You are viewing a plain text version of this content. The canonical link for it is here.

Posted to users@hop.apache.org by "casesolved-co-uk (via GitHub)" <gi...@apache.org> on 2025/04/04 16:46:20 UTC

[D] Merge Join - key literals? (hop)

GitHub user casesolved-co-uk created a discussion: Merge Join - key literals?

Hi,
I've just started using Hop but couldn't find the answer in the docs:
Is there a way to use literals in the Merge Join transform (and in general)?

My use-case is to replicate a query like:
SELECT *
FROM tableone t1
INNER JOIN tabletwo t2
ON t2.parent=t1.name and t2.parenttype='tableone' and t2.parentfield='somefield'

Thanks!

GitHub link: https://github.com/apache/hop/discussions/5131

----
This is an automatically sent email for users@hop.apache.org.
To unsubscribe, please send an email to: users-unsubscribe@hop.apache.org

Re: [D] Merge Join - key literals? (hop)

Posted by "casesolved-co-uk (via GitHub)" <gi...@apache.org>.

GitHub user casesolved-co-uk edited a discussion: Merge Join - key literals?

Hi,
I've just started using Hop but couldn't find the answer in the docs:
Is there a way to use literals in the Merge Join transform (and in general)?

My use-case is to replicate a query like:
SELECT *
FROM tableone t1
INNER JOIN tabletwo t2
ON t2.parent=t1.name AND t2.parenttype='tableone' AND t2.parentfield='somefield'

Thanks!

GitHub link: https://github.com/apache/hop/discussions/5131

----
This is an automatically sent email for users@hop.apache.org.
To unsubscribe, please send an email to: users-unsubscribe@hop.apache.org

Re: [D] Merge Join - key literals? (hop)

Posted by "liosc (via GitHub)" <gi...@apache.org>.

GitHub user liosc edited a comment on the discussion: Merge Join - key literals?

Some use cases could be addressed by the "Database join" transform in which you can use a SQL statement hence literals.

GitHub link: https://github.com/apache/hop/discussions/5131#discussioncomment-12736875

----
This is an automatically sent email for users@hop.apache.org.
To unsubscribe, please send an email to: users-unsubscribe@hop.apache.org

Re: [D] Merge Join - key literals? (hop)

Posted by "bamaer (via GitHub)" <gi...@apache.org>.

GitHub user bamaer edited a comment on the discussion: Merge Join - key literals?

nope. the easiest way to work around that would be to use an "Add Constants" transform to add your literal to the stream and use those in your join conditions. 

GitHub link: https://github.com/apache/hop/discussions/5131#discussioncomment-12728776

----
This is an automatically sent email for users@hop.apache.org.
To unsubscribe, please send an email to: users-unsubscribe@hop.apache.org

Re: [D] Merge Join - key literals? (hop)

Posted by "bamaer (via GitHub)" <gi...@apache.org>.

GitHub user bamaer added a comment to the discussion: Merge Join - key literals?

nope. the easiest way to work around that would be to use an "Add Constants" transform to add your literal to the stream. 

GitHub link: https://github.com/apache/hop/discussions/5131#discussioncomment-12728776

----
This is an automatically sent email for users@hop.apache.org.
To unsubscribe, please send an email to: users-unsubscribe@hop.apache.org

Re: [D] Merge Join - key literals? (hop)

Posted by "liosc (via GitHub)" <gi...@apache.org>.

GitHub user liosc added a comment to the discussion: Merge Join - key literals?

Some use case could be addressed by the "Database join" transform in which you can use a SQL statement hence literals.

GitHub link: https://github.com/apache/hop/discussions/5131#discussioncomment-12736875

----
This is an automatically sent email for users@hop.apache.org.
To unsubscribe, please send an email to: users-unsubscribe@hop.apache.org