本文為英文版的機器翻譯版本，如內容有任何歧義或不一致之處，概以英文版為準。

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

Athena 引擎版本 3 中的函數以 Trino 為基礎。如需有關 Trino 函數、運算子和表達式的資訊，請參閱 Trino 文件中的 [Functions and operators](https://trino.io/docs/current/functions.html) (函數和運算子)，以及以下具體子節。
+  [Aggregate](https://trino.io/docs/current/functions/aggregate.html) 
+  [Array](https://trino.io/docs/current/functions/array.html) (陣列) 
+  [：二進位](https://trino.io/docs/current/functions/binary.html) 
+  [Bitwise](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) 
+  [Conversion](https://trino.io/docs/current/functions/conversion.html) (轉換) 
+  [日期和時間](https://trino.io/docs/current/functions/datetime.html) 
+  [Decimal](https://trino.io/docs/current/functions/decimal.html) (小數) 
+  [Geospatial](https://trino.io/docs/current/functions/geospatial.html) (地理空間) 
+  [HyperLogLog](https://trino.io/docs/current/functions/hyperloglog.html) 
+  [IP Address](https://trino.io/docs/current/functions/ipaddress.html) (IP 地址) 
+  [JSON](https://trino.io/docs/current/functions/json.html) 
+  [Lambda](https://trino.io/docs/current/functions/lambda.html) 
+  [Logical](https://trino.io/docs/current/functions/logical.html) (邏輯) 
+  [Machine learning](https://trino.io/docs/current/functions/ml.html) (機器學習) 
+  [Map](https://trino.io/docs/current/functions/map.html) 
+  [Math](https://trino.io/docs/current/functions/math.html) 
+  [Quantile digest](https://trino.io/docs/current/functions/qdigest.html) (分位數摘要) 
+  [Regular expression](https://trino.io/docs/current/functions/regexp.html) (常規表達式) 
+  [Session](https://trino.io/docs/current/functions/session.html) (工作階段) 
+  [Set Digest](https://trino.io/docs/current/functions/setdigest.html) 
+  [：字串](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-Digest](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 中找不到該函式。

傳回包含主體 (IAM 角色或 Identity Center 身分) 的 ARN 的 `VARCHAR`，其中該主體可執行呼叫函式的查詢。例如，如果查詢調用者使用 IAM 角色的許可來執行查詢，則函式會傳回 IAM 角色的 ARN。執行查詢的角色必須允許 `LakeFormation:GetDataLakePrincipal` 動作。

### Usage
<a name="functions-invoker-principal-usage"></a>

```
SELECT invoker_principal()
```

下列資料表會顯示範例結果。


****  

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