Skip to content

Cannot read all data on insert using ReplacingMergeTree and DateTime64 nanos  #95

@tim-spectrust

Description

@tim-spectrust

Hello, I am encountering the following error when inserting a somewhat large row into a table:

bad response: Code: 33. DB::Exception: Cannot read all data. Bytes read: 1. Bytes expected: 8.: (at row 2)
: While executing BinaryRowInputFormat. (CANNOT_READ_ALL_DATA) (version 23.9.2.56 (official build)))

Here is an example to reproduce where I am just setting None for all Option's (vast majority of columns) to limit the cause. As the struct matches the DDL exactly, I suspect it may have to do with using ReplacingMergeTree engine, using DateTime64 with nanosecond resolution (which I am serializing as an i64), or just the large size of the struct being serialized.

DDL:

CREATE TABLE IF NOT EXISTS events (
    field_1 String NULL,
    field_2 String NULL,
    field_3 String NULL,
    field_4 String NULL,
    field_5 String NULL,
    field_6 String NULL,
    field_7 String NULL,
    field_8 String NULL,
    field_9 String NULL,
    field_10 String NULL,
    field_11 String NULL,
    field_12 String NULL,
    field_13 String NULL,
    field_14 String NULL,
    field_15 Float64 NULL,
    field_16 String NULL,
    field_17 Float64 NULL,
    field_18 String NULL,
    field_19 String NULL,
    field_20 String NULL,
    field_21 String NULL,
    field_22 String NULL,
    field_23 String NULL,
    field_24 String NULL,
    field_25 String NULL,
    field_26 String NULL,
    field_27 String NULL,
    field_28 String NULL,
    field_29 String NULL,
    field_30 String NULL,
    field_31 String NULL,
    field_32 String NULL,
    field_33 Float64 NULL,
    field_34 String NULL,
    field_35 Float64 NULL,
    field_36 String NULL,
    field_37 String NULL,
    field_38 String NULL,
    field_39 String NULL,
    field_40 String NULL,
    field_41 String NULL,
    field_42 String NULL,
    field_43 String NULL,
    field_44 String NULL,
    field_45 String NULL,
    field_46 String NULL,
    field_47 String NULL,
    field_48 String NULL,
    field_49 String NULL,
    field_50 String NULL,
    field_51 Float64 NULL,
    field_52 String NULL,
    field_53 Float64 NULL,
    field_54 String NULL,
    field_55 String NULL,
    field_56 String NULL,
    field_57 String NULL,
    field_58 String NULL,
    field_59 String NULL,
    field_60 String NULL,
    field_61 String NULL,
    field_62 String NULL,
    field_63 String NULL,
    field_64 String NULL,
    field_65 String NULL,
    field_66 String NULL,
    field_67 String NULL,
    field_68 String NULL,
    field_69 Float64 NULL,
    field_70 String NULL,
    field_71 Float64 NULL,
    field_72 String NULL,
    field_73 String NULL,
    field_74 String NULL,
    field_75 Float64 NULL,
    field_76 String NULL,
    field_77 String NULL,
    field_78 String NULL,
    field_79 String NULL,
    field_80 String NULL,
    field_81 String NULL,
    field_82 String NULL,
    field_83 String NULL,
    field_84 String NULL,
    field_85 String NULL,
    field_86 String NULL,
    field_87 String NULL,
    field_88 String NULL,
    field_89 String NULL,
    field_90 String NULL,
    field_91 Float64 NULL,
    field_92 String NULL,
    field_93 UInt64 NULL,
    field_94 String NULL,
    field_95 Float64 NULL,
    field_96 String NULL,
    field_97 String NULL,
    field_98 String NULL,
    field_99 DateTime64(9, 'UTC'),
    field_100 DateTime64(9, 'UTC'),
    field_101 String NULL,
    field_102 String NULL,
    field_103 String NULL,
    field_104 String NULL,
    field_105 String NULL,
    field_106 String NULL,
    field_107 String NULL,
    field_108 String NULL,
    field_109 String NULL,
    field_110 String NULL,
    field_111 String NULL,
    field_112 String NULL,
    field_113 String NULL,
    field_114 String NULL,
    field_115 UUID, 
    field_116 String NULL,
    field_117 String NULL,
    field_118 String NULL,
    field_119 String NULL,
    field_120 String NULL,
    field_121 String NULL,
    field_122 IPv4 NULL,
    field_123 String NULL,
    field_124 String NULL,
    field_125 String NULL,
    field_126 String NULL,
    field_127 String NULL,
    field_128 String NULL,
    field_129 String NULL,
    field_130 String NULL,
    field_131 String NULL,
    field_132 Boolean NULL,
    field_133 String NULL,
    field_134 String NULL,
    field_135 String NULL,
    field_136 Float64 NULL,
    field_137 String NULL,
    field_138 Float64 NULL,
    field_139 String NULL,
    field_140 String NULL,
    field_141 String NULL,
    field_142 String NULL,
    field_143 String NULL,
    field_144 IPv4 NULL,
    field_145 String NULL,
    field_146 String NULL,
    field_147 String NULL,
    field_148 String NULL,
    field_149 String NULL,
    field_150 String NULL,
    field_151 String NULL,
    field_152 String NULL,
    field_153 String NULL,
    field_154 Boolean NULL,
    field_155 String NULL,
    field_156 String NULL,
    field_157 String NULL,
    field_158 Float64 NULL,
    field_159 String NULL,
    field_160 Float64 NULL,
    field_161 String NULL,
    field_162 String NULL,
    field_163 String NULL,
    field_164 String NULL,
    field_165 String NULL,
    field_166 IPv4 NULL,
    field_167 String NULL,
    field_168 String NULL,
    field_169 String NULL,
    field_170 String NULL,
    field_171 String NULL,
    field_172 String NULL,
    field_173 String NULL,
    field_174 String NULL,
    field_175 String NULL,
    field_176 Boolean NULL,
    field_177 String NULL,
    field_178 String NULL,
    field_179 String NULL,
    field_180 Float64 NULL,
    field_181 String NULL,
    field_182 Float64 NULL,
    field_183 String NULL,
    field_184 String NULL,
    field_185 String NULL,
    field_186 String NULL,
    field_187 String NULL,
    field_188 Boolean NULL,
    field_189 String NULL,
    field_190 String NULL,
    field_191 String NULL,
    field_192 String NULL,
    field_193 String NULL,
    field_194 String NULL,
    field_195 String NULL,
    field_196 String NULL,
    field_197 String NULL,
    field_198 String NULL,
    field_199 String NULL,
    field_200 String NULL,
    field_201 String NULL,
    field_202 String NULL,
    field_203 String NULL,
    field_204 String NULL,
    field_205 String NULL,
    field_206 String NULL,
    field_207 String NULL,
    field_208 String NULL,
    field_209 String NULL,
    field_210 String NULL,
    field_211 String NULL,
    field_212 String NULL,
    field_213 String NULL,
    field_214 String NULL,
    field_215 String NULL,
    field_216 String NULL,
    field_217 String NULL,
    field_218 String NULL,
    field_219 String NULL,
    field_220 String NULL,
    field_221 String NULL,
    field_222 UInt8 NULL,
    field_223 String NULL,
    field_224 UInt8 NULL,
    field_225 String NULL,
    field_226 String NULL,
    field_227 String NULL,
    field_228 String NULL,
    field_229 String NULL,
    field_230 String NULL,
    field_231 String NULL,
    field_232 String NULL,
    field_233 String NULL,
    field_234 String NULL,
    field_235 String NULL,
    field_236 String NULL,
    field_237 String NULL,
    field_238 String NULL,
    field_239 String NULL,
    field_240 UInt8 NULL,
    field_241 String NULL,
    field_242 UInt8 NULL,
    field_243 String NULL,
    field_244 String NULL,
    field_245 String NULL,
    field_246 String NULL,
    field_247 String NULL,
    field_248 String NULL,
    field_249 String NULL,
    field_250 String NULL,
    field_251 String NULL,
    field_252 String NULL,
    field_253 String NULL,
    field_254 String NULL,
    field_255 String NULL,
    field_256 String NULL,
    field_257 String NULL,
    field_258 String NULL,
    field_259 String NULL,
    field_260 String NULL,
    field_261 String NULL,
    field_262 String NULL,
    field_263 String NULL,
    field_264 String NULL,
    field_265 String NULL,
    field_266 String NULL,
    field_267 String NULL,
    field_268 UInt16 NULL,
    field_269 String NULL,
    field_270 String NULL,
    field_271 String NULL,
    field_272 String NULL,
    field_273 String NULL,
    field_274 Int64 NULL,
    field_275 String NULL,
    field_276 String, 
    field_277 UInt64 NULL,
    field_278 String NULL,
    field_279 String NULL,
    field_280 String NULL,
    field_281 String NULL,
    field_282 String NULL,
    field_283 String NULL,
    field_284 String NULL,
    field_285 String NULL,
    field_286 String NULL,
    field_287 Float64 NULL,
    field_288 String NULL,
    field_289 String NULL,
    field_290 String NULL,
    field_291 String NULL,
    field_292 String NULL,
    field_293 DateTime64(9, 'UTC'),
    field_294 String NULL,
    field_295 String NULL,
    field_296 String NULL,
    field_297 String NULL,
    field_298 String NULL,
    field_299 String NULL,
    field_300 String NULL,
    field_301 String NULL,
    field_302 String NULL,
    field_303 String NULL,
    field_304 String NULL,
    field_305 String NULL,
    field_306 String NULL,
    field_307 String NULL,
    field_308 String NULL,
    field_309 String NULL,
    field_310 String NULL,
    field_311 String NULL,
    field_312 String NULL,
    field_313 String NULL,
    field_314 String NULL,
    field_315 String NULL,
    field_316 String NULL,
    field_317 String NULL,
    field_318 String NULL,
    field_319 String NULL,
    field_320 String NULL,
    field_321 String NULL,
    field_322 String NULL,
    field_323 String NULL,
    field_324 String NULL,
    field_325 String NULL,
    field_326 String NULL,
    field_327 String NULL,
    field_328 String NULL,
    field_329 String NULL,
    field_330 String NULL,
    field_331 String NULL,
    field_332 String NULL,
    field_333 String NULL,
    field_334 String NULL,
    field_335 String NULL,
    field_336 String NULL,
    field_337 String NULL,
    field_338 String NULL,
    field_339 String NULL,
    field_340 String NULL,
    field_341 String NULL,
    field_342 String NULL,
    field_343 String NULL,
    field_344 String NULL,
    field_345 String NULL,
    field_346 String NULL,
    field_347 String NULL,
    field_348 String NULL,
    field_349 String NULL,
    field_350 String NULL,
    field_351 String NULL,
    field_352 String NULL,
    field_353 String NULL,
    field_354 String NULL,
    field_355 String NULL,
    field_356 String NULL,
    field_357 String NULL,
    field_358 String NULL,
    field_359 String NULL,
    field_360 String NULL,
    field_361 String NULL,
    field_362 String NULL,
    field_363 String NULL,
    field_364 String NULL,
    field_365 String NULL,
    field_366 String NULL,
    field_367 String NULL,
    field_368 String NULL,
    field_369 String NULL,
    field_370 String NULL,
    field_371 String NULL,
    field_372 String NULL,
    field_373 String NULL,
    field_374 String NULL,
    field_375 String NULL,
    field_376 String NULL,
    field_377 String NULL,
    field_378 String NULL,
    field_379 String NULL,
    field_380 String NULL,
    field_381 String NULL,
    field_382 String NULL,
    field_383 String NULL,
    field_384 String NULL,
    field_385 String NULL,
    field_386 String NULL,
    field_387 String NULL,
    field_388 String NULL,
    field_389 String NULL,
    field_390 String NULL,
    field_391 String NULL,
    field_392 String NULL,
    field_393 String NULL,
    field_394 Float64 NULL,
    field_395 String NULL,
    field_396 Float64 NULL,
    field_397 String NULL,
    field_398 Float64 NULL,
    field_399 String NULL,
    field_400 Float64 NULL,
    field_401 String NULL,
    field_402 Float64 NULL,
    field_403 String NULL,
    field_404 Float64 NULL,
    field_405 String NULL,
    field_406 Float64 NULL,
    field_407 String NULL,
    field_408 Float64 NULL,
    field_409 String NULL,
    field_410 Float64 NULL,
    field_411 String NULL,
    field_412 Float64 NULL,
    field_413 String NULL,
    field_414 Float64 NULL,
    field_415 String NULL,
    field_416 Float64 NULL,
    field_417 String NULL,
    field_418 Float64 NULL,
    field_419 String NULL,
    field_420 Float64 NULL,
    field_421 String NULL,
    field_422 Float64 NULL,
    field_423 String NULL,
    field_424 Float64 NULL,
    field_425 String NULL,
    field_426 Float64 NULL,
    field_427 String NULL,
    field_428 Float64 NULL,
    field_429 String NULL,
    field_430 Float64 NULL,
    field_431 String NULL,
    field_432 Float64 NULL,
    field_433 String NULL,
    field_434 Float64 NULL,
    field_435 String NULL,
    field_436 Float64 NULL,
    field_437 String NULL,
    field_438 Float64 NULL,
    field_439 String NULL,
    field_440 Float64 NULL,
    field_441 String NULL,
    field_442 Float64 NULL,
    field_443 String NULL,
    field_444 Float64 NULL,
    field_445 String NULL,
    field_446 Float64 NULL,
    field_447 String NULL,
    field_448 Float64 NULL,
    field_449 String NULL,
    field_450 Float64 NULL,
    field_451 String NULL,
    field_452 Float64 NULL,
    field_453 String NULL,
    field_454 String NULL,
    field_455 String NULL,
    field_456 String NULL,
    field_457 String NULL,
    field_458 String NULL,
    field_459 String NULL,
    field_460 String NULL,
    field_461 String NULL,
    field_462 String NULL,
    field_463 String NULL,
    field_464 String NULL,
    field_465 String NULL,
    field_466 String NULL,
    field_467 String NULL,
    field_468 String NULL,
    field_469 String NULL,
    field_470 String NULL,
    field_471 String NULL,
    field_472 String NULL,
    field_473 String NULL,
    field_474 String NULL,
    field_475 String NULL,
    field_476 String NULL,
    field_477 String NULL,
    field_478 String NULL,
    field_479 String NULL,
    field_480 String NULL,
    field_481 String NULL,
    field_482 String NULL,
    field_483 String NULL,
    field_484 String NULL,
    field_485 String NULL,
    field_486 String NULL,
    field_487 String NULL,
    field_488 String NULL,
    field_489 String NULL,
    field_490 String NULL,
    field_491 String NULL,
    field_492 String NULL,
    field_493 String NULL,
    field_494 String NULL,
    field_495 String NULL,
    field_496 String NULL,
    field_497 String NULL,
    field_498 String NULL,
    field_499 String NULL,
    field_500 String NULL,
    field_501 String NULL,
    field_502 String NULL,
    field_503 String NULL,
    field_504 String NULL,
    field_505 String NULL,
    field_506 String NULL,
    field_507 String NULL,
    field_508 String NULL,
    field_509 String NULL,
    field_510 String NULL,
    field_511 String NULL,
    field_512 String NULL,
    field_513 String NULL,
    field_514 String NULL,
    field_515 String NULL,
    field_516 String NULL,
    field_517 Enum8('x' = 0,'y' = 1,'z' = 2) NULL,
    field_518 Array(String) NOT NULL DEFAULT [],
    field_519 Array(Tuple(String, String)) DEFAULT []
)
ENGINE = ReplacingMergeTree()
ORDER BY (field_276, field_99, field_100, field_115)
PRIMARY KEY (field_276, field_99)
;

