· 8 years ago · Apr 14, 2018, 09:38 PM
1#!/bin/bash
2
3set -euo pipefail
4
5schemas_count=1000
6tables_count=1000
7columns_count=100
8catalog=memory
9
10mkdir -p tables
11echo "CREATE SCHEMA IF NOT EXISTS $catalog.schema_0;"
12cat <<EOF
13CREATE TABLE IF NOT EXISTS $catalog.schema_0.table_0 (
14 column_00 VARCHAR,
15 column_01 VARCHAR,
16 column_02 VARCHAR,
17 column_03 VARCHAR,
18 column_04 VARCHAR,
19 column_05 VARCHAR,
20 column_06 VARCHAR,
21 column_07 VARCHAR,
22 column_08 VARCHAR,
23 column_09 VARCHAR,
24 column_10 VARCHAR,
25 column_11 VARCHAR,
26 column_12 VARCHAR,
27 column_13 VARCHAR,
28 column_14 VARCHAR,
29 column_15 VARCHAR,
30 column_16 VARCHAR,
31 column_17 VARCHAR,
32 column_18 VARCHAR,
33 column_19 VARCHAR,
34 column_20 VARCHAR,
35 column_21 VARCHAR,
36 column_22 VARCHAR,
37 column_23 VARCHAR,
38 column_24 VARCHAR,
39 column_25 VARCHAR,
40 column_26 VARCHAR,
41 column_27 VARCHAR,
42 column_28 VARCHAR,
43 column_29 VARCHAR,
44 column_30 VARCHAR,
45 column_31 VARCHAR,
46 column_32 VARCHAR,
47 column_33 VARCHAR,
48 column_34 VARCHAR,
49 column_35 VARCHAR,
50 column_36 VARCHAR,
51 column_37 VARCHAR,
52 column_38 VARCHAR,
53 column_39 VARCHAR,
54 column_40 VARCHAR,
55 column_41 VARCHAR,
56 column_42 VARCHAR,
57 column_43 VARCHAR,
58 column_44 VARCHAR,
59 column_45 VARCHAR,
60 column_46 VARCHAR,
61 column_47 VARCHAR,
62 column_48 VARCHAR,
63 column_49 VARCHAR,
64 column_50 VARCHAR,
65 column_51 VARCHAR,
66 column_52 VARCHAR,
67 column_53 VARCHAR,
68 column_54 VARCHAR,
69 column_55 VARCHAR,
70 column_56 VARCHAR,
71 column_57 VARCHAR,
72 column_58 VARCHAR,
73 column_59 VARCHAR,
74 column_60 VARCHAR,
75 column_61 VARCHAR,
76 column_62 VARCHAR,
77 column_63 VARCHAR,
78 column_64 VARCHAR,
79 column_65 VARCHAR,
80 column_66 VARCHAR,
81 column_67 VARCHAR,
82 column_68 VARCHAR,
83 column_69 VARCHAR,
84 column_70 VARCHAR,
85 column_71 VARCHAR,
86 column_72 VARCHAR,
87 column_73 VARCHAR,
88 column_74 VARCHAR,
89 column_75 VARCHAR,
90 column_76 VARCHAR,
91 column_77 VARCHAR,
92 column_78 VARCHAR,
93 column_79 VARCHAR,
94 column_80 VARCHAR,
95 column_81 VARCHAR,
96 column_82 VARCHAR,
97 column_83 VARCHAR,
98 column_84 VARCHAR,
99 column_85 VARCHAR,
100 column_86 VARCHAR,
101 column_87 VARCHAR,
102 column_88 VARCHAR,
103 column_89 VARCHAR,
104 column_90 VARCHAR,
105 column_91 VARCHAR,
106 column_92 VARCHAR,
107 column_93 VARCHAR,
108 column_94 VARCHAR,
109 column_95 VARCHAR,
110 column_96 VARCHAR,
111 column_97 VARCHAR,
112 column_98 VARCHAR,
113 column_99 VARCHAR);
114EOF
115for t in `seq $tables_count`; do
116 echo "CREATE TABLE IF NOT EXISTS $catalog.schema_0.table_$t(LIKE $catalog.schema_0.table_0);"
117done
118for s in `seq $schemas_count`; do
119 echo "CREATE SCHEMA IF NOT EXISTS $catalog.schema_$s;"
120done