ClickhouseBuilder icon indicating copy to clipboard operation
ClickhouseBuilder copied to clipboard

How to make join on diffent column names?

Open mark-ambrazhevich-spiral opened this issue 4 years ago • 8 comments

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

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 avatar Apr 03 '20 12:04 evsign

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

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

evsign avatar Apr 03 '20 14:04 evsign

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).

evsign avatar Apr 03 '20 15:04 evsign

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

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

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

lopn avatar Jun 04 '21 14:06 lopn

I made pull request...

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

SamAntUA avatar Oct 12 '21 13:10 SamAntUA