Rust Row struct:

#[derive(Debug, Row, Serialize, Deserialize)]
pub struct MyRow {
    field_1: Option<String>,
    field_2: Option<String>,
    field_3: Option<String>,
    field_4: Option<String>,
    field_5: Option<String>,
    field_6: Option<String>,
    field_7: Option<String>,
    field_8: Option<String>,
    field_9: Option<String>,
    field_10: Option<String>,
    field_11: Option<String>,
    field_12: Option<String>,
    field_13: Option<String>,
    field_14: Option<String>,
    field_15: Option<f64>,
    field_16: Option<String>,
    field_17: Option<f64>,
    field_18: Option<String>,
    field_19: Option<String>,
    field_20: Option<String>,
    field_21: Option<String>,
    field_22: Option<String>,
    field_23: Option<String>,
    field_24: Option<String>,
    field_25: Option<String>,
    field_26: Option<String>,
    field_27: Option<String>,
    field_28: Option<String>,
    field_29: Option<String>,
    field_30: Option<String>,
    field_31: Option<String>,
    field_32: Option<String>,
    field_33: Option<f64>,
    field_34: Option<String>,
    field_35: Option<f64>,
    field_36: Option<String>,
    field_37: Option<String>,
    field_38: Option<String>,
    field_39: Option<String>,
    field_40: Option<String>,
    field_41: Option<String>,
    field_42: Option<String>,
    field_43: Option<String>,
    field_44: Option<String>,
    field_45: Option<String>,
    field_46: Option<String>,
    field_47: Option<String>,
    field_48: Option<String>,
    field_49: Option<String>,
    field_50: Option<String>,
    field_51: Option<f64>,
    field_52: Option<String>,
    field_53: Option<f64>,
    field_54: Option<String>,
    field_55: Option<String>,
    field_56: Option<String>,
    field_57: Option<String>,
    field_58: Option<String>,
    field_59: Option<String>,
    field_60: Option<String>,
    field_61: Option<String>,
    field_62: Option<String>,
    field_63: Option<String>,
    field_64: Option<String>,
    field_65: Option<String>,
    field_66: Option<String>,
    field_67: Option<String>,
    field_68: Option<String>,
    field_69: Option<f64>,
    field_70: Option<String>,
    field_71: Option<f64>,
    field_72: Option<String>,
    field_73: Option<String>,
    field_74: Option<String>,
    field_75: Option<f64>,
    field_76: Option<String>,
    field_77: Option<String>,
    field_78: Option<String>,
    field_79: Option<String>,
    field_80: Option<String>,
    field_81: Option<String>,
    field_82: Option<String>,
    field_83: Option<String>,
    field_84: Option<String>,
    field_85: Option<String>,
    field_86: Option<String>,
    field_87: Option<String>,
    field_88: Option<String>,
    field_89: Option<String>,
    field_90: Option<String>,
    field_91: Option<f64>,
    field_92: Option<String>,
    field_93: Option<u64>,
    field_94: Option<String>,
    field_95: Option<f64>,
    field_96: Option<String>,
    field_97: Option<String>,
    field_98: Option<String>,
    field_99: i64, // DateTime64(9, 'UTC'),
    field_100: i64, // DateTime64(9, 'UTC'),
    field_101: Option<String>,
    field_102: Option<String>,
    field_103: Option<String>,
    field_104: Option<String>,
    field_105: Option<String>,
    field_106: Option<String>,
    field_107: Option<String>,
    field_108: Option<String>,
    field_109: Option<String>,
    field_110: Option<String>,
    field_111: Option<String>,
    field_112: Option<String>,
    field_113: Option<String>,
    field_114: Option<String>,
    field_115: Uuid,
    field_116: Option<String>,
    field_117: Option<String>,
    field_118: Option<String>,
    field_119: Option<String>,
    field_120: Option<String>,
    field_121: Option<String>,
    field_122: Option<Ipv4Addr>,
    field_123: Option<String>,
    field_124: Option<String>,
    field_125: Option<String>,
    field_126: Option<String>,
    field_127: Option<String>,
    field_128: Option<String>,
    field_129: Option<String>,
    field_130: Option<String>,
    field_131: Option<String>,
    field_132: Option<bool>,
    field_133: Option<String>,
    field_134: Option<String>,
    field_135: Option<String>,
    field_136: Option<f64>,
    field_137: Option<String>,
    field_138: Option<f64>,
    field_139: Option<String>,
    field_140: Option<String>,
    field_141: Option<String>,
    field_142: Option<String>,
    field_143: Option<String>,
    field_144: Option<Ipv4Addr>,
    field_145: Option<String>,
    field_146: Option<String>,
    field_147: Option<String>,
    field_148: Option<String>,
    field_149: Option<String>,
    field_150: Option<String>,
    field_151: Option<String>,
    field_152: Option<String>,
    field_153: Option<String>,
    field_154: Option<bool>,
    field_155: Option<String>,
    field_156: Option<String>,
    field_157: Option<String>,
    field_158: Option<f64>,
    field_159: Option<String>,
    field_160: Option<f64>,
    field_161: Option<String>,
    field_162: Option<String>,
    field_163: Option<String>,
    field_164: Option<String>,
    field_165: Option<String>,
    field_166: Option<Ipv4Addr>,
    field_167: Option<String>,
    field_168: Option<String>,
    field_169: Option<String>,
    field_170: Option<String>,
    field_171: Option<String>,
    field_172: Option<String>,
    field_173: Option<String>,
    field_174: Option<String>,
    field_175: Option<String>,
    field_176: Option<bool>,
    field_177: Option<String>,
    field_178: Option<String>,
    field_179: Option<String>,
    field_180: Option<f64>,
    field_181: Option<String>,
    field_182: Option<f64>,
    field_183: Option<String>,
    field_184: Option<String>,
    field_185: Option<String>,
    field_186: Option<String>,
    field_187: Option<String>,
    field_188: Option<bool>,
    field_189: Option<String>,
    field_190: Option<String>,
    field_191: Option<String>,
    field_192: Option<String>,
    field_193: Option<String>,
    field_194: Option<String>,
    field_195: Option<String>,
    field_196: Option<String>,
    field_197: Option<String>,
    field_198: Option<String>,
    field_199: Option<String>,
    field_200: Option<String>,
    field_201: Option<String>,
    field_202: Option<String>,
    field_203: Option<String>,
    field_204: Option<String>,
    field_205: Option<String>,
    field_206: Option<String>,
    field_207: Option<String>,
    field_208: Option<String>,
    field_209: Option<String>,
    field_210: Option<String>,
    field_211: Option<String>,
    field_212: Option<String>,
    field_213: Option<String>,
    field_214: Option<String>,
    field_215: Option<String>,
    field_216: Option<String>,
    field_217: Option<String>,
    field_218: Option<String>,
    field_219: Option<String>,
    field_220: Option<String>,
    field_221: Option<String>,
    field_222: Option<u8>,
    field_223: Option<String>,
    field_224: Option<u8>,
    field_225: Option<String>,
    field_226: Option<String>,
    field_227: Option<String>,
    field_228: Option<String>,
    field_229: Option<String>,
    field_230: Option<String>,
    field_231: Option<String>,
    field_232: Option<String>,
    field_233: Option<String>,
    field_234: Option<String>,
    field_235: Option<String>,
    field_236: Option<String>,
    field_237: Option<String>,
    field_238: Option<String>,
    field_239: Option<String>,
    field_240: Option<u8>,
    field_241: Option<String>,
    field_242: Option<u8>,
    field_243: Option<String>,
    field_244: Option<String>,
    field_245: Option<String>,
    field_246: Option<String>,
    field_247: Option<String>,
    field_248: Option<String>,
    field_249: Option<String>,
    field_250: Option<String>,
    field_251: Option<String>,
    field_252: Option<String>,
    field_253: Option<String>,
    field_254: Option<String>,
    field_255: Option<String>,
    field_256: Option<String>,
    field_257: Option<String>,
    field_258: Option<String>,
    field_259: Option<String>,
    field_260: Option<String>,
    field_261: Option<String>,
    field_262: Option<String>,
    field_263: Option<String>,
    field_264: Option<String>,
    field_265: Option<String>,
    field_266: Option<String>,
    field_267: Option<String>,
    field_268: Option<u16>,
    field_269: Option<String>,
    field_270: Option<String>,
    field_271: Option<String>,
    field_272: Option<String>,
    field_273: Option<String>,
    field_274: Option<i64>,
    field_275: Option<String>,
    field_276: String,
    field_277: Option<u64>,
    field_278: Option<String>,
    field_279: Option<String>,
    field_280: Option<String>,
    field_281: Option<String>,
    field_282: Option<String>,
    field_283: Option<String>,
    field_284: Option<String>,
    field_285: Option<String>,
    field_286: Option<String>,
    field_287: Option<f64>,
    field_288: Option<String>,
    field_289: Option<String>,
    field_290: Option<String>,
    field_291: Option<String>,
    field_292: Option<String>,
    field_293: i64, // DateTime64(9, 'UTC'),
    field_294: Option<String>,
    field_295: Option<String>,
    field_296: Option<String>,
    field_297: Option<String>,
    field_298: Option<String>,
    field_299: Option<String>,
    field_300: Option<String>,
    field_301: Option<String>,
    field_302: Option<String>,
    field_303: Option<String>,
    field_304: Option<String>,
    field_305: Option<String>,
    field_306: Option<String>,
    field_307: Option<String>,
    field_308: Option<String>,
    field_309: Option<String>,
    field_310: Option<String>,
    field_311: Option<String>,
    field_312: Option<String>,
    field_313: Option<String>,
    field_314: Option<String>,
    field_315: Option<String>,
    field_316: Option<String>,
    field_317: Option<String>,
    field_318: Option<String>,
    field_319: Option<String>,
    field_320: Option<String>,
    field_321: Option<String>,
    field_322: Option<String>,
    field_323: Option<String>,
    field_324: Option<String>,
    field_325: Option<String>,
    field_326: Option<String>,
    field_327: Option<String>,
    field_328: Option<String>,
    field_329: Option<String>,
    field_330: Option<String>,
    field_331: Option<String>,
    field_332: Option<String>,
    field_333: Option<String>,
    field_334: Option<String>,
    field_335: Option<String>,
    field_336: Option<String>,
    field_337: Option<String>,
    field_338: Option<String>,
    field_339: Option<String>,
    field_340: Option<String>,
    field_341: Option<String>,
    field_342: Option<String>,
    field_343: Option<String>,
    field_344: Option<String>,
    field_345: Option<String>,
    field_346: Option<String>,
    field_347: Option<String>,
    field_348: Option<String>,
    field_349: Option<String>,
    field_350: Option<String>,
    field_351: Option<String>,
    field_352: Option<String>,
    field_353: Option<String>,
    field_354: Option<String>,
    field_355: Option<String>,
    field_356: Option<String>,
    field_357: Option<String>,
    field_358: Option<String>,
    field_359: Option<String>,
    field_360: Option<String>,
    field_361: Option<String>,
    field_362: Option<String>,
    field_363: Option<String>,
    field_364: Option<String>,
    field_365: Option<String>,
    field_366: Option<String>,
    field_367: Option<String>,
    field_368: Option<String>,
    field_369: Option<String>,
    field_370: Option<String>,
    field_371: Option<String>,
    field_372: Option<String>,
    field_373: Option<String>,
    field_374: Option<String>,
    field_375: Option<String>,
    field_376: Option<String>,
    field_377: Option<String>,
    field_378: Option<String>,
    field_379: Option<String>,
    field_380: Option<String>,
    field_381: Option<String>,
    field_382: Option<String>,
    field_383: Option<String>,
    field_384: Option<String>,
    field_385: Option<String>,
    field_386: Option<String>,
    field_387: Option<String>,
    field_388: Option<String>,
    field_389: Option<String>,
    field_390: Option<String>,
    field_391: Option<String>,
    field_392: Option<String>,
    field_393: Option<String>,
    field_394: Option<f64>,
    field_395: Option<String>,
    field_396: Option<f64>,
    field_397: Option<String>,
    field_398: Option<f64>,
    field_399: Option<String>,
    field_400: Option<f64>,
    field_401: Option<String>,
    field_402: Option<f64>,
    field_403: Option<String>,
    field_404: Option<f64>,
    field_405: Option<String>,
    field_406: Option<f64>,
    field_407: Option<String>,
    field_408: Option<f64>,
    field_409: Option<String>,
    field_410: Option<f64>,
    field_411: Option<String>,
    field_412: Option<f64>,
    field_413: Option<String>,
    field_414: Option<f64>,
    field_415: Option<String>,
    field_416: Option<f64>,
    field_417: Option<String>,
    field_418: Option<f64>,
    field_419: Option<String>,
    field_420: Option<f64>,
    field_421: Option<String>,
    field_422: Option<f64>,
    field_423: Option<String>,
    field_424: Option<f64>,
    field_425: Option<String>,
    field_426: Option<f64>,
    field_427: Option<String>,
    field_428: Option<f64>,
    field_429: Option<String>,
    field_430: Option<f64>,
    field_431: Option<String>,
    field_432: Option<f64>,
    field_433: Option<String>,
    field_434: Option<f64>,
    field_435: Option<String>,
    field_436: Option<f64>,
    field_437: Option<String>,
    field_438: Option<f64>,
    field_439: Option<String>,
    field_440: Option<f64>,
    field_441: Option<String>,
    field_442: Option<f64>,
    field_443: Option<String>,
    field_444: Option<f64>,
    field_445: Option<String>,
    field_446: Option<f64>,
    field_447: Option<String>,
    field_448: Option<f64>,
    field_449: Option<String>,
    field_450: Option<f64>,
    field_451: Option<String>,
    field_452: Option<f64>,
    field_453: Option<String>,
    field_454: Option<String>,
    field_455: Option<String>,
    field_456: Option<String>,
    field_457: Option<String>,
    field_458: Option<String>,
    field_459: Option<String>,
    field_460: Option<String>,
    field_461: Option<String>,
    field_462: Option<String>,
    field_463: Option<String>,
    field_464: Option<String>,
    field_465: Option<String>,
    field_466: Option<String>,
    field_467: Option<String>,
    field_468: Option<String>,
    field_469: Option<String>,
    field_470: Option<String>,
    field_471: Option<String>,
    field_472: Option<String>,
    field_473: Option<String>,
    field_474: Option<String>,
    field_475: Option<String>,
    field_476: Option<String>,
    field_477: Option<String>,
    field_478: Option<String>,
    field_479: Option<String>,
    field_480: Option<String>,
    field_481: Option<String>,
    field_482: Option<String>,
    field_483: Option<String>,
    field_484: Option<String>,
    field_485: Option<String>,
    field_486: Option<String>,
    field_487: Option<String>,
    field_488: Option<String>,
    field_489: Option<String>,
    field_490: Option<String>,
    field_491: Option<String>,
    field_492: Option<String>,
    field_493: Option<String>,
    field_494: Option<String>,
    field_495: Option<String>,
    field_496: Option<String>,
    field_497: Option<String>,
    field_498: Option<String>,
    field_499: Option<String>,
    field_500: Option<String>,
    field_501: Option<String>,
    field_502: Option<String>,
    field_503: Option<String>,
    field_504: Option<String>,
    field_505: Option<String>,
    field_506: Option<String>,
    field_507: Option<String>,
    field_508: Option<String>,
    field_509: Option<String>,
    field_510: Option<String>,
    field_511: Option<String>,
    field_512: Option<String>,
    field_513: Option<String>,
    field_514: Option<String>,
    field_515: Option<String>,
    field_516: Option<String>,
    field_517: Option<u8>,
    field_518: Vec<String>,
    field_519: Vec<(String, String)>,
}

