ClickHouse / clickhouse-java

Java client and JDBC driver for ClickHouse
https://clickhouse.com
Apache License 2.0
1.39k stars 513 forks source link

Caused by: org.apache.http.TruncatedChunkException: Truncated chunk ( expected size: 4096; actual size: 4088) #654

Open a394023466 opened 3 years ago

a394023466 commented 3 years ago

Caused by: org.apache.http.TruncatedChunkException: Truncated chunk ( expected size: 4096; actual size: 4088)

a394023466 commented 3 years ago

image

zhicwu commented 3 years ago

Is your ClickHouse server behind a proxy like nginx? Can you share more information like version of ClickHouse and JDBC driver, SQL and table schema if applicable?

a394023466 commented 3 years ago

CREATE TABLE hqms.clean_tags( globalId String, C14x01C String, C15x01N String, C35x01C String, C35x02C String, C35x03C String, C35x04C String, C35x05C String, C35x06C String, C35x07C String, C35x08C String, C35x09C String, C35x10C String, C35x11C String, C35x12C String, C35x13C String, C35x14C String, C35x15C String, C35x16C String, C35x17C String, C35x18C String, C35x19C String, C35x20C String, C35x21C String, C35x22C String, C35x23C String, C35x24C String, C35x25C String, C35x26C String, C35x27C String, C35x28C String, C35x29C String, C35x30C String, C35x31C String, C35x32C String, C35x33C String, C35x34C String, C35x35C String, C35x36C String, C35x37C String, C35x38C String, C35x39C String, C35x40C String, C36x01N String, C36x02N String, C36x03N String, C36x04N String, C36x05N String, C36x06N String, C36x07N String, C36x08N String, C36x09N String, C36x10N String, C36x11N String, C36x12N String, C36x13N String, C36x14N String, C36x15N String, C36x16N String, C36x17N String, C36x18N String, C36x19N String, C36x20N String, C36x21N String, C36x22N String, C36x23N String, C36x24N String, C36x25N String, C36x26N String, C36x27N String, C36x28N String, C36x29N String, C36x30N String, C36x31N String, C36x32N String, C36x33N String, C36x34N String, C36x35N String, C36x36N String, C36x37N String, C36x38N String, C36x39N String, C36x40N String, C21x01C String, C42x01C String, C42x02C String, C42x03C String, C42x04C String, C42x05C String, C42x06C String, C42x07C String, C42x08C String, C42x09C String, C42x10C String, C42x11C String, C42x12C String, C42x13C String, C42x14C String, C42x15C String, C42x16C String, C42x17C String, C42x18C String, C42x19C String, C42x20C String, C42x21C String, C42x22C String, C42x23C String, C42x24C String, C42x25C String, C42x26C String, C42x27C String, C42x28C String, C42x29C String, C42x30C String, C42x31C String, C42x32C String, C42x33C String, C42x34C String, C42x35C String, C42x36C String, C42x37C String, C42x38C String, C42x39C String, C42x40C String, A26 String, A29 String, A28C String, A31C String, A30_P1 String, A30_P2 String, A30_P3 String, A27_P1 String, A27_P2 String, A27_P3 String, D15 Float64 , D16 Float64 , D17 Float64 , D18 Float64 , D11 Float64 , D12 Float64 , D19 Float64 , D21 Float64 , D22 Float64 , D26 Float64 , D27 Float64 , D28 Float64 , D29 Float64 , D30 Float64 , D31 Float64 , D32 Float64 , D33 Float64 , D34 Float64 , D14 Float64 , D20 Float64 , D20x01 Float64 , D20x02 Float64 , D23 Float64 , D24 Float64 , D25 Float64 , D13 Float64 , D01 Float64 , D09 Float64 , C06x01C String, C06x02C String, C06x03C String, C06x04C String, C06x05C String, C06x06C String, C06x07C String, C06x08C String, C06x09C String, C06x10C String, C06x11C String, C06x12C String, C06x13C String, C06x14C String, C06x15C String, C06x16C String, C06x17C String, C06x18C String, C06x19C String, C06x20C String, C06x21C String, C06x22C String, C06x23C String, C06x24C String, C06x25C String, C06x26C String, C06x27C String, C06x28C String, C06x29C String, C06x30C String, C06x31C String, C06x32C String, C06x33C String, C06x34C String, C06x35C String, C06x36C String, C06x37C String, C06x38C String, C06x39C String, C06x40C String, C12C String, C09C String, F07x01C String, F07x02C String, C16x01 String, C37x01 String, C37x02 String, C37x03 String, C37x04 String, C37x05 String, C37x06 String, C37x07 String, C37x08 String, C37x09 String, C37x10 String, C37x11 String, C37x12 String, C37x13 String, C37x14 String, C37x15 String, C37x16 String, C37x17 String, C37x18 String, C37x19 String, C37x20 String, C37x21 String, C37x22 String, C37x23 String, C37x24 String, C37x25 String, C37x26 String, C37x27 String, C37x28 String, C37x29 String, C37x30 String, C37x31 String, C37x32 String, C37x33 String, C37x34 String, C37x35 String, C37x36 String, C37x37 String, C37x38 String, C37x39 String, C37x40 String, C05C String, C08x01C String, C08x02C String, C08x03C String, C08x04C String, C08x05C String, C08x06C String, C08x07C String, C08x08C String, C08x09C String, C08x10C String, C08x11C String, C08x12C String, C08x13C String, C08x14C String, C08x15C String, C08x16C String, C08x17C String, C08x18C String, C08x19C String, C08x20C String, C08x21C String, C08x22C String, C08x23C String, C08x24C String, C08x25C String, C08x26C String, C08x27C String, C08x28C String, C08x29C String, C08x30C String, C08x31C String, C08x32C String, C08x33C String, C08x34C String, C08x35C String, C08x36C String, C08x37C String, C08x38C String, C08x39C String, C08x40C String, A14 Int32, A13 String, B12 String, A20_P1 String, A20_P2 String, A20_P3 String, A12C Int32, A16 Int32, C03C String, C49x01 String, C49x02 String, C49x03 String, C49x04 String, C49x05 String, B13C String, B21C String, B16C String, C48x01C String, C48x02C String, C48x03C String, C48x04C String, C48x05C String, B15 String, B34C String, C34C String, A20 String, B36C Int32, orgid String, B11C String, shoushu Int32, shoushu1 Int32, shoushu2 Int32, shoushu3 Int32, shoushu4 Int32, shoushu_wy Int32, surg3 Int32, surg4 Int32, mini Int32, diag_wu Int32, diag_wu1 Int32, diag_wu2 Int32, diag_wu3 Int32, diag_wu4 Int32, diag_wu5 Int32, diag_wu6 Int32, diag_wu7 Int32, diag_wu8 Int32, diag_wu9 Int32, diag_wu10 Int32, diag_wu11 Int32, diag_wu12 Int32, diag_wu13 Int32, diag_wu14 Int32, diag_wu15 Int32, diag_wu16 Int32, diag_wu17 Int32, diag_wu18 Int32, diag_wu19 Int32, diag_wu20 Int32, diag_wu21 Int32, diag_wu22 Int32, diag_wu23 Int32, diag_wu24 Int32, diag_wu25 Int32, diag_wu26 Int32, diag_wu27 Int32, diag_wu28 Int32, diag_wu29 Int32, diag_wu30 Int32, diag_wu31 Int32, diag_wu32 Int32, diag_wu33 Int32, diag_wu34 Int32, diag_wu35 Int32, diag_wu36 Int32, diag_wu37 Int32, diag_wu38 Int32, diag_wu39 Int32, diag_wu40 Int32, age_fin Int32, sex Int32, child Int32, newborn Int32, chanfu_wy Int32, icu Int32, icd_use Int32, status Int32, sjdays_erji Int32, thesameperson String, rehos Int32, day_period Int32, zeqi Int32, zeqi_comp Int32, cut1 Int32, cut1_infect Int32, from_pro String, from_proid Int32, from_city String, from_cityid Int32, pro String, proid Int32, city String, cityid Int32, yidi Int32, benshi Int32, fee_check Float64, fee_opt Float64, fee_supl Float64, fee_other Float64, fee_sugy Float64, fee_med Float64, fee_nur Float64, fee_total Float64, fee_own Float64, fee_available_all Float64, fee_all Float64, fee_available1 Float64, d_age1 Int32, d_age2 Int32, age_abr Int32, disease1 Int32, disease2 Int32, disease3 Int32, disease4 Int32, disease5 Int32, disease6 Int32, disease7 Int32, disease8 Int32, disease9_1 Int32, disease9_2 Int32, disease10 Int32, disease11 Int32, disease12 Int32, disease13 Int32, disease14 Int32, disease15 Int32, disease16 Int32, disease17 Int32, disease18 Int32, disease19 Int32, disease20 Int32, disease_all Int32, operation1_1 Int32, operation1_2 Int32, operation2 Int32, operation3 Int32, operation4 Int32, operation5 Int32, operation6 Int32, operation7 Int32, operation8 Int32, operation9 Int32, operation10 Int32, operation11 Int32, operation12 Int32, operation13 Int32, operation14 Int32, operation15 Int32, operation16 Int32, operation17 Int32, operation18 Int32, operation19 Int32, operation20 Int32, operation_all Int32, cancer1 Int32, cancer2 Int32, cancer3 Int32, cancer4 Int32, cancer5 Int32, cancer6 Int32, cancer7 Int32, cancer8 Int32, cancer9 Int32, cancer10 Int32, cancer11 Int32, cancer12 Int32, cancer13 Int32, cancer14 Int32, cancer15 Int32, cancer16 Int32, cancer_all Int32, z51_0 Int32, z51_h Int32, z51_q Int32, operate1_1 Int32, operate2_1 Int32, operate3_1 Int32, operate4_1 Int32, operate5_1 Int32, operate6_1 Int32, operate7_1 Int32, operate8_1 Int32, operate9_1 Int32, operate10_1 Int32, operate11_1 Int32, operate12_1 Int32, operate13_1 Int32, operate14_1 Int32, operate1 Int32, operate2 Int32, operate3 Int32, operate4 Int32, operate5 Int32, operate6 Int32, operate7 Int32, operate8 Int32, operate9 Int32, operate10 Int32, operate11 Int32, operate12 Int32, operate13 Int32, operate14 Int32, operate_all Int32, cancer_1 Int32, cancer_3 Int32, cancer_5 Int32, cancer_7 Int32, cancer_9 Int32, cancer_11 Int32, cancer_13 Int32, cancer_15 Int32, cancer_17 Int32, cancer_19 Int32, cancer_21 Int32, cancer_23 Int32, cancer_25 Int32, cancer_27 Int32, cancer_29 Int32, cancer_31 Int32, cancer_2 Int32, cancer_4 Int32, cancer_6 Int32, cancer_8 Int32, cancer_10 Int32, cancer_12 Int32, cancer_14 Int32, cancer_16 Int32, cancer_18 Int32, cancer_20 Int32, cancer_22 Int32, cancer_24 Int32, cancer_26 Int32, cancer_28 Int32, cancer_30 Int32, cancer_32 Int32, cancer_2_1 Int32, cancer_4_1 Int32, cancer_6_1 Int32, cancer_8_1 Int32, cancer_10_1 Int32, cancer_12_1 Int32, cancer_14_1 Int32, cancer_16_1 Int32, cancer_18_1 Int32, cancer_20_1 Int32, cancer_22_1 Int32, cancer_24_1 Int32, cancer_26_1 Int32, cancer_28_1 Int32, cancer_30_1 Int32, cancer_32_1 Int32, cancer_2_2 Int32, cancer_4_2 Int32, cancer_6_2 Int32, cancer_8_2 Int32, cancer_10_2 Int32, cancer_12_2 Int32, cancer_14_2 Int32, cancer_16_2 Int32, cancer_18_2 Int32, cancer_20_2 Int32, cancer_22_2 Int32, cancer_24_2 Int32, cancer_26_2 Int32, cancer_28_2 Int32, cancer_30_2 Int32, cancer_32_2 Int32, cancer_nosurg Int32, op_com1 Int32, op_com2 Int32, op_com3 Int32, op_com4 Int32, op_com5 Int32, op_com6 Int32, op_com7 Int32, op_com8 Int32, op_com9 Int32, op_com10 Int32, op_com11 Int32, op_com12 Int32, op_com13 Int32, op_com14 Int32, op_com15_1 Int32, op_com15_2 Int32, op_com15_3 Int32, op_com15_4 Int32, op_com15_5 Int32, op_com15_6 Int32, op_com15_7 Int32, op_com15_8 Int32, op_com15 Int32, op_com15_9 Int32, op_com15b Int32, op_com16_1 Int32, op_com16_2 Int32, op_com16_3 Int32, op_com16_4 Int32, op_com16 Int32, op_com17 Int32, op_com18 Int32, op_com19 Int32, op_com20 Int32, op_com21 Int32, op_com22 Int32, op_com23 Int32, op_com24 Int32, op_com25 Int32, op_com26 Int32, op_com27 Int32, op_com28_1 Int32, op_com28_2 Int32, op_com28_3 Int32, op_com29_1 Int32, op_com29_2 Int32, op_com29_3 Int32, op_com29_4 Int32, op_com29_5 Int32, op_com29_6 Int32, op_com29_7 Int32, op_com30 Int32, op_com_surg Int32, op_com_fm Int32, op_com_other Int32, op_com_icu Int32, op_com_all Int32, pe Int32, dvt Int32, septicemia Int32, hematoma Int32, wbreak Int32, sudden_death Int32, rf Int32, fistula Int32, ileus Int32, lmd Int32, si Int32, ana_comp Int32, pi Int32, aki Int32, cimd Int32, ctrspl Int32, craa Int32, op_com_surg1 Int32, lowdisease1 Int32, lowdisease2 Int32, lowdisease3 Int32, lowdisease4 Int32, lowdisease5 Int32, lowdisease6 Int32, lowdisease7 Int32, lowdisease8 Int32, lowdisease9 Int32, lowdisease10 Int32, lowdisease11 Int32, lowdisease12 Int32, lowdisease13 Int32, lowdisease14 Int32, lowdisease15 Int32, lowdisease16 Int32, lowdisease17 Int32, lowdisease18 Int32, lowdisease19 Int32, lowdisease20 Int32, lowdisease21 Int32, lowdisease22 Int32, lowdisease23 Int32, lowdisease24 Int32, lowdisease25 Int32, lowdisease26 Int32, lowdisease27 Int32, lowdisease28 Int32, lowdisease29 Int32, lowdisease30 Int32, lowdisease31 Int32, lowdisease32 Int32, lowdisease33 Int32, lowdisease34 Int32, lowdisease35 Int32, lowdisease36 Int32, lowdisease37 Int32, lowdisease38 Int32, lowdisease39 Int32, lowdisease40 Int32, lowdisease41 Int32, lowdisease42 Int32, lowdisease43 Int32, lowdisease44 Int32, lowdisease45 Int32, lowdisease46 Int32, lowdisease47 Int32, lowdisease48 Int32, lowdisease49 Int32, lowdisease50 Int32, lowdisease51 Int32, lowdisease52 Int32, lowdisease53 Int32, lowdisease54 Int32, lowdisease55 Int32, lowdisease56 Int32, lowdisease57 Int32, lowdisease58 Int32, lowdisease59 Int32, lowdisease60 Int32, lowdisease61 Int32, lowdisease62 Int32, lowdisease63 Int32, lowdisease64 Int32, lowdisease65 Int32, lowdisease66 Int32, lowdisease67 Int32, lowdisease68 Int32, lowdisease69 Int32, lowdisease70 Int32, lowdisease71 Int32, lowdisease72 Int32, lowdisease73 Int32, lowdisease74 Int32, lowdisease75 Int32, lowdisease76 Int32, lowdisease77 Int32, lowdisease78 Int32, lowdisease79 Int32, lowdisease80 Int32, lowdisease81 Int32, lowdisease82 Int32, lowdisease83 Int32, lowdisease84 Int32, lowdisease85 Int32, lowdisease86 Int32, lowdisease87 Int32, lowdisease88 Int32, lowdisease89 Int32, lowdisease90 Int32, lowdisease91 Int32, lowdisease92 Int32, lowdisease93 Int32, lowdisease94 Int32, lowdisease95 Int32, lowdisease96 Int32, lowdisease97 Int32, lowdisease98 Int32, lowdisease99 Int32, lowdisease100 Int32, lowdisease101 Int32, lowdisease102 Int32, lowdisease103 Int32, lowdisease104 Int32, lowdisease105 Int32, lowdisease106 Int32, lowdisease107 Int32, lowdisease108 Int32, lowdisease109 Int32, lowdisease110 Int32, lowdisease111 Int32, lowdisease112 Int32, lowdisease113 Int32, lowdisease114 Int32, lowdisease115 Int32, lowdisease_all Int32, op_comcftmp1_1 Int32, op_comcftmp1_2 Int32, op_comcftmp1_3 Int32, op_comcftmp1_4 Int32, op_comcftmp1_5 Int32, op_comcftmp1_6 Int32, op_comcftmp1_7 Int32, op_comcftmp1_8 Int32, op_comcftmp1_9 Int32, op_comcftmp1_10 Int32, op_comcftmp1_11 Int32, op_comcftmp1_12 Int32, op_comcftmp1_13 Int32, op_comcftmp1_14 Int32, op_comcftmp1_15 Int32, op_comcftmp1_16 Int32, op_comcftmp1_17 Int32, op_comcftmp1_18 Int32, op_comcftmp1_19 Int32, op_comcftmp1_20 Int32, op_comcftmp1_21 Int32, op_comcftmp1_22 Int32, op_comcftmp1_23 Int32, op_comcftmp1_24 Int32, op_comcftmp1_25 Int32, op_comcftmp1_26 Int32, op_comcftmp1_27 Int32, op_comcftmp1_28 Int32, op_comcftmp1_29 Int32, op_comcftmp1_30 Int32, op_comcftmp1_31 Int32, op_comcftmp1_32 Int32, op_comcftmp1_33 Int32, op_comcftmp1_34 Int32, op_comcftmp1_35 Int32, op_comcftmp1_36 Int32, op_comcftmp1_37 Int32, op_comcftmp1_38 Int32, op_comcftmp1_39 Int32, op_comcftmp1_40 Int32, op_comcftmp1_41 Int32, op_comcftmp1_42 Int32, op_comcftmp1_43 Int32, op_comcftmp1_44 Int32, op_comcftmp1_45 Int32, op_comcftmp1_46 Int32, op_comcftmp1_47 Int32, op_comcftmp1_48 Int32, op_comcftmp1_49 Int32, op_comcftmp1_50 Int32, op_comcftmp1_51 Int32, op_comcftmp1_52 Int32, op_comcftmp1_53 Int32, op_comcftmp1_54 Int32, op_comcftmp1_55 Int32, op_comcftmp1_56 Int32, op_comcftmp1_57 Int32, op_comcftmp1_58 Int32, op_comcftmp1_59 Int32, op_comcftmp1_60 Int32, op_comcftmp1_61 Int32, op_comcftmp1_62 Int32, op_comcftmp1_63 Int32, op_comcftmp1_64 Int32, op_comcftmp1_65 Int32, op_comcftmp1_66 Int32, op_comcftmp1_67 Int32, op_comcftmp1_68 Int32, op_comcftmp1_69 Int32, op_comcftmp1_70 Int32, op_comcftmp1_71 Int32, op_comcftmp1_72 Int32, op_comcftmp1_73 Int32, op_comcftmp2_1 Int32, op_comcftmp2_2 Int32, op_comcftmp2_3 Int32, op_comcftmp2_4 Int32, op_comcftmp2_5 Int32, op_comcftmp2_6 Int32, op_comcftmp2_7 Int32, op_comcftmp2_8 Int32, op_comcftmp2_9 Int32, op_comcftmp2_10 Int32, op_comcftmp2_11 Int32, op_comcftmp2_12 Int32, op_comcftmp2_13 Int32, op_comcftmp2_14 Int32, op_comcftmp2_15 Int32, op_comcftmp2_16 Int32, op_comcftmp2_17 Int32, op_comcftmp2_18 Int32, op_comcftmp2_19 Int32, op_comcftmp2_20 Int32, op_comcftmp2_21 Int32, op_comcftmp2_22 Int32, op_comcftmp2_23 Int32, op_comcftmp2_24 Int32, op_comcftmp2_25 Int32, op_comcftmp2_26 Int32, op_comcftmp2_27 Int32, op_comcftmp2_28 Int32, op_comcftmp2_29 Int32, op_comcftmp2_30 Int32, op_comcftmp2_31 Int32, op_comcftmp2_32 Int32, op_comcftmp2_33 Int32, op_comcftmp2_34 Int32, op_comcftmp2_35 Int32, op_comcftmp2_36 Int32, op_comcftmp2_37 Int32, op_comcftmp2_38 Int32, op_comcftmp2_39 Int32, op_comcftmp2_40 Int32, op_comcftmp2_41 Int32, op_comcftmp2_42 Int32, op_comcftmp2_43 Int32, op_comcftmp2_44 Int32, op_comcftmp2_45 Int32, op_comcftmp2_46 Int32, op_comcftmp2_47 Int32, op_comcftmp2_48 Int32, op_comcftmp2_49 Int32, op_comcftmp2_50 Int32, op_comcftmp2_51 Int32, op_comcftmp2_52 Int32, op_comcftmp2_53 Int32, op_comcftmp2_54 Int32, op_comcftmp2_55 Int32, op_comcftmp2_56 Int32, op_comcftmp2_57 Int32, op_comcftmp2_58 Int32, op_comcftmp2_59 Int32, op_comcftmp2_60 Int32, op_comcftmp2_61 Int32, op_comcftmp2_62 Int32, op_comcftmp2_63 Int32, op_comcftmp2_64 Int32, op_comcftmp2_65 Int32, op_comcftmp2_66 Int32, op_comcftmp2_67 Int32, op_comcftmp2_68 Int32, op_comcftmp2_69 Int32, ydfm Int32, yachuang Int32, chanfu Int32, pougong Int32, xinzang Int32, kidney Int32, fm_newborn Int32, fm Int32, lw1 Int32, lw2 Int32, lw3 Int32, lw4 Int32, dn1 Int32, dn2 Int32, dn3 Int32, dn4 Int32, rijian Int32, ami Int32, hf Int32, pnmn_adult Int32, pnmn_kid Int32, ci Int32, hr Int32, kr Int32, cabg Int32, caesarean Int32, copd Int32, org_level Int32, org_type String, hxn_diag Int32, hxn_diag_yn Int32, hxn_op Int32, hxn_op_yn Int32, xhn_diag Int32, xhn_diag_yn Int32, xhn_op Int32, xhn_op_yn Int32, xxg_diag Int32, xxg_diag_yn Int32, xxg_op Int32, xxg_op_yn Int32, nfm_diag Int32, nfm_diag_yn Int32, snk_diag Int32, snk_diag_yn Int32, snk_op Int32, snk_op_yn Int32, xyb_diag Int32, xyb_diag_yn Int32, xyb_op Int32, xyb_op_yn Int32, fslcmy_diag Int32, fslcmy_diag_yn Int32, sjnk_diag Int32, sjnk_diag_yn Int32, jsb_diag Int32, jsb_diag_yn Int32, kidsum_diag Int32, kidsum_diag_yn Int32, kidsum_op Int32, ptwk_diag Int32, ptwk_diag_yn Int32, ptwk_op Int32, ptwk_op_yn Int32, gw_diag Int32, gw_diag_yn Int32, gw_op Int32, gw_op_yn Int32, mn_diag Int32, mn_diag_yn Int32, mn_op Int32, mn_op_yn Int32, sjwk_diag Int32, sjwk_diag_yn Int32, sjwk_op Int32, sjwk_op_yn Int32, xxwk_diag Int32, xxwk_diag_yn Int32, xxwk_op Int32, xxwk_op_yn Int32, cf_diag Int32, cf_diag_yn Int32, cf_op Int32, cf_op_yn Int32, xewk_diag Int32, xewk_diag_yn Int32, xewk_op Int32, xewk_op_yn Int32, ebyh_diag Int32, ebyh_diag_yn Int32, ebyh_op Int32, ebyh_op_yn Int32, yk_diag Int32, yk_diag_yn Int32, yk_op Int32, yk_op_yn Int32, crb_diag Int32, crb_diag_yn Int32, crb_op Int32, crb_op_yn Int32, zl_diag Int32, zl_diag_yn Int32, zl_op Int32, zl_op_yn Int32, hxn_yn Int32, xhn_yn Int32, xxg_yn Int32, nfm_yn Int32, snk_yn Int32, xyb_yn Int32, fslcmy_yn Int32, sjnk_yn Int32, jsb_yn Int32, kidsum_yn Int32, ptwk_yn Int32, gw_yn Int32, mn_yn Int32, sjwk_yn Int32, xxwk_yn Int32, cf_yn Int32, xewk_yn Int32, ebyh_yn Int32, yk_yn Int32, crb_yn Int32, zl_yn Int32, op_yn Int32, diag_yn Int32, yn Int32, B20 Int32, D23x01 Float64, ynks String, aged_diag_yn Int32, aged_op_yn Int32, aged_yn Int32, create_date DateTime DEFAULT now()
) ENGINE=MergeTree PARTITION BY toYYYYMM(toDateTime(B15)) ORDER BY B15;

zhicwu commented 3 years ago

Thanks for sharing the table structure. I didn't see any complex data type like Array / Map etc. being used there, so I really don't know what could be the cause. Mind to provide more information as I asked earlier?

Lastly, although it's a bit off the topic, you probably should consider to use Array so that you don't have to define many columns with different suffix.