Geo intersection left anti join（几何左反连接（Geo intersection left anti join））

Supported in: Streaming

Anti joins input datasets based on whether input geometries overlap. Returns only rows from the left dataset where the geometry does not intersect with any geometry in the right dataset. Rows with null or invalid join keys are considered non-intersecting.

Transform categories: Geospatial, Join

Declared arguments

• Condition for columns to select on the left: All columns in the left input schema will be tested to see if they match this condition. If they match, the column will be selected in the output.
  ColumnPredicate
• Condition for columns to select on the right: All columns in the right input schema will be tested to see if they match this condition. If they match, the column will be selected in the output.
  ColumnPredicate
• Join key: GeoJSON columns from the left and right inputs on which to join.
  Tuple\, Column\\>
• Left dataset: Left dataset to use in join.
  Table
• Right dataset: Right dataset to use in join.
  Table
• optional Prefix for columns from right: Prefix to add to all columns on the right hand side.
  Literal\

Examples

Example 1: Base case

Argument values:

• Condition for columns to select on the left:
  allColumns(
  
  )
• Condition for columns to select on the right:
  allColumns(
  
  )
• Join key: (geometryColLhs, geometryColRhs)
• Left dataset: ri.foundry.main.dataset.left
• Right dataset: ri.foundry.main.dataset.right
• Prefix for columns from right: null

Inputs:

ri.foundry.main.dataset.left

geometryColLhs	col1Lhs
{"type":"Polygon","coordinates":[[[0.0,0.0],[0.0,10.0],[10.0,10.0],[10.0,0.0],[0.0,0.0]]]}	42.0
{"coordinates": [55.0, 5.0], "type":"Point"}	43.0

ri.foundry.main.dataset.right

geometryColRhs	col1Rhs
{"coordinates": [[[2.0, 2.0], [7.0, 2.0], [7.0, 7.0], [2.0, 7.0], [2.0, 2.0]]], "type": "Polygon"}	rhsVal1
{"coordinates": [[[12.0, 12.0], [17.0, 12.0], [17.0, 17.0], [12.0, 17.0], [12.0, 12.0]]], "type": "Polygon"}	rhsVal2
{"coordinates": [0.0, 0.0], "type":"Point"}	rhsVal3
{"coordinates": [15.0, 15.0], "type":"Point"}	rhsVal4

Output:

geometryColLhs	col1Lhs
{"coordinates": [55.0, 5.0], "type":"Point"}	43.0

---

Example 2: Base case

Argument values:

• Condition for columns to select on the left:
  allColumns(
  
  )
• Condition for columns to select on the right:
  allColumns(
  
  )
• Join key: (geometryColLhs, geometryColRhs)
• Left dataset: ri.foundry.main.dataset.left
• Right dataset: ri.foundry.main.dataset.right
• Prefix for columns from right: null

Inputs:

ri.foundry.main.dataset.left

geometryColLhs	lhs1
{}	42.0
{"type":"Polygon","coordinates":[[[0.0,0.0],[0.0,10.0],[10.0,10.0],[10.0,0.0],[0.0,0.0]]]}	43.0

ri.foundry.main.dataset.right

geometryColRhs	rhs1
{"coordinates": [[[2.0, 2.0], [7.0, 2.0], [7.0, 7.0], [2.0, 7.0], [2.0, 2.0]]], "type": "Polygon"}	rhsVal1

Output:

geometryColLhs	lhs1
{}	42.0

---

Example 3: Base case

Argument values:

• Condition for columns to select on the left:
  columnNameIsIn(
   columnNames: [lhs1],
  )
• Condition for columns to select on the right:
  allColumns(
  
  )
• Join key: (geometryColLhs, geometryColRhs)
• Left dataset: ri.foundry.main.dataset.left
• Right dataset: ri.foundry.main.dataset.right
• Prefix for columns from right: null

Inputs:

ri.foundry.main.dataset.left

geometryColLhs	lhs1
{"type":"Polygon","coordinates":[[[0.0,0.0],[0.0,10.0],[10.0,10.0],[10.0,0.0],[0.0,0.0]]]}	42.0
{"coordinates": [55.0, 5.0], "type":"Point"}	43.0

ri.foundry.main.dataset.right

geometryColRhs	rhs1
{"coordinates": [[[2.0, 2.0], [7.0, 2.0], [7.0, 7.0], [2.0, 7.0], [2.0, 2.0]]], "type": "Polygon"}	rhsVal1

Output:

lhs1
43.0

---

Example 4: Base case

Argument values:

• Condition for columns to select on the left:
  allColumns(
  
  )
• Condition for columns to select on the right:
  allColumns(
  
  )
• Join key: (geometryColLhs, geometryColRhs)
• Left dataset: ri.foundry.main.dataset.left
• Right dataset: ri.foundry.main.dataset.right
• Prefix for columns from right: null

Inputs:

ri.foundry.main.dataset.left

geometryColLhs	col1Lhs
{"type":"Polygon","coordinates":[[[0.0,0.0],[0.0,10.0],[10.0,10.0],[10.0,0.0],[0.0,0.0]]]}	1.0
{"type":"Polygon","coordinates":[[[0.0,0.0],[0.0,10.0],[10.0,10.0],[10.0,0.0],[0.0,0.0]]]}	2.0

ri.foundry.main.dataset.right

geometryColRhs	col1Rhs
{"coordinates": [[[2.0, 2.0], [7.0, 2.0], [7.0, 7.0], [2.0, 7.0], [2.0, 2.0]]], "type": "Polygon"}	rhsVal1

Output:

geometryColLhs	col1Lhs

---

Example 5: Base case

Argument values:

• Condition for columns to select on the left:
  allColumns(
  
  )
• Condition for columns to select on the right:
  allColumns(
  
  )
• Join key: (geometryColLhs, geometryColRhs)
• Left dataset: ri.foundry.main.dataset.left
• Right dataset: ri.foundry.main.dataset.right
• Prefix for columns from right: null

Inputs:

ri.foundry.main.dataset.left

geometryColLhs	col1Lhs
{"coordinates": [55.0, 5.0], "type":"Point"}	1.0
{"coordinates": [[[21.0, 21.0], [27.0, 21.0], [27.0, 27.0], [21.0, 27.0], [21.0, 21.0]]], "type": "Polygon"}	2.0
{"coordinates": [15.0, 15.0], "type":"Point"}	3.0

ri.foundry.main.dataset.right

geometryColRhs	col1Rhs
{"coordinates": [[[2.0, 2.0], [7.0, 2.0], [7.0, 7.0], [2.0, 7.0], [2.0, 2.0]]], "type": "Polygon"}	rhsVal1
{"coordinates": [0.0, 0.0], "type":"Point"}	rhsVal2

Output:

geometryColLhs	col1Lhs
{"coordinates": [55.0, 5.0], "type":"Point"}	1.0
{"coordinates": [[[21.0, 21.0], [27.0, 21.0], [27.0, 27.0], [21.0, 27.0], [21.0, 21.0]]], "type": "Polygon"}	2.0
{"coordinates": [15.0, 15.0], "type":"Point"}	3.0

---

Example 6: Base case

Argument values:

• Condition for columns to select on the left:
  allColumns(
  
  )
• Condition for columns to select on the right:
  allColumns(
  
  )
• Join key: (geometryColLhs, geometryColRhs)
• Left dataset: ri.foundry.main.dataset.left
• Right dataset: ri.foundry.main.dataset.right
• Prefix for columns from right: null

Inputs:

ri.foundry.main.dataset.left

geometryColLhs	col1Lhs
{"type":"Polygon","coordinates":[[[0.0,0.0],[0.0,10.0],[10.0,10.0],[10.0,0.0],[0.0,0.0]]]}	1.0
{"coordinates": [55.0, 5.0], "type":"Point"}	2.0
{"coordinates": [15.0, 5.0], "type":"Point"}	3.0
{"coordinates": [[[20.0, 10.0], [27.0, 10.0], [27.0, 17.0], [20.0, 17.0], [20.0, 10.0]]], "type": "Polygon"}	4.0
{"coordinates": [[[21.0, 21.0], [27.0, 21.0], [27.0, 27.0], [21.0, 27.0], [21.0, 21.0]]], "type": "Polygon"}	5.0

ri.foundry.main.dataset.right

geometryColRhs	col1Rhs
{"coordinates": [[[2.0, 2.0], [7.0, 2.0], [7.0, 7.0], [2.0, 7.0], [2.0, 2.0]]], "type": "Polygon"}	rhsVal1
{"coordinates": [0.0, 0.0], "type":"Point"}	rhsVal2
{"coordinates": [[-1.0, -1.0], [5.0, 5.0]], "type":"LineString"}	rhsVal3

Output:

geometryColLhs	col1Lhs
{"coordinates": [55.0, 5.0], "type":"Point"}	2.0
{"coordinates": [15.0, 5.0], "type":"Point"}	3.0
{"coordinates": [[[20.0, 10.0], [27.0, 10.0], [27.0, 17.0], [20.0, 17.0], [20.0, 10.0]]], "type": "Polygon"}	4.0
{"coordinates": [[[21.0, 21.0], [27.0, 21.0], [27.0, 27.0], [21.0, 27.0], [21.0, 21.0]]], "type": "Polygon"}	5.0

---

Example 7: Base case

Argument values:

• Condition for columns to select on the left:
  allColumns(
  
  )
• Condition for columns to select on the right:
  allColumns(
  
  )
• Join key: (geometryColLhs, geometryColRhs)
• Left dataset: ri.foundry.main.dataset.left
• Right dataset: ri.foundry.main.dataset.right
• Prefix for columns from right: null

Inputs:

ri.foundry.main.dataset.left

geometryColLhs	col1Lhs
{"type":"Polygon","coordinates":[[[0.0,0.0],[0.0,10.0],[10.0,10.0],[10.0,0.0],[0.0,0.0]]]}	1.0
{"coordinates": [55.0, 5.0], "type":"Point"}	2.0

ri.foundry.main.dataset.right

geometryColRhs	col1Rhs
{"coordinates": [[[2.0, 2.0], [7.0, 2.0], [7.0, 7.0], [2.0, 7.0], [2.0, 2.0]]], "type": "Polygon"}	rhsVal1
{"coordinates": [[[12.0, 12.0], [17.0, 12.0], [17.0, 17.0], [12.0, 17.0], [12.0, 12.0]]], "type": "Polygon"}	rhsVal2
{"coordinates": [0.0, 0.0], "type":"Point"}	rhsVal3
{"coordinates": [15.0, 15.0], "type":"Point"}	rhsVal4
{"coordinates": [[-1.0, -1.0], [5.0, 5.0]], "type":"LineString"}	rhsVal5
{"coordinates": [[20.0, 20.0], [21.0, 23.0]], "type":"LineString"}	rhsVal6

Output:

geometryColLhs	col1Lhs
{"coordinates": [55.0, 5.0], "type":"Point"}	2.0

---

Example 8: Base case

Argument values:

• Condition for columns to select on the left:
  allColumns(
  
  )
• Condition for columns to select on the right:
  allColumns(
  
  )
• Join key: (geometry, geometry)
• Left dataset: ri.foundry.main.dataset.left
• Right dataset: ri.foundry.main.dataset.right
• Prefix for columns from right: rhs_

Inputs:

ri.foundry.main.dataset.left

geometry	value
{"type":"Polygon","coordinates":[[[0.0,0.0],[0.0,10.0],[10.0,10.0],[10.0,0.0],[0.0,0.0]]]}	42.0
{"coordinates": [55.0, 5.0], "type":"Point"}	43.0

ri.foundry.main.dataset.right

