-
Notifications
You must be signed in to change notification settings - Fork 108
Expand file tree
/
Copy pathtable.sql
More file actions
76 lines (76 loc) · 1.65 KB
/
table.sql
File metadata and controls
76 lines (76 loc) · 1.65 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
CREATE TABLE person (
id BIGINT,
name VARCHAR,
emailAddress VARCHAR,
creditCard VARCHAR,
city VARCHAR,
state VARCHAR,
date_time TIMESTAMP(3) NOT NULL {lateness},
extra VARCHAR
) WITH ('connectors' = '[
{{
"format": {{
"name": "csv",
"config": {{}}
}},
"transport": {{
"name": "nexmark",
"config": {{
"table": "person",
"options": {{
"events": {events},
"threads": {cores},
"batch_size_per_thread": 1000
}}
}}
}}
}}
]');
CREATE TABLE auction (
id BIGINT,
itemName VARCHAR,
description VARCHAR,
initialBid BIGINT,
reserve BIGINT,
date_time TIMESTAMP(3) NOT NULL {lateness},
expires TIMESTAMP(3),
seller BIGINT,
category BIGINT,
extra VARCHAR
) WITH ('connectors' = '[
{{
"format": {{
"name": "csv",
"config": {{}}
}},
"transport": {{
"name": "nexmark",
"config": {{
"table": "auction"
}}
}}
}}
]');
CREATE TABLE bid (
auction BIGINT,
bidder BIGINT,
price BIGINT,
channel VARCHAR,
url VARCHAR,
date_time TIMESTAMP(3) NOT NULL {lateness},
extra VARCHAR
) WITH ('connectors' = '[
{{
"format": {{
"name": "csv",
"config": {{}}
}},
"transport": {{
"name": "nexmark",
"config": {{
"table": "bid"
}}
}},
"max_batch_size": 160000
}}
]');