Datatype from a parquet column is not matched with HeavDB table
val locationIds = Some(List(LocationDashboardId(840))),
When this is written in a parquet file, I could see the schema below.
|-- locationIds: array (nullable = true)
| |-- element: struct (containsNull = true)
| | |-- serializedId: array (nullable = true)
| | | |-- element: Integer (containsNull = true)
However, when this is being inserted to a heavydb table for the column with datatype INTEGER[] NOT NULL, the below error occurs.
Conversion from Parquet type "INT32" to HeavyDB type "INTEGER[]" is not allowed. Please use an appropriate column type. Parquet column: element, HeavyDB column: location_ids, Parquet file: /migration_csv/final/part-00000-680ff400-af6a-42d8-b471-fa654d0c844e-c000.snappy.parquet.
Please help me with the approach.
-
Hi Abdul Rahim Kamaludeen,
Could you share the parquet file you are trying to ingest or some sample rows?
In any case, could you run the \detect_parquet command from the heavysql command?
It'd return field names, datatypes, some sample data, and a DDL of the table.\detect_parquet /opt/opendata/flights/flights_none.parquet
[cut output]
CREATE TABLE your_table_name(flight_year SMALLINT, flight_mmonth SMALLINT, flight_dayofmonth SMALLINT, flight_dayofweek SMALLINT, deptime SMALLINT, crsdeptime SMALLINT, arrtime SMALLINT, crsarrtime SMALLINT, uniquecarrier TEXT ENCODING DICT, flightnum SMALLINT, tailnum TEXT ENCODING DICT, actualelapsedtime SMALLINT, crselapsedtime SMALLINT, airtime SMALLINT, arrdelay SMALLINT, depdelay SMALLINT, origin TEXT ENCODING DICT, dest TEXT ENCODING DICT, distance SMALLINT, taxiin SMALLINT, taxiout SMALLINT, cancelled SMALLINT, cancellationcode TEXT ENCODING DICT, diverted SMALLINT, carrierdelay SMALLINT, weatherdelay SMALLINT, nasdelay SMALLINT, securitydelay SMALLINT, lateaircraftdelay SMALLINT, dep_timestamp TIMESTAMP(3), arr_timestamp TIMESTAMP(3), carrier_name TEXT ENCODING DICT, plane_type TEXT ENCODING DICT, plane_manufacturer TEXT ENCODING DICT, plane_issue_date TEXT ENCODING DICT, plane_model TEXT ENCODING DICT, plane_status TEXT ENCODING DICT, plane_aircraft_type TEXT ENCODING DICT, plane_engine_type TEXT ENCODING DICT, plane_year SMALLINT, origin_name TEXT ENCODING DICT, origin_city TEXT ENCODING DICT, origin_state TEXT ENCODING DICT, origin_country TEXT ENCODING DICT, origin_lat FLOAT, origin_lon FLOAT, dest_name TEXT ENCODING DICT, dest_city TEXT ENCODING DICT, dest_state TEXT ENCODING DICT, dest_country TEXT ENCODING DICT, dest_lat FLOAT, dest_lon FLOAT);And post the reulteing DDLs?
Bests,
Candido -
Hi Candido Dessanti ,Please find the link to the parquet file.
https://1drv.ms/u/s!Am2VAAyMxmQGoTVKc9hK2X_l5Ya7?e=hwfaqS
If you want to understand the structure, I have converted that as Json file here
result.jsonI executed the \detect_parquet /path/to/file and was spammed with the below result.
column_1 column_2 column_3 column_4 column_5 column_6 column_7 column_8 column_9 column_10 column_11 column_12 column_13 column_14 column_15 column_16 column_17 column_18 column_19 column_20 column_21 column_22 column_23 column_24 column_25 column_26 column_27 column_28 column_29 column_30 column_31 column_32 column_33 column_34 column_35 column_36 column_37 column_38 column_39 column_40 column_41 column_42 column_43 column_44 column_45 column_46 column_47 column_48 column_49 column_50 column_51 column_52 column_53 column_54 column_55 column_56 column_57 column_58 column_59 column_60 column_61 column_62 column_63 column_64 column_65 column_66 column_67 column_68 column_69 column_70 column_71 column_72 column_73 column_74 column_75 column_76 column_77 column_78 column_79 column_80 column_81 column_82 column_83 column_84 column_85 column_86 column_87 column_88 column_89 column_90 column_91 column_92 column_93 column_94 column_95 column_96 column_97 column_98 column_99 column_100 column_101 column_102 column_103 column_104 column_105 column_106 column_107 column_108 column_109 column_110 column_111 column_112 column_113 column_114 column_115 column_116 column_117 column_118 column_119 column_120 column_121 column_122 column_123 column_124 column_125 column_126 column_127 column_128 column_129 column_130 column_131 column_132 column_133 column_134 column_135 column_136 column_137 column_138 column_139 column_140 column_141 column_142 column_143 column_144 column_145 column_146 column_147 column_148 column_149 column_150 column_151 column_152 column_153 column_154 column_155 column_156 column_157 column_158 column_159 column_160 column_161 column_162 column_163 column_164 column_165 column_166 column_167 column_168 column_169 column_170 column_171 column_172 column_173 column_174 column_175 column_176 column_177 column_178 column_179 column_180 column_181 column_182 column_183 column_184 column_185 column_186 column_187 column_188 column_189 column_190 column_191 column_192 column_193 column_194 column_195 column_196 column_197 column_198 column_199 column_200 column_201 column_202 column_203 column_204 column_205 column_206 column_207 column_208 column_209 column_210 column_211 column_212 column_213 column_214 column_215 column_216 column_217 column_218 column_219 column_220 column_221 column_222 column_223 column_224 column_225 column_226 column_227 column_228 column_229 column_230 column_231 column_232 column_233 column_234 column_235 column_236 column_237 column_238 column_239 column_240 column_241 column_242 column_243 column_244 column_245 column_246 column_247 column_248 column_249 column_250 column_251 column_252 column_253 column_254 column_255 column_256 column_257 column_258 column_259 column_260 column_261 column_262 column_263 column_264 column_265 column_266 column_267 column_268 column_269 column_270 column_271 column_272 column_273 column_274 column_275 column_276 column_277 column_278 column_279 column_280 column_281 column_282 column_283 column_284 column_285 column_286 column_287 column_288 column_289 column_290 column_291 column_292 column_293 column_294 column_295 column_296 column_297 column_298 column_299 column_300 column_301 column_302 column_303 column_304 column_305 column_306 column_307 column_308 column_309 column_310 column_311 column_312 column_313 column_314 column_315 column_316 column_317 column_318 column_319 column_320 column_321 column_322 column_323 column_324 column_325 column_326 column_327 column_328 column_329 column_330 column_331 column_332 column_333 column_334 column_335 column_336 column_337 column_338 column_339 column_340 column_341 column_342 column_343 column_344 column_345 column_346 column_347 column_348 column_349 column_350 column_351 column_352 column_353 column_354 column_355 column_356 column_357 column_358 column_359 column_360 column_361 column_362 column_363 column_364 column_365 column_366 column_367 column_368 column_369 column_370 column_371 column_372 column_373 column_374 column_375 column_376 column_377 column_378 column_379 column_380 column_381 column_382 column_383 column_384 column_385 column_386 column_387 column_388 column_389 column_390 column_391 column_392 column_393 column_394 column_395 column_396 column_397 column_398 column_399 column_400 column_401 column_402 column_403 column_404 column_405 column_406 column_407 column_408 column_409 column_410 column_411 column_412 column_413 column_414 column_415 column_416 column_417 column_418 column_419 column_420 column_421 column_422 column_423 column_424 column_425 column_426 column_427 column_428 column_429 column_430 column_431 column_432 column_433 column_434 column_435 column_436 column_437 column_438 column_439 column_440 column_441 column_442 column_443 column_444 column_445 column_446 column_447 column_448 column_449 column_450 column_451 column_452 column_453 column_454 column_455 column_456 column_457 column_458 column_459 column_460 column_461 column_462 column_463 column_464 column_465 column_466 column_467 column_468 column_469 column_470 column_471 column_472 column_473 column_474 column_475 column_476 column_477 column_478 column_479 column_480 column_481 column_482 column_483 column_484 column_485 column_486 column_487 column_488 column_489 column_490 column_491 column_492 column_493 column_494 column_495 column_496 column_497 column_498 column_499 column_500 column_501 column_502 column_503 column_504 column_505 column_506 column_507
TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT
PAR1??H
spark_sc
fileTypeId
accessesCount
piiCountTotal
piiCount10
piiCount11
piiCount12
piiCount13
piiCount14
piiCount15
piiCount16
piiCount17
ownerGroupIds
departmentIds
%f1Score "fields":[{"name":"k "type":{"type":"stru "fields":[{"name":"s "type":{"type":"arra "elementType":"long" "containsNull":true} "nullable":true "metadata":{}}]} "nullable":false "metadata":{}} {"name":"createdTime "type":"long" "nullable":true "metadata":{}} {"name":"lastModifie "type":"long" "nullable":true "metadata":{}} {"name":"filePath" "type":"string" "nullable":true "metadata":{}} {"name":"fileName" "type":"string" "nullable":true "metadata":{}} {"name":"extension" "type":"string" "nullable":true "metadata":{}} {"name":"fileTypeId" "type":{"type":"stru "fields":[{"name":"s "type":{"type":"arra "elementType":"long" "containsNull":true} "nullable":true "metadata":{}}]} "nullable":false "metadata":{}} {"name":"hashBytes" "type":"string" "nullable":true "metadata":{}} {"name":"hashText" "type":"string" "nullable":true "metadata":{}} {"name":"langId" "type":{"type":"stru "fields":[{"name":"s "type":{"type":"arra "elementType":"long" "containsNull":true} "nullable":true "metadata":{}}]} "nullable":false "metadata":{}} {"name":"sizeBytes" "type":"long" "nullable":true "metadata":{}} {"name":"isPrivacyAn "type":"boolean" "nullable":true "metadata":{}} {"name":"toxicityRaw "type":"integer" "nullable":true "metadata":{}} {"name":"privacyRisk "type":"integer" "nullable":true "metadata":{}} {"name":"accessesCou "type":"integer" "nullable":true "metadata":{}} {"name":"piiCountTot "type":"long" "nullable":true "metadata":{}} {"name":"piiCount1" "type":"long" "nullable":true "metadata":{}} {"name":"piiCount2" "type":"long" "nullable":true "metadata":{}} {"name":"piiCount3" "type":"long" "nullable":true "metadata":{}} {"name":"piiCount4" "type":"long" "nullable":true "metadata":{}} {"name":"piiCount5" "type":"long" "nullable":true "metadata":{}} {"name":"piiCount6" "type":"long" "nullable":true "metadata":{}} {"name":"piiCount7" "type":"long" "nullable":true "metadata":{}} {"name":"piiCount8" "type":"long" "nullable":true "metadata":{}} {"name":"piiCount9" "type":"long" "nullable":true "metadata":{}} {"name":"piiCount10" "type":"long" "nullable":true "metadata":{}} {"name":"piiCount11" "type":"long" "nullable":true "metadata":{}} {"name":"piiCount12" "type":"long" "nullable":true "metadata":{}} {"name":"piiCount13" "type":"long" "nullable":true "metadata":{}} {"name":"piiCount14" "type":"long" "nullable":true "metadata":{}} {"name":"piiCount15" "type":"long" "nullable":true "metadata":{}} {"name":"piiCount16" "type":"long" "nullable":true "metadata":{}} {"name":"piiCount17" "type":"long" "nullable":true "metadata":{}} {"name":"dataSourceI "type":{"type":"stru "fields":[{"name":"s "type":{"type":"arra "elementType":"long" "containsNull":true} "nullable":true "metadata":{}}]} "nullable":false "metadata":{}} {"name":"locationIds "type":{"type":"arra "elementType":{"type "fields":[{"name":"s "type":{"type":"arra "elementType":"byte" "containsNull":false "nullable":true "metadata":{}}]} "containsNull":true} "nullable":true "metadata":{}} {"name":"ownerUserId "type":{"type":"arra "elementType":{"type "fields":[{"name":"s "type":{"type":"arra "elementType":"byte" "containsNull":false "nullable":true "metadata":{}}]} "containsNull":true} "nullable":true "metadata":{}} {"name":"ownerGroupI "type":{"type":"arra "elementType":{"type "fields":[{"name":"s "type":{"type":"arra "elementType":"byte" "containsNull":false "nullable":true "metadata":{}}]} "containsNull":true} "nullable":true "metadata":{}} {"name":"departmentI "type":{"type":"arra "elementType":{"type "fields":[{"name":"s "type":{"type":"arra "elementType":"byte" "containsNull":false "nullable":true "metadata":{}}]} "containsNull":true} "nullable":true "metadata":{}} {"name":"directGroup "type":{"type":"arra "elementType":{"type "fields":[{"name":"s "type":{"type":"arra "elementType":"byte" "containsNull":false "nullable":true "metadata":{}}]} "containsNull":true} "nullable":true "metadata":{}} {"name":"directUserI "type":{"type":"arra "elementType":{"type "fields":[{"name":"s "type":{"type":"arra "elementType":"byte" "containsNull":false "nullable":true "metadata":{}}]} "containsNull":true} "nullable":true "metadata":{}} {"name":"isClassifyA "type":"boolean" "nullable":true "metadata":{}} {"name":"f1Score" "type":"double" "nullable":true "metadata":{}} {"name":"securityRis "type":"integer" "nullable":true "metadata":{}} {"name":"categoryIdL "type":{"type":"stru "fields":[{"name":"s "type":{"type":"arra "elementType":"byte" "containsNull":false "nullable":true "metadata":{}}]} "nullable":true "metadata":{}} {"name":"categoryIdL "type":{"type":"stru "fields":[{"name":"s "type":{"type":"arra "elementType":"byte" "containsNull":false "nullable":true "metadata":{}}]} "nullable":true "metadata":{}} {"name":"categoryIdL "type":{"type":"stru "fields":[{"name":"s "type":{"type":"arra "elementType":"byte" "containsNull":false "nullable":true "metadata":{}}]} "nullable":true "metadata":{}} {"name":"confidentia "type":{"type":"stru "fields":[{"name":"s "type":{"type":"arra "elementType":"byte" "containsNull":false "nullable":true "metadata":{}}]} "nullable":true "metadata":{}} {"name":"isDuplicate "type":"boolean" "nullable":true "metadata":{}} {"name":"isInScope" "type":"boolean" "nullable":true "metadata":{}} {"name":"filePathIdL "type":{"type":"stru "fields":[{"name":"s "type":{"type":"arra "elementType":"byte" "containsNull":false "nullable":true "metadata":{}}]} "nullable":true "metadata":{}} {"name":"filePathIdL "type":{"type":"stru "fields":[{"name":"s "type":{"type":"arra "elementType":"byte" "containsNull":false "nullable":true "metadata":{}}]} "nullable":true "metadata":{}} {"name":"filePathIdL "type":{"type":"stru "fields":[{"name":"s "type":{"type":"arra "elementType":"byte" "containsNull":false "nullable":true "metadata":{}}]} "nullable":true "metadata":{}} {"name":"fileMetaHBa "type":"string" "nullable":true "metadata":{}} {"name":"sharingTime "type":"long" "nullable":true "metadata":{}} {"name":"sharingByUs "type":{"type":"arra "elementType":{"type "fields":[{"name":"s "type":{"type":"arra "elementType":"byte" "containsNull":false "nullable":true "metadata":{}}]} "containsNull":true} "nullable":true "metadata":{}} {"name":"publicExtUs "type":{"type":"arra "elementType":{"type "fields":[{"name":"s "type":{"type":"arra "elementType":"byte" "containsNull":false "nullable":true "metadata":{}}]} "containsNull":true} "nullable":true "metadata":{}} {"name":"publicExtUs "type":"integer" "nullable":true "metadata":{}} {"name":"businessExt "type":{"type":"arra "elementType":{"type "fields":[{"name":"s "type":{"type":"arra "elementType":"byte" "containsNull":false "nullable":true "metadata":{}}]} "containsNull":true} "nullable":true "metadata":{}} {"name":"businessExt "type":"integer" "nullable":true "metadata":{}} {"name":"extUserIdAc "type":{"type":"arra "elementType":{"type "fields":[{"name":"s "type":{"type":"arra "elementType":"byte" "containsNull":false "nullable":true "metadata":{}}]} "containsNull":true} "nullable":true "metadata":{}} {"name":"domainIdAcc "type":{"type":"arra "elementType":{"type "fields":[{"name":"s "type":{"type":"arra "elementType":"byte" "containsNull":false "nullable":true "metadata":{}}]} "containsNull":true} "nullable":true "metadata":{}} {"name":"userTrustLe "type":{"type":"arra "elementType":{"type "fields":[{"name":"s "type":{"type":"arra "elementType":"byte" "containsNull":false "nullable":true "metadata":{}}]} "containsNull":true} "nullable":true "metadata":{}} {"name":"hasSensitiv "type":"boolean" "nullable":true "metadata":{}} {"name":"sensitiveId "type":"integer" "nullable":true "metadata":{}} {"name":"appTypeId" "type":{"type":"stru "fields":[{"name":"s "type":{"type":"arra "elementType":"byte" "containsNull":false "nullable":true "metadata":{}}]} "nullable":true "metadata":{}} {"name":"isExternalS "type":"boolean" "nullable":true "metadata":{}} {"name":"isException "type":"boolean" "nullable":true "metadata":{}} {"name":"onRevocatio "type":"boolean" "nullable":true "metadata":{}} {"name":"remoteUrl" "type":"string" "nullable":true "metadata":{}} {"name":"efsRiskScor "type":"integer" "nullable":true "metadata":{}} {"name":"isProtected "type":"boolean" "nullable":true "metadata":{}} {"name":"aipLabel" "type":"string" "nullable":true "metadata":{}} {"name":"directGroup "type":{"type":"arra "elementType":{"type "fields":[{"name":"s "type":{"type":"arra "elementType":"byte" "containsNull":false "nullable":true "metadata":{}}]} "containsNull":true} "nullable":true "metadata":{}} {"name":"directAcces "type":"string" "nullable":true "metadata":{}} {"name":"datasourceT "type":{"type":"stru "fields":[{"name":"s "type":{"type":"arra "elementType":"byte" "containsNull":false "nullable":true "metadata":{}}]} "nullable":true "metadata":{}} {"name":"anyoneLinkA "type":"integer" "nullable":true "metadata":{}} {"name":"sharingLink "type":{"type":"arra "elementType":{"type "fields":[{"name":"s "type":{"type":"arra "elementType":"byte" "containsNull":false "nullable":true "metadata":{}}]} "containsNull":true} "nullable":true "metadata":{}} {"name":"isAnyoneLin "type":"boolean" "nullable":true "metadata":{}} {"name":"anyoneLinkE "type":"long" "nullable":true "metadata":{}}]}
CREATE TABLE your_table_name(column_1 TEXT ENCODING DICT, column_2 TEXT ENCODING DICT, column_3 TEXT ENCODING DICT, column_4 TEXT ENCODING DICT, column_5 TEXT ENCODING DICT, column_6 TEXT ENCODING DICT, column_7 TEXT ENCODING DICT, column_8 TEXT ENCODING DICT, column_9 TEXT ENCODING DICT, column_10 TEXT ENCODING DICT, column_11 TEXT ENCODING DICT, column_12 TEXT ENCODING DICT, column_13 TEXT ENCODING DICT, column_14 TEXT ENCODING DICT, column_15 TEXT ENCODING DICT, column_16 TEXT ENCODING DICT, column_17 TEXT ENCODING DICT, column_18 TEXT ENCODING DICT, column_19 TEXT ENCODING DICT, column_20 TEXT ENCODING DICT, column_21 TEXT ENCODING DICT, column_22 TEXT ENCODING DICT, column_23 TEXT ENCODING DICT, column_24 TEXT ENCODING DICT, column_25 TEXT ENCODING DICT, column_26 TEXT ENCODING DICT, column_27 TEXT ENCODING DICT, column_28 TEXT ENCODING DICT, column_29 TEXT ENCODING DICT, column_30 TEXT ENCODING DICT, column_31 TEXT ENCODING DICT, column_32 TEXT ENCODING DICT, column_33 TEXT ENCODING DICT, column_34 TEXT ENCODING DICT, column_35 TEXT ENCODING DICT, column_36 TEXT ENCODING DICT, column_37 TEXT ENCODING DICT, column_38 TEXT ENCODING DICT, column_39 TEXT ENCODING DICT, column_40 TEXT ENCODING DICT, column_41 TEXT ENCODING DICT, column_42 TEXT ENCODING DICT, column_43 TEXT ENCODING DICT, column_44 TEXT ENCODING DICT, column_45 TEXT ENCODING DICT, column_46 TEXT ENCODING DICT, column_47 TEXT ENCODING DICT, column_48 TEXT ENCODING DICT, column_49 TEXT ENCODING DICT, column_50 TEXT ENCODING DICT, column_51 TEXT ENCODING DICT, column_52 TEXT ENCODING DICT, column_53 TEXT ENCODING DICT, column_54 TEXT ENCODING DICT, column_55 TEXT ENCODING DICT, column_56 TEXT ENCODING DICT, column_57 TEXT ENCODING DICT, column_58 TEXT ENCODING DICT, column_59 TEXT ENCODING DICT, column_60 TEXT ENCODING DICT, column_61 TEXT ENCODING DICT, column_62 TEXT ENCODING DICT, column_63 TEXT ENCODING DICT, column_64 TEXT ENCODING DICT, column_65 TEXT ENCODING DICT, column_66 TEXT ENCODING DICT, column_67 TEXT ENCODING DICT, column_68 TEXT ENCODING DICT, column_69 TEXT ENCODING DICT, column_70 TEXT ENCODING DICT, column_71 TEXT ENCODING DICT, column_72 TEXT ENCODING DICT, column_73 TEXT ENCODING DICT, column_74 TEXT ENCODING DICT, column_75 TEXT ENCODING DICT, column_76 TEXT ENCODING DICT, column_77 TEXT ENCODING DICT, column_78 TEXT ENCODING DICT, column_79 TEXT ENCODING DICT, column_80 TEXT ENCODING DICT, column_81 TEXT ENCODING DICT, column_82 TEXT ENCODING DICT, column_83 TEXT ENCODING DICT, column_84 TEXT ENCODING DICT, column_85 TEXT ENCODING DICT, column_86 TEXT ENCODING DICT, column_87 TEXT ENCODING DICT, column_88 TEXT ENCODING DICT, column_89 TEXT ENCODING DICT, column_90 TEXT ENCODING DICT, column_91 TEXT ENCODING DICT, column_92 TEXT ENCODING DICT, column_93 TEXT ENCODING DICT, column_94 TEXT ENCODING DICT, column_95 TEXT ENCODING DICT, column_96 TEXT ENCODING DICT, column_97 TEXT ENCODING DICT, column_98 TEXT ENCODING DICT, column_99 TEXT ENCODING DICT, column_100 TEXT ENCODING DICT, column_101 TEXT ENCODING DICT, column_102 TEXT ENCODING DICT, column_103 TEXT ENCODING DICT, column_104 TEXT ENCODING DICT, column_105 TEXT ENCODING DICT, column_106 TEXT ENCODING DICT, column_107 TEXT ENCODING DICT, column_108 TEXT ENCODING DICT, column_109 TEXT ENCODING DICT, column_110 TEXT ENCODING DICT, column_111 TEXT ENCODING DICT, column_112 TEXT ENCODING DICT, column_113 TEXT ENCODING DICT, column_114 TEXT ENCODING DICT, column_115 TEXT ENCODING DICT, column_116 TEXT ENCODING DICT, column_117 TEXT ENCODING DICT, column_118 TEXT ENCODING DICT, column_119 TEXT ENCODING DICT, column_120 TEXT ENCODING DICT, column_121 TEXT ENCODING DICT, column_122 TEXT ENCODING DICT, column_123 TEXT ENCODING DICT, column_124 TEXT ENCODING DICT, column_125 TEXT ENCODING DICT, column_126 TEXT ENCODING DICT, column_127 TEXT ENCODING DICT, column_128 TEXT ENCODING DICT, column_129 TEXT ENCODING DICT, column_130 TEXT ENCODING DICT, column_131 TEXT ENCODING DICT, column_132 TEXT ENCODING DICT, column_133 TEXT ENCODING DICT, column_134 TEXT ENCODING DICT, column_135 TEXT ENCODING DICT, column_136 TEXT ENCODING DICT, column_137 TEXT ENCODING DICT, column_138 TEXT ENCODING DICT, column_139 TEXT ENCODING DICT, column_140 TEXT ENCODING DICT, column_141 TEXT ENCODING DICT, column_142 TEXT ENCODING DICT, column_143 TEXT ENCODING DICT, column_144 TEXT ENCODING DICT, column_145 TEXT ENCODING DICT, column_146 TEXT ENCODING DICT, column_147 TEXT ENCODING DICT, column_148 TEXT ENCODING DICT, column_149 TEXT ENCODING DICT, column_150 TEXT ENCODING DICT, column_151 TEXT ENCODING DICT, column_152 TEXT ENCODING DICT, column_153 TEXT ENCODING DICT, column_154 TEXT ENCODING DICT, column_155 TEXT ENCODING DICT, column_156 TEXT ENCODING DICT, column_157 TEXT ENCODING DICT, column_158 TEXT ENCODING DICT, column_159 TEXT ENCODING DICT, column_160 TEXT ENCODING DICT, column_161 TEXT ENCODING DICT, column_162 TEXT ENCODING DICT, column_163 TEXT ENCODING DICT, column_164 TEXT ENCODING DICT, column_165 TEXT ENCODING DICT, column_166 TEXT ENCODING DICT, column_167 TEXT ENCODING DICT, column_168 TEXT ENCODING DICT, column_169 TEXT ENCODING DICT, column_170 TEXT ENCODING DICT, column_171 TEXT ENCODING DICT, column_172 TEXT ENCODING DICT, column_173 TEXT ENCODING DICT, column_174 TEXT ENCODING DICT, column_175 TEXT ENCODING DICT, column_176 TEXT ENCODING DICT, column_177 TEXT ENCODING DICT, column_178 TEXT ENCODING DICT, column_179 TEXT ENCODING DICT, column_180 TEXT ENCODING DICT, column_181 TEXT ENCODING DICT, column_182 TEXT ENCODING DICT, column_183 TEXT ENCODING DICT, column_184 TEXT ENCODING DICT, column_185 TEXT ENCODING DICT, column_186 TEXT ENCODING DICT, column_187 TEXT ENCODING DICT, column_188 TEXT ENCODING DICT, column_189 TEXT ENCODING DICT, column_190 TEXT ENCODING DICT, column_191 TEXT ENCODING DICT, column_192 TEXT ENCODING DICT, column_193 TEXT ENCODING DICT, column_194 TEXT ENCODING DICT, column_195 TEXT ENCODING DICT, column_196 TEXT ENCODING DICT, column_197 TEXT ENCODING DICT, column_198 TEXT ENCODING DICT, column_199 TEXT ENCODING DICT, column_200 TEXT ENCODING DICT, column_201 TEXT ENCODING DICT, column_202 TEXT ENCODING DICT, column_203 TEXT ENCODING DICT, column_204 TEXT ENCODING DICT, column_205 TEXT ENCODING DICT, column_206 TEXT ENCODING DICT, column_207 TEXT ENCODING DICT, column_208 TEXT ENCODING DICT, column_209 TEXT ENCODING DICT, column_210 TEXT ENCODING DICT, column_211 TEXT ENCODING DICT, column_212 TEXT ENCODING DICT, column_213 TEXT ENCODING DICT, column_214 TEXT ENCODING DICT, column_215 TEXT ENCODING DICT, column_216 TEXT ENCODING DICT, column_217 TEXT ENCODING DICT, column_218 TEXT ENCODING DICT, column_219 TEXT ENCODING DICT, column_220 TEXT ENCODING DICT, column_221 TEXT ENCODING DICT, column_222 TEXT ENCODING DICT, column_223 TEXT ENCODING DICT, column_224 TEXT ENCODING DICT, column_225 TEXT ENCODING DICT, column_226 TEXT ENCODING DICT, column_227 TEXT ENCODING DICT, column_228 TEXT ENCODING DICT, column_229 TEXT ENCODING DICT, column_230 TEXT ENCODING DICT, column_231 TEXT ENCODING DICT, column_232 TEXT ENCODING DICT, column_233 TEXT ENCODING DICT, column_234 TEXT ENCODING DICT, column_235 TEXT ENCODING DICT, column_236 TEXT ENCODING DICT, column_237 TEXT ENCODING DICT, column_238 TEXT ENCODING DICT, column_239 TEXT ENCODING DICT, column_240 TEXT ENCODING DICT, column_241 TEXT ENCODING DICT, column_242 TEXT ENCODING DICT, column_243 TEXT ENCODING DICT, column_244 TEXT ENCODING DICT, column_245 TEXT ENCODING DICT, column_246 TEXT ENCODING DICT, column_247 TEXT ENCODING DICT, column_248 TEXT ENCODING DICT, column_249 TEXT ENCODING DICT, column_250 TEXT ENCODING DICT, column_251 TEXT ENCODING DICT, column_252 TEXT ENCODING DICT, column_253 TEXT ENCODING DICT, column_254 TEXT ENCODING DICT, column_255 TEXT ENCODING DICT, column_256 TEXT ENCODING DICT, column_257 TEXT ENCODING DICT, column_258 TEXT ENCODING DICT, column_259 TEXT ENCODING DICT, column_260 TEXT ENCODING DICT, column_261 TEXT ENCODING DICT, column_262 TEXT ENCODING DICT, column_263 TEXT ENCODING DICT, column_264 TEXT ENCODING DICT, column_265 TEXT ENCODING DICT, column_266 TEXT ENCODING DICT, column_267 TEXT ENCODING DICT, column_268 TEXT ENCODING DICT, column_269 TEXT ENCODING DICT, column_270 TEXT ENCODING DICT, column_271 TEXT ENCODING DICT, column_272 TEXT ENCODING DICT, column_273 TEXT ENCODING DICT, column_274 TEXT ENCODING DICT, column_275 TEXT ENCODING DICT, column_276 TEXT ENCODING DICT, column_277 TEXT ENCODING DICT, column_278 TEXT ENCODING DICT, column_279 TEXT ENCODING DICT, column_280 TEXT ENCODING DICT, column_281 TEXT ENCODING DICT, column_282 TEXT ENCODING DICT, column_283 TEXT ENCODING DICT, column_284 TEXT ENCODING DICT, column_285 TEXT ENCODING DICT, column_286 TEXT ENCODING DICT, column_287 TEXT ENCODING DICT, column_288 TEXT ENCODING DICT, column_289 TEXT ENCODING DICT, column_290 TEXT ENCODING DICT, column_291 TEXT ENCODING DICT, column_292 TEXT ENCODING DICT, column_293 TEXT ENCODING DICT, column_294 TEXT ENCODING DICT, column_295 TEXT ENCODING DICT, column_296 TEXT ENCODING DICT, column_297 TEXT ENCODING DICT, column_298 TEXT ENCODING DICT, column_299 TEXT ENCODING DICT, column_300 TEXT ENCODING DICT, column_301 TEXT ENCODING DICT, column_302 TEXT ENCODING DICT, column_303 TEXT ENCODING DICT, column_304 TEXT ENCODING DICT, column_305 TEXT ENCODING DICT, column_306 TEXT ENCODING DICT, column_307 TEXT ENCODING DICT, column_308 TEXT ENCODING DICT, column_309 TEXT ENCODING DICT, column_310 TEXT ENCODING DICT, column_311 TEXT ENCODING DICT, column_312 TEXT ENCODING DICT, column_313 TEXT ENCODING DICT, column_314 TEXT ENCODING DICT, column_315 TEXT ENCODING DICT, column_316 TEXT ENCODING DICT, column_317 TEXT ENCODING DICT, column_318 TEXT ENCODING DICT, column_319 TEXT ENCODING DICT, column_320 TEXT ENCODING DICT, column_321 TEXT ENCODING DICT, column_322 TEXT ENCODING DICT, column_323 TEXT ENCODING DICT, column_324 TEXT ENCODING DICT, column_325 TEXT ENCODING DICT, column_326 TEXT ENCODING DICT, column_327 TEXT ENCODING DICT, column_328 TEXT ENCODING DICT, column_329 TEXT ENCODING DICT, column_330 TEXT ENCODING DICT, column_331 TEXT ENCODING DICT, column_332 TEXT ENCODING DICT, column_333 TEXT ENCODING DICT, column_334 TEXT ENCODING DICT, column_335 TEXT ENCODING DICT, column_336 TEXT ENCODING DICT, column_337 TEXT ENCODING DICT, column_338 TEXT ENCODING DICT, column_339 TEXT ENCODING DICT, column_340 TEXT ENCODING DICT, column_341 TEXT ENCODING DICT, column_342 TEXT ENCODING DICT, column_343 TEXT ENCODING DICT, column_344 TEXT ENCODING DICT, column_345 TEXT ENCODING DICT, column_346 TEXT ENCODING DICT, column_347 TEXT ENCODING DICT, column_348 TEXT ENCODING DICT, column_349 TEXT ENCODING DICT, column_350 TEXT ENCODING DICT, column_351 TEXT ENCODING DICT, column_352 TEXT ENCODING DICT, column_353 TEXT ENCODING DICT, column_354 TEXT ENCODING DICT, column_355 TEXT ENCODING DICT, column_356 TEXT ENCODING DICT, column_357 TEXT ENCODING DICT, column_358 TEXT ENCODING DICT, column_359 TEXT ENCODING DICT, column_360 TEXT ENCODING DICT, column_361 TEXT ENCODING DICT, column_362 TEXT ENCODING DICT, column_363 TEXT ENCODING DICT, column_364 TEXT ENCODING DICT, column_365 TEXT ENCODING DICT, column_366 TEXT ENCODING DICT, column_367 TEXT ENCODING DICT, column_368 TEXT ENCODING DICT, column_369 TEXT ENCODING DICT, column_370 TEXT ENCODING DICT, column_371 TEXT ENCODING DICT, column_372 TEXT ENCODING DICT, column_373 TEXT ENCODING DICT, column_374 TEXT ENCODING DICT, column_375 TEXT ENCODING DICT, column_376 TEXT ENCODING DICT, column_377 TEXT ENCODING DICT, column_378 TEXT ENCODING DICT, column_379 TEXT ENCODING DICT, column_380 TEXT ENCODING DICT, column_381 TEXT ENCODING DICT, column_382 TEXT ENCODING DICT, column_383 TEXT ENCODING DICT, column_384 TEXT ENCODING DICT, column_385 TEXT ENCODING DICT, column_386 TEXT ENCODING DICT, column_387 TEXT ENCODING DICT, column_388 TEXT ENCODING DICT, column_389 TEXT ENCODING DICT, column_390 TEXT ENCODING DICT, column_391 TEXT ENCODING DICT, column_392 TEXT ENCODING DICT, column_393 TEXT ENCODING DICT, column_394 TEXT ENCODING DICT, column_395 TEXT ENCODING DICT, column_396 TEXT ENCODING DICT, column_397 TEXT ENCODING DICT, column_398 TEXT ENCODING DICT, column_399 TEXT ENCODING DICT, column_400 TEXT ENCODING DICT, column_401 TEXT ENCODING DICT, column_402 TEXT ENCODING DICT, column_403 TEXT ENCODING DICT, column_404 TEXT ENCODING DICT, column_405 TEXT ENCODING DICT, column_406 TEXT ENCODING DICT, column_407 TEXT ENCODING DICT, column_408 TEXT ENCODING DICT, column_409 TEXT ENCODING DICT, column_410 TEXT ENCODING DICT, column_411 TEXT ENCODING DICT, column_412 TEXT ENCODING DICT, column_413 TEXT ENCODING DICT, column_414 TEXT ENCODING DICT, column_415 TEXT ENCODING DICT, column_416 TEXT ENCODING DICT, column_417 TEXT ENCODING DICT, column_418 TEXT ENCODING DICT, column_419 TEXT ENCODING DICT, column_420 TEXT ENCODING DICT, column_421 TEXT ENCODING DICT, column_422 TEXT ENCODING DICT, column_423 TEXT ENCODING DICT, column_424 TEXT ENCODING DICT, column_425 TEXT ENCODING DICT, column_426 TEXT ENCODING DICT, column_427 TEXT ENCODING DICT, column_428 TEXT ENCODING DICT, column_429 TEXT ENCODING DICT, column_430 TEXT ENCODING DICT, column_431 TEXT ENCODING DICT, column_432 TEXT ENCODING DICT, column_433 TEXT ENCODING DICT, column_434 TEXT ENCODING DICT, column_435 TEXT ENCODING DICT, column_436 TEXT ENCODING DICT, column_437 TEXT ENCODING DICT, column_438 TEXT ENCODING DICT, column_439 TEXT ENCODING DICT, column_440 TEXT ENCODING DICT, column_441 TEXT ENCODING DICT, column_442 TEXT ENCODING DICT, column_443 TEXT ENCODING DICT, column_444 TEXT ENCODING DICT, column_445 TEXT ENCODING DICT, column_446 TEXT ENCODING DICT, column_447 TEXT ENCODING DICT, column_448 TEXT ENCODING DICT, column_449 TEXT ENCODING DICT, column_450 TEXT ENCODING DICT, column_451 TEXT ENCODING DICT, column_452 TEXT ENCODING DICT, column_453 TEXT ENCODING DICT, column_454 TEXT ENCODING DICT, column_455 TEXT ENCODING DICT, column_456 TEXT ENCODING DICT, column_457 TEXT ENCODING DICT, column_458 TEXT ENCODING DICT, column_459 TEXT ENCODING DICT, column_460 TEXT ENCODING DICT, column_461 TEXT ENCODING DICT, column_462 TEXT ENCODING DICT, column_463 TEXT ENCODING DICT, column_464 TEXT ENCODING DICT, column_465 TEXT ENCODING DICT, column_466 TEXT ENCODING DICT, column_467 TEXT ENCODING DICT, column_468 TEXT ENCODING DICT, column_469 TEXT ENCODING DICT, column_470 TEXT ENCODING DICT, column_471 TEXT ENCODING DICT, column_472 TEXT ENCODING DICT, column_473 TEXT ENCODING DICT, column_474 TEXT ENCODING DICT, column_475 TEXT ENCODING DICT, column_476 TEXT ENCODING DICT, column_477 TEXT ENCODING DICT, column_478 TEXT ENCODING DICT, column_479 TEXT ENCODING DICT, column_480 TEXT ENCODING DICT, column_481 TEXT ENCODING DICT, column_482 TEXT ENCODING DICT, column_483 TEXT ENCODING DICT, column_484 TEXT ENCODING DICT, column_485 TEXT ENCODING DICT, column_486 TEXT ENCODING DICT, column_487 TEXT ENCODING DICT, column_488 TEXT ENCODING DICT, column_489 TEXT ENCODING DICT, column_490 TEXT ENCODING DICT, column_491 TEXT ENCODING DICT, column_492 TEXT ENCODING DICT, column_493 TEXT ENCODING DICT, column_494 TEXT ENCODING DICT, column_495 TEXT ENCODING DICT, column_496 TEXT ENCODING DICT, column_497 TEXT ENCODING DICT, column_498 TEXT ENCODING DICT, column_499 TEXT ENCODING DICT, column_500 TEXT ENCODING DICT, column_501 TEXT ENCODING DICT, column_502 TEXT ENCODING DICT, column_503 TEXT ENCODING DICT, column_504 TEXT ENCODING DICT, column_505 TEXT ENCODING DICT, column_506 TEXT ENCODING DICT, column_507 TEXT ENCODING DICT);
Please sign in to leave a comment.
Comments
2 comments