geometry	value
{"coordinates": [[[2.0, 2.0], [7.0, 2.0], [7.0, 7.0], [2.0, 7.0], [2.0, 2.0]]], "type": "Polygon"}	rhsVal1
{"coordinates": [[[12.0, 12.0], [17.0, 12.0], [17.0, 17.0], [12.0, 17.0], [12.0, 12.0]]], "type": "Polygon"}	rhsVal2
{"coordinates": [0.0, 0.0], "type":"Point"}	rhsVal3
{"coordinates": [15.0, 15.0], "type":"Point"}	rhsVal4

Output:

geometry	value
{"coordinates": [55.0, 5.0], "type":"Point"}	43.0

---

Example 9: Base case

Argument values:

• Condition for columns to select on the left:
  columnNameIsIn(
   columnNames: [geometryColLhs],
  )
• Condition for columns to select on the right:
  allColumns(
  
  )
• Join key: (geometryColLhs, geometryColRhs)
• Left dataset: ri.foundry.main.dataset.left
• Right dataset: ri.foundry.main.dataset.right
• Prefix for columns from right: null

Inputs:

ri.foundry.main.dataset.left

geometryColLhs	col1Lhs
{"type":"Polygon","coordinates":[[[0.0,0.0],[0.0,10.0],[10.0,10.0],[10.0,0.0],[0.0,0.0]]]}	42.0
{"coordinates": [55.0, 5.0], "type":"Point"}	43.0

ri.foundry.main.dataset.right

geometryColRhs	col1Rhs
{"coordinates": [[[2.0, 2.0], [7.0, 2.0], [7.0, 7.0], [2.0, 7.0], [2.0, 2.0]]], "type": "Polygon"}	rhsVal1

Output:

geometryColLhs
{"coordinates": [55.0, 5.0], "type":"Point"}

---

Example 10: Null case

Argument values:

• Condition for columns to select on the left:
  allColumns(
  
  )
• Condition for columns to select on the right:
  allColumns(
  
  )
• Join key: (geometryColLhs, geometryColRhs)
• Left dataset: ri.foundry.main.dataset.left
• Right dataset: ri.foundry.main.dataset.right
• Prefix for columns from right: null

Inputs:

ri.foundry.main.dataset.left

geometryColLhs	lhs1
{"type":"Polygon","coordinates":[[[0.0,0.0],[0.0,10.0],[10.0,10.0],[10.0,0.0],[0.0,0.0]]]}	1.0
null	2.0
{}	3.0
{"coordinates": [55.0, 5.0], "type":"Point"}	4.0

ri.foundry.main.dataset.right

geometryColRhs	rhs1
{"coordinates": [[[2.0, 2.0], [7.0, 2.0], [7.0, 7.0], [2.0, 7.0], [2.0, 2.0]]], "type": "Polygon"}	rhsVal1
null	rhsVal2

Output:

geometryColLhs	lhs1
null	2.0
{}	3.0
{"coordinates": [55.0, 5.0], "type":"Point"}	4.0

---

Example 11: Null case

Argument values:

• Condition for columns to select on the left:
  allColumns(
  
  )
• Condition for columns to select on the right:
  allColumns(
  
  )
• Join key: (geometryColLhs, geometryColRhs)
• Left dataset: ri.foundry.main.dataset.left
• Right dataset: ri.foundry.main.dataset.right
• Prefix for columns from right: null

Inputs:

ri.foundry.main.dataset.left

geometryColLhs	lhs1
null	42.0
{"type":"Polygon","coordinates":[[[0.0,0.0],[0.0,10.0],[10.0,10.0],[10.0,0.0],[0.0,0.0]]]}	43.0

ri.foundry.main.dataset.right

geometryColRhs	rhs1
{"coordinates": [[[2.0, 2.0], [7.0, 2.0], [7.0, 7.0], [2.0, 7.0], [2.0, 2.0]]], "type": "Polygon"}	rhsVal1

Output:

geometryColLhs	lhs1
null	42.0

---

---

中文翻译