Rust insert:

let mut insert = client.insert::<MyRow>("my_table")?;

let row = MyRow {
    field_1: None,
    field_2: None,
    field_3: None,
    field_4: None,
    field_5: None,
    field_6: None,
    field_7: None,
    field_8: None,
    field_9: None,
    field_10: None,
    field_11: None,
    field_12: None,
    field_13: None,
    field_14: None,
    field_15: None,
    field_16: None,
    field_17: None,
    field_18: None,
    field_19: None,
    field_20: None,
    field_21: None,
    field_22: None,
    field_23: None,
    field_24: None,
    field_25: None,
    field_26: None,
    field_27: None,
    field_28: None,
    field_29: None,
    field_30: None,
    field_31: None,
    field_32: None,
    field_33: None,
    field_34: None,
    field_35: None,
    field_36: None,
    field_37: None,
    field_38: None,
    field_39: None,
    field_40: None,
    field_41: None,
    field_42: None,
    field_43: None,
    field_44: None,
    field_45: None,
    field_46: None,
    field_47: None,
    field_48: None,
    field_49: None,
    field_50: None,
    field_51: None,
    field_52: None,
    field_53: None,
    field_54: None,
    field_55: None,
    field_56: None,
    field_57: None,
    field_58: None,
    field_59: None,
    field_60: None,
    field_61: None,
    field_62: None,
    field_63: None,
    field_64: None,
    field_65: None,
    field_66: None,
    field_67: None,
    field_68: None,
    field_69: None,
    field_70: None,
    field_71: None,
    field_72: None,
    field_73: None,
    field_74: None,
    field_75: None,
    field_76: None,
    field_77: None,
    field_78: None,
    field_79: None,
    field_80: None,
    field_81: None,
    field_82: None,
    field_83: None,
    field_84: None,
    field_85: None,
    field_86: None,
    field_87: None,
    field_88: None,
    field_89: None,
    field_90: None,
    field_91: None,
    field_92: None,
    field_93: None,
    field_94: None,
    field_95: None,
    field_96: None,
    field_97: None,
    field_98: None,
    field_99: some_chrono_datetime.timestamp_nanos_opt().unwrap(), // DateTime<Utc> -> i64
    field_100: another_chrono_datetime.timestamp_nanos_opt().unwrap(), // DateTime<Utc> -> i64
    field_101: None,
    field_102: None,
    field_103: None,
    field_104: None,
    field_105: None,
    field_106: None,
    field_107: None,
    field_108: None,
    field_109: None,
    field_110: None,
    field_111: None,
    field_112: None,
    field_113: None,
    field_114: None,
    field_115: some_id, // uuid::Uuid
    field_116: None,
    field_117: None,
    field_118: None,
    field_119: None,
    field_120: None,
    field_121: None,
    field_122: None,
    field_123: None,
    field_124: None,
    field_125: None,
    field_126: None,
    field_127: None,
    field_128: None,
    field_129: None,
    field_130: None,
    field_131: None,
    field_132: None,
    field_133: None,
    field_134: None,
    field_135: None,
    field_136: None,
    field_137: None,
    field_138: None,
    field_139: None,
    field_140: None,
    field_141: None,
    field_142: None,
    field_143: None,
    field_144: None,
    field_145: None,
    field_146: None,
    field_147: None,
    field_148: None,
    field_149: None,
    field_150: None,
    field_151: None,
    field_152: None,
    field_153: None,
    field_154: None,
    field_155: None,
    field_156: None,
    field_157: None,
    field_158: None,
    field_159: None,
    field_160: None,
    field_161: None,
    field_162: None,
    field_163: None,
    field_164: None,
    field_165: None,
    field_166: None,
    field_167: None,
    field_168: None,
    field_169: None,
    field_170: None,
    field_171: None,
    field_172: None,
    field_173: None,
    field_174: None,
    field_175: None,
    field_176: None,
    field_177: None,
    field_178: None,
    field_179: None,
    field_180: None,
    field_181: None,
    field_182: None,
    field_183: None,
    field_184: None,
    field_185: None,
    field_186: None,
    field_187: None,
    field_188: None,
    field_189: None,
    field_190: None,
    field_191: None,
    field_192: None,
    field_193: None,
    field_194: None,
    field_195: None,
    field_196: None,
    field_197: None,
    field_198: None,
    field_199: None,
    field_200: None,
    field_201: None,
    field_202: None,
    field_203: None,
    field_204: None,
    field_205: None,
    field_206: None,
    field_207: None,
    field_208: None,
    field_209: None,
    field_210: None,
    field_211: None,
    field_212: None,
    field_213: None,
    field_214: None,
    field_215: None,
    field_216: None,
    field_217: None,
    field_218: None,
    field_219: None,
    field_220: None,
    field_221: None,
    field_222: None,
    field_223: None,
    field_224: None,
    field_225: None,
    field_226: None,
    field_227: None,
    field_228: None,
    field_229: None,
    field_230: None,
    field_231: None,
    field_232: None,
    field_233: None,
    field_234: None,
    field_235: None,
    field_236: None,
    field_237: None,
    field_238: None,
    field_239: None,
    field_240: None,
    field_241: None,
    field_242: None,
    field_243: None,
    field_244: None,
    field_245: None,
    field_246: None,
    field_247: None,
    field_248: None,
    field_249: None,
    field_250: None,
    field_251: None,
    field_252: None,
    field_253: None,
    field_254: None,
    field_255: None,
    field_256: None,
    field_257: None,
    field_258: None,
    field_259: None,
    field_260: None,
    field_261: None,
    field_262: None,
    field_263: None,
    field_264: None,
    field_265: None,
    field_266: None,
    field_267: None,
    field_268: None,
    field_269: None,
    field_270: None,
    field_271: None,
    field_272: None,
    field_273: None,
    field_274: None,
    field_275: None,
    field_276: another_id, // String
    field_277: None,
    field_278: None,
    field_279: None,
    field_280: None,
    field_281: None,
    field_282: None,
    field_283: None,
    field_284: None,
    field_285: None,
    field_286: None,
    field_287: None,
    field_288: None,
    field_289: None,
    field_290: None,
    field_291: None,
    field_292: None,
    field_293: third_chrono_datetime.timestamp_nanos_opt().unwrap(), // DateTime<Utc> -> i64
    field_294: None,
    field_295: None,
    field_296: None,
    field_297: None,
    field_298: None,
    field_299: None,
    field_300: None,
    field_301: None,
    field_302: None,
    field_303: None,
    field_304: None,
    field_305: None,
    field_306: None,
    field_307: None,
    field_308: None,
    field_309: None,
    field_310: None,
    field_311: None,
    field_312: None,
    field_313: None,
    field_314: None,
    field_315: None,
    field_316: None,
    field_317: None,
    field_318: None,
    field_319: None,
    field_320: None,
    field_321: None,
    field_322: None,
    field_323: None,
    field_324: None,
    field_325: None,
    field_326: None,
    field_327: None,
    field_328: None,
    field_329: None,
    field_330: None,
    field_331: None,
    field_332: None,
    field_333: None,
    field_334: None,
    field_335: None,
    field_336: None,
    field_337: None,
    field_338: None,
    field_339: None,
    field_340: None,
    field_341: None,
    field_342: None,
    field_343: None,
    field_344: None,
    field_345: None,
    field_346: None,
    field_347: None,
    field_348: None,
    field_349: None,
    field_350: None,
    field_351: None,
    field_352: None,
    field_353: None,
    field_354: None,
    field_355: None,
    field_356: None,
    field_357: None,
    field_358: None,
    field_359: None,
    field_360: None,
    field_361: None,
    field_362: None,
    field_363: None,
    field_364: None,
    field_365: None,
    field_366: None,
    field_367: None,
    field_368: None,
    field_369: None,
    field_370: None,
    field_371: None,
    field_372: None,
    field_373: None,
    field_374: None,
    field_375: None,
    field_376: None,
    field_377: None,
    field_378: None,
    field_379: None,
    field_380: None,
    field_381: None,
    field_382: None,
    field_383: None,
    field_384: None,
    field_385: None,
    field_386: None,
    field_387: None,
    field_388: None,
    field_389: None,
    field_390: None,
    field_391: None,
    field_392: None,
    field_393: None,
    field_394: None,
    field_395: None,
    field_396: None,
    field_397: None,
    field_398: None,
    field_399: None,
    field_400: None,
    field_401: None,
    field_402: None,
    field_403: None,
    field_404: None,
    field_405: None,
    field_406: None,
    field_407: None,
    field_408: None,
    field_409: None,
    field_410: None,
    field_411: None,
    field_412: None,
    field_413: None,
    field_414: None,
    field_415: None,
    field_416: None,
    field_417: None,
    field_418: None,
    field_419: None,
    field_420: None,
    field_421: None,
    field_422: None,
    field_423: None,
    field_424: None,
    field_425: None,
    field_426: None,
    field_427: None,
    field_428: None,
    field_429: None,
    field_430: None,
    field_431: None,
    field_432: None,
    field_433: None,
    field_434: None,
    field_435: None,
    field_436: None,
    field_437: None,
    field_438: None,
    field_439: None,
    field_440: None,
    field_441: None,
    field_442: None,
    field_443: None,
    field_444: None,
    field_445: None,
    field_446: None,
    field_447: None,
    field_448: None,
    field_449: None,
    field_450: None,
    field_451: None,
    field_452: None,
    field_453: None,
    field_454: None,
    field_455: None,
    field_456: None,
    field_457: None,
    field_458: None,
    field_459: None,
    field_460: None,
    field_461: None,
    field_462: None,
    field_463: None,
    field_464: None,
    field_465: None,
    field_466: None,
    field_467: None,
    field_468: None,
    field_469: None,
    field_470: None,
    field_471: None,
    field_472: None,
    field_473: None,
    field_474: None,
    field_475: None,
    field_476: None,
    field_477: None,
    field_478: None,
    field_479: None,
    field_480: None,
    field_481: None,
    field_482: None,
    field_483: None,
    field_484: None,
    field_485: None,
    field_486: None,
    field_487: None,
    field_488: None,
    field_489: None,
    field_490: None,
    field_491: None,
    field_492: None,
    field_493: None,
    field_494: None,
    field_495: None,
    field_496: None,
    field_497: None,
    field_498: None,
    field_499: None,
    field_500: None,
    field_501: None,
    field_502: None,
    field_503: None,
    field_504: None,
    field_505: None,
    field_506: None,
    field_507: None,
    field_508: None,
    field_509: None,
    field_510: None,
    field_511: None,
    field_512: None,
    field_513: None,
    field_514: None,
    field_515: None,
    field_516: None,
    field_517: None,
    field_518: Vec::new(),
    field_519: Vec::new(),
};

insert.write(&e).await?;
insert.end().await?;

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions