appletreeisyellow commented on issue #11170: URL: https://github.com/apache/datafusion/issues/11170#issuecomment-2272373886
Hi @samuelcolvin! I'm playing around your example code [samuelcolvin/datafusion-id-experiment](https://github.com/samuelcolvin/datafusion-id-experiment) on my Mac M1 and I got empty results for all the queries. <details> <summary>Click to see what I did and what I got</summary> <br> 1. `cargo build --release` 2. `./target/release/union-scratch` 3. Got the following: ```sql loading data from simple_fixed.parquet loading data from simple_string.parquet loading data from int.parquet loading data from decimal.parquet running: select * from simple_fixed where id=arrow_cast(decode('57f16cbaf865bcd9adcc71c03200fd60', 'hex'), 'FixedSizeBinary(16)') ++ ++ query time: 102.351167ms running: select * from simple_fixed where id=arrow_cast(decode('57f16cbaf865bcd9adcc71c03200fd60', 'hex'), 'FixedSizeBinary(16)') ++ ++ query time: 81.322958ms running: select * from simple_fixed_sorted where id=arrow_cast(decode('57f16cbaf865bcd9adcc71c03200fd60', 'hex'), 'FixedSizeBinary(16)') ++ ++ query time: 89.593416ms running: select * from simple_string where id='7wIBWI3Ol4njEVD8' ++ ++ query time: 138.759125ms running: select * from simple_string where id='7wIBWI3Ol4njEVD8' ++ ++ query time: 128.254459ms running: select * from simple_string_sorted where id='7wIBWI3Ol4njEVD8' ++ ++ query time: 20.043959ms running: select * from int where id=1485542105725837362 ++ ++ query time: 77.541083ms running: select * from int where id=1485542105725837362 ++ ++ query time: 77.021583ms running: select * from int_sorted where id=1485542105725837362 ++ ++ query time: 59.955709ms running: select * from decimal where id=arrow_cast('5714204269946304998258834512.6198419457', 'Decimal128(38, 10)') ++ ++ query time: 96.231125ms running: select * from decimal where id=arrow_cast('5714204269946304998258834512.6198419457', 'Decimal128(38, 10)') ++ ++ query time: 105.458583ms running: select * from decimal_sorted where id=arrow_cast('5714204269946304998258834512.6198419457', 'Decimal128(38, 10)') ++ ++ query time: 13.88675ms ``` </details> Is this what is expected? -- 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