几何左反连接（Geo intersection left anti join）

支持：流式处理（Streaming）

根据输入几何对象是否重叠对输入数据集进行反连接。仅返回左侧数据集中几何对象与右侧数据集中任何几何对象均不相交的行。连接键（join key）为空或无效的行被视为不相交。

转换类别：地理空间（Geospatial）、连接（Join）

声明参数

• 左侧列选择条件： 左侧输入模式中的所有列都将被测试是否匹配此条件。如果匹配，该列将被选中输出。
  ColumnPredicate
• 右侧列选择条件： 右侧输入模式中的所有列都将被测试是否匹配此条件。如果匹配，该列将被选中输出。
  ColumnPredicate
• 连接键： 来自左侧和右侧输入的用于连接的 GeoJSON 列。
  Tuple\, Column\\>
• 左侧数据集： 用于连接的左侧数据集。
  Table
• 右侧数据集： 用于连接的右侧数据集。
  Table
• 可选 右侧列前缀： 为右侧所有列添加的前缀。
  Literal\

示例

示例 1：基本情况

参数值：

• 左侧列选择条件：
  allColumns(
  
  )
• 右侧列选择条件：
  allColumns(
  
  )
• 连接键： (geometryColLhs, geometryColRhs)
• 左侧数据集： ri.foundry.main.dataset.left
• 右侧数据集： ri.foundry.main.dataset.right
• 右侧列前缀： null

输入：

ri.foundry.main.dataset.left

geometryColLhs	col1Lhs
{"type":"Polygon","coordinates":[[[0.0,0.0],[0.0,10.0],[10.0,10.0],[10.0,0.0],[0.0,0.0]]]}	42.0
{"coordinates": [55.0, 5.0], "type":"Point"}	43.0

ri.foundry.main.dataset.right

geometryColRhs	col1Rhs
{"coordinates": [[[2.0, 2.0], [7.0, 2.0], [7.0, 7.0], [2.0, 7.0], [2.0, 2.0]]], "type": "Polygon"}	rhsVal1
{"coordinates": [[[12.0, 12.0], [17.0, 12.0], [17.0, 17.0], [12.0, 17.0], [12.0, 12.0]]], "type": "Polygon"}	rhsVal2
{"coordinates": [0.0, 0.0], "type":"Point"}	rhsVal3
{"coordinates": [15.0, 15.0], "type":"Point"}	rhsVal4

输出：

geometryColLhs	col1Lhs
{"coordinates": [55.0, 5.0], "type":"Point"}	43.0

---

示例 2：基本情况

参数值：

• 左侧列选择条件：
  allColumns(
  
  )
• 右侧列选择条件：
  allColumns(
  
  )
• 连接键： (geometryColLhs, geometryColRhs)
• 左侧数据集： ri.foundry.main.dataset.left
• 右侧数据集： ri.foundry.main.dataset.right
• 右侧列前缀： null

输入：

ri.foundry.main.dataset.left

geometryColLhs	lhs1
{}	42.0
{"type":"Polygon","coordinates":[[[0.0,0.0],[0.0,10.0],[10.0,10.0],[10.0,0.0],[0.0,0.0]]]}	43.0

ri.foundry.main.dataset.right

geometryColRhs	rhs1
{"coordinates": [[[2.0, 2.0], [7.0, 2.0], [7.0, 7.0], [2.0, 7.0], [2.0, 2.0]]], "type": "Polygon"}	rhsVal1

输出：

geometryColLhs	lhs1
{}	42.0

---

示例 3：基本情况

参数值：

• 左侧列选择条件：
  columnNameIsIn(
   columnNames: [lhs1],
  )
• 右侧列选择条件：
  allColumns(
  
  )
• 连接键： (geometryColLhs, geometryColRhs)
• 左侧数据集： ri.foundry.main.dataset.left
• 右侧数据集： ri.foundry.main.dataset.right
• 右侧列前缀： null

输入：

ri.foundry.main.dataset.left

