UBarney commented on code in PR #21090:
URL: https://github.com/apache/datafusion/pull/21090#discussion_r3009835225


##########
benchmarks/queries/clickbench/extended/q8.sql:
##########
@@ -0,0 +1,4 @@
+-- Must set for ClickBench hits_partitioned dataset. See 
https://github.com/apache/datafusion/issues/16591
+-- set datafusion.execution.parquet.binary_as_string = true
+
+SELECT "RegionID", "UserAgent", "OS", 
AVG(to_timestamp("ResponseEndTiming")-to_timestamp("ResponseStartTiming")) as 
avg_response_time, 
AVG(to_timestamp("ResponseEndTiming")-to_timestamp("ConnectTiming")) as 
avg_latency FROM hits GROUP BY "RegionID", "UserAgent", "OS" ORDER BY 
avg_latency DESC limit 10;

Review Comment:
   This query was missed in [this 
PR](https://github.com/apache/datafusion/pull/16476/changes#diff-dc16b5e605f0fd85d3166b5d7aa0116fbe290eb663c9c9240973321ec283714a).
   



-- 
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]

Reply via email to