SQL Reference
HIVE_PARTITION_COMPONENT
hive_partition_component(name, value)
Section titled “hive_partition_component(name, value)”- name: VARCHAR
- value: ANY
Example
Section titled “Example”SELECT hive_partition_component('year', 2024);SQL Reference
SELECT hive_partition_component('year', 2024);