geometryColLhs	lhs1
{"type":"Polygon","coordinates":[[[0.0,0.0],[0.0,10.0],[10.0,10.0],[10.0,0.0],[0.0,0.0]]]}	42.0
{"coordinates": [55.0, 5.0], "type":"Point"}	43.0

ri.foundry.main.dataset.right

geometryColRhs	rhs1
{"coordinates": [[[2.0, 2.0], [7.0, 2.0], [7.0, 7.0], [2.0, 7.0], [2.0, 2.0]]], "type": "Polygon"}	rhsVal1

输出：

lhs1
43.0

---

示例 4：基本情况

参数值：

• 左侧列选择条件：
  allColumns(
  
  )
• 右侧列选择条件：
  allColumns(
  
  )
• 连接键： (geometryColLhs, geometryColRhs)
• 左侧数据集： ri.foundry.main.dataset.left
• 右侧数据集： ri.foundry.main.dataset.right
• 右侧列前缀： null

输入：

ri.foundry.main.dataset.left

geometryColLhs	col1Lhs
{"type":"Polygon","coordinates":[[[0.0,0.0],[0.0,10.0],[10.0,10.0],[10.0,0.0],[0.0,0.0]]]}	1.0
{"type":"Polygon","coordinates":[[[0.0,0.0],[0.0,10.0],[10.0,10.0],[10.0,0.0],[0.0,0.0]]]}	2.0

ri.foundry.main.dataset.right

geometryColRhs	col1Rhs
{"coordinates": [[[2.0, 2.0], [7.0, 2.0], [7.0, 7.0], [2.0, 7.0], [2.0, 2.0]]], "type": "Polygon"}	rhsVal1

输出：

geometryColLhs	col1Lhs

---

示例 5：基本情况

参数值：

• 左侧列选择条件：
  allColumns(
  
  )
• 右侧列选择条件：
  allColumns(
  
  )
• 连接键： (geometryColLhs, geometryColRhs)
• 左侧数据集： ri.foundry.main.dataset.left
• 右侧数据集： ri.foundry.main.dataset.right
• 右侧列前缀： null

输入：

ri.foundry.main.dataset.left

geometryColLhs	col1Lhs
{"coordinates": [55.0, 5.0], "type":"Point"}	1.0
{"coordinates": [[[21.0, 21.0], [27.0, 21.0], [27.0, 27.0], [21.0, 27.0], [21.0, 21.0]]], "type": "Polygon"}	2.0
{"coordinates": [15.0, 15.0], "type":"Point"}	3.0

ri.foundry.main.dataset.right

geometryColRhs	col1Rhs
{"coordinates": [[[2.0, 2.0], [7.0, 2.0], [7.0, 7.0], [2.0, 7.0], [2.0, 2.0]]], "type": "Polygon"}	rhsVal1
{"coordinates": [0.0, 0.0], "type":"Point"}	rhsVal2

输出：

geometryColLhs	col1Lhs
{"coordinates": [55.0, 5.0], "type":"Point"}	1.0
{"coordinates": [[[21.0, 21.0], [27.0, 21.0], [27.0, 27.0], [21.0, 27.0], [21.0, 21.0]]], "type": "Polygon"}	2.0
{"coordinates": [15.0, 15.0], "type":"Point"}	3.0

---

示例 6：基本情况

参数值：

• 左侧列选择条件：
  allColumns(
  
  )
• 右侧列选择条件：
  allColumns(
  
  )
• 连接键： (geometryColLhs, geometryColRhs)
• 左侧数据集： ri.foundry.main.dataset.left
• 右侧数据集： ri.foundry.main.dataset.right
• 右侧列前缀： null

输入：

ri.foundry.main.dataset.left

