왼쪽 조인

항목	값
화면 이름	Left join
식별자	`complexLeftJoinV1`
지원 실행 방식	Batch, Faster
범주	조인 (Join)

왼쪽의 모든 행을 유지하고 지정한 조건에 맞는 오른쪽 행을 결합합니다.

입력 인자

이름	지정 여부	자료형	의미와 조건
`Condition for columns to select on the left`	필수	`ColumnPredicate`	왼쪽 스키마의 각 열을 검사하여 조건에 맞는 열만 출력으로 선택합니다.
`Condition for columns to select on the right`	필수	`ColumnPredicate`	오른쪽 스키마의 각 열을 검사하여 조건에 맞는 열만 출력으로 선택합니다.
`Join condition`	필수	`Expression<Boolean>`	조인 조건입니다.
`Left dataset`	필수	`Table`	조인에 사용할 왼쪽 데이터셋입니다.
`Right dataset`	필수	`Table`	조인에 사용할 오른쪽 데이터셋입니다.
`Prefix for columns from right`	선택	`Literal<String>`	오른쪽의 모든 열에 붙일 접두사입니다.

입출력 예시

예시 1: 기본 동작

인자 값:

Condition for columns to select on the left:
columnNameIsIn(
columnNames: [tail_number, airline],
)
Condition for columns to select on the right:
columnNameIsIn(
columnNames: [home_airport],
)
Join condition:
equals(
left: tail_number,
right: tail_number,
)
Left dataset: ri.foundry.main.dataset.left
Right dataset: ri.foundry.main.dataset.right
Prefix for columns from right: null

입력:

ri.foundry.main.dataset.left

tail_number	airline	miles	factor
XB-123	foundry air	124	2
MT-222	new airline	1123	5
XB-123	foundry airline	335	5
MT-222	new air	565	4
KK-452	new air	222	1
PA-452	new air	212	2
XB-123	foundry airline	1134	2

ri.foundry.main.dataset.right

tail_number	home_airport
XB-123	LHR
MT-222	CPH
KK-452	JFK
JR-201	IAD

출력:

tail_number	airline	home_airport
XB-123	foundry air	LHR
MT-222	new airline	CPH
XB-123	foundry airline	LHR
MT-222	new air	CPH
KK-452	new air	JFK
PA-452	new air	null
XB-123	foundry airline	LHR

예시 2: 기본 동작

여러 비교를 결합한 조인 조건의 예시입니다.

인자 값:

Condition for columns to select on the left:
columnNameIsIn(
columnNames: [tail_number, airline, factor],
)
Condition for columns to select on the right:
columnNameIsIn(
columnNames: [tail_number, home_airport, factor],
)
Join condition:
lessThan(
left: factor,
right: factor,
)
Left dataset: ri.foundry.main.dataset.left
Right dataset: ri.foundry.main.dataset.right
Prefix for columns from right: right_

입력:

ri.foundry.main.dataset.left

tail_number	airline	miles	factor
XB-123	foundry air	124	2
MT-222	new airline	1123	5
XB-123	foundry airline	335	5
MT-222	new air	565	4
KK-452	new air	222	1
PA-452	new air	212	2
XB-123	foundry airline	1134	2

ri.foundry.main.dataset.right

tail_number	home_airport	factor
XB-123	LHR	2
MT-222	CPH	1
KK-452	JFK	10
JR-201	IAD	4

출력:

tail_number	airline	factor	right_tail_number	right_home_airport	right_factor
XB-123	foundry air	2	KK-452	JFK	10
XB-123	foundry air	2	JR-201	IAD	4
MT-222	new airline	5	KK-452	JFK	10
XB-123	foundry airline	5	KK-452	JFK	10
MT-222	new air	4	KK-452	JFK	10
KK-452	new air	1	XB-123	LHR	2
KK-452	new air	1	KK-452	JFK	10
KK-452	new air	1	JR-201	IAD	4
PA-452	new air	2	KK-452	JFK	10
PA-452	new air	2	JR-201	IAD	4
XB-123	foundry airline	2	KK-452	JFK	10
XB-123	foundry airline	2	JR-201	IAD	4

예시 3: 기본 동작

null과 null이 같은지를 조건으로 조인해도 해당 행은 결합하지 않습니다.

인자 값:

Condition for columns to select on the left:
columnNameIsIn(
columnNames: [tail_number, airline],
)
Condition for columns to select on the right:
columnNameIsIn(
columnNames: [home_airport],
)
Join condition:
equals(
left: tail_number,
right: tail_number,
)
Left dataset: ri.foundry.main.dataset.left
Right dataset: ri.foundry.main.dataset.right
Prefix for columns from right: null

입력:

ri.foundry.main.dataset.left

tail_number	airline	miles	factor
XB-123	foundry air	124	2
null	new airline	1123	5

ri.foundry.main.dataset.right

tail_number	home_airport
XB-123	LHR
null	CPH

출력:

tail_number	airline	home_airport
XB-123	foundry air	LHR
null	new airline	null

예시 4: 기본 동작

인자 값:

Condition for columns to select on the left:
columnNameIsIn(
columnNames: [tail_number, airline, factor],
)
Condition for columns to select on the right:
columnNameIsIn(
columnNames: [home_airport],
)
Join condition:
and(
conditions: [
equals(
left: tail_number,
right: tail_number,
),
equals(
left: factor,
right: factor,
)],
)
Left dataset: ri.foundry.main.dataset.left
Right dataset: ri.foundry.main.dataset.right
Prefix for columns from right: null

입력:

ri.foundry.main.dataset.left

tail_number	airline	miles	factor
XB-123	foundry air	124	2
MT-222	new airline	1123	5
XB-123	foundry airline	335	5
MT-222	new air	565	4
KK-452	new air	222	1
PA-452	new air	212	2
XB-123	foundry airline	1134	2

ri.foundry.main.dataset.right

tail_number	home_airport	factor
XB-123	LHR	2
MT-222	CPH	1
KK-452	JFK	10
JR-201	IAD	4

출력:

tail_number	airline	factor	home_airport
XB-123	foundry air	2	LHR
MT-222	new airline	5	null
XB-123	foundry airline	5	null
MT-222	new air	4	null
KK-452	new air	1	null
PA-452	new air	2	null
XB-123	foundry airline	2	LHR

예시 5: 기본 동작

인자 값:

Condition for columns to select on the left:
allColumns(

)
Condition for columns to select on the right:
columnNameIsIn(
columnNames: [home_airport],
)
Join condition:
equals(
left: tail_number,
right: tail_number,
)
Left dataset: ri.foundry.main.dataset.left
Right dataset: ri.foundry.main.dataset.right
Prefix for columns from right: null

입력:

ri.foundry.main.dataset.left

tail_number	airline	miles	factor
XB-123	foundry air	124	2
MT-222	new airline	1123	5
XB-123	foundry airline	335	5
MT-222	new air	565	4
KK-452	new air	222	1
PA-452	new air	212	2
XB-123	foundry airline	1134	2

ri.foundry.main.dataset.right

tail_number	home_airport
XB-123	LHR
MT-222	CPH
KK-452	JFK
JR-201	IAD

출력:

tail_number	airline	miles	factor	home_airport
XB-123	foundry air	124	2	LHR
MT-222	new airline	1123	5	CPH
XB-123	foundry airline	335	5	LHR
MT-222	new air	565	4	CPH
KK-452	new air	222	1	JFK
PA-452	new air	212	2	null
XB-123	foundry airline	1134	2	LHR

Keyboard shortcuts

팔란티어 플랫폼 한국어 해설