Skip to content

Commit 23a2181

Browse files
adriangbclaude
andcommitted
Backfill clickbench_extended.slt with queries q7-q14
The file only mirrored q0-q6; q7-q13 were added to benchmarks/queries/clickbench/extended/ without a corresponding sqllogictest entry, and this PR's new q14 would have widened that gap. Co-Authored-By: Claude Sonnet 5 <[email protected]>
1 parent 450f189 commit 23a2181

1 file changed

Lines changed: 70 additions & 0 deletions

File tree

‎datafusion/sqllogictest/test_files/clickbench_extended.slt‎

Lines changed: 70 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -61,6 +61,76 @@ SELECT COUNT(*) AS ShareCount FROM hits WHERE "IsMobile" = 1 AND "MobilePhoneMod
6161
----
6262
0
6363

64+
query IIII
65+
SELECT "WatchID", MIN("ResolutionWidth") as wmin, MAX("ResolutionWidth") as wmax, SUM("IsRefresh") as srefresh FROM hits GROUP BY "WatchID" ORDER BY "WatchID" DESC LIMIT 10;
66+
----
67+
9110818468285196899 0 0 0
68+
8924809397503602651 0 0 0
69+
8740403056911509777 0 0 0
70+
8156744413230856864 0 0 0
71+
8120543446287442873 0 0 0
72+
6864353419233967042 0 0 0
73+
6635790769678439148 0 0 0
74+
6308646140879811077 0 0 0
75+
5206346422301499756 0 0 0
76+
4894690465724379622 0 0 0
77+
78+
query III??
79+
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;
80+
----
81+
229 3 44 0 days 0 hours 0 mins 0.000000000 secs 0 days 0 hours 0 mins 0.000000000 secs
82+
197 7 39 0 days 0 hours 0 mins 0.000000000 secs 0 days 0 hours 0 mins 0.000000000 secs
83+
839 3 2 0 days 0 hours 0 mins 0.000000000 secs 0 days 0 hours 0 mins 0.000000000 secs
84+
839 0 0 0 days 0 hours 0 mins 0.000000000 secs 0 days 0 hours 0 mins 0.000000000 secs
85+
39 7 2 0 days 0 hours 0 mins 0.000000000 secs 0 days 0 hours 0 mins 0.000000000 secs
86+
87+
query I
88+
SELECT MAX(len) FROM (
89+
SELECT LENGTH(FIRST_VALUE("URL" ORDER BY "EventTime")) as len
90+
FROM hits
91+
GROUP BY "UserID"
92+
);
93+
----
94+
72
95+
96+
query I
97+
SELECT MAX(len) FROM (
98+
SELECT LENGTH(FIRST_VALUE("URL" ORDER BY "EventTime")) as len
99+
FROM hits
100+
GROUP BY "OS"
101+
);
102+
----
103+
57
104+
105+
query I
106+
SELECT MAX(fv) FROM (
107+
SELECT FIRST_VALUE("WatchID" ORDER BY "EventTime") as fv
108+
FROM hits
109+
GROUP BY "UserID"
110+
);
111+
----
112+
9110818468285196899
113+
114+
query I
115+
SELECT MAX(fv) FROM (
116+
SELECT FIRST_VALUE("WatchID" ORDER BY "EventTime") as fv
117+
FROM hits
118+
GROUP BY "OS"
119+
);
120+
----
121+
9110818468285196899
122+
123+
query I
124+
SELECT SUM("CounterID") AS counter_id_sum
125+
FROM hits
126+
WHERE "URL" < 'zzzz';
127+
----
128+
173
129+
130+
query TII
131+
SELECT "SearchPhrase", COUNT(*) AS c, COUNT(DISTINCT "MobilePhoneModel") AS models FROM hits WHERE "SearchPhrase" <> '' GROUP BY "SearchPhrase" ORDER BY c DESC LIMIT 10;
132+
----
133+
64134

65135
statement ok
66136
drop table hits;

0 commit comments

Comments
 (0)