Describe the bug
On running the query below on the Clickbench multi file dataset,
SELECT "SearchPhrase" FROM hits WHERE "SearchPhrase" <> '' ORDER BY to_timestamp_seconds("EventTime"), "SearchPhrase" LIMIT 10;
we get this error,
Arrow error: Invalid argument error: The data type type Binary has no natural order
To Reproduce
Download the data using,
./benchmarks/bench.sh data clickbench_partitioned
A hits_multi directory with the parquet files will be created.
Execute the above queries,
datafusion-cli -c "CREATE EXTERNAL TABLE hits STORED AS PARQUET LOCATION 'hits_multi';" "{query}"
Expected behavior
The queries should run successfully without erroring.
Additional context
Datafusion 29.0.0