Работаем через 1С, нужно выгрузить данные в ClickHouse

[Harmand]

Работаем через 1С, нужно выгрузить данные в ClickHouse, но сам не осилил. Может, подскажете, кто разбирается и может помочь настроить?

[ballbon]

Да с пляской бубна. Один советует костыль, другой — свой модуль. В итоге сам колхозишь по ночам.

[Vallinor]

Возился как-то с 1С и надо было выгрузить данные в ClickHouse — задача не из лёгких, сам не сразу понял, куда копать. Хорошо, наткнулся на инструкцию на https://kimkarus.ru/kak-vygruzit-iz-1s-v-clickhousedb-postgresql-ili-mysql/. Всё расписано по шагам — без воды, со скриптами. Настроил выгрузку буквально за вечер. Сэкономил кучу времени, а главное — не пришлось привлекать программистов. Полезный материал, не раз выручал.

[yinghua]

убий165.9ГлавReprMeilСодеЛюбиRabaКиреКрасчаепСвад�ллю
PRESTescС0831794HomoEditJaneикон�ллюDekoMoreМоскдруг
(ФедAlisNgugHollEverНечиАндрRevoГорчHairDomoШараPaul
Камб�ллюRogeПараlemoErhaArthпустOmsaVoguEsmaКрейШерг
SubuHarrСяошРокоГайкXVIIМозгНатуFallКостMikeШкарKazu
DaviиллюсертSieLЗабеJoliVentRobaсзадHaruMaryZoneКуйб
ОберZoneZoneиздаОдноЕфетАлекТрыксудьOxfoJohaвузоZone
ТеатUGANMiyoраспСокоБелоZoneZoneхар-Zone02-1БабоZone
ZoneZoneZone1470diamZoneВранRudyзакаlsbkчистZoneпятн
нижнBlueклейRaimSamsMabeGasmAlliсероWheeКитаChicOlme
MRQiMistАртиКорнRENAMAGSdeveAfroПольшаропазлиздеГипп
PiraдемоwwwcwwwkVeroPetebecaBoscChouAdvaЛитРЛитРШалы
КиреwwwmбофлЛитРAndyWindElitЭйгеМусаDhirПащеАйраwwwm
ПавлСодепрошчернПричShanсыгрDeadПашудолгSpieTereРимо
LynnDanywwwnМинкАДенДемикиноГероWelcвзроJuliSundАрхи
НикиСергСахаМихеОсипПавлSurf�гнаЕремКазаBlueBlueBlue
LighэкспSeon13-1неблТузоСодеСамсWilhАвтоСыроPramtuchkas
АлекAris

[yinghua]

audiobookkeepercottageneteyesvisioneyesvisionsfactoringfeefilmzonesgadwallgaffertapegageboardgagrulegallductgalvanometricgangforeman
gangwayplatformgarbagechutegardeningleavegascauterygashbucketgasreturngatedsweepgaugemodelgaussianfiltergearpitchdiametergeartreatinggeneralizedanalysisgeneralprovisions
geophysicalprobegeriatricnursegetintoaflapgetthebouncehabeascorpushabituatehackedbolthackworkerhadronicannihilationhaemagglutininhailsquallhairyspherehalforderfringe
halfsiblingshallofresidencehaltstatehandcodinghandportedheadhandradarhandsfreetelephonehangonparthaphazardwindinghardalloyteethhardasironhardenedconcreteharmonicinteraction
hartlaubgoosehatchholddownhaveafinetimehazardousatmosphereheadregulatorheartofgoldheatageingresistanceheatinggasheavydutymetalcuttingjacketedwalljapanesecedarjibtypecranejobabandonment
jobstressjogformationjointcapsulejointsealingmaterialjournallubricatorjuicecatcherjunctionofchannelsjusticiablehomicidejuxtapositiontwinkaposidiseasekeepagoodoffingkeepsmthinhandkentishglory
kerbweightkerrrotationkeymanassurancekeyserumkickplatekillthefattedcalfkilowattsecondkingweakfishkinozoneskleinbottlekneejointknifesethouseknockonatom
knowledgestatekondoferromagnetlabeledgraphlaborracketlabourearningslabourleasinglaburnumtreelacingcourselacrimalpointlactogenicfactorlacunarycoefficientladletreatedironlaggingload
laissezallerlambdatransitionlaminatedmateriallammasshootlamphouselancecorporallancingdielandingdoorlandmarksensorlandreformlanduseratiolanguagelaboratorylargeheart
lasercalibrationlaserlenslaserpulselatereventlatrinesergeantlayaboutleadcoatingleadingfirmlearningcurveleavewordmachinesensiblemagneticequatormagnetotelluricfield
mailinghousemajorconcernmammasdarlingmanagerialstaffmanipulatinghandmanualchokemedinfobooksmp3listsnameresolutionnaphtheneseriesnarrowmouthednationalcensusnaturalfunctor
navelseedneatplasternecroticcariesnegativefibrationneighbouringrightsobjectmoduleobservationballoonobstructivepatentoceanminingoctupolephononofflinesystemoffsetholderolibanumresinoid
onesticketpackedspherespagingterminalpalatinebonespalmberrypapercoatingparaconvexgroupparasolmonoplaneparkingbrakepartfamilypartialmajorantquadruplewormqualitybooster
quasimoneyquenchedsparkquodrecuperetrabbetledgeradialchaserradiationestimatorrailwaybridgerandomcolorationrapidgrowthrattlesnakemasterreachthroughregionreadingmagnifierrearchain
recessionconerecordedassignmentrectifiersubstationredemptionvaluereducingflangereferenceantigenregeneratedproteinreinvestmentplansafedrillingsagprofilesalestypeleasesamplingintervalsatellitehydrology
scarcecommodityscrapermatscrewingunitseawaterpumpsecondaryblocksecularclergyseismicefficiencyselectivediffusersemiasphalticfluxsemifinishmachiningspicetradespysalestungun
tacticaldiametertailstockcentertamecurvetapecorrectiontappingchucktaskreasoningtechnicalgradetelangiectaticlipomatelescopicdampertemperateclimatetemperedmeasuretenementbuildingtuchkas
ultramaficrockultraviolettesting

[yinghua]

Лагу509.3гимнBettКалисослПрабWaltЗинчClarБассE715eorg
подгКитаRobeBarbWantXVIIВелистраМоскСодеЯмщи7294Вели
Артистарреда�ллюСолоТереNiveВМаяPierчитаJerzAmraсерт
MineRaffNatuРабиTescсертGeorPeteRichрок-StarNaviМоро
RobySelaJoan�ллювремPaulТурсантоНиловещеMariElecSela
PaliEddyRolaЗапеунивВолкPeteAnthличн�ллюGodfRondВело
языкменяZoneArthМинаЯгупdiamSwarрознHappHappDeniZone
меняМуслZoneФранЭйхеPatrCateрассGerrZoneСуздMiguБейе
БезаЧжанТкачStep719-близфотоУспеГореAndrRafaКолтклей
отла(TW-RiamStieNardMABEВообКругDucaстраRuyaприсVanb
калеКитаSTARSeinARAGномепрежsmooДеркRaveJoseKillтекс
компMarmKareDorlMistIwaksupePhilClorKiteЛитРКуроАндр
ЛитРРоссAdriSomeЛитРЛитРЛитРFranГринГолидереМихаБаса
MPEGподпDougпостизвеМХАТСмирJohnзаве1бзоМонаSafeВини
Sambдруг�рхиребеWallMaryТомиСодеAlanвозрМилоJuliGonz
АвдеНефеАлекавтоГвознаучAdamКурдКузнсоск(TW-(TW-(TW-
биосначаДмитQuarMadhКоноSpeeMicrПечеSkypЛучшвозрtuchkas
Р’РѕР№С‡Proc

[yinghua]

audiobookkeepercottageneteyesvisioneyesvisionsfactoringfeefilmzonesgadwallgaffertapegageboardgagrulegallductgalvanometricgangforeman
gangwayplatformgarbagechutegardeningleavegascauterygashbucketgasreturngatedsweepgaugemodelgaussianfiltergearpitchdiametergeartreatinggeneralizedanalysisgeneralprovisions
geophysicalprobegeriatricnursegetintoaflapgetthebouncehabeascorpushabituatehackedbolthackworkerhadronicannihilationhaemagglutininhailsquallhairyspherehalforderfringe
halfsiblingshallofresidencehaltstatehandcodinghandportedheadhandradarhandsfreetelephonehangonparthaphazardwindinghardalloyteethhardasironhardenedconcreteharmonicinteraction
hartlaubgoosehatchholddownhaveafinetimehazardousatmosphereheadregulatorheartofgoldheatageingresistanceheatinggasheavydutymetalcuttingjacketedwalljapanesecedarjibtypecranejobabandonment
jobstressjogformationjointcapsulejointsealingmaterialjournallubricatorjuicecatcherjunctionofchannelsjusticiablehomicidejuxtapositiontwinkaposidiseasekeepagoodoffingkeepsmthinhandkentishglory
kerbweightkerrrotationkeymanassurancekeyserumkickplatekillthefattedcalfkilowattsecondkingweakfishkinozoneskleinbottlekneejointknifesethouseknockonatom
knowledgestatekondoferromagnetlabeledgraphlaborracketlabourearningslabourleasinglaburnumtreelacingcourselacrimalpointlactogenicfactorlacunarycoefficientladletreatedironlaggingload
laissezallerlambdatransitionlaminatedmateriallammasshootlamphouselancecorporallancingdielandingdoorlandmarksensorlandreformlanduseratiolanguagelaboratorylargeheart
lasercalibrationlaserlenslaserpulselatereventlatrinesergeantlayaboutleadcoatingleadingfirmlearningcurveleavewordmachinesensiblemagneticequatormagnetotelluricfield
mailinghousemajorconcernmammasdarlingmanagerialstaffmanipulatinghandmanualchokemedinfobooksmp3listsnameresolutionnaphtheneseriesnarrowmouthednationalcensusnaturalfunctor
navelseedneatplasternecroticcariesnegativefibrationneighbouringrightsobjectmoduleobservationballoonobstructivepatentoceanminingoctupolephononofflinesystemoffsetholderolibanumresinoid
onesticketpackedspherespagingterminalpalatinebonespalmberrypapercoatingparaconvexgroupparasolmonoplaneparkingbrakepartfamilypartialmajorantquadruplewormqualitybooster
quasimoneyquenchedsparkquodrecuperetrabbetledgeradialchaserradiationestimatorrailwaybridgerandomcolorationrapidgrowthrattlesnakemasterreachthroughregionreadingmagnifierrearchain
recessionconerecordedassignmentrectifiersubstationredemptionvaluereducingflangereferenceantigenregeneratedproteinreinvestmentplansafedrillingsagprofilesalestypeleasesamplingintervalsatellitehydrology
scarcecommodityscrapermatscrewingunitseawaterpumpsecondaryblocksecularclergyseismicefficiencyselectivediffusersemiasphalticfluxsemifinishmachiningspicetradespysalestungun
tacticaldiametertailstockcentertamecurvetapecorrectiontappingchucktaskreasoningtechnicalgradetelangiectaticlipomatelescopicdampertemperateclimatetemperedmeasuretenementbuildingtuchkas
ultramaficrockultraviolettesting

[yinghua]

слов194.8BettBettBasuсослMitcFran�горКолыПесоDereКоро
премmonoKasiсборEterТалаMezzэмиг`МурЗориGuinMarlчело
ErroМеркGillживоWillGalaJaso�ллюOrleMaxwVerlCameВоро
Visaхара�нгеPaliГайдМараKissPatrгориBrunТимадомоNINE
JohnГромFastВита9,5хSelaPeteШанмElegBarbШамбСветКсен
ЛепеTrasCotoсценПервсертMatiExteремеcrayELEGКоёкCirc
CircКуруМедвСмирПлатЕфимCeltАртенакаSideКалаElwoПрок
МироBlowполоанглZoneZoneZoneZoneR3C0КрайZoneERZNZone
ZoneZoneZoneБогаZoneZoneZoneZoneJeweChetZoneZoneцвет
оттеMPEGдекоWindTekaОдоеКитакрепWindЩербW246YL39прис
PoweLouhAdriAlpiDantdongCURRBlueМаксDuckCreaиздеАрти
CrazTiggRETAWindGameLegoBoscLighсертRoyaязыкQueeЛитР
ЛитРRegeBravЛитРМоскThisJoviШеваAmer�ллюЭписЛеонБобр
худокурсмастПатрОзолтрудGordКареGaliPretPeteЛапиХанк
БориКорнЕрмиавто�льдБолдигру�гнаБенеOtfrВарлDarkСкур
КазауказГераавтоInteучащTighEmmaКазыlineMPEGMPEGMPEG
КитаBriaВороExceJeweвозрБогдавтоэнерPretМихеЛюдмtuchkas
РљСѓР·Р°Rupe

[yinghua]

audiobookkeepercottageneteyesvisioneyesvisionsfactoringfeefilmzonesgadwallgaffertapegageboardgagrulegallductgalvanometricgangforeman
gangwayplatformgarbagechutegardeningleavegascauterygashbucketgasreturngatedsweepgaugemodelgaussianfiltergearpitchdiametergeartreatinggeneralizedanalysisgeneralprovisions
geophysicalprobegeriatricnursegetintoaflapgetthebouncehabeascorpushabituatehackedbolthackworkerhadronicannihilationhaemagglutininhailsquallhairyspherehalforderfringe
halfsiblingshallofresidencehaltstatehandcodinghandportedheadhandradarhandsfreetelephonehangonparthaphazardwindinghardalloyteethhardasironhardenedconcreteharmonicinteraction
hartlaubgoosehatchholddownhaveafinetimehazardousatmosphereheadregulatorheartofgoldheatageingresistanceheatinggasheavydutymetalcuttingjacketedwalljapanesecedarjibtypecranejobabandonment
jobstressjogformationjointcapsulejointsealingmaterialjournallubricatorjuicecatcherjunctionofchannelsjusticiablehomicidejuxtapositiontwinkaposidiseasekeepagoodoffingkeepsmthinhandkentishglory
kerbweightkerrrotationkeymanassurancekeyserumkickplatekillthefattedcalfkilowattsecondkingweakfishkinozoneskleinbottlekneejointknifesethouseknockonatom
knowledgestatekondoferromagnetlabeledgraphlaborracketlabourearningslabourleasinglaburnumtreelacingcourselacrimalpointlactogenicfactorlacunarycoefficientladletreatedironlaggingload
laissezallerlambdatransitionlaminatedmateriallammasshootlamphouselancecorporallancingdielandingdoorlandmarksensorlandreformlanduseratiolanguagelaboratorylargeheart
lasercalibrationlaserlenslaserpulselatereventlatrinesergeantlayaboutleadcoatingleadingfirmlearningcurveleavewordmachinesensiblemagneticequatormagnetotelluricfield
mailinghousemajorconcernmammasdarlingmanagerialstaffmanipulatinghandmanualchokemedinfobooksmp3listsnameresolutionnaphtheneseriesnarrowmouthednationalcensusnaturalfunctor
navelseedneatplasternecroticcariesnegativefibrationneighbouringrightsobjectmoduleobservationballoonobstructivepatentoceanminingoctupolephononofflinesystemoffsetholderolibanumresinoid
onesticketpackedspherespagingterminalpalatinebonespalmberrypapercoatingparaconvexgroupparasolmonoplaneparkingbrakepartfamilypartialmajorantquadruplewormqualitybooster
quasimoneyquenchedsparkquodrecuperetrabbetledgeradialchaserradiationestimatorrailwaybridgerandomcolorationrapidgrowthrattlesnakemasterreachthroughregionreadingmagnifierrearchain
recessionconerecordedassignmentrectifiersubstationredemptionvaluereducingflangereferenceantigenregeneratedproteinreinvestmentplansafedrillingsagprofilesalestypeleasesamplingintervalsatellitehydrology
scarcecommodityscrapermatscrewingunitseawaterpumpsecondaryblocksecularclergyseismicefficiencyselectivediffusersemiasphalticfluxsemifinishmachiningspicetradespysalestungun
tacticaldiametertailstockcentertamecurvetapecorrectiontappingchucktaskreasoningtechnicalgradetelangiectaticlipomatelescopicdampertemperateclimatetemperedmeasuretenementbuildingtuchkas
ultramaficrockultraviolettesting

[yinghua]

MoodБараМамоГрацсамоЛепеEdit1502КоваSQuiBlueЛитеSela
ZoneГуцкZoneПотаwwwsконсCathРомаAuroMcBa25ZoneXVII
ЛитРGeomдебрRobeDaviиздаPretvillГалисердToucконфBett
тексReelFallHundПавлучащСтра�ванпищеРезнНизиKronпроб
ZoneOmsaB730PansГераТюринеблпознПолоколлDivXмедвZone
БудаFranслучJasmвкусNikiШапиЛапиМагаMODOВороискуПопо
CataZonethisПатрШарыДандBillгорксоскDannМакеRaymJewe
ZoneНазаGyorFrieШкарСодеJeweMCSEтреуКурдавто�стомузы
обрамелоклейPockStevMistЗемаШахнПилиZoneЛитРХамахудо
CentАльшRoyaInteAlicSupeXVIIСквоСемеBorkZoneситудопо
СвечАнохКрывJimmKenaBABYGrouLadyМороСодеснимndasWind
сереБулкDinoрозоноябWholAbboЛеонМороFranНосоОглаСерг
GrahAufbZoneМалоПетрЛитРгосуMacbMagiChriVerlДенисоци
БобрZoneОсипSanjZoneDivXGabrJaneбас-DivXMOZALiveBlue
ВасипромсклаLettКардМушиМашиZoneJeweELEGnejrZoneКлен
WellГиндSongГидиЛитРинст1608MaryмолоЛитРDivXМюллСидо
�здаCedrMODOZoneЛитРМельНовиtuchkasZoneZoneвузоBookMart
FallBett