benchmark: Drop side_input table from most Nexmark queries.

blp · blp · commit a852daa83e6a · 2024-11-06T00:40:20.000Z
Only query q13 uses the `side_input` table but all of them had it defined.
This moves it to just query q13, because having it in the others kept them
from working with fault tolerance (because `side_input` uses the datagen
connect that doesn't implement FT yet).

Signed-off-by: Ben Pfaff &lt;blp@feldera.com&gt;
diff --git a/benchmark/feldera-sql/benchmarks/nexmark/queries/q13.sql b/benchmark/feldera-sql/benchmarks/nexmark/queries/q13.sql
@@ -1,3 +1,24 @@
+CREATE TABLE side_input (
+  date_time TIMESTAMP,
+  key BIGINT,
+  value VARCHAR
+) WITH ('connectors' = '[{
+  "transport": {
+      "name": "datagen",
+      "config": {
+        "plan": [
+          {
+            "limit": 100,
+            "fields": {
+              "date_time": { "range": [1724444408000, 4102444800000] },
+              "key": { "range": [0, 100] }
+            }
+          }
+        ]
+      }
+    }
+}]');
+
 CREATE VIEW Q13 AS
 SELECT
     B.auction,
diff --git a/benchmark/feldera-sql/benchmarks/nexmark/table.sql b/benchmark/feldera-sql/benchmarks/nexmark/table.sql
@@ -74,23 +74,3 @@ CREATE TABLE bid (
 	"max_batch_size": 160000
     }}
 ]');
-CREATE TABLE side_input (
-  date_time TIMESTAMP,
-  key BIGINT,
-  value VARCHAR
-) WITH ('connectors' = '[{{
-  "transport": {{
-      "name": "datagen",
-      "config": {{
-        "plan": [
-          {{
-            "limit": 100,
-            "fields": {{
-              "date_time": {{ "range": [1724444408000, 4102444800000] }},
-              "key": {{ "range": [0, 100] }}
-            }}
-          }}
-        ]
-      }}
-    }}
-}}]');
