Hi Team, We are running into the below error when we are trying to run a simple query a partitioned table in Spark.
*MetaException(message:Filtering is supported only on partition keys of type string) * Our the partition column has been to type *date *instead of string and query is a very simple SQL as shown below. *SELECT * FROM my_table WHERE partition_col = date '2023-04-11'* Any idea why spark mandates partition columns to be of type string?. Is there a recommended work around for this issue?