java.lang.IllegalStateException: Some elements in the partition id list have a different length

[fqshopify]

The partitionValuesFromIdAndDataType method in BigQueryPartitionUtils.java fails when partition IDs include special BigQuery partition identifiers like __NULL__ or __UNPARTITIONED__.

Error:

java.lang.IllegalStateException: Some elements in the partition id list have a different length: [2023062822, 2023062823, __NULL__]

Root cause: The code validates that all partition IDs have the same length and are numeric. Special partition IDs like __NULL__ (8 chars, non-numeric) fail this check when mixed with e.g. hourly partitions like 2023062822 (10 chars, numeric).