

# Athena 引擎版本 3 函数
<a name="functions-env3"></a>

Athena 引擎版本 3 中的函数是基于 Trino。有关 Trino 函数、运算符和表达式的信息，请参阅 [函数和运算符](https://trino.io/docs/current/functions.html) 以及 Trino 文档中的以下子章节。
+  [聚合](https://trino.io/docs/current/functions/aggregate.html) 
+  [数组](https://trino.io/docs/current/functions/array.html) 
+  [二进制](https://trino.io/docs/current/functions/binary.html) 
+  [按位运算](https://trino.io/docs/current/functions/bitwise.html) 
+  [Color (颜色)](https://trino.io/docs/current/functions/color.html) 
+  [Comparison](https://trino.io/docs/current/functions/comparison.html)（比较） 
+  [条件](https://trino.io/docs/current/functions/conditional.html) 
+  [转换](https://trino.io/docs/current/functions/conversion.html) 
+  [日期和时间](https://trino.io/docs/current/functions/datetime.html) 
+  [十进制](https://trino.io/docs/current/functions/decimal.html) 
+  [地理空间](https://trino.io/docs/current/functions/geospatial.html) 
+  [HyperLogLog](https://trino.io/docs/current/functions/hyperloglog.html) 
+  [IP 地址](https://trino.io/docs/current/functions/ipaddress.html) 
+  [JSON](https://trino.io/docs/current/functions/json.html) 
+  [Lambda](https://trino.io/docs/current/functions/lambda.html) 
+  [逻辑](https://trino.io/docs/current/functions/logical.html) 
+  [机器学习](https://trino.io/docs/current/functions/ml.html) 
+  [Map](https://trino.io/docs/current/functions/map.html) 
+  [数学](https://trino.io/docs/current/functions/math.html) 
+  [分位数摘要](https://trino.io/docs/current/functions/qdigest.html) 
+  [正则表达式](https://trino.io/docs/current/functions/regexp.html) 
+  [会话](https://trino.io/docs/current/functions/session.html) 
+  [设置摘要](https://trino.io/docs/current/functions/setdigest.html) 
+  [String](https://trino.io/docs/current/functions/string.html) 
+  [表](https://trino.io/docs/current/functions/table.html) 
+  [Teradata](https://trino.io/docs/current/functions/teradata.html) 
+  [T-摘要](https://trino.io/docs/current/functions/tdigest.html) 
+  [URL](https://trino.io/docs/current/functions/url.html) 
+  [UUID](https://trino.io/docs/current/functions/uuid.html) 
+  [窗口](https://trino.io/docs/current/functions/window.html) 

## invoker\$1principal() 函数
<a name="functions-env3-invoker-principal"></a>

`invoker_principal` 函数是 Athena 引擎版本 3 独有的，在 Trino 中找不到。

返回 `VARCHAR`，其中包含运行调用函数的查询的主体（IAM 角色或 Identity Center 标识）的 ARN。例如，如果查询调用者使用 IAM 角色的权限来运行查询，则函数将返回 IAM 角色的 ARN。运行查询的角色必须允许 `LakeFormation:GetDataLakePrincipal` 操作。

### 使用量
<a name="functions-invoker-principal-usage"></a>

```
SELECT invoker_principal()
```

下表显示了一个示例结果。


****  

| \$1 | \$1col0 | 
| --- | --- | 
| 1 | arn:aws:iam::111122223333:role/Admin | 