You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
Repository navigation
Commit 23a2181
Browse filesBrowse the repository at this point in the historyBrowse files
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]>
Copy file name to clipboardExpand all lines: datafusion/sqllogictest/test_files/clickbench_extended.slt
+70Lines changed: 70 additions & 0 deletions
Original file line number
Diff line number
Diff line change
@@ -61,6 +61,76 @@ SELECT COUNT(*) AS ShareCount FROM hits WHERE "IsMobile" = 1 AND "MobilePhoneMod
61
61
----
62
62
0
63
63
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;
0 commit comments