xevix · August 13, 2025 06:21
diff --git a/list_hive_partitions.sql b/list_hive_partitions.sql
 WITH hive_cols AS (
  PIVOT (
    SELECT
      file.split('/').list_filter(lambda x: x.contains('=')).list_transform(lambda x: x.split('=')).unnest() AS kv,
      file
    FROM glob('/path/to/hive/**/*.parquet')
  )
  ON kv[1]
  USING first(kv[2])
 )
 FROM hive_cols;
	WITH hive_cols AS (
	PIVOT (
	SELECT
	file.split('/').list_filter(lambda x: x.contains('=')).list_transform(lambda x: x.split('=')).unnest() AS kv,
	file
	FROM glob('/path/to/hive/*/.parquet')
	)
	ON kv[1]
	USING first(kv[2])
	)
	FROM hive_cols;