Changeset: c3b323ae9dc2 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/c3b323ae9dc2
Modified Files:
        sql/test/nested/Tests/bluesky.test.in
Branch: nested
Log Message:

q3 bluesky now runs


diffs (29 lines):

diff --git a/sql/test/nested/Tests/bluesky.test.in 
b/sql/test/nested/Tests/bluesky.test.in
--- a/sql/test/nested/Tests/bluesky.test.in
+++ b/sql/test/nested/Tests/bluesky.test.in
@@ -68,10 +68,21 @@ app.bsky.feed.repost
 1
 1
 
-# Q2 CRASH bluesky benchmark
-#query TII
-#SELECT data."commit"."collection" AS event, "hour"(epoch(cast(data.time_us as 
bigint)/(1000*1000))) as hour_of_day, count(*) AS cnt FROM bluesky WHERE 
data.kind = 'commit' AND data."commit"."operation" = 'create' AND 
data."commit"."collection" in ('app.bsky.feed.post', 'app.bsky.feed.repost', 
'app.bsky.feed.like') GROUP BY event, hour_of_day ORDER BY hour_of_day, event
-#----
+
+# Q3 bluesky benchmark
+query TII
+SELECT data."commit"."collection" AS event, "hour"(epoch(cast(data.time_us as 
bigint)/(1000*1000))) as hour_of_day, count(*) AS cnt FROM bluesky WHERE 
data.kind = 'commit' AND data."commit"."operation" = 'create' AND 
data."commit"."collection" in ('app.bsky.feed.post', 'app.bsky.feed.repost', 
'app.bsky.feed.like') GROUP BY event, hour_of_day ORDER BY hour_of_day, event
+----
+app.bsky.feed.post
+ 17
+ 3
+app.bsky.feed.like
+ 17
+ 3
+app.bsky.graph.repost
+ 17
+ 1
+
 
 # Q4
 query TT
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]

Reply via email to