SEGMENT_
On this page
Segment_
Syntax
SELECT a, SEGMENT_ID(t) FROM t WHERE SEGMENT_ID(t) = 1;
Return Type
Integer.
Example
SELECT asset_desc, SEGMENT_ID(assets) FROM assets WHERE SEGMENT_ID(assets) = 3000002;
+-----------------+--------------------+
| asset_desc | segment_id(assets) |
+-----------------+--------------------+
| mac_book_pro | 3000002 |
| mac_book_pro | 3000002 |
| iphone_13 | 3000002 |
| mac_book_air_M1 | 3000002 |
| mac_book_pro | 3000002 |
+-----------------+--------------------+Note
This built-in works only on columnstore tables.
Related Info
-
See JSON_
AGG for the table and values used in the example above.
Last modified: March 11, 2024