Reproduce File not found checksums.txt

README

1) Take master version of ClickHouse(20.4 for example)
2) Create database and tables
3) You can write data once or several times
4) Restart server several times (actually I write and restart server several times, but there is no other)
5) After several minutes I can see exceptions in log

mass_create_tables.sql

CREATE TABLE mass_table_110 ( A Int32, B Int32 ) ENGINE = Memory();
CREATE TABLE mass_table_111 ( ANIMAL Nullable(String) ) engine = TinyLog;
CREATE TABLE mass_table_112 ( EventDate Date, Id UInt64, Data String, Version UInt32) ENGINE = ReplacingMergeTree(EventDate, Id, 8192, Version);
CREATE TABLE mass_table_113 ( a DateTime ) ENGINE = MergeTree ORDER BY tuple();
CREATE TABLE mass_table_114 ( created_date Date DEFAULT toDate(created_at), created_at DateTime DEFAULT now(), strings Array(String) DEFAULT emptyArrayString()) ENGINE = MergeTree(created_date, cityHash64(created_at), (created_date, cityHash64(created_at)), 8192);
CREATE TABLE mass_table_115 ( date Date, a Int32, b Int32, c Int32, d Int32) ENGINE = MergeTree(date, (a, date), 8192);
CREATE TABLE mass_table_116 ( date Date, platform Enum8('a' = 0, 'b' = 1, 'c' = 2), app Enum8('a' = 0, 'b' = 1) ) ENGINE = MergeTree(date, (platform, app), 8192);
CREATE TABLE mass_table_117 ( dt Date, site_id Int32, site_key String ) ENGINE = MergeTree(dt, (site_id, site_key, dt), 8192);
CREATE TABLE mass_table_118 ( id Nullable(String) ) ENGINE = Memory;
CREATE TABLE mass_table_119 ( id Nullable(String), not_id Nullable(String) ) ENGINE = Memory;
CREATE TABLE mass_table_120 ( id String ) ENGINE = Log;
CREATE TABLE mass_table_121 ( id String ) ENGINE = Memory;
CREATE TABLE mass_table_122 ( id String ) ENGINE = StripeLog;
CREATE TABLE mass_table_123 ( id String, name String ) ENGINE = StripeLog;
CREATE TABLE mass_table_124 ( n UInt64, m UInt64 MATERIALIZED n+1 ) ENGINE = Log;
CREATE TABLE mass_table_125 ( parent_id String ) ENGINE = Log;
CREATE TABLE mass_table_127 ( s String, i Int64) ENGINE = Memory;
CREATE TABLE mass_table_128 ( statementId String, eventDate Date, eventHour DateTime, eventTime DateTime, verb String, objectId String, onCourse UInt8, courseId UInt16, contextRegistration String, resultScoreRaw Float64, resultScoreMin Float64, resultScoreMax Float64, resultSuccess UInt8, resultCompletition UInt8, resultDuration UInt32, resultResponse String, learnerId String, learnerHash String, contextId UInt16) ENGINE = MergeTree ORDER BY tuple();
CREATE TABLE mass_table_129 ( x Enum('hello' = 1, 'world' = 128) ) ENGINE = TinyLog;
CREATE TABLE mass_table_130 ( x Enum('hello' = 1, 'world' = 2) ) ENGINE = TinyLog;
CREATE TABLE mass_table_131 (A String, B String, ts DateTime) ENGINE = MergeTree PARTITION BY toStartOfDay(ts) ORDER BY (ts, A, B);
CREATE TABLE mass_table_132 (A UInt8) ENGINE = Null;
CREATE TABLE mass_table_133 (A UInt8) ENGINE = TinyLog;
CREATE TABLE mass_table_134 (APIKey Int32, EventValueForPostback String) ENGINE = MergeTree ORDER BY tuple();
CREATE TABLE mass_table_135 (APIKey Int32, SomeColumn String) ENGINE = MergeTree ORDER BY tuple();
CREATE TABLE mass_table_136 (APIKey UInt8, SessionType UInt8) ENGINE = MergeTree() PARTITION BY APIKey ORDER BY tuple();
CREATE TABLE mass_table_137 (B String, ts DateTime) ENGINE = MergeTree PARTITION BY toStartOfDay(ts) ORDER BY (ts, B);
CREATE TABLE mass_table_138 (CounterID UInt32, AdvEngineID UInt8, RegionID UInt32, SearchPhrase String, UserID UInt64) ENGINE = Log;
CREATE TABLE mass_table_139 (CounterID UInt32, AdvEngineID UInt8, RegionID UInt32, SearchPhrase String, UserID UInt64) ENGINE = StripeLog;
CREATE TABLE mass_table_140 (CounterID UInt32, AdvEngineID UInt8, RegionID UInt32, SearchPhrase String, UserID UInt64) ENGINE = TinyLog;
CREATE TABLE mass_table_141 (CounterID UInt32, StartDate Date ) ENGINE = Memory;
CREATE TABLE mass_table_143 (CounterID UInt32, UserID UInt64) ENGINE = MergeTree ORDER BY UserID SAMPLE BY UserID;
CREATE TABLE mass_table_144 (Domain UInt8, `Users.UserID` Array(UInt64), `Users.Dates` Array(Array(Date))) ENGINE = MergeTree ORDER BY Domain SETTINGS vertical_merge_algorithm_min_rows_to_activate = 0, vertical_merge_algorithm_min_columns_to_activate = 0;
CREATE TABLE mass_table_145 (EventDate Date, CounterID UInt32) ENGINE = MergeTree(EventDate, CounterID, 8192);
CREATE TABLE mass_table_146 (EventDate Date, CounterID UInt32, UserID UInt64, EventTime DateTime, UTCEventTime DateTime) ENGINE = MergeTree(EventDate, CounterID, 8192);
CREATE TABLE mass_table_147 (EventDate Date, EventTime DateTime) ENGINE = MergeTree(EventDate, EventTime, 8192);
CREATE TABLE mass_table_148 (EventDate Date, UTCEventTime DateTime, MoscowEventDate Date DEFAULT toDate(UTCEventTime)) ENGINE = MergeTree(EventDate, UTCEventTime, 8192);
CREATE TABLE mass_table_149 (EventTime DateTime, EventDate Date, CounterID UInt32, UserID UInt64, URL String, Referer String) ENGINE = MergeTree(EventDate, intHash32(UserID), (CounterID, EventDate, intHash32(UserID), EventTime), 8192);
CREATE TABLE mass_table_150 (FlightDate Date, Carrier String, FlightNum String) ENGINE = Memory;
CREATE TABLE mass_table_151 (N UInt32, S String) Engine = TinyLog;
CREATE TABLE mass_table_152 (N UInt32,S String) Engine = Log;
CREATE TABLE mass_table_153 (Num UInt32, Name String) ENGINE = Memory;
CREATE TABLE mass_table_154 (OrderId UInt64, OrderName String, OrderDate DateTime) engine = Log;
CREATE TABLE mass_table_155 (S1 String, S2 String, S3 FixedString(2)) ENGINE=Memory;
CREATE TABLE mass_table_156 (SomeField1 Int64, SomeField2 Double) ENGINE = MergeTree() ORDER BY tuple();
CREATE TABLE mass_table_157 (SomeKey UInt64, SomeValue String) ENGINE = MergeTree() ORDER BY SomeKey SETTINGS index_granularity_bytes = 0;
CREATE TABLE mass_table_158 (SomeKey UInt64, SomeValue String) ENGINE = MergeTree() ORDER BY SomeKey;
CREATE TABLE mass_table_164 (UserID UInt64) ENGINE = Log;
CREATE TABLE mass_table_165 (UserID UInt64) ENGINE=Memory;
CREATE TABLE mass_table_166 (UserID UInt64, loyalty Int8) ENGINE = Join(ANY, INNER, UserID);
CREATE TABLE mass_table_167 (`A` Int64) ENGINE = MergeTree() ORDER BY tuple();
CREATE TABLE mass_table_168 (`CounterID` UInt64, `value` String) ENGINE = MergeTree() ORDER BY CounterID;
CREATE TABLE mass_table_169 (`WatchID` UInt64, `JavaEnable` UInt8, `Title` String, `GoodEvent` Int16, `EventTime` DateTime, `EventDate` Date, `CounterID` UInt32, `ClientIP` UInt32, `ClientIP6` FixedString(16), `RegionID` UInt32, `UserID` UInt64, `CounterClass` Int8, `OS` UInt8, `UserAgent` UInt8, `URL` String, `Referer` String, `URLDomain` String, `RefererDomain` String, `Refresh` UInt8, `IsRobot` UInt8, `RefererCategories` Array(UInt16), `URLCategories` Array(UInt16), `URLRegions` Array(UInt32), `RefererRegions` Array(UInt32), `ResolutionWidth` UInt16, `ResolutionHeight` UInt16, `ResolutionDepth` UInt8, `FlashMajor` UInt8, `FlashMinor` UInt8, `FlashMinor2` String, `NetMajor` UInt8, `NetMinor` UInt8, `UserAgentMajor` UInt16, `UserAgentMinor` FixedString(2), `CookieEnable` UInt8, `JavascriptEnable` UInt8, `IsMobile` UInt8, `MobilePhone` UInt8, `MobilePhoneModel` String, `Params` String, `IPNetworkID` UInt32, `TraficSourceID` Int8, `SearchEngineID` UInt16, `SearchPhrase` String, `AdvEngineID` UInt8, `IsArtifical` UInt8, `WindowClientWidth` UInt16, `WindowClientHeight` UInt16, `ClientTimeZone` Int16, `ClientEventTime` DateTime, `SilverlightVersion1` UInt8, `SilverlightVersion2` UInt8, `SilverlightVersion3` UInt32, `SilverlightVersion4` UInt16, `PageCharset` String, `CodeVersion` UInt32, `IsLink` UInt8, `IsDownload` UInt8, `IsNotBounce` UInt8, `FUniqID` UInt64, `HID` UInt32, `IsOldCounter` UInt8, `IsEvent` UInt8, `IsParameter` UInt8, `DontCountHits` UInt8, `WithHash` UInt8, `HitColor` FixedString(1), `UTCEventTime` DateTime, `Age` UInt8, `Sex` UInt8, `Income` UInt8, `Interests` UInt16, `Robotness` UInt8, `GeneralInterests` Array(UInt16), `RemoteIP` UInt32, `RemoteIP6` FixedString(16), `WindowName` Int32, `OpenerName` Int32, `HistoryLength` Int16, `BrowserLanguage` FixedString(2), `BrowserCountry` FixedString(2), `SocialNetwork` String, `SocialAction` String, `HTTPError` UInt16, `SendTiming` Int32, `DNSTiming` Int32, `ConnectTiming` Int32, `ResponseStartTiming` Int32, `ResponseEndTiming` Int32, `FetchTiming` Int32, `RedirectTiming` Int32, `DOMInteractiveTiming` Int32, `DOMContentLoadedTiming` Int32, `DOMCompleteTiming` Int32, `LoadEventStartTiming` Int32, `LoadEventEndTiming` Int32, `NSToDOMContentLoadedTiming` Int32, `FirstPaintTiming` Int32, `RedirectCount` Int8, `SocialSourceNetworkID` UInt8, `SocialSourcePage` String, `ParamPrice` Int64, `ParamOrderID` String, `ParamCurrency` FixedString(3), `ParamCurrencyID` UInt16, `GoalsReached` Array(UInt32), `OpenstatServiceName` String, `OpenstatCampaignID` String, `OpenstatAdID` String, `OpenstatSourceID` String, `UTMSource` String, `UTMMedium` String, `UTMCampaign` String, `UTMContent` String, `UTMTerm` String, `FromTag` String, `HasGCLID` UInt8, `RefererHash` UInt64, `URLHash` UInt64, `CLID` UInt32, `YCLID` UInt64, `ShareService` String, `ShareURL` String, `ShareTitle` String, `ParsedParams.Key1` Array(String), `ParsedParams.Key2` Array(String), `ParsedParams.Key3` Array(String), `ParsedParams.Key4` Array(String), `ParsedParams.Key5` Array(String), `ParsedParams.ValueDouble` Array(Float64), `IslandID` FixedString(16), `RequestNum` UInt32, `RequestTry` UInt8) ENGINE = MergeTree() PARTITION BY toYYYYMM(EventDate) ORDER BY (CounterID, EventDate, intHash32(UserID)) SAMPLE BY intHash32(UserID) SETTINGS index_granularity=8192, enable_mixed_granularity_parts=1, index_granularity_bytes=0;
CREATE TABLE mass_table_170 (`WatchID` UInt64, `JavaEnable` UInt8, `Title` String, `GoodEvent` Int16, `EventTime` DateTime, `EventDate` Date, `CounterID` UInt32, `ClientIP` UInt32, `ClientIP6` FixedString(16), `RegionID` UInt32, `UserID` UInt64, `CounterClass` Int8, `OS` UInt8, `UserAgent` UInt8, `URL` String, `Referer` String, `URLDomain` String, `RefererDomain` String, `Refresh` UInt8, `IsRobot` UInt8, `RefererCategories` Array(UInt16), `URLCategories` Array(UInt16), `URLRegions` Array(UInt32), `RefererRegions` Array(UInt32), `ResolutionWidth` UInt16, `ResolutionHeight` UInt16, `ResolutionDepth` UInt8, `FlashMajor` UInt8, `FlashMinor` UInt8, `FlashMinor2` String, `NetMajor` UInt8, `NetMinor` UInt8, `UserAgentMajor` UInt16, `UserAgentMinor` FixedString(2), `CookieEnable` UInt8, `JavascriptEnable` UInt8, `IsMobile` UInt8, `MobilePhone` UInt8, `MobilePhoneModel` String, `Params` String, `IPNetworkID` UInt32, `TraficSourceID` Int8, `SearchEngineID` UInt16, `SearchPhrase` String, `AdvEngineID` UInt8, `IsArtifical` UInt8, `WindowClientWidth` UInt16, `WindowClientHeight` UInt16, `ClientTimeZone` Int16, `ClientEventTime` DateTime, `SilverlightVersion1` UInt8, `SilverlightVersion2` UInt8, `SilverlightVersion3` UInt32, `SilverlightVersion4` UInt16, `PageCharset` String, `CodeVersion` UInt32, `IsLink` UInt8, `IsDownload` UInt8, `IsNotBounce` UInt8, `FUniqID` UInt64, `HID` UInt32, `IsOldCounter` UInt8, `IsEvent` UInt8, `IsParameter` UInt8, `DontCountHits` UInt8, `WithHash` UInt8, `HitColor` FixedString(1), `UTCEventTime` DateTime, `Age` UInt8, `Sex` UInt8, `Income` UInt8, `Interests` UInt16, `Robotness` UInt8, `GeneralInterests` Array(UInt16), `RemoteIP` UInt32, `RemoteIP6` FixedString(16), `WindowName` Int32, `OpenerName` Int32, `HistoryLength` Int16, `BrowserLanguage` FixedString(2), `BrowserCountry` FixedString(2), `SocialNetwork` String, `SocialAction` String, `HTTPError` UInt16, `SendTiming` Int32, `DNSTiming` Int32, `ConnectTiming` Int32, `ResponseStartTiming` Int32, `ResponseEndTiming` Int32, `FetchTiming` Int32, `RedirectTiming` Int32, `DOMInteractiveTiming` Int32, `DOMContentLoadedTiming` Int32, `DOMCompleteTiming` Int32, `LoadEventStartTiming` Int32, `LoadEventEndTiming` Int32, `NSToDOMContentLoadedTiming` Int32, `FirstPaintTiming` Int32, `RedirectCount` Int8, `SocialSourceNetworkID` UInt8, `SocialSourcePage` String, `ParamPrice` Int64, `ParamOrderID` String, `ParamCurrency` FixedString(3), `ParamCurrencyID` UInt16, `GoalsReached` Array(UInt32), `OpenstatServiceName` String, `OpenstatCampaignID` String, `OpenstatAdID` String, `OpenstatSourceID` String, `UTMSource` String, `UTMMedium` String, `UTMCampaign` String, `UTMContent` String, `UTMTerm` String, `FromTag` String, `HasGCLID` UInt8, `RefererHash` UInt64, `URLHash` UInt64, `CLID` UInt32, `YCLID` UInt64, `ShareService` String, `ShareURL` String, `ShareTitle` String, `ParsedParams.Key1` Array(String), `ParsedParams.Key2` Array(String), `ParsedParams.Key3` Array(String), `ParsedParams.Key4` Array(String), `ParsedParams.Key5` Array(String), `ParsedParams.ValueDouble` Array(Float64), `IslandID` FixedString(16), `RequestNum` UInt32, `RequestTry` UInt8) ENGINE = MergeTree() PARTITION BY toYYYYMM(EventDate) ORDER BY (CounterID, EventDate, intHash32(UserID)) SAMPLE BY intHash32(UserID) SETTINGS index_granularity=8192, enable_mixed_granularity_parts=1;
CREATE TABLE mass_table_171 (`WatchID` UInt64, `JavaEnable` UInt8, `Title` String, `GoodEvent` Int16, `EventTime` DateTime, `EventDate` Date, `CounterID` UInt32, `ClientIP` UInt32, `ClientIP6` FixedString(16), `RegionID` UInt32, `UserID` UInt64, `CounterClass` Int8, `OS` UInt8, `UserAgent` UInt8, `URL` String, `Referer` String, `URLDomain` String, `RefererDomain` String, `Refresh` UInt8, `IsRobot` UInt8, `RefererCategories` Array(UInt16), `URLCategories` Array(UInt16), `URLRegions` Array(UInt32), `RefererRegions` Array(UInt32), `ResolutionWidth` UInt16, `ResolutionHeight` UInt16, `ResolutionDepth` UInt8, `FlashMajor` UInt8, `FlashMinor` UInt8, `FlashMinor2` String, `NetMajor` UInt8, `NetMinor` UInt8, `UserAgentMajor` UInt16, `UserAgentMinor` FixedString(2), `CookieEnable` UInt8, `JavascriptEnable` UInt8, `IsMobile` UInt8, `MobilePhone` UInt8, `MobilePhoneModel` String, `Params` String, `IPNetworkID` UInt32, `TraficSourceID` Int8, `SearchEngineID` UInt16, `SearchPhrase` String, `AdvEngineID` UInt8, `IsArtifical` UInt8, `WindowClientWidth` UInt16, `WindowClientHeight` UInt16, `ClientTimeZone` Int16, `ClientEventTime` DateTime, `SilverlightVersion1` UInt8, `SilverlightVersion2` UInt8, `SilverlightVersion3` UInt32, `SilverlightVersion4` UInt16, `PageCharset` String, `CodeVersion` UInt32, `IsLink` UInt8, `IsDownload` UInt8, `IsNotBounce` UInt8, `FUniqID` UInt64, `HID` UInt32, `IsOldCounter` UInt8, `IsEvent` UInt8, `IsParameter` UInt8, `DontCountHits` UInt8, `WithHash` UInt8, `HitColor` FixedString(1), `UTCEventTime` DateTime, `Age` UInt8, `Sex` UInt8, `Income` UInt8, `Interests` UInt16, `Robotness` UInt8, `GeneralInterests` Array(UInt16), `RemoteIP` UInt32, `RemoteIP6` FixedString(16), `WindowName` Int32, `OpenerName` Int32, `HistoryLength` Int16, `BrowserLanguage` FixedString(2), `BrowserCountry` FixedString(2), `SocialNetwork` String, `SocialAction` String, `HTTPError` UInt16, `SendTiming` Int32, `DNSTiming` Int32, `ConnectTiming` Int32, `ResponseStartTiming` Int32, `ResponseEndTiming` Int32, `FetchTiming` Int32, `RedirectTiming` Int32, `DOMInteractiveTiming` Int32, `DOMContentLoadedTiming` Int32, `DOMCompleteTiming` Int32, `LoadEventStartTiming` Int32, `LoadEventEndTiming` Int32, `NSToDOMContentLoadedTiming` Int32, `FirstPaintTiming` Int32, `RedirectCount` Int8, `SocialSourceNetworkID` UInt8, `SocialSourcePage` String, `ParamPrice` Int64, `ParamOrderID` String, `ParamCurrency` FixedString(3), `ParamCurrencyID` UInt16, `GoalsReached` Array(UInt32), `OpenstatServiceName` String, `OpenstatCampaignID` String, `OpenstatAdID` String, `OpenstatSourceID` String, `UTMSource` String, `UTMMedium` String, `UTMCampaign` String, `UTMContent` String, `UTMTerm` String, `FromTag` String, `HasGCLID` UInt8, `RefererHash` UInt64, `URLHash` UInt64, `CLID` UInt32, `YCLID` UInt64, `ShareService` String, `ShareURL` String, `ShareTitle` String, `ParsedParams.Key1` Array(String), `ParsedParams.Key2` Array(String), `ParsedParams.Key3` Array(String), `ParsedParams.Key4` Array(String), `ParsedParams.Key5` Array(String), `ParsedParams.ValueDouble` Array(Float64), `IslandID` FixedString(16), `RequestNum` UInt32, `RequestTry` UInt8) ENGINE = MergeTree() PARTITION BY toYYYYMM(EventDate) ORDER BY (CounterID, EventDate, intHash32(UserID)) SAMPLE BY intHash32(UserID) SETTINGS index_granularity=8192, index_granularity_bytes=0;
CREATE TABLE mass_table_173 (`a` UInt64) ENGINE = MergeTree ORDER BY tuple();
CREATE TABLE mass_table_174 (`boolean_false` Nullable(String)) ENGINE = MergeTree ORDER BY tuple();
CREATE TABLE mass_table_176 (`dt` Date, `uid` String) ENGINE = MergeTree PARTITION BY toYYYYMMDD(dt) ORDER BY uid SETTINGS index_granularity = 8192;
CREATE TABLE mass_table_177 (`dt` Date, `uid` String, `name` String, `city` String) ENGINE = MergeTree PARTITION BY toYYYYMMDD(dt) ORDER BY name SETTINGS index_granularity = 8192;
CREATE TABLE mass_table_178 (`id1` UInt32, `id2` UInt32, `valA` UInt32) ENGINE = TinyLog;
CREATE TABLE mass_table_179 (`id1` UInt32, `val1` UInt8) ENGINE = Join(ANY, LEFT, id1);
CREATE TABLE mass_table_180 (`id2` UInt32, `val2` UInt8) ENGINE = Join(ANY, LEFT, id2);
CREATE TABLE mass_table_181 (`index` UInt8) ENGINE = MergeTree ORDER BY `index`;
CREATE TABLE mass_table_182 (`int8` Int8, `int16` Int16, `int32` Int32, `int64` Int64, INDEX idx (`int8`, `int16`, `int32`, `int64`) TYPE bloom_filter(0.01) GRANULARITY 8192 ) ENGINE = MergeTree() ORDER BY `int8`;
CREATE TABLE mass_table_183 (`pt` Date) ENGINE = MergeTree PARTITION BY pt ORDER BY pt SETTINGS index_granularity = 8192;
CREATE TABLE mass_table_185 (a Array(Int64), b Array(Float64), c Array(UInt64)) ENGINE=Memory;
CREATE TABLE mass_table_186 (a Array(Int8), b UInt32, c Nullable(String), d Decimal32(4), e Nullable(Enum16('h' = 1, 'w' = 5 , 'o' = -200)), f Float64, g Tuple(Date, DateTime, DateTime64, UUID), h FixedString(2)) ENGINE=Memory;
CREATE TABLE mass_table_187 (a Array(Int8), d Decimal32(4), c Tuple(DateTime64(3), UUID)) ENGINE=GenerateRandom();
CREATE TABLE mass_table_188 (a Array(Int8), d Decimal32(4), c Tuple(DateTime64(3), UUID)) ENGINE=GenerateRandom(10, 5, 3);
CREATE TABLE mass_table_189 (a Array(Int8), d Decimal32(4), c Tuple(DateTime64(3), UUID)) ENGINE=Memory;
CREATE TABLE mass_table_190 (a Array(String), b Array(String)) ENGINE = Memory;
CREATE TABLE mass_table_191 (a Array(String), b Array(UInt8)) ENGINE = Memory;
CREATE TABLE mass_table_192 (a Array(UInt64), b Array(String), c Array(Array(Date))) ENGINE = Memory;
CREATE TABLE mass_table_196 (a Int) ENGINE = Log;
CREATE TABLE mass_table_197 (a Int) ENGINE = Memory;
CREATE TABLE mass_table_198 (a Int) ENGINE = MergeTree ORDER BY a;
CREATE TABLE mass_table_199 (a Int, b Int) ENGINE = MergeTree ORDER BY (a / b);
CREATE TABLE mass_table_200 (a Int, b Int, c Int) ENGINE = MergeTree ORDER BY tuple();
CREATE TABLE mass_table_201 (a Int32) ENGINE = Memory;
CREATE TABLE mass_table_202 (a Int32) Engine=MergeTree order by tuple();
CREATE TABLE mass_table_203 (a Int32, n Int32) ENGINE = Memory;
CREATE TABLE mass_table_204 (a Int64, b Int64) ENGINE=Memory;
CREATE TABLE mass_table_205 (a Int64, b Int64, c Int64) ENGINE = MergeTree ORDER BY (a, b);
CREATE TABLE mass_table_206 (a Int64, b Int64, c String) ENGINE = MergeTree ORDER BY (a, b);
CREATE TABLE mass_table_207 (a Int64, b String) ENGINE = Memory;
CREATE TABLE mass_table_208 (a Int8, b Nullable(Int8)) ENGINE = Memory;
CREATE TABLE mass_table_210 (a String) ENGINE = Memory;
CREATE TABLE mass_table_211 (a String) Engine = MergeTree PARTITION BY tuple() ORDER BY a;
CREATE TABLE mass_table_212 (a String, b DateTime) ENGINE=MergeTree order by a;
CREATE TABLE mass_table_213 (a String, b Int32, s Int32) ENGINE = Memory;
CREATE TABLE mass_table_214 (a String, b String) ENGINE = Memory();
CREATE TABLE mass_table_215 (a String, b Tuple(String, String)) ENGINE = Memory();
CREATE TABLE mass_table_216 (a String, c Array(String)) ENGINE = Memory();
CREATE TABLE mass_table_217 (a String, c Tuple(String, String)) ENGINE = Memory();
CREATE TABLE mass_table_218 (a Tuple(DateTime, Int32)) ENGINE = MergeTree() ORDER BY a;
CREATE TABLE mass_table_219 (a UInt32) ENGINE = Memory;
CREATE TABLE mass_table_220 (a UInt32, b Int32) ENGINE = Memory;
CREATE TABLE mass_table_221 (a UInt32, b Nullable(Int32)) ENGINE = Memory;
CREATE TABLE mass_table_222 (a UInt32, b UInt32) ENGINE = Memory;
CREATE TABLE mass_table_223 (a UInt32, b UInt32, c UInt32) ENGINE = Memory;
CREATE TABLE mass_table_224 (a UInt32, b UInt8) ENGINE = Memory;
CREATE TABLE mass_table_225 (a UInt32, date Date, b UInt64, c UInt64, str String, d Int8, arr Array(UInt64), arr_alias Array(UInt64) ALIAS arr) ENGINE = MergeTree(date, intHash32(c), (a, date, intHash32(c), b), 8192);
CREATE TABLE mass_table_226 (a UInt32, t UInt32) ENGINE = Memory;
CREATE TABLE mass_table_227 (a UInt64 default 0, n UInt64) ENGINE = MergeTree() PARTITION BY tuple() ORDER BY (a);
CREATE TABLE mass_table_228 (a UInt64) engine=MergeTree() ORDER BY a;
CREATE TABLE mass_table_229 (a UInt64, b UInt64) ENGINE = Log;
CREATE TABLE mass_table_230 (a UInt64, b UInt64) ENGINE = Memory;
CREATE TABLE mass_table_231 (a UInt64, b UInt64) ENGINE = StripeLog;
CREATE TABLE mass_table_232 (a UInt64, b UInt64) ENGINE = TinyLog;
CREATE TABLE mass_table_233 (a UInt64, b UInt64, c UInt64, d UInt64) ENGINE=MergeTree() ORDER BY (a, b);
CREATE TABLE mass_table_234 (a UInt8 ALIAS b, b UInt8) ENGINE Log;
CREATE TABLE mass_table_235 (a UInt8) ENGINE = Memory;
CREATE TABLE mass_table_236 (a UInt8) ENGINE MergeTree ORDER BY a;
CREATE TABLE mass_table_237 (a UInt8, b Array(DateTime)) ENGINE Memory;
CREATE TABLE mass_table_238 (a UInt8, b DEFAULT 0, c DEFAULT identity(b)) ENGINE = Memory;
CREATE TABLE mass_table_239 (a UInt8, b Int32, c UInt8 ALIAS a, d Int64 ALIAS b + 1, e Int32 alias a + b) ENGINE = MergeTree ORDER BY tuple();
CREATE TABLE mass_table_240 (a UInt8, b String) ENGINE MergeTree ORDER BY a;
CREATE TABLE mass_table_241 (a UInt8, b String, c Array(UInt32)) ENGINE = Buffer(currentDatabase(), null_sink_00126, 1, 1000, 1000, 1000, 1000, 1000000, 1000000);
CREATE TABLE mass_table_242 (a UInt8, b String, c Array(UInt32)) ENGINE = Null;
CREATE TABLE mass_table_243 (a UInt8, b UInt8) ENGINE = Memory;
CREATE TABLE mass_table_244 (a UInt8, b UInt8) ENGINE MergeTree ORDER BY a;
CREATE TABLE mass_table_245 (a UInt8, b UInt8) ENGINE=Memory;
CREATE TABLE mass_table_246 (a UInt8, b UInt8) Engine = Join(ANY, LEFT, a);
CREATE TABLE mass_table_247 (a UInt8, b UInt8, c UInt16 ALIAS a + b) ENGINE = MergeTree ORDER BY a;
CREATE TABLE mass_table_248 (a UInt8, b UInt8, c UInt8) ENGINE = Memory;
CREATE TABLE mass_table_249 (a1 Array(UInt16), a2 Array(UInt16), a3 Array(Array(UInt16)), a4 Array(Array(UInt16)) ) ENGINE = Memory;
CREATE TABLE mass_table_250 (a1 Array(UInt8), a2 Array(UInt32) ) ENGINE = Memory;
CREATE TABLE mass_table_251 (a1 UInt8) ENGINE=Memory;
CREATE TABLE mass_table_252 (a3 Array(Array(UInt8)), a4 Array(Array(UInt32)) ) ENGINE = Memory;
CREATE TABLE mass_table_253 (aaa String, bbb String) ENGINE = Memory;
CREATE TABLE mass_table_254 (addr String) ENGINE = Memory;
CREATE TABLE mass_table_255 (addr UInt32) ENGINE = Memory;
CREATE TABLE mass_table_256 (amount float, business_dttm DateTime) engine Log;
CREATE TABLE mass_table_257 (app Enum8('a' = 0, 'b' = 1)) ENGINE = Memory;
CREATE TABLE mass_table_258 (arr Array(Int32), id Int32) ENGINE = Memory;
CREATE TABLE mass_table_259 (arr Array(Int32), id UInt32) ENGINE = Memory;
CREATE TABLE mass_table_260 (arr Array(Nullable(Float64))) ENGINE = Memory;
CREATE TABLE mass_table_261 (arr Array(Nullable(Int64))) ENGINE = Memory;
CREATE TABLE mass_table_262 (arr Array(Nullable(String))) ENGINE = Memory;
CREATE TABLE mass_table_263 (arr Array(String), id Int32) ENGINE = Memory;
CREATE TABLE mass_table_264 (arr Array(String), id UInt32) ENGINE = Memory;
CREATE TABLE mass_table_265 (arr Array(UInt8), str String, int Int32) ENGINE = Memory;
CREATE TABLE mass_table_266 (arr_int Array(UInt8), arr_string Array(String)) ENGINE=Memory;
CREATE TABLE mass_table_268 (b UInt32, c UInt32) ENGINE = Memory;
CREATE TABLE mass_table_269 (b UInt32, t UInt32) ENGINE = Memory;
CREATE TABLE mass_table_270 (b UInt8, a UInt8) ENGINE = Memory;
CREATE TABLE mass_table_271 (c Int64, d String) ENGINE = Memory;
CREATE TABLE mass_table_272 (c String, a String, d DateTime) ENGINE=MergeTree order by c;
CREATE TABLE mass_table_273 (c UInt8, d String) ENGINE MergeTree ORDER BY c;
CREATE TABLE mass_table_274 (c1 Nullable(UInt32), c2 Nullable(String))ENGINE = Log;
CREATE TABLE mass_table_275 (c1 String, c2 String) ENGINE = Memory;
CREATE TABLE mass_table_276 (col1 Array(Nullable(String))) Engine=TinyLog;
CREATE TABLE mass_table_277 (col1 Array(Nullable(String)), col2 Nullable(String)) Engine=TinyLog;
CREATE TABLE mass_table_278 (col1 Array(Nullable(String)), col2 String) Engine=TinyLog;
CREATE TABLE mass_table_279 (col1 Array(Nullable(String)), col2 UInt64) Engine=TinyLog;
CREATE TABLE mass_table_280 (col1 Array(Nullable(UInt64))) Engine=Memory;
CREATE TABLE mass_table_281 (col1 Array(Nullable(UInt64))) Engine=TinyLog;
CREATE TABLE mass_table_282 (col1 Array(Nullable(UInt64)), col2 Nullable(UInt64)) Engine=TinyLog;
CREATE TABLE mass_table_283 (col1 Array(Nullable(UInt64)), col2 UInt64) Engine=TinyLog;
CREATE TABLE mass_table_284 (col1 Array(Nullable(UInt8)), col2 String) ENGINE=TinyLog;
CREATE TABLE mass_table_285 (col1 Nullable(Int8), col2 Nullable(UInt16), col3 Nullable(Float32)) Engine=TinyLog;
CREATE TABLE mass_table_286 (col1 Nullable(String)) ENGINE=TinyLog;
CREATE TABLE mass_table_287 (col1 Nullable(String)) Engine=TinyLog;
CREATE TABLE mass_table_288 (col1 Nullable(String), col2 Nullable(UInt8), col3 String) ENGINE=TinyLog;
CREATE TABLE mass_table_289 (col1 Nullable(String), col2 String) ENGINE=TinyLog;
CREATE TABLE mass_table_290 (col1 Nullable(UInt64)) Engine=TinyLog;
CREATE TABLE mass_table_291 (col1 Nullable(UInt64), col2 Nullable(UInt64)) Engine=Memory;
CREATE TABLE mass_table_292 (col1 Nullable(UInt64), col2 UInt64) Engine=Memory;
CREATE TABLE mass_table_293 (col1 Nullable(UInt64), col2 UInt64, col3 Nullable(UInt64), col4 String) ENGINE=TinyLog;
CREATE TABLE mass_table_294 (col1 Nullable(UInt64), col2 UInt64, col3 String) ENGINE=TinyLog;
CREATE TABLE mass_table_295 (col1 Nullable(UInt8), col2 String) ENGINE=TinyLog;
CREATE TABLE mass_table_296 (col1 String) Engine=TinyLog;
CREATE TABLE mass_table_297 (col1 String, col2 Nullable(UInt8), col3 String) ENGINE=TinyLog;
CREATE TABLE mass_table_298 (col1 UInt32, col2 ALIAS col1, col3 DEFAULT col2) Engine = MergeTree() ORDER BY tuple();
CREATE TABLE mass_table_299 (col1 UInt64) ENGINE=TinyLog;
CREATE TABLE mass_table_300 (col1 UInt64) Engine=TinyLog;
CREATE TABLE mass_table_301 (col1 UInt64, col2 Nullable(UInt64)) Engine=Memory;
CREATE TABLE mass_table_302 (col1 UInt64, col2 String, col3 String, col4 String) ENGINE=TinyLog;
CREATE TABLE mass_table_303 (col1 UInt64, col2 String, col3 String, col4 String, col5 String, col6 String, col7 String) ENGINE=TinyLog;
CREATE TABLE mass_table_304 (cond1 Nullable(UInt8), then1 Int8, cond2 UInt8, then2 Nullable(UInt16), then3 Nullable(Float32)) Engine=TinyLog;
CREATE TABLE mass_table_305 (d Date DEFAULT '2000-01-01', k UInt64 DEFAULT 0, x UInt16) ENGINE = MergeTree(d, k, 1);
CREATE TABLE mass_table_306 (d Date DEFAULT '2000-01-01', k UInt64, u AggregateFunction(uniq, UInt64)) ENGINE = AggregatingMergeTree(d, k, 8192);
CREATE TABLE mass_table_307 (d Date DEFAULT '2000-01-01', x DateTime, y UInt64, z UInt64) ENGINE = MergeTree() PARTITION BY d ORDER BY (toStartOfMinute(x), y, z) SETTINGS index_granularity_bytes=19, write_final_mark = 0;
CREATE TABLE mass_table_308 (d Date DEFAULT '2000-01-01', x DateTime, y UInt64, z UInt64) ENGINE = MergeTree(d, (toStartOfMinute(x), y, z), 1);
CREATE TABLE mass_table_309 (d Date DEFAULT '2000-01-01', x String) ENGINE = MergeTree(d, d, 1);
CREATE TABLE mass_table_310 (d Date DEFAULT '2000-01-01', x UInt16) ENGINE = MergeTree(d, x, x, 10);
CREATE TABLE mass_table_311 (d Date DEFAULT '2000-01-01', x UInt64) ENGINE = MergeTree(d, x, 8192);
CREATE TABLE mass_table_313 (d Date DEFAULT '2000-01-01', x UInt64, y UInt64, z UInt64) ENGINE = MergeTree(d, (x, y, z), 1);
CREATE TABLE mass_table_314 (d Date DEFAULT '2000-01-01', x UInt8) ENGINE = MergeTree(d, x, x, 10);
CREATE TABLE mass_table_316 (d Date DEFAULT toDate('2015-05-01'), x UInt64) ENGINE = MergeTree(d, x, 1);
CREATE TABLE mass_table_317 (d Date DEFAULT toDate('2015-05-01'), x UInt64, y UInt64, z UInt64) ENGINE = MergeTree(d, (x, z), 1);
CREATE TABLE mass_table_318 (d Date DEFAULT toDate(t), t DateTime) ENGINE = MergeTree(d, t, 8192);
CREATE TABLE mass_table_319 (d Date DEFAULT today(), x Int8) ENGINE = MergeTree(d, -x, 1);
CREATE TABLE mass_table_320 (d Date DEFAULT today(), x UInt32, u UInt64, s String) ENGINE = Memory;
CREATE TABLE mass_table_321 (d Date DEFAULT today(), x UInt32, u UInt64, s String) ENGINE = MergeTree(d, cityHash64(u, s), (x, d, cityHash64(u, s)), 8192);
CREATE TABLE mass_table_322 (d Date DEFAULT today(), x UInt64) ENGINE = Buffer(test2_00158, mt_00158, 16, 100, 100, 1000000, 1000000, 1000000000, 1000000000);
CREATE TABLE mass_table_323 (d Date) ENGINE = Memory;
CREATE TABLE mass_table_324 (d Date) ENGINE = MergeTree ORDER BY d PARTITION BY d;
CREATE TABLE mass_table_325 (d Date) ENGINE = MergeTree(d, d, 1);
CREATE TABLE mass_table_328 (d Date, a String, b String) ENGINE = MergeTree(d, d, 8192);
CREATE TABLE mass_table_329 (d Date, a String, b UInt8, x String, y Int8, z UInt32) ENGINE = MergeTree(d, (a, b), 111);
CREATE TABLE mass_table_330 (d Date, a String, x UInt32, y UInt64, z Float64) ENGINE = SummingMergeTree(d, a, 8192);
CREATE TABLE mass_table_331 (d Date, a String, x UInt32, y UInt64, z Float64) ENGINE = SummingMergeTree(d, a, 8192, (y, z));
CREATE TABLE mass_table_332 (d Date, dt DateTime, id Integer) ENGINE = Memory;
CREATE TABLE mass_table_333 (d Date, e Enum8('foo'=1, 'bar'=2)) Engine = MergeTree PARTITION BY d ORDER BY (d) SETTINGS index_granularity_bytes=10000, write_final_mark=1;
CREATE TABLE mass_table_334 (d Date, e Enum8('foo'=1, 'bar'=2)) Engine = MergeTree(d, (d), 8192);
CREATE TABLE mass_table_336 (d Date, k UInt64, i32 Int32) ENGINE=MergeTree(d, k, 8192);
CREATE TABLE mass_table_338 (d Date, k UInt64, s String) ENGINE = ReplacingMergeTree(d, k, 2);
CREATE TABLE mass_table_339 (d Date, k UInt64, s String, v UInt16) ENGINE = ReplacingMergeTree(d, k, 1, v);
CREATE TABLE mass_table_340 (d Date, k UInt64, s String, v UInt16) ENGINE = ReplacingMergeTree(d, k, 8192, v);
CREATE TABLE mass_table_341 (d Date, k UInt64, v Int8) ENGINE=SummingMergeTree(d, k, 8192);
CREATE TABLE mass_table_342 (d Date, key UInt64, data String) ENGINE = MergeTree() PARTITION BY toYYYYMM(d) ORDER BY key;
CREATE TABLE mass_table_343 (d Date, n UInt64, host String, code UInt64) ENGINE = MergeTree(d, (n, host, code), 1);
CREATE TABLE mass_table_344 (d Date, num Int64, str String) ENGINE = MergeTree(d, d, 8192);
CREATE TABLE mass_table_345 (d Date, s AggregateFunction(uniq, UInt64)) ENGINE = MergeTree(d, d, 8192);
CREATE TABLE mass_table_346 (d Date, s Nullable(String), u Nullable(UInt8), a Array(Nullable(Float32))) ENGINE = Memory;
CREATE TABLE mass_table_347 (d Date, s String) ENGINE = MergeTree(d, s, 8192);
CREATE TABLE mass_table_348 (d Date, s String, u UInt8, i Int64, f Float64, a Array(UInt8)) ENGINE = Memory;
CREATE TABLE mass_table_349 (d Date, t DateTime) ENGINE = MergeTree(d, (d, t), 1);
CREATE TABLE mass_table_350 (d Date, v UInt32, g String) ENGINE=MergeTree(d, d, 8192);
CREATE TABLE mass_table_351 (d Date, x Nullable(UInt64)) ENGINE = MergeTree(d, d, 8192);
CREATE TABLE mass_table_352 (d Date, x UInt32) ENGINE MergeTree(d, x, 8192);
CREATE TABLE mass_table_354 (d Date, x UInt32, s String) ENGINE = ReplacingMergeTree ORDER BY x PARTITION BY d;
CREATE TABLE mass_table_355 (d Date, x UInt8) ENGINE = MergeTree PARTITION BY toMonday(d) ORDER BY x;
CREATE TABLE mass_table_356 (d Date, x UInt8, y UInt8) ENGINE MergeTree ORDER BY x PARTITION BY (d, x);
CREATE TABLE mass_table_357 (d DateTime) ENGINE = Memory;
CREATE TABLE mass_table_358 (d DateTime, a Int default 777 ttl d + interval 5 SECOND) ENGINE = MergeTree ORDER BY d;
CREATE TABLE mass_table_359 (d Decimal(4, 3)) ENGINE = MergeTree ORDER BY d SETTINGS index_granularity = 1;
CREATE TABLE mass_table_360 (data_name String, data_value UInt32) ENGINE = Memory;
CREATE TABLE mass_table_361 (date Date DEFAULT '0000-00-00', x Enum8('0' = 0, '1' = 1, '2' = 2), d Enum8('0' = 0, '1' = 1, '2' = 2)) ENGINE = MergeTree(date, x, 1);
CREATE TABLE mass_table_362 (date Date DEFAULT today(), fs FixedString(16)) ENGINE = MergeTree(date, (date, fs), 8192);
CREATE TABLE mass_table_363 (date Date, id Int8, name String, value Int64) ENGINE = MergeTree(date, (id, date), 8192);
CREATE TABLE mass_table_364 (date Date, id Int8, name String, value Int64, sign Int8) ENGINE = CollapsingMergeTree(sign) ORDER BY (id, date);
CREATE TABLE mass_table_365 (date Date, id UInt8) ENGINE = MergeTree() ORDER BY id;
CREATE TABLE mass_table_366 (date Date, id UInt8) ENGINE = MergeTree(date, id, 8192);
CREATE TABLE mass_table_367 (date Date, keys Array(Nullable(UInt8))) ENGINE = MergeTree(date, date, 1);
CREATE TABLE mass_table_368 (date Date, name String) ENGINE = Memory;
CREATE TABLE mass_table_370 (date Date, uid Int32)ENGINE = Memory;
CREATE TABLE mass_table_371 (date Date, val Int, str String) ENGINE = Memory;
CREATE TABLE mass_table_372 (date Date, value Date MATERIALIZED toDate('2017-08-01')) ENGINE = MergeTree(date, date, 8192);
CREATE TABLE mass_table_373 (date Date, value Int64) ENGINE = MergeTree(date, date, 8192);
CREATE TABLE mass_table_374 (date Date, value UInt32) ENGINE = MergeTree(date, date, 8192);
CREATE TABLE mass_table_375 (date Date, value UInt64) ENGINE = MergeTree(date, date, 8192);
CREATE TABLE mass_table_376 (date Date, value UInt64, s String, m FixedString(16)) ENGINE = MergeTree(date, (date, value), 8);
CREATE TABLE mass_table_377 (date Date, x UInt32 Codec(Delta), s FixedString(128)) ENGINE = MergeTree ORDER BY tuple();
CREATE TABLE mass_table_378 (date DateTime('Europe/Moscow')) Engine = MergeTree ORDER BY (toStartOfHour(date));
CREATE TABLE mass_table_379 (date_time DateTime, value SimpleAggregateFunction(sum,UInt64)) ENGINE = AggregatingMergeTree PARTITION BY toStartOfInterval(date_time, INTERVAL 1 DAY) ORDER BY (date_time);
CREATE TABLE mass_table_380 (dim_key Int64, dim_id String) ENGINE = MergeTree Order by (dim_key);
CREATE TABLE mass_table_381 (domain String) ENGINE = Memory;
CREATE TABLE mass_table_382 (dt Date DEFAULT now(), id UInt32, id2 UInt32 DEFAULT id + 1) ENGINE = MergeTree(dt, dt, 8192);
CREATE TABLE mass_table_383 (dt DateTime, x UInt64) ENGINE = MergeTree PARTITION BY toYYYYMMDD(dt) ORDER BY x SETTINGS min_merge_bytes_to_use_direct_io=1, index_granularity = 8192;
CREATE TABLE mass_table_384 (dummy UInt8) ENGINE = Memory;
CREATE TABLE mass_table_385 (e Enum8('hello' = 1, 'world' = 2)) ENGINE = Memory;
CREATE TABLE mass_table_386 (entityIri String) ENGINE = Memory;
CREATE TABLE mass_table_387 (eventDate Date, id String) ENGINE = MergeTree() PARTITION BY tuple() ORDER BY eventDate;
CREATE TABLE mass_table_388 (events Array(UInt8), counts Array(UInt8)) ENGINE = Log;
CREATE TABLE mass_table_389 (field String, not_field String) ENGINE = Memory;
CREATE TABLE mass_table_391 (foo String, bar UInt64) ENGINE = Memory;
CREATE TABLE mass_table_392 (hash UInt64) ENGINE = Memory();
CREATE TABLE mass_table_394 (i Int8, n UInt8 DEFAULT 42, s String DEFAULT concat('test', CAST(n, 'String'))) ENGINE=TinyLog;
CREATE TABLE mass_table_395 (i UInt32, x_value Float64, y_value Float64) ENGINE = Memory;
CREATE TABLE mass_table_396 (i UInt64, s String, u UUID, d Date, t DateTime, a Array(UInt32)) ENGINE = Memory;
CREATE TABLE mass_table_397 (i UInt8) ENGINE = MergeTree PARTITION BY tuple() ORDER BY tuple();
CREATE TABLE mass_table_399 (i64 Int64, i32 Int32) ENGINE = Memory;
CREATE TABLE mass_table_400 (id Int32) ENGINE = Memory;
CREATE TABLE mass_table_401 (id Int32) Engine=Memory;
CREATE TABLE mass_table_402 (id Int32, name String) ENGINE = Join (ANY, LEFT, id) SETTINGS any_join_distinct_right_table_keys = 1;
CREATE TABLE mass_table_403 (id Int32, name String) Engine=Memory;
CREATE TABLE mass_table_404 (id Int32, user_id Nullable(Int32)) Engine = Memory();
CREATE TABLE mass_table_405 (id Int32, value Float64, master_id Int32) ENGINE = MergeTree() ORDER BY id;
CREATE TABLE mass_table_406 (id Nullable(UInt32), cat String) ENGINE = Log;
CREATE TABLE mass_table_407 (id String, value String) ENGINE = Join(ANY, LEFT, id) SETTINGS any_join_distinct_right_table_keys = 1;
CREATE TABLE mass_table_408 (id String, version Date) ENGINE = ReplacingMergeTree(version, id, 8192);
CREATE TABLE mass_table_409 (id UInt16 CODEC(Delta(2))) ENGINE MergeTree() order by tuple();
CREATE TABLE mass_table_410 (id UInt32) ENGINE = Memory;
CREATE TABLE mass_table_411 (id UInt32, event_date Date, priority UInt32, description String) ENGINE = MergeTree(event_date, intHash32(id), (id, event_date, intHash32(id)), 8192);
CREATE TABLE mass_table_412 (id UInt32, name String) ENGINE = Memory;
CREATE TABLE mass_table_413 (id UInt32, value1 String ) ENGINE ReplacingMergeTree() ORDER BY id;
CREATE TABLE mass_table_414 (id UInt32, value2 String ) ENGINE ReplacingMergeTree() ORDER BY id;
CREATE TABLE mass_table_415 (id UInt32, value3 String ) ENGINE ReplacingMergeTree() ORDER BY id;
CREATE TABLE mass_table_423 (id UInt64) ENGINE = Log;
CREATE TABLE mass_table_424 (id UInt64) ENGINE = Memory;
CREATE TABLE mass_table_425 (id UInt64) ENGINE = MergeTree() PARTITION BY id ORDER BY id;
CREATE TABLE mass_table_426 (id UInt64) ENGINE = Set;
CREATE TABLE mass_table_427 (id UInt64) ENGINE = StripeLog;
CREATE TABLE mass_table_428 (id UInt64) ENGINE = TinyLog;
CREATE TABLE mass_table_429 (id UInt64, date Date, uid UInt32) ENGINE = MergeTree(date, id, 8192);
CREATE TABLE mass_table_430 (id UInt64, date Date, uid UInt32, name String, Sign Int8) ENGINE = CollapsingMergeTree(date, intHash32(uid), (id, date, intHash32(uid)), 8192, Sign);
CREATE TABLE mass_table_431 (id UInt64, name String, num UInt64) ENGINE = MergeTree ORDER BY (id, name);
CREATE TABLE mass_table_432 (ip IPv4, cidr UInt8) ENGINE = Memory;
CREATE TABLE mass_table_433 (ip IPv6, cidr UInt8) ENGINE = Memory;
CREATE TABLE mass_table_434 (ipv4_ IPv4) ENGINE = Memory;
CREATE TABLE mass_table_435 (ipv6_ IPv6) ENGINE = Memory;
CREATE TABLE mass_table_436 (k UInt32) ENGINE = Memory;
CREATE TABLE mass_table_437 (k UInt32, `n.x` Array(UInt64), `n.y` Array(UInt64)) ENGINE = MergeTree ORDER BY k;
CREATE TABLE mass_table_438 (k UInt32, b UInt64, t UInt32) ENGINE = MergeTree() ORDER BY (k, t);
CREATE TABLE mass_table_439 (k UInt32, name String) ENGINE = Memory;
CREATE TABLE mass_table_440 (k UInt32, t DateTime, a Float64) ENGINE = MergeTree() ORDER BY (k, t);
CREATE TABLE mass_table_441 (k UInt32, t DateTime, b Float64) ENGINE = MergeTree() ORDER BY (k, t);
CREATE TABLE mass_table_442 (k UInt32, t UInt32, a UInt64) ENGINE = MergeTree() ORDER BY (k, t);
CREATE TABLE mass_table_443 (k UInt32, t UInt32, b UInt64) ENGINE = MergeTree() ORDER BY (k, t);
CREATE TABLE mass_table_444 (k UInt32, t UInt32, tv UInt64) ENGINE = Memory;
CREATE TABLE mass_table_445 (k UInt32, v UInt32) ENGINE Join(Any, Left, k) SETTINGS join_any_take_last_row = 1;
CREATE TABLE mass_table_446 (k UInt32, v UInt32) ENGINE Join(Any, Left, k);
CREATE TABLE mass_table_447 (k UInt32, v1 UInt64) ENGINE MergeTree ORDER BY k;
CREATE TABLE mass_table_448 (k UInt64, a String, b Nullable(String)) ENGINE = Log;
CREATE TABLE mass_table_449 (k UInt64, s String) ENGINE = Join(ANY, LEFT, k);
CREATE TABLE mass_table_450 (k UInt8, d String) ENGINE = Memory;
CREATE TABLE mass_table_451 (k UInt8, x String) ENGINE = Join(ANY, LEFT, k);
CREATE TABLE mass_table_452 (k UInt8, x String) ENGINE = Memory;
CREATE TABLE mass_table_453 (k1 UInt32, k2 UInt32, k3 UInt32, val_t1 String) ENGINE=TinyLog;
CREATE TABLE mass_table_454 (key Array(Array(Array(Array(Float64)))), name String, value UInt64) ENGINE = Memory;
CREATE TABLE mass_table_455 (key Array(Array(Array(Tuple(Float64, Float64)))), name String, value UInt64) ENGINE = Memory;
CREATE TABLE mass_table_456 (key Array(Array(Float64)), name String, value UInt64) ENGINE = Memory;
CREATE TABLE mass_table_457 (key Array(Tuple(Float64, Float64)), name String, value UInt64) ENGINE = Memory;
CREATE TABLE mass_table_458 (key Array(UInt8), s String, n UInt64, d Date MATERIALIZED '2000-01-01') ENGINE = MergeTree(d, (key, s, n), 1);
CREATE TABLE mass_table_459 (key Int) Engine=Memory();
CREATE TABLE mass_table_460 (key Int, _shard_num String) Engine=Memory();
CREATE TABLE mass_table_461 (key Int, value UInt16) Engine=Memory();
CREATE TABLE mass_table_462 (key Int64, value_default String, value_expression String) ENGINE = MergeTree ORDER BY tuple();
CREATE TABLE mass_table_464 (key UInt32, data UInt64) ENGINE = MergeTree ORDER BY key SETTINGS index_granularity=1;
CREATE TABLE mass_table_465 (key UInt32, t DateTime, bid Float64, ask Float64) ENGINE = MergeTree() ORDER BY (key, t);
CREATE TABLE mass_table_466 (key UInt32, t DateTime, tv Float64) ENGINE = MergeTree() ORDER BY (key, t);
CREATE TABLE mass_table_467 (key UInt32, value UInt32) ENGINE = MergeTree() ORDER BY key PRIMARY KEY key;
CREATE TABLE mass_table_468 (key UInt64) ENGINE=TinyLog();
CREATE TABLE mass_table_469 (key UInt64) Engine=Buffer(currentDatabase(), dist_out, 1, 0, 0, 0, 0, 0, 0);
CREATE TABLE mass_table_470 (key UInt64) Engine=Null();
CREATE TABLE mass_table_471 (key UInt64, d32 Decimal32(2), d64 Decimal64(2), d128 Decimal128(2)) ENGINE = Memory;
CREATE TABLE mass_table_472 (key UInt64, val UInt64) Engine=Memory();
CREATE TABLE mass_table_473 (key int, INDEX i1 key TYPE minmax GRANULARITY 1) Engine=MergeTree() ORDER BY key;
CREATE TABLE mass_table_474 (key1 Int32, id1 Int64, c1 Int64) ENGINE = MergeTree PARTITION BY id1 ORDER BY (key1) ;
CREATE TABLE mass_table_475 (key_column UInt64, value_column String) ENGINE = MergeTree ORDER BY key_column;
CREATE TABLE mass_table_476 (lat Float64, lon Float64, resolution UInt8) ENGINE = Memory;
CREATE TABLE mass_table_477 (learnerId UInt64) ENGINE = Memory;
CREATE TABLE mass_table_478 (message String, info String, message_type String) ENGINE = Log;
CREATE TABLE mass_table_479 (model_id UInt8) ENGINE = Memory;
CREATE TABLE mass_table_480 (n Int32) ENGINE = Memory;
CREATE TABLE mass_table_481 (n Int8) ENGINE = Buffer(currentDatabase(), file, 16, 10, 200, 10000, 1000000, 10000000, 1000000000);
CREATE TABLE mass_table_482 (n Int8) ENGINE = Memory;
CREATE TABLE mass_table_484 (n UInt64) ENGINE = MergeTree ORDER BY n SETTINGS index_granularity = 1;
CREATE TABLE mass_table_485 (n UInt8 DEFAULT 42, s String DEFAULT concat('test', CAST(n, 'String'))) ENGINE = Memory;
CREATE TABLE mass_table_486 (n UInt8) ENGINE = Memory;
CREATE TABLE mass_table_487 (n UInt8) ENGINE = MergeTree() ORDER BY n;
CREATE TABLE mass_table_488 (name String) ENGINE = MergeTree ORDER BY name;
CREATE TABLE mass_table_489 (name String, value UInt32) ENGINE = Memory;
CREATE TABLE mass_table_492 (num UInt64, str String) ENGINE = MergeTree ORDER BY num;
CREATE TABLE mass_table_493 (number UInt32, square UInt32) ENGINE = MergeTree ORDER BY tuple();
CREATE TABLE mass_table_494 (number UInt32, square UInt64) ENGINE = MergeTree ORDER BY tuple();
CREATE TABLE mass_table_495 (number UInt64) ENGINE = Log;
CREATE TABLE mass_table_496 (number UInt64) ENGINE = Memory;
CREATE TABLE mass_table_497 (number UInt64, data String) ENGINE = Join(ANY, INNER, number) SETTINGS any_join_distinct_right_table_keys = 1;
CREATE TABLE mass_table_498 (number UInt64, num2 UInt64) ENGINE = Log;
CREATE TABLE mass_table_499 (number UInt8) ENGINE = Memory;
CREATE TABLE mass_table_500 (number UInt8, value Float32) Engine = Join(ANY, LEFT, number);
CREATE TABLE mass_table_502 (order_key Array(UInt64), i8 Array(Int8), i16 Array(Int16), i32 Array(Int32), i64 Array(Int64), u8 Array(UInt8), u16 Array(UInt16), u32 Array(UInt32), u64 Array(UInt64), f32 Array(Float32), f64 Array(Float64), date Array(Date), date_time Array(DateTime('Europe/Moscow')), str Array(String), fixed_string Array(FixedString(5)), INDEX idx (i8, i16, i32, i64, u8, u16, u32, u64, f32, f64, date, date_time, str, fixed_string) TYPE bloom_filter GRANULARITY 1) ENGINE = MergeTree() ORDER BY order_key SETTINGS index_granularity = 6;
CREATE TABLE mass_table_503 (order_key UInt64, i8 Int8, i16 Int16, i32 Int32, i64 Int64, u8 UInt8, u16 UInt16, u32 UInt32, u64 UInt64, f32 Float32, f64 Float64, date Date, date_time DateTime('Europe/Moscow'), str String, fixed_string FixedString(5), INDEX idx (i8, i16, i32, i64, u8, u16, u32, u64, f32, f64, date, date_time, str, fixed_string) TYPE bloom_filter GRANULARITY 1) ENGINE = MergeTree() ORDER BY order_key SETTINGS index_granularity = 6;
CREATE TABLE mass_table_504 (order_key UInt64, i8 Nullable(Int8), i16 Nullable(Int16), i32 Nullable(Int32), i64 Nullable(Int64), u8 Nullable(UInt8), u16 Nullable(UInt16), u32 Nullable(UInt32), u64 Nullable(UInt64), f32 Nullable(Float32), f64 Nullable(Float64), date Nullable(Date), date_time Nullable(DateTime('Europe/Moscow')), str Nullable(String), fixed_string Nullable(FixedString(5)), INDEX idx (i8, i16, i32, i64, u8, u16, u32, u64, f32, f64, date, date_time, str, fixed_string) TYPE bloom_filter GRANULARITY 1) ENGINE = MergeTree() ORDER BY order_key SETTINGS index_granularity = 6;
CREATE TABLE mass_table_506 (order_key int, i Array(int), INDEX idx i TYPE bloom_filter(1.01) GRANULARITY 1024) ENGINE = MergeTree() ORDER BY order_key SETTINGS index_granularity = 1024;
CREATE TABLE mass_table_508 (order_key int, str Array(String), INDEX idx str TYPE bloom_filter(1.01) GRANULARITY 1024) ENGINE = MergeTree() ORDER BY order_key SETTINGS index_granularity = 1024;
CREATE TABLE mass_table_509 (p Date, k UInt64) ENGINE = MergeTree(p, k, 1);
CREATE TABLE mass_table_510 (p Date, k UInt64) ENGINE = Null;
CREATE TABLE mass_table_511 (p Date, k UInt64, s UInt64) ENGINE = SummingMergeTree(p, k, 1);
CREATE TABLE mass_table_512 (p Date, k UInt8, d AggregateFunction(sum, UInt64) DEFAULT arrayReduce('sumState', [toUInt64(200)])) ENGINE = AggregatingMergeTree(p, k, 1);
CREATE TABLE mass_table_513 (p UInt64, k String, d UInt64) ENGINE = MergeTree PARTITION BY p ORDER BY k;
CREATE TABLE mass_table_514 (pickup_date Date, city_id UInt32, uid UInt32)ENGINE = Memory;
CREATE TABLE mass_table_515 (platform Enum8('a' = 0, 'b' = 1)) ENGINE = Memory;
CREATE TABLE mass_table_516 (product_price Int64, product_weight Int16, amount Int64) Engine=TinyLog;
CREATE TABLE mass_table_517 (s Array(String)) ENGINE = MergeTree ORDER BY tuple() SETTINGS index_granularity = 1000;
CREATE TABLE mass_table_518 (s String) ENGINE = Log;
CREATE TABLE mass_table_519 (s String) ENGINE = MergeTree ORDER BY s SETTINGS index_granularity = 1;
CREATE TABLE mass_table_520 (s String) ENGINE = MergeTree ORDER BY s;
CREATE TABLE mass_table_521 (s String) ENGINE MergeTree PARTITION BY length(s) ORDER BY s;
CREATE TABLE mass_table_522 (s String, arr Array(UInt8)) ENGINE = Memory;
CREATE TABLE mass_table_523 (s String, d Date DEFAULT today()) ENGINE = MergeTree(d, (s, d), 1);
CREATE TABLE mass_table_524 (s String, k UInt64) ENGINE = Join(ANY, LEFT, k) SETTINGS join_use_nulls = 1;
CREATE TABLE mass_table_526 (s String, ns Nullable(String), narr Array(Nullable(UInt64))) ENGINE = Log;
CREATE TABLE mass_table_527 (s String, ns Nullable(String), narr Array(Nullable(UInt64))) ENGINE = StripeLog;
CREATE TABLE mass_table_528 (s String, ns Nullable(String), narr Array(Nullable(UInt64))) ENGINE = TinyLog;
CREATE TABLE mass_table_529 (s String, x Array(UInt8), k UInt64) ENGINE = Join(ALL, INNER, k);
CREATE TABLE mass_table_530 (s String, x Array(UInt8), k UInt64) ENGINE = Join(ALL, LEFT, k);
CREATE TABLE mass_table_531 (s String, x Array(UInt8), k UInt64) ENGINE = Join(ANY, INNER, k);
CREATE TABLE mass_table_532 (s String, x Array(UInt8), k UInt64) ENGINE = Join(ANY, LEFT, k);
CREATE TABLE mass_table_533 (s String, x Array(UInt8), k UInt64) ENGINE = Join(ANY, LEFT, s);
CREATE TABLE mass_table_534 (s String, x Int8, y Int8) ENGINE = MergeTree ORDER BY tuple();
CREATE TABLE mass_table_535 (s String, x UInt8) ENGINE = MergeTree PARTITION BY s ORDER BY x;
CREATE TABLE mass_table_536 (site String, user_id UInt64, z Float64) ENGINE = Log;
CREATE TABLE mass_table_537 (start Integer, end Integer) engine = Memory;
CREATE TABLE mass_table_538 (str FixedString(3)) ENGINE = Memory;
CREATE TABLE mass_table_539 (str String) ENGINE = MergeTree ORDER BY (str);
CREATE TABLE mass_table_540 (str String, dec Decimal64(8)) ENGINE = MergeTree ORDER BY dec;
CREATE TABLE mass_table_541 (str String, dec Decimal64(8)) ENGINE = MergeTree ORDER BY str;
CREATE TABLE mass_table_542 (str1 String, str2 String) ENGINE = Memory;
CREATE TABLE mass_table_543 (t DateTime) ENGINE = MergeTree PARTITION BY toDate(t) ORDER BY (t);
CREATE TABLE mass_table_544 (t DateTime64(3, 'UTC')) ENGINE = MergeTree() ORDER BY t;
CREATE TABLE mass_table_545 (t Int32, a UInt8) ENGINE = MergeTree ORDER BY tuple();
CREATE TABLE mass_table_546 (t Tuple(Date, UInt32, UInt64)) ENGINE = Memory;
CREATE TABLE mass_table_547 (t Tuple(int)) ENGINE = Memory;
CREATE TABLE mass_table_548 (t UInt32, k UInt32, b UInt64) ENGINE = MergeTree() ORDER BY (k, t);
CREATE TABLE mass_table_549 (test UInt8) ENGINE = TinyLog;
CREATE TABLE mass_table_550 (timecol DateTime, value Int32) ENGINE = MergeTree order by tuple();
CREATE TABLE mass_table_551 (timestamp UInt64) ENGINE = MergeTree ORDER BY (intHash32(timestamp)) SAMPLE BY intHash32(timestamp);
CREATE TABLE mass_table_552 (tkey Int32) ENGINE = MergeTree order by tuple();
CREATE TABLE mass_table_553 (ts DateTime, id String, id_b String) ENGINE = MergeTree PARTITION BY toStartOfHour(ts) ORDER BY (ts,id);
CREATE TABLE mass_table_554 (ts DateTime, id String, id_c String) ENGINE = MergeTree PARTITION BY toStartOfHour(ts) ORDER BY (ts,id);
CREATE TABLE mass_table_555 (u64 UInt64, i32 Int32, i64 UInt64, INDEX idx (i32) TYPE bloom_filter GRANULARITY 1) ENGINE = MergeTree() ORDER BY u64 SETTINGS index_granularity = 6;
CREATE TABLE mass_table_556 (uid String, its UInt32, action_code String, day Date) ENGINE = MergeTree(day, (uid, its), 8192);
CREATE TABLE mass_table_557 (uid UInt64, ts DateTime, val Float64) ENGINE = MergeTree PARTITION BY toDate(ts) ORDER BY (uid, ts);
CREATE TABLE mass_table_558 (user_id Int32, name String) Engine = Join(ANY, LEFT, user_id);
CREATE TABLE mass_table_559 (userid UInt64) ENGINE = MergeTree() PARTITION BY (intDiv(userid, 500)) ORDER BY (userid) SETTINGS index_granularity = 8192;
CREATE TABLE mass_table_560 (userid UInt64) ENGINE = Set;
CREATE TABLE mass_table_562 (v UInt64) ENGINE = Null;
CREATE TABLE mass_table_563 (v UInt64) Engine = MergeTree() ORDER BY v;
CREATE TABLE mass_table_564 (v1 String, v2 UInt8, v3 DEFAULT v2 * 16, v4 UInt8 DEFAULT 8) ENGINE = MergeTree() ORDER BY v2;
CREATE TABLE mass_table_566 (v6 FixedString(16)) ENGINE=Memory;
CREATE TABLE mass_table_567 (val Date) ENGINE = MergeTree ORDER BY val SETTINGS index_granularity = 1, index_granularity_bytes = 0;
CREATE TABLE mass_table_568 (val Enum16('hello' = 1, 'world' = 2, 'yandex' = 256, 'clickhouse' = 257)) ENGINE = MergeTree ORDER BY val SETTINGS index_granularity = 1, index_granularity_bytes = 0;
CREATE TABLE mass_table_569 (val FixedString(1)) ENGINE = MergeTree ORDER BY val SETTINGS index_granularity = 1, index_granularity_bytes = 0;
CREATE TABLE mass_table_570 (val Int32) ENGINE = MergeTree ORDER BY val SETTINGS index_granularity = 1, index_granularity_bytes = 0;
CREATE TABLE mass_table_571 (val Int64) engine = Memory;
CREATE TABLE mass_table_573 (val String) ENGINE = MergeTree ORDER BY val SETTINGS index_granularity = 1, index_granularity_bytes = 0;
CREATE TABLE mass_table_574 (val UInt32) ENGINE = MergeTree ORDER BY val SETTINGS index_granularity = 1, index_granularity_bytes = 0;
CREATE TABLE mass_table_575 (val UInt64) engine = Memory;
CREATE TABLE mass_table_576 (val1 String, val2 UInt32) ENGINE = MergeTree ORDER BY val1;
CREATE TABLE mass_table_577 (val_t2 String, k3 UInt32, k2_alias UInt32, k1 UInt32) ENGINE=TinyLog;
CREATE TABLE mass_table_578 (value Int8) ENGINE = TinyLog;
CREATE TABLE mass_table_579 (value UInt64) ENGINE=Memory();
CREATE TABLE mass_table_580 (value UInt8, name String) ENGINE = MergeTree() ORDER BY value;
CREATE TABLE mass_table_581 (value UInt8, word String) ENGINE = MergeTree() ORDER BY value;
CREATE TABLE mass_table_582 (value1 UInt64, value2 UInt64) ENGINE = MergeTree ORDER BY tuple();
CREATE TABLE mass_table_583 (x Array(String), y Nullable(String), z Array(Array(Nullable(String)))) ENGINE = TinyLog;
CREATE TABLE mass_table_584 (x Array(UInt32), z String DEFAULT '', y Array(UInt32)) ENGINE = Memory;
CREATE TABLE mass_table_585 (x Array(UInt64)) ENGINE = TinyLog;
CREATE TABLE mass_table_586 (x Array(UInt64), y ALIAS x, s String) ENGINE = MergeTree ORDER BY tuple();
CREATE TABLE mass_table_587 (x Array(UInt64), z String DEFAULT '', y Array(UInt64)) ENGINE = Memory;
CREATE TABLE mass_table_588 (x Array(UInt8)) ENGINE=TinyLog;
CREATE TABLE mass_table_589 (x DateTime) ENGINE = Memory;
CREATE TABLE mass_table_590 (x Enum8('browser' = 1, 'mobile' = 2), y String) ENGINE = Memory;
CREATE TABLE mass_table_591 (x FixedString(16)) ENGINE = Memory;
CREATE TABLE mass_table_592 (x Float64) ENGINE = Log;
CREATE TABLE mass_table_593 (x Float64, y Float64, def_i UInt64, def_s String) ENGINE = Memory;
CREATE TABLE mass_table_594 (x Int32) ENGINE = Log;
CREATE TABLE mass_table_595 (x Int32) ENGINE = Memory;
CREATE TABLE mass_table_596 (x Int64) ENGINE = Memory;
CREATE TABLE mass_table_597 (x Int64, y Int64, insert_time DateTime) ENGINE = MergeTree ORDER BY tuple();
CREATE TABLE mass_table_598 (x Int8) ENGINE=Log;
CREATE TABLE mass_table_599 (x Nullable(String)) ENGINE = Memory;
CREATE TABLE mass_table_600 (x Nullable(UInt32), lc Nullable(String)) ENGINE = Memory;
CREATE TABLE mass_table_601 (x String) ENGINE = Memory;
CREATE TABLE mass_table_602 (x String) ENGINE = MergeTree ORDER BY x;
CREATE TABLE mass_table_603 (x String) ENGINE = Null;
CREATE TABLE mass_table_604 (x String) ENGINE = Set;
CREATE TABLE mass_table_605 (x String, y String) ENGINE = TinyLog;
CREATE TABLE mass_table_606 (x UInt16) ENGINE = TinyLog;
CREATE TABLE mass_table_607 (x UInt32) ENGINE = MergeTree ORDER BY x SETTINGS index_granularity = 1;
CREATE TABLE mass_table_608 (x UInt32) ENGINE = MergeTree ORDER BY x SETTINGS index_granularity_bytes = 4, write_final_mark = 0;
CREATE TABLE mass_table_609 (x UInt32) ENGINE TinyLog;
CREATE TABLE mass_table_611 (x UInt32, lc String) ENGINE = Memory;
CREATE TABLE mass_table_612 (x UInt32, s String) engine = Join(ALL, FULL, x) SETTINGS join_use_nulls = 1;
CREATE TABLE mass_table_613 (x UInt32, s String) engine = Join(ALL, FULL, x);
CREATE TABLE mass_table_614 (x UInt32, s String) engine = Join(ALL, INNER, x) SETTINGS join_use_nulls = 1;
CREATE TABLE mass_table_615 (x UInt32, s String) engine = Join(ALL, INNER, x);
CREATE TABLE mass_table_616 (x UInt32, s String) engine = Join(ALL, LEFT, x) SETTINGS join_use_nulls = 1;
CREATE TABLE mass_table_617 (x UInt32, s String) engine = Join(ALL, LEFT, x);
CREATE TABLE mass_table_618 (x UInt32, s String) engine = Join(ALL, RIGHT, x) SETTINGS join_use_nulls = 1;
CREATE TABLE mass_table_619 (x UInt32, s String) engine = Join(ALL, RIGHT, x);
CREATE TABLE mass_table_620 (x UInt32, s String) engine = Join(ANTI, LEFT, x);
CREATE TABLE mass_table_621 (x UInt32, s String) engine = Join(ANTI, RIGHT, x);
CREATE TABLE mass_table_622 (x UInt32, s String) engine = Join(ANY, INNER, x);
CREATE TABLE mass_table_623 (x UInt32, s String) engine = Join(ANY, LEFT, x);
CREATE TABLE mass_table_624 (x UInt32, s String) engine = Join(ANY, RIGHT, x);
CREATE TABLE mass_table_625 (x UInt32, s String) engine = Join(SEMI, LEFT, x);
CREATE TABLE mass_table_626 (x UInt32, s String) engine = Join(SEMI, RIGHT, x);
CREATE TABLE mass_table_627 (x UInt32, s String) engine = Memory;
CREATE TABLE mass_table_628 (x UInt32, s String, sign Int8) ENGINE CollapsingMergeTree(sign) ORDER BY tuple();
CREATE TABLE mass_table_629 (x UInt32, s String, v UInt32) ENGINE ReplacingMergeTree(v) ORDER BY tuple();
CREATE TABLE mass_table_630 (x UInt32, str String) engine = Memory;
CREATE TABLE mass_table_631 (x UInt32, y Int32) ENGINE MergeTree PARTITION BY x ORDER BY x;
CREATE TABLE mass_table_632 (x UInt32, y String) ENGINE MergeTree ORDER BY tuple() SETTINGS vertical_merge_algorithm_min_rows_to_activate=0, vertical_merge_algorithm_min_columns_to_activate=0;
CREATE TABLE mass_table_633 (x UInt32, y UInt32 ALIAS x + 1) ENGINE TinyLog;
CREATE TABLE mass_table_634 (x UInt32, y UInt32 DEFAULT x + 1) ENGINE TinyLog;
CREATE TABLE mass_table_635 (x UInt32, y UInt32 DEFAULT x) ENGINE = Memory;
CREATE TABLE mass_table_636 (x UInt32, y UInt32 MATERIALIZED x + 1) ENGINE TinyLog;
CREATE TABLE mass_table_637 (x UInt32, y UInt32) ENGINE MergeTree ORDER BY x;
CREATE TABLE mass_table_638 (x UInt32, y UInt32) ENGINE MergeTree() ORDER BY x;
CREATE TABLE mass_table_639 (x UInt32, y UInt32) ENGINE TinyLog;
CREATE TABLE mass_table_640 (x UInt32, y UInt32, val UInt32) ENGINE SummingMergeTree ORDER BY (x, y);
CREATE TABLE mass_table_641 (x UInt32, y UInt64) engine = MergeTree ORDER BY (x,y);
CREATE TABLE mass_table_642 (x UInt32, z UInt64) ENGINE MergeTree ORDER BY x;
CREATE TABLE mass_table_643 (x UInt64) ENGINE = Memory;
CREATE TABLE mass_table_644 (x UInt64) ENGINE = MergeTree ORDER BY tuple() SETTINGS index_granularity = 256;
CREATE TABLE mass_table_645 (x UInt64) ENGINE = MergeTree ORDER BY tuple();
CREATE TABLE mass_table_646 (x UInt64) ENGINE = MergeTree ORDER BY x PARTITION BY x;
CREATE TABLE mass_table_647 (x UInt64) ENGINE = MergeTree ORDER BY x SETTINGS index_granularity = 1;
CREATE TABLE mass_table_648 (x UInt64) ENGINE = MergeTree ORDER BY x SETTINGS max_part_loading_threads = 16, parts_to_delay_insert = 100000, parts_to_throw_insert = 100000;
CREATE TABLE mass_table_649 (x UInt64) ENGINE = MergeTree ORDER BY x SETTINGS max_part_removal_threads = 16, cleanup_delay_period = 1, cleanup_delay_period_random_add = 0, old_parts_lifetime = 1, parts_to_delay_insert = 100000, parts_to_throw_insert = 100000;
CREATE TABLE mass_table_650 (x UInt64) ENGINE = MergeTree ORDER BY x;
CREATE TABLE mass_table_651 (x UInt64) ENGINE = TinyLog;
CREATE TABLE mass_table_652 (x UInt64, arr Array(Array(String))) ENGINE = MergeTree ORDER BY x;
CREATE TABLE mass_table_653 (x UInt64, arr Array(Array(String)), t Tuple(String, Array(Nullable(String)), Tuple(UInt32, Date))) ENGINE = Log;
CREATE TABLE mass_table_654 (x UInt64, arr Array(Array(String)), t Tuple(String, Array(Nullable(String)), Tuple(UInt32, Date))) ENGINE = Memory;
CREATE TABLE mass_table_655 (x UInt64, arr Array(Array(String)), t Tuple(String, Array(Nullable(String)), Tuple(UInt32, Date))) ENGINE = StripeLog;
CREATE TABLE mass_table_656 (x UInt64, arr Array(Array(String)), t Tuple(String, Array(Nullable(String)), Tuple(UInt32, Date))) ENGINE = TinyLog;
CREATE TABLE mass_table_657 (x UInt64, d Date DEFAULT today()) ENGINE = MergeTree(d, intHash64(x), intHash64(x), 10);
CREATE TABLE mass_table_658 (x UInt64, date Date) ENGINE = MergeTree(date, x, 1);
CREATE TABLE mass_table_660 (x UInt64, p UInt8) ENGINE = MergeTree ORDER BY tuple() PARTITION BY p SETTINGS index_granularity_bytes=10000, write_final_mark=1;
CREATE TABLE mass_table_661 (x UInt64, p UInt8) ENGINE = MergeTree ORDER BY tuple() PARTITION BY p;
CREATE TABLE mass_table_662 (x UInt64, s String) ENGINE = MergeTree ORDER BY x;
CREATE TABLE mass_table_663 (x UInt64, y UInt64 DEFAULT throwIf(x > 1500000)) ENGINE = Memory;
CREATE TABLE mass_table_664 (x UInt64, y UInt64 DEFAULT x) ENGINE = Memory;
CREATE TABLE mass_table_665 (x UInt64, y UInt64) ENGINE = Buffer(currentDatabase(), dst_00753, 1, 99999, 99999, 1, 1, 99999, 99999);
CREATE TABLE mass_table_666 (x UInt64, y UInt64) ENGINE = MergeTree ORDER BY tuple();
CREATE TABLE mass_table_668 (x UInt8) ENGINE = Log;
CREATE TABLE mass_table_669 (x UInt8) ENGINE = Memory;
CREATE TABLE mass_table_670 (x UInt8) ENGINE = MergeTree ORDER BY tuple();
CREATE TABLE mass_table_671 (x UInt8) ENGINE = MergeTree ORDER BY x;
CREATE TABLE mass_table_672 (x UInt8) ENGINE = MergeTree ORDER BY x;
CREATE TABLE mass_table_673 (x UInt8) ENGINE = Null;
CREATE TABLE mass_table_675 (x UInt8) ENGINE = StripeLog;
CREATE TABLE mass_table_677 (x UInt8) ENGINE = TinyLog;
CREATE TABLE mass_table_678 (x UInt8) ENGINE Memory;
CREATE TABLE mass_table_679 (x UInt8) ENGINE MergeTree ORDER BY x;
CREATE TABLE mass_table_685 (x UInt8, s String) ENGINE = MergeTree ORDER BY tuple();
CREATE TABLE mass_table_686 (x UInt8, title String) ENGINE = Memory;
CREATE TABLE mass_table_687 (x UInt8, y Date) ENGINE = MergeTree ORDER BY x;
CREATE TABLE mass_table_688 (x UInt8, y Float32, z String) ENGINE = Memory;
CREATE TABLE mass_table_689 (x UUID) ENGINE=TinyLog;
CREATE TABLE mass_table_695 ENGINE = Log AS SELECT number FROM numbers (1000);
CREATE TABLE mass_table_696 ENGINE = Memory AS SELECT number % 10 as id, toString (intDiv((number%10000), 10)) as v FROM system.numbers LIMIT 10000000;
CREATE TABLE mass_table_697 ENGINE = Memory AS SELECT number FROM numbers (1000);
CREATE TABLE mass_table_698 ENGINE = Memory AS SELECT number as _table FROM numbers (1000);
CREATE TABLE mass_table_699 ENGINE = MergeTree ORDER BY intHash32 (number) SAMPLE BY intHash32(number) AS SELECT number FROM numbers(1000);
CREATE TABLE mass_table_700 ENGINE = MergeTree ORDER BY number AS SELECT number FROM numbers (1000);
CREATE TABLE mass_table_701 ENGINE = MergeTree ORDER BY number AS SELECT number, arrayMap (x -> (x, [x], [[x]], (x, toString(x))), arrayMap(x -> range(x), range(number % 10))) AS value FROM system.numbers LIMIT 100000;
CREATE TABLE mass_table_703 ENGINE = StripeLog AS SELECT number FROM numbers (1000);
CREATE TABLE mass_table_704 ENGINE = TinyLog AS SELECT number FROM numbers (1000);
CREATE TABLE mass_table_705 Engine = MergeTree ORDER BY number AS SELECT number, toString (rand()) x from numbers(10000000);

script.sh

# STEP 1 CREATE DB AND TABLES
clickhouse-client -m -n <<< "DROP DATABASE IF EXISTS tmp1; CREATE DATABASE tmp1";
sleep 1;
cat ./mass_create_tables.sql  | tee /dev/fd/2 | clickhouse-client -m -n --database tmp1

# WRITE DATA
for table in $(cat ./mass_create_tables.sql | grep -v mass_table_701  |grep -v mass_table_457 | grep -v GenerateRandom | grep -v AggregateFunction | grep -v LowCardinality | grep -v ALIAS | awk '{print $3}'); do echo $table && echo "DESC TABLE " $table " ;" | clickhouse-client -m -n --database tmp1 | grep -v MATERIALIZED | awk  'BEGIN {FS = "[\t]+"};{print "`"$1 "` " $2 ","}'| tr -d '\n'| head -c-1 | awk -v table="$table" '{print "INSERT INTO " table " SELECT * FROM generateRandom(\x27" $0 "\x27, 1, 10, 2) LIMIT 100;"}' | clickhouse-client -m -n --database tmp1 --log-level=debug; done