Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

How to make join on diffent column names? #25

Open
mark-ambrazhevich-spiral opened this issue Mar 31, 2020 · 8 comments
Open

How to make join on diffent column names? #25

mark-ambrazhevich-spiral opened this issue Mar 31, 2020 · 8 comments

Comments

@mark-ambrazhevich-spiral

How to make join on different column names?
select * from t1 all left join t2 on t1.v =t2.viewId;

@evsign
Copy link
Collaborator

evsign commented Apr 3, 2020

For now this types of joins is not supported. I intend to make this possible some time later.

Just as a quick and dirty solution you may create a subquery for join where you can alias needed column for join with needed name.

@evsign evsign closed this as completed Apr 3, 2020
@mark-ambrazhevich-spiral
Copy link
Author

mark-ambrazhevich-spiral commented Apr 3, 2020

@evsign Will you accept pull request if I implement this feature?

@evsign
Copy link
Collaborator

evsign commented Apr 3, 2020

Of course! If this will be test covered and well documented, i will be very glad to accept such!)

@evsign evsign reopened this Apr 3, 2020
@evsign
Copy link
Collaborator

evsign commented Apr 3, 2020

Also expected that with this will come complete rework of joins "interface" accordingly to pretty big changes in clickhouse since time of this lib appearance).

@mark-ambrazhevich-spiral
Copy link
Author

Ok, thank you, I'll have a look.

@mark-ambrazhevich-spiral
Copy link
Author

@evsign , I made pull request, please check.
ps. This is my second github profile.

@lopn
Copy link

lopn commented Jun 4, 2021

@evsign Is there any follow-up arrangement for this feature? I want to use it

@SamAntUA
Copy link

SamAntUA commented Oct 12, 2021

I made pull request...

Has it been pulled into master? How can I use this feature?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

4 participants