geometryColLhs	col1Lhs
{"type":"Polygon","coordinates":[[[0.0,0.0],[0.0,10.0],[10.0,10.0],[10.0,0.0],[0.0,0.0]]]}	1.0
{"coordinates": [55.0, 5.0], "type":"Point"}	2.0
{"coordinates": [15.0, 5.0], "type":"Point"}	3.0
{"coordinates": [[[20.0, 10.0], [27.0, 10.0], [27.0, 17.0], [20.0, 17.0], [20.0, 10.0]]], "type": "Polygon"}	4.0
{"coordinates": [[[21.0, 21.0], [27.0, 21.0], [27.0, 27.0], [21.0, 27.0], [21.0, 21.0]]], "type": "Polygon"}	5.0

ri.foundry.main.dataset.right

geometryColRhs	col1Rhs
{"coordinates": [[[2.0, 2.0], [7.0, 2.0], [7.0, 7.0], [2.0, 7.0], [2.0, 2.0]]], "type": "Polygon"}	rhsVal1
{"coordinates": [0.0, 0.0], "type":"Point"}	rhsVal2
{"coordinates": [[-1.0, -1.0], [5.0, 5.0]], "type":"LineString"}	rhsVal3

输出：

geometryColLhs	col1Lhs
{"coordinates": [55.0, 5.0], "type":"Point"}	2.0
{"coordinates": [15.0, 5.0], "type":"Point"}	3.0
{"coordinates": [[[20.0, 10.0], [27.0, 10.0], [27.0, 17.0], [20.0, 17.0], [20.0, 10.0]]], "type": "Polygon"}	4.0
{"coordinates": [[[21.0, 21.0], [27.0, 21.0], [27.0, 27.0], [21.0, 27.0], [21.0, 21.0]]], "type": "Polygon"}	5.0

---

示例 7：基本情况

参数值：

• 左侧列选择条件：
  allColumns(
  
  )
• 右侧列选择条件：
  allColumns(
  
  )
• 连接键： (geometryColLhs, geometryColRhs)
• 左侧数据集： ri.foundry.main.dataset.left
• 右侧数据集： ri.foundry.main.dataset.right
• 右侧列前缀： null

输入：

ri.foundry.main.dataset.left

geometryColLhs	col1Lhs
{"type":"Polygon","coordinates":[[[0.0,0.0],[0.0,10.0],[10.0,10.0],[10.0,0.0],[0.0,0.0]]]}	1.0
{"coordinates": [55.0, 5.0], "type":"Point"}	2.0

ri.foundry.main.dataset.right

geometryColRhs	col1Rhs
{"coordinates": [[[2.0, 2.0], [7.0, 2.0], [7.0, 7.0], [2.0, 7.0], [2.0, 2.0]]], "type": "Polygon"}	rhsVal1
{"coordinates": [[[12.0, 12.0], [17.0, 12.0], [17.0, 17.0], [12.0, 17.0], [12.0, 12.0]]], "type": "Polygon"}	rhsVal2
{"coordinates": [0.0, 0.0], "type":"Point"}	rhsVal3
{"coordinates": [15.0, 15.0], "type":"Point"}	rhsVal4
{"coordinates": [[-1.0, -1.0], [5.0, 5.0]], "type":"LineString"}	rhsVal5
{"coordinates": [[20.0, 20.0], [21.0, 23.0]], "type":"LineString"}	rhsVal6

输出：

geometryColLhs	col1Lhs
{"coordinates": [55.0, 5.0], "type":"Point"}	2.0

---

示例 8：基本情况

参数值：

• 左侧列选择条件：
  allColumns(
  
  )
• 右侧列选择条件：
  allColumns(
  
  )
• 连接键： (geometry, geometry)
• 左侧数据集： ri.foundry.main.dataset.left
• 右侧数据集： ri.foundry.main.dataset.right
• 右侧列前缀： rhs_

输入：

ri.foundry.main.dataset.left

geometry	value
{"type":"Polygon","coordinates":[[[0.0,0.0],[0.0,10.0],[10.0,10.0],[10.0,0.0],[0.0,0.0]]]}	42.0
{"coordinates": [55.0, 5.0], "type":"Point"}	43.0

ri.foundry.main.dataset.right

