tony-ps-lin-appier opened a new issue, #6440: URL: https://github.com/apache/paimon/issues/6440
### Search before asking - [x] I searched in the [issues](https://github.com/apache/paimon/issues) and found nothing similar. ### Paimon version 1.2.0 ### Compute Engine spark 3.5 ### Minimal reproduce step 1. create table ``` CREATE TABLE main.test ( order_id STRING, order_price DOUBLE, order_date STRING, order_hour INT ) USING paimon PARTITIONED BY (order_date, order_hour) TBLPROPERTIES ( 'bucket-key' = 'order_id', 'bucket' = '16', 'primary-key' = 'order_date,order_hour,order_id', 'deletion-vectors.enabled' = 'true' ); ``` 2. insert some record ``` INSERT INTO main.test VALUES ('order_001', 1.0, '2025-10-10', 11) ``` 3. run a query with `DISTINCT` ``` SELECT DISTINCT order_hour FROM main.test ``` ### What doesn't meet your expectations? Resulting ``` Py4JJavaError: An error occurred while calling o154.showString. : java.lang.ClassCastException: class org.apache.paimon.data.BinaryString cannot be cast to class java.lang.Integer (org.apache.paimon.data.BinaryString is in unnamed module of loader org.apache.spark.util.MutableURLClassLoader @989da1; java.lang.Integer is in module java.base of loader 'bootstrap') ``` ### Anything else? If I modify partition columns to ``` order_date DATE, order_hour INT ``` the above error will not happen, which seems a little weird to me. But when using `DATE` type in partition columns, I will encounter another issue: [[Bug] expire_partitions procedure fails on DATE type partition columns](https://github.com/apache/paimon/issues/6439) ### Are you willing to submit a PR? - [ ] I'm willing to submit a PR! -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