geometry	value
{"coordinates": [[[2.0, 2.0], [7.0, 2.0], [7.0, 7.0], [2.0, 7.0], [2.0, 2.0]]], "type": "Polygon"}	rhsVal1
{"coordinates": [[[12.0, 12.0], [17.0, 12.0], [17.0, 17.0], [12.0, 17.0], [12.0, 12.0]]], "type": "Polygon"}	rhsVal2
{"coordinates": [0.0, 0.0], "type":"Point"}	rhsVal3
{"coordinates": [15.0, 15.0], "type":"Point"}	rhsVal4

输出：

geometry	value
{"coordinates": [55.0, 5.0], "type":"Point"}	43.0

---

示例 9：基本情况

参数值：

• 左侧列选择条件：
  columnNameIsIn(
   columnNames: [geometryColLhs],
  )
• 右侧列选择条件：
  allColumns(
  
  )
• 连接键： (geometryColLhs, geometryColRhs)
• 左侧数据集： ri.foundry.main.dataset.left
• 右侧数据集： ri.foundry.main.dataset.right
• 右侧列前缀： null

输入：

ri.foundry.main.dataset.left

geometryColLhs	col1Lhs
{"type":"Polygon","coordinates":[[[0.0,0.0],[0.0,10.0],[10.0,10.0],[10.0,0.0],[0.0,0.0]]]}	42.0
{"coordinates": [55.0, 5.0], "type":"Point"}	43.0

ri.foundry.main.dataset.right

geometryColRhs	col1Rhs
{"coordinates": [[[2.0, 2.0], [7.0, 2.0], [7.0, 7.0], [2.0, 7.0], [2.0, 2.0]]], "type": "Polygon"}	rhsVal1

输出：

geometryColLhs
{"coordinates": [55.0, 5.0], "type":"Point"}

---

示例 10：空值情况

参数值：

• 左侧列选择条件：
  allColumns(
  
  )
• 右侧列选择条件：
  allColumns(
  
  )
• 连接键： (geometryColLhs, geometryColRhs)
• 左侧数据集： ri.foundry.main.dataset.left
• 右侧数据集： ri.foundry.main.dataset.right
• 右侧列前缀： null

输入：

ri.foundry.main.dataset.left

geometryColLhs	lhs1
{"type":"Polygon","coordinates":[[[0.0,0.0],[0.0,10.0],[10.0,10.0],[10.0,0.0],[0.0,0.0]]]}	1.0
null	2.0
{}	3.0
{"coordinates": [55.0, 5.0], "type":"Point"}	4.0

ri.foundry.main.dataset.right

geometryColRhs	rhs1
{"coordinates": [[[2.0, 2.0], [7.0, 2.0], [7.0, 7.0], [2.0, 7.0], [2.0, 2.0]]], "type": "Polygon"}	rhsVal1
null	rhsVal2

输出：

geometryColLhs	lhs1
null	2.0
{}	3.0
{"coordinates": [55.0, 5.0], "type":"Point"}	4.0

---

示例 11：空值情况

参数值：

• 左侧列选择条件：
  allColumns(
  
  )
• 右侧列选择条件：
  allColumns(
  
  )
• 连接键： (geometryColLhs, geometryColRhs)
• 左侧数据集： ri.foundry.main.dataset.left
• 右侧数据集： ri.foundry.main.dataset.right
• 右侧列前缀： null

输入：

ri.foundry.main.dataset.left

geometryColLhs	lhs1
null	42.0
{"type":"Polygon","coordinates":[[[0.0,0.0],[0.0,10.0],[10.0,10.0],[10.0,0.0],[0.0,0.0]]]}	43.0

ri.foundry.main.dataset.right

geometryColRhs	rhs1
{"coordinates": [[[2.0, 2.0], [7.0, 2.0], [7.0, 7.0], [2.0, 7.0], [2.0, 2.0]]], "type": "Polygon"}	rhsVal1

输出：

geometryColLhs	lhs1
null	42.0

---