query.cpp 145 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930193119321933193419351936193719381939194019411942194319441945194619471948194919501951195219531954195519561957195819591960196119621963196419651966196719681969197019711972197319741975197619771978197919801981198219831984198519861987198819891990199119921993199419951996199719981999200020012002200320042005200620072008200920102011201220132014201520162017201820192020202120222023202420252026202720282029203020312032203320342035203620372038203920402041204220432044204520462047204820492050205120522053205420552056205720582059206020612062206320642065206620672068206920702071207220732074207520762077207820792080208120822083208420852086208720882089209020912092209320942095209620972098209921002101210221032104210521062107210821092110211121122113211421152116211721182119212021212122212321242125212621272128212921302131213221332134213521362137213821392140214121422143214421452146214721482149215021512152215321542155215621572158215921602161216221632164216521662167216821692170217121722173217421752176217721782179218021812182218321842185218621872188218921902191219221932194219521962197219821992200220122022203220422052206220722082209221022112212221322142215221622172218221922202221222222232224222522262227222822292230223122322233223422352236223722382239224022412242224322442245224622472248224922502251225222532254225522562257225822592260226122622263226422652266226722682269227022712272227322742275227622772278227922802281228222832284228522862287228822892290229122922293229422952296229722982299230023012302230323042305230623072308230923102311231223132314231523162317231823192320232123222323232423252326232723282329233023312332233323342335233623372338233923402341234223432344234523462347234823492350235123522353235423552356235723582359236023612362236323642365236623672368236923702371237223732374237523762377237823792380238123822383238423852386238723882389239023912392239323942395239623972398239924002401240224032404240524062407240824092410241124122413241424152416241724182419242024212422242324242425242624272428242924302431243224332434243524362437243824392440244124422443244424452446244724482449245024512452245324542455245624572458245924602461246224632464246524662467246824692470247124722473247424752476247724782479248024812482248324842485248624872488248924902491249224932494249524962497249824992500250125022503250425052506250725082509251025112512251325142515251625172518251925202521252225232524252525262527252825292530253125322533253425352536253725382539254025412542254325442545254625472548254925502551255225532554255525562557255825592560256125622563256425652566256725682569257025712572257325742575257625772578257925802581258225832584258525862587258825892590259125922593259425952596259725982599260026012602260326042605260626072608260926102611261226132614261526162617261826192620262126222623262426252626262726282629263026312632263326342635263626372638263926402641264226432644264526462647264826492650265126522653265426552656265726582659266026612662266326642665266626672668266926702671267226732674267526762677267826792680268126822683268426852686268726882689269026912692269326942695269626972698269927002701270227032704270527062707270827092710271127122713271427152716271727182719272027212722272327242725272627272728272927302731273227332734273527362737273827392740274127422743274427452746274727482749275027512752275327542755275627572758275927602761276227632764276527662767276827692770277127722773277427752776277727782779278027812782278327842785278627872788278927902791279227932794279527962797279827992800280128022803280428052806280728082809281028112812281328142815281628172818281928202821282228232824282528262827282828292830283128322833283428352836283728382839284028412842284328442845284628472848284928502851285228532854285528562857285828592860286128622863286428652866286728682869287028712872287328742875287628772878287928802881288228832884288528862887288828892890289128922893289428952896289728982899290029012902290329042905290629072908290929102911291229132914291529162917291829192920292129222923292429252926292729282929293029312932293329342935293629372938293929402941294229432944294529462947294829492950295129522953295429552956295729582959296029612962296329642965296629672968296929702971297229732974297529762977297829792980298129822983298429852986298729882989299029912992299329942995299629972998299930003001300230033004300530063007300830093010301130123013301430153016301730183019302030213022302330243025302630273028302930303031303230333034303530363037303830393040304130423043304430453046304730483049305030513052305330543055305630573058305930603061306230633064306530663067306830693070307130723073307430753076307730783079308030813082308330843085308630873088308930903091309230933094309530963097309830993100310131023103310431053106310731083109311031113112311331143115311631173118311931203121312231233124312531263127312831293130313131323133313431353136313731383139314031413142314331443145314631473148314931503151315231533154315531563157315831593160316131623163316431653166316731683169317031713172317331743175317631773178317931803181318231833184318531863187318831893190319131923193319431953196319731983199320032013202320332043205320632073208320932103211321232133214321532163217321832193220322132223223322432253226322732283229323032313232323332343235323632373238323932403241324232433244324532463247324832493250325132523253325432553256325732583259326032613262326332643265326632673268326932703271327232733274327532763277327832793280328132823283328432853286328732883289329032913292329332943295329632973298329933003301330233033304330533063307330833093310331133123313331433153316331733183319332033213322332333243325332633273328332933303331333233333334333533363337333833393340334133423343334433453346334733483349335033513352335333543355335633573358335933603361336233633364336533663367336833693370337133723373337433753376337733783379338033813382338333843385338633873388338933903391339233933394339533963397339833993400340134023403340434053406340734083409341034113412341334143415341634173418341934203421342234233424342534263427342834293430343134323433343434353436343734383439344034413442344334443445344634473448344934503451345234533454345534563457345834593460346134623463346434653466346734683469347034713472347334743475347634773478347934803481348234833484348534863487348834893490349134923493349434953496349734983499350035013502350335043505350635073508350935103511351235133514351535163517351835193520352135223523352435253526352735283529353035313532353335343535353635373538353935403541354235433544354535463547354835493550355135523553355435553556355735583559356035613562356335643565356635673568356935703571357235733574357535763577357835793580358135823583358435853586358735883589359035913592359335943595359635973598359936003601360236033604360536063607360836093610361136123613361436153616361736183619362036213622362336243625362636273628362936303631363236333634363536363637363836393640364136423643364436453646364736483649365036513652365336543655365636573658365936603661366236633664366536663667366836693670367136723673367436753676367736783679368036813682368336843685368636873688368936903691369236933694369536963697369836993700370137023703370437053706370737083709371037113712371337143715371637173718371937203721372237233724372537263727372837293730373137323733373437353736373737383739374037413742374337443745374637473748374937503751375237533754375537563757375837593760376137623763376437653766376737683769377037713772377337743775377637773778377937803781378237833784378537863787378837893790379137923793379437953796379737983799380038013802380338043805380638073808380938103811381238133814381538163817381838193820382138223823382438253826382738283829383038313832383338343835383638373838383938403841384238433844384538463847384838493850385138523853385438553856385738583859386038613862386338643865386638673868386938703871387238733874387538763877387838793880388138823883388438853886388738883889389038913892389338943895389638973898389939003901390239033904390539063907390839093910391139123913391439153916391739183919392039213922392339243925392639273928392939303931393239333934393539363937393839393940394139423943394439453946394739483949395039513952395339543955395639573958395939603961396239633964396539663967396839693970397139723973397439753976397739783979398039813982398339843985
  1. #include "node.h"
  2. #include "context.h"
  3. #include "object_processing.h"
  4. #include <yql/essentials/ast/yql_type_string.h>
  5. #include <yql/essentials/core/sql_types/yql_callable_names.h>
  6. #include <yql/essentials/providers/common/provider/yql_provider_names.h>
  7. #include <library/cpp/charset/ci_string.h>
  8. #include <util/digest/fnv.h>
  9. using namespace NYql;
  10. namespace NSQLTranslationV1 {
  11. bool ValidateView(TPosition pos, TContext& ctx, TStringBuf service, TViewDescription& view) {
  12. if (view.PrimaryFlag && !(service == KikimrProviderName || service == YdbProviderName)) {
  13. ctx.Error(pos) << "primary view is not supported for " << service << " tables";
  14. return false;
  15. }
  16. return true;
  17. }
  18. class TUniqueTableKey: public ITableKeys {
  19. public:
  20. TUniqueTableKey(TPosition pos, const TString& service, const TDeferredAtom& cluster,
  21. const TDeferredAtom& name, const TViewDescription& view)
  22. : ITableKeys(pos)
  23. , Service(service)
  24. , Cluster(cluster)
  25. , Name(name)
  26. , View(view)
  27. , Full(name.GetRepr())
  28. {
  29. if (!View.ViewName.empty()) {
  30. Full += ":" + View.ViewName;
  31. }
  32. }
  33. bool SetPrimaryView(TContext& ctx, TPosition pos) override {
  34. Y_UNUSED(ctx);
  35. Y_UNUSED(pos);
  36. View = {"", true};
  37. return true;
  38. }
  39. bool SetViewName(TContext& ctx, TPosition pos, const TString& view) override {
  40. Y_UNUSED(ctx);
  41. Y_UNUSED(pos);
  42. Full = Name.GetRepr();
  43. View = {view};
  44. if (!View.empty()) {
  45. Full = ":" + View.ViewName;
  46. }
  47. return true;
  48. }
  49. const TString* GetTableName() const override {
  50. return Name.GetLiteral() ? &Full : nullptr;
  51. }
  52. TNodePtr BuildKeys(TContext& ctx, ITableKeys::EBuildKeysMode mode) override {
  53. if (View == TViewDescription{"@"}) {
  54. auto key = Y("TempTable", Name.Build());
  55. return key;
  56. }
  57. bool tableScheme = mode == ITableKeys::EBuildKeysMode::CREATE;
  58. if (tableScheme && !View.empty()) {
  59. ctx.Error(Pos) << "Table view can not be created with CREATE TABLE clause";
  60. return nullptr;
  61. }
  62. auto path = ctx.GetPrefixedPath(Service, Cluster, Name);
  63. if (!path) {
  64. return nullptr;
  65. }
  66. auto key = Y("Key", Q(Y(Q(tableScheme ? "tablescheme" : "table"), Y("String", path))));
  67. key = AddView(key, View);
  68. if (!ValidateView(GetPos(), ctx, Service, View)) {
  69. return nullptr;
  70. }
  71. if (mode == ITableKeys::EBuildKeysMode::INPUT &&
  72. IsQueryMode(ctx.Settings.Mode) &&
  73. Service != KikimrProviderName &&
  74. Service != RtmrProviderName &&
  75. Service != YdbProviderName) {
  76. key = Y("MrTableConcat", key);
  77. }
  78. return key;
  79. }
  80. private:
  81. TString Service;
  82. TDeferredAtom Cluster;
  83. TDeferredAtom Name;
  84. TViewDescription View;
  85. TString Full;
  86. };
  87. TNodePtr BuildTableKey(TPosition pos, const TString& service, const TDeferredAtom& cluster,
  88. const TDeferredAtom& name, const TViewDescription& view) {
  89. return new TUniqueTableKey(pos, service, cluster, name, view);
  90. }
  91. class TTopicKey: public ITableKeys {
  92. public:
  93. TTopicKey(TPosition pos, const TDeferredAtom& cluster, const TDeferredAtom& name)
  94. : ITableKeys(pos)
  95. , Cluster(cluster)
  96. , Name(name)
  97. , Full(name.GetRepr())
  98. {
  99. }
  100. const TString* GetTableName() const override {
  101. return Name.GetLiteral() ? &Full : nullptr;
  102. }
  103. TNodePtr BuildKeys(TContext& ctx, ITableKeys::EBuildKeysMode) override {
  104. const auto path = ctx.GetPrefixedPath(Service, Cluster, Name);
  105. if (!path) {
  106. return nullptr;
  107. }
  108. auto key = Y("Key", Q(Y(Q("topic"), Y("String", path))));
  109. return key;
  110. }
  111. private:
  112. TString Service;
  113. TDeferredAtom Cluster;
  114. TDeferredAtom Name;
  115. TString View;
  116. TString Full;
  117. };
  118. TNodePtr BuildTopicKey(TPosition pos, const TDeferredAtom& cluster, const TDeferredAtom& name) {
  119. return new TTopicKey(pos, cluster, name);
  120. }
  121. static INode::TPtr CreateIndexType(TIndexDescription::EType type, const INode& node) {
  122. switch (type) {
  123. case TIndexDescription::EType::GlobalSync:
  124. return node.Q("syncGlobal");
  125. case TIndexDescription::EType::GlobalAsync:
  126. return node.Q("asyncGlobal");
  127. case TIndexDescription::EType::GlobalSyncUnique:
  128. return node.Q("syncGlobalUnique");
  129. case TIndexDescription::EType::GlobalVectorKmeansTree:
  130. return node.Q("globalVectorKmeansTree");
  131. }
  132. }
  133. enum class ETableSettingsParsingMode {
  134. Create,
  135. Alter
  136. };
  137. static INode::TPtr CreateTableSettings(const TTableSettings& tableSettings, ETableSettingsParsingMode parsingMode, const INode& node) {
  138. // short aliases for member function calls
  139. auto Y = [&node](auto&&... args) { return node.Y(std::forward<decltype(args)>(args)...); };
  140. auto Q = [&node](auto&&... args) { return node.Q(std::forward<decltype(args)>(args)...); };
  141. auto L = [&node](auto&&... args) { return node.L(std::forward<decltype(args)>(args)...); };
  142. auto settings = Y();
  143. if (tableSettings.DataSourcePath) {
  144. settings = L(settings, Q(Y(Q("data_source_path"), tableSettings.DataSourcePath)));
  145. }
  146. if (tableSettings.Location) {
  147. if (tableSettings.Location.IsSet()) {
  148. settings = L(settings, Q(Y(Q("location"), tableSettings.Location.GetValueSet())));
  149. } else {
  150. Y_ENSURE(parsingMode != ETableSettingsParsingMode::Create, "Can't reset LOCATION in create mode");
  151. settings = L(settings, Q(Y(Q("location"))));
  152. }
  153. }
  154. for (const auto& resetableParam : tableSettings.ExternalSourceParameters) {
  155. Y_ENSURE(resetableParam, "Empty parameter");
  156. if (resetableParam.IsSet()) {
  157. const auto& [id, value] = resetableParam.GetValueSet();
  158. settings = L(settings, Q(Y(Q(id.Name), value)));
  159. } else {
  160. Y_ENSURE(parsingMode != ETableSettingsParsingMode::Create,
  161. "Can't reset " << resetableParam.GetValueReset().Name << " in create mode"
  162. );
  163. settings = L(settings, Q(Y(Q(resetableParam.GetValueReset().Name))));
  164. }
  165. }
  166. if (tableSettings.CompactionPolicy) {
  167. settings = L(settings, Q(Y(Q("compactionPolicy"), tableSettings.CompactionPolicy)));
  168. }
  169. if (tableSettings.AutoPartitioningBySize) {
  170. const auto& ref = tableSettings.AutoPartitioningBySize.GetRef();
  171. settings = L(settings, Q(Y(Q("autoPartitioningBySize"), BuildQuotedAtom(ref.Pos, ref.Name))));
  172. }
  173. if (tableSettings.UniformPartitions && parsingMode == ETableSettingsParsingMode::Create) {
  174. settings = L(settings, Q(Y(Q("uniformPartitions"), tableSettings.UniformPartitions)));
  175. }
  176. if (tableSettings.PartitionAtKeys && parsingMode == ETableSettingsParsingMode::Create) {
  177. auto keysDesc = Y();
  178. for (const auto& key : tableSettings.PartitionAtKeys) {
  179. auto columnsDesc = Y();
  180. for (auto column : key) {
  181. columnsDesc = L(columnsDesc, column);
  182. }
  183. keysDesc = L(keysDesc, Q(columnsDesc));
  184. }
  185. settings = L(settings, Q(Y(Q("partitionAtKeys"), Q(keysDesc))));
  186. }
  187. if (tableSettings.PartitionSizeMb) {
  188. settings = L(settings, Q(Y(Q("partitionSizeMb"), tableSettings.PartitionSizeMb)));
  189. }
  190. if (tableSettings.AutoPartitioningByLoad) {
  191. const auto& ref = tableSettings.AutoPartitioningByLoad.GetRef();
  192. settings = L(settings, Q(Y(Q("autoPartitioningByLoad"), BuildQuotedAtom(ref.Pos, ref.Name))));
  193. }
  194. if (tableSettings.MinPartitions) {
  195. settings = L(settings, Q(Y(Q("minPartitions"), tableSettings.MinPartitions)));
  196. }
  197. if (tableSettings.MaxPartitions) {
  198. settings = L(settings, Q(Y(Q("maxPartitions"), tableSettings.MaxPartitions)));
  199. }
  200. if (tableSettings.PartitionCount) {
  201. settings = L(settings, Q(Y(Q("maxPartitions"), tableSettings.PartitionCount)));
  202. settings = L(settings, Q(Y(Q("minPartitions"), tableSettings.PartitionCount)));
  203. }
  204. if (tableSettings.KeyBloomFilter) {
  205. const auto& ref = tableSettings.KeyBloomFilter.GetRef();
  206. settings = L(settings, Q(Y(Q("keyBloomFilter"), BuildQuotedAtom(ref.Pos, ref.Name))));
  207. }
  208. if (tableSettings.ReadReplicasSettings) {
  209. settings = L(settings, Q(Y(Q("readReplicasSettings"), tableSettings.ReadReplicasSettings)));
  210. }
  211. if (const auto& ttl = tableSettings.TtlSettings) {
  212. if (ttl.IsSet()) {
  213. const auto& ttlSettings = ttl.GetValueSet();
  214. auto opts = Y();
  215. opts = L(opts, Q(Y(Q("columnName"), BuildQuotedAtom(ttlSettings.ColumnName.Pos, ttlSettings.ColumnName.Name))));
  216. auto tiersDesc = Y();
  217. for (const auto& tier : ttlSettings.Tiers) {
  218. auto tierDesc = Y();
  219. tierDesc = L(tierDesc, Q(Y(Q("evictionDelay"), tier.EvictionDelay)));
  220. if (tier.StorageName) {
  221. tierDesc = L(tierDesc, Q(Y(Q("storageName"), BuildQuotedAtom(tier.StorageName->Pos, tier.StorageName->Name))));
  222. }
  223. tiersDesc = L(tiersDesc, Q(tierDesc));
  224. }
  225. opts = L(opts, Q(Y(Q("tiers"), Q(tiersDesc))));
  226. if (ttlSettings.ColumnUnit) {
  227. opts = L(opts, Q(Y(Q("columnUnit"), Q(ToString(*ttlSettings.ColumnUnit)))));
  228. }
  229. settings = L(settings, Q(Y(Q("setTtlSettings"), Q(opts))));
  230. } else {
  231. YQL_ENSURE(parsingMode != ETableSettingsParsingMode::Create, "Can't reset TTL settings in create mode");
  232. settings = L(settings, Q(Y(Q("resetTtlSettings"), Q(Y()))));
  233. }
  234. }
  235. if (const auto& tiering = tableSettings.Tiering) {
  236. if (tiering.IsSet()) {
  237. settings = L(settings, Q(Y(Q("setTiering"), tiering.GetValueSet())));
  238. } else {
  239. YQL_ENSURE(parsingMode != ETableSettingsParsingMode::Create, "Can't reset TIERING in create mode");
  240. settings = L(settings, Q(Y(Q("resetTiering"), Q(Y()))));
  241. }
  242. }
  243. if (tableSettings.StoreExternalBlobs) {
  244. const auto& ref = tableSettings.StoreExternalBlobs.GetRef();
  245. settings = L(settings, Q(Y(Q("storeExternalBlobs"), BuildQuotedAtom(ref.Pos, ref.Name))));
  246. }
  247. if (tableSettings.StoreType && parsingMode == ETableSettingsParsingMode::Create) {
  248. const auto& ref = tableSettings.StoreType.GetRef();
  249. settings = L(settings, Q(Y(Q("storeType"), BuildQuotedAtom(ref.Pos, ref.Name))));
  250. }
  251. if (tableSettings.PartitionByHashFunction && parsingMode == ETableSettingsParsingMode::Create) {
  252. settings = L(settings, Q(Y(Q("partitionByHashFunction"), tableSettings.PartitionByHashFunction)));
  253. }
  254. return settings;
  255. }
  256. static INode::TPtr CreateVectorIndexSettings(const TVectorIndexSettings& vectorIndexSettings, const INode& node) {
  257. // short aliases for member function calls
  258. auto Y = [&node](auto&&... args) { return node.Y(std::forward<decltype(args)>(args)...); };
  259. auto Q = [&node](auto&&... args) { return node.Q(std::forward<decltype(args)>(args)...); };
  260. auto L = [&node](auto&&... args) { return node.L(std::forward<decltype(args)>(args)...); };
  261. auto settings = Y();
  262. if (vectorIndexSettings.Distance && vectorIndexSettings.Similarity) {
  263. Y_ENSURE(false, "distance and similarity shouldn't be set at the same time");
  264. } else if (vectorIndexSettings.Distance) {
  265. settings = L(settings, Q(Y(Q("distance"), Q(ToString(*vectorIndexSettings.Distance)))));
  266. } else if (vectorIndexSettings.Similarity) {
  267. settings = L(settings, Q(Y(Q("similarity"), Q(ToString(*vectorIndexSettings.Similarity)))));
  268. } else {
  269. Y_ENSURE(false, "distance or similarity should be set");
  270. }
  271. settings = L(settings, Q(Y(Q("vector_type"), Q(ToString(*vectorIndexSettings.VectorType)))));
  272. settings = L(settings, Q(Y(Q("vector_dimension"), Q(ToString(vectorIndexSettings.VectorDimension)))));
  273. settings = L(settings, Q(Y(Q("clusters"), Q(ToString(vectorIndexSettings.Clusters)))));
  274. settings = L(settings, Q(Y(Q("levels"), Q(ToString(vectorIndexSettings.Levels)))));
  275. return settings;
  276. }
  277. static INode::TPtr CreateIndexDesc(const TIndexDescription& index, ETableSettingsParsingMode parsingMode, const INode& node) {
  278. auto indexColumns = node.Y();
  279. for (const auto& col : index.IndexColumns) {
  280. indexColumns = node.L(indexColumns, BuildQuotedAtom(col.Pos, col.Name));
  281. }
  282. auto dataColumns = node.Y();
  283. for (const auto& col : index.DataColumns) {
  284. dataColumns = node.L(dataColumns, BuildQuotedAtom(col.Pos, col.Name));
  285. }
  286. const auto& indexType = node.Y(node.Q("indexType"), CreateIndexType(index.Type, node));
  287. const auto& indexName = node.Y(node.Q("indexName"), BuildQuotedAtom(index.Name.Pos, index.Name.Name));
  288. auto indexNode = node.Y(
  289. node.Q(indexName),
  290. node.Q(indexType),
  291. node.Q(node.Y(node.Q("indexColumns"), node.Q(indexColumns))),
  292. node.Q(node.Y(node.Q("dataColumns"), node.Q(dataColumns)))
  293. );
  294. if (index.TableSettings.IsSet()) {
  295. const auto& tableSettings = node.Q(node.Y(
  296. node.Q("tableSettings"),
  297. node.Q(CreateTableSettings(index.TableSettings, parsingMode, node))
  298. ));
  299. indexNode = node.L(indexNode, tableSettings);
  300. }
  301. if (const auto* indexSettingsPtr = std::get_if<TVectorIndexSettings>(&index.IndexSettings)) {
  302. const auto& indexSettings = node.Q(node.Y(
  303. node.Q("indexSettings"),
  304. node.Q(CreateVectorIndexSettings(*indexSettingsPtr, node))));
  305. indexNode = node.L(indexNode, indexSettings);
  306. }
  307. return indexNode;
  308. }
  309. static INode::TPtr CreateAlterIndex(const TIndexDescription& index, const INode& node) {
  310. const auto& indexName = node.Y(node.Q("indexName"), BuildQuotedAtom(index.Name.Pos, index.Name.Name));
  311. const auto& tableSettings = node.Y(
  312. node.Q("tableSettings"),
  313. node.Q(CreateTableSettings(index.TableSettings, ETableSettingsParsingMode::Alter, node))
  314. );
  315. return node.Y(
  316. node.Q(indexName),
  317. node.Q(tableSettings)
  318. );
  319. }
  320. static INode::TPtr CreateChangefeedDesc(const TChangefeedDescription& desc, const INode& node) {
  321. auto settings = node.Y();
  322. if (desc.Settings.Mode) {
  323. settings = node.L(settings, node.Q(node.Y(node.Q("mode"), desc.Settings.Mode)));
  324. }
  325. if (desc.Settings.Format) {
  326. settings = node.L(settings, node.Q(node.Y(node.Q("format"), desc.Settings.Format)));
  327. }
  328. if (desc.Settings.InitialScan) {
  329. settings = node.L(settings, node.Q(node.Y(node.Q("initial_scan"), desc.Settings.InitialScan)));
  330. }
  331. if (desc.Settings.VirtualTimestamps) {
  332. settings = node.L(settings, node.Q(node.Y(node.Q("virtual_timestamps"), desc.Settings.VirtualTimestamps)));
  333. }
  334. if (desc.Settings.BarriersInterval) {
  335. settings = node.L(settings, node.Q(node.Y(node.Q("barriers_interval"), desc.Settings.BarriersInterval)));
  336. }
  337. if (desc.Settings.RetentionPeriod) {
  338. settings = node.L(settings, node.Q(node.Y(node.Q("retention_period"), desc.Settings.RetentionPeriod)));
  339. }
  340. if (desc.Settings.TopicAutoPartitioning) {
  341. settings = node.L(settings, node.Q(node.Y(node.Q("topic_auto_partitioning"), desc.Settings.TopicAutoPartitioning)));
  342. }
  343. if (desc.Settings.TopicMaxActivePartitions) {
  344. settings = node.L(settings, node.Q(node.Y(node.Q("topic_max_active_partitions"), desc.Settings.TopicMaxActivePartitions)));
  345. }
  346. if (desc.Settings.TopicPartitions) {
  347. settings = node.L(settings, node.Q(node.Y(node.Q("topic_min_active_partitions"), desc.Settings.TopicPartitions)));
  348. }
  349. if (desc.Settings.AwsRegion) {
  350. settings = node.L(settings, node.Q(node.Y(node.Q("aws_region"), desc.Settings.AwsRegion)));
  351. }
  352. if (const auto& sink = desc.Settings.SinkSettings) {
  353. switch (sink->index()) {
  354. case 0: // local
  355. settings = node.L(settings, node.Q(node.Y(node.Q("local"), node.Q(node.Y()))));
  356. break;
  357. default:
  358. YQL_ENSURE(false, "Unexpected sink settings");
  359. }
  360. }
  361. auto state = node.Y();
  362. if (desc.Disable) {
  363. state = node.Q("disable");
  364. }
  365. return node.Y(
  366. node.Q(node.Y(node.Q("name"), BuildQuotedAtom(desc.Name.Pos, desc.Name.Name))),
  367. node.Q(node.Y(node.Q("settings"), node.Q(settings))),
  368. node.Q(node.Y(node.Q("state"), node.Q(state)))
  369. );
  370. }
  371. class TPrepTableKeys: public ITableKeys {
  372. public:
  373. TPrepTableKeys(TPosition pos, const TString& service, const TDeferredAtom& cluster,
  374. const TString& func, const TVector<TTableArg>& args)
  375. : ITableKeys(pos)
  376. , Service(service)
  377. , Cluster(cluster)
  378. , Func(func)
  379. , Args(args)
  380. {
  381. }
  382. void ExtractTableName(TContext&ctx, TTableArg& arg) {
  383. MakeTableFromExpression(Pos, ctx, arg.Expr, arg.Id);
  384. }
  385. TNodePtr BuildKeys(TContext& ctx, ITableKeys::EBuildKeysMode mode) override {
  386. if (mode == ITableKeys::EBuildKeysMode::CREATE) {
  387. // TODO: allow creation of multiple tables
  388. ctx.Error(Pos) << "Mutiple table creation is not implemented yet";
  389. return nullptr;
  390. }
  391. TCiString func(Func);
  392. if (func != "object" && func != "walkfolders") {
  393. for (auto& arg: Args) {
  394. if (arg.Expr->GetLabel()) {
  395. ctx.Error(Pos) << "Named arguments are not supported for table function " << to_upper(Func);
  396. return nullptr;
  397. }
  398. }
  399. }
  400. if (func == "concat_strict") {
  401. auto tuple = Y();
  402. for (auto& arg: Args) {
  403. ExtractTableName(ctx, arg);
  404. TNodePtr key;
  405. if (arg.HasAt) {
  406. key = Y("TempTable", arg.Id.Build());
  407. } else {
  408. auto path = ctx.GetPrefixedPath(Service, Cluster, arg.Id);
  409. if (!path) {
  410. return nullptr;
  411. }
  412. key = Y("Key", Q(Y(Q("table"), Y("String", path))));
  413. key = AddView(key, arg.View);
  414. if (!ValidateView(GetPos(), ctx, Service, arg.View)) {
  415. return nullptr;
  416. }
  417. }
  418. tuple = L(tuple, key);
  419. }
  420. return Q(tuple);
  421. }
  422. else if (func == "concat") {
  423. auto concat = Y("MrTableConcat");
  424. for (auto& arg : Args) {
  425. ExtractTableName(ctx, arg);
  426. TNodePtr key;
  427. if (arg.HasAt) {
  428. key = Y("TempTable", arg.Id.Build());
  429. } else {
  430. auto path = ctx.GetPrefixedPath(Service, Cluster, arg.Id);
  431. if (!path) {
  432. return nullptr;
  433. }
  434. key = Y("Key", Q(Y(Q("table"), Y("String", path))));
  435. key = AddView(key, arg.View);
  436. if (!ValidateView(GetPos(), ctx, Service, arg.View)) {
  437. return nullptr;
  438. }
  439. }
  440. concat = L(concat, key);
  441. }
  442. return concat;
  443. }
  444. else if (func == "range" || func == "range_strict" || func == "like" || func == "like_strict" ||
  445. func == "regexp" || func == "regexp_strict" || func == "filter" || func == "filter_strict") {
  446. bool isRange = func.StartsWith("range");
  447. bool isFilter = func.StartsWith("filter");
  448. size_t minArgs = isRange ? 1 : 2;
  449. size_t maxArgs = isRange ? 5 : 4;
  450. if (Args.size() < minArgs || Args.size() > maxArgs) {
  451. ctx.Error(Pos) << Func << " requires from " << minArgs << " to " << maxArgs << " arguments, but got: " << Args.size();
  452. return nullptr;
  453. }
  454. if (ctx.DiscoveryMode) {
  455. ctx.Error(Pos, TIssuesIds::YQL_NOT_ALLOWED_IN_DISCOVERY) << Func << " is not allowed in Discovery mode";
  456. return nullptr;
  457. }
  458. for (ui32 index=0; index < Args.size(); ++index) {
  459. auto& arg = Args[index];
  460. if (arg.HasAt) {
  461. ctx.Error(Pos) << "Temporary tables are not supported here";
  462. return nullptr;
  463. }
  464. if (!arg.View.empty()) {
  465. TStringBuilder sb;
  466. sb << "Use the last argument of " << Func << " to specify a VIEW." << Endl;
  467. if (isRange) {
  468. sb << "Possible arguments are: prefix, from, to, suffix, view." << Endl;
  469. } else if (isFilter) {
  470. sb << "Possible arguments are: prefix, filtering callable, suffix, view." << Endl;
  471. } else {
  472. sb << "Possible arguments are: prefix, pattern, suffix, view." << Endl;
  473. }
  474. sb << "Pass empty string in arguments if you want to skip.";
  475. ctx.Error(Pos) << sb;
  476. return nullptr;
  477. }
  478. if (!func.StartsWith("filter") || index != 1) {
  479. ExtractTableName(ctx, arg);
  480. }
  481. }
  482. auto path = ctx.GetPrefixedPath(Service, Cluster, Args[0].Id);
  483. if (!path) {
  484. return nullptr;
  485. }
  486. auto range = Y(func.EndsWith("_strict") ? "MrTableRangeStrict" : "MrTableRange", path);
  487. TNodePtr predicate;
  488. TDeferredAtom suffix;
  489. if (func.StartsWith("range")) {
  490. TDeferredAtom min;
  491. TDeferredAtom max;
  492. if (Args.size() > 1) {
  493. min = Args[1].Id;
  494. }
  495. if (Args.size() > 2) {
  496. max = Args[2].Id;
  497. }
  498. if (Args.size() > 3) {
  499. suffix = Args[3].Id;
  500. }
  501. if (min.Empty() && max.Empty()) {
  502. predicate = BuildLambda(Pos, Y("item"), Y("Bool", Q("true")));
  503. }
  504. else {
  505. auto minPred = !min.Empty() ? Y(">=", "item", Y("String", min.Build())) : nullptr;
  506. auto maxPred = !max.Empty() ? Y("<=", "item", Y("String", max.Build())) : nullptr;
  507. if (!minPred) {
  508. predicate = BuildLambda(Pos, Y("item"), maxPred);
  509. } else if (!maxPred) {
  510. predicate = BuildLambda(Pos, Y("item"), minPred);
  511. } else {
  512. predicate = BuildLambda(Pos, Y("item"), Y("And", minPred, maxPred));
  513. }
  514. }
  515. } else {
  516. if (Args.size() > 2) {
  517. suffix = Args[2].Id;
  518. }
  519. if (func.StartsWith("regexp")) {
  520. if (!ctx.PragmaRegexUseRe2) {
  521. ctx.Warning(Pos, TIssuesIds::CORE_LEGACY_REGEX_ENGINE) << "Legacy regex engine works incorrectly with unicode. Use PRAGMA RegexUseRe2='true';";
  522. }
  523. auto pattern = Args[1].Id;
  524. auto udf = ctx.PragmaRegexUseRe2 ?
  525. Y("Udf", Q("Re2.Grep"), Q(Y(Y("String", pattern.Build()), Y("Null")))):
  526. Y("Udf", Q("Pcre.BacktrackingGrep"), Y("String", pattern.Build()));
  527. predicate = BuildLambda(Pos, Y("item"), Y("Apply", udf, "item"));
  528. } else if (func.StartsWith("like")) {
  529. auto pattern = Args[1].Id;
  530. auto convertedPattern = Y("Apply", Y("Udf", Q("Re2.PatternFromLike")),
  531. Y("String", pattern.Build()));
  532. auto udf = Y("Udf", Q("Re2.Match"), Q(Y(convertedPattern, Y("Null"))));
  533. predicate = BuildLambda(Pos, Y("item"), Y("Apply", udf, "item"));
  534. } else {
  535. predicate = BuildLambda(Pos, Y("item"), Y("Apply", Args[1].Expr, "item"));
  536. }
  537. }
  538. range = L(range, predicate);
  539. range = L(range, suffix.Build() ? suffix.Build() : BuildQuotedAtom(Pos, ""));
  540. auto key = Y("Key", Q(Y(Q("table"), range)));
  541. if (Args.size() == maxArgs) {
  542. const auto& lastArg = Args.back();
  543. if (!lastArg.View.empty()) {
  544. ctx.Error(Pos) << Func << " requires that view should be set as last argument";
  545. return nullptr;
  546. }
  547. if (!lastArg.Id.Empty()) {
  548. key = L(key, Q(Y(Q("view"), Y("String", lastArg.Id.Build()))));
  549. }
  550. }
  551. return key;
  552. } else if (func == "each" || func == "each_strict") {
  553. auto each = Y(func == "each" ? "MrTableEach" : "MrTableEachStrict");
  554. for (auto& arg : Args) {
  555. if (arg.HasAt) {
  556. ctx.Error(Pos) << "Temporary tables are not supported here";
  557. return nullptr;
  558. }
  559. auto type = Y("ListType", Y("DataType", Q("String")));
  560. auto key = Y("Key", Q(Y(Q("table"), Y("EvaluateExpr",
  561. Y("EnsureType", Y("Coalesce", arg.Expr,
  562. Y("List", type)), type)))));
  563. key = AddView(key, arg.View);
  564. if (!ValidateView(GetPos(), ctx, Service, arg.View)) {
  565. return nullptr;
  566. }
  567. each = L(each, key);
  568. }
  569. if (ctx.PragmaUseTablePrefixForEach) {
  570. TStringBuf prefixPath = ctx.GetPrefixPath(Service, Cluster);
  571. if (prefixPath) {
  572. each = L(each, BuildQuotedAtom(Pos, TString(prefixPath)));
  573. }
  574. }
  575. return each;
  576. }
  577. else if (func == "folder") {
  578. size_t minArgs = 1;
  579. size_t maxArgs = 2;
  580. if (Args.size() < minArgs || Args.size() > maxArgs) {
  581. ctx.Error(Pos) << Func << " requires from " << minArgs << " to " << maxArgs << " arguments, but found: " << Args.size();
  582. return nullptr;
  583. }
  584. if (ctx.DiscoveryMode) {
  585. ctx.Error(Pos, TIssuesIds::YQL_NOT_ALLOWED_IN_DISCOVERY) << Func << " is not allowed in Discovery mode";
  586. return nullptr;
  587. }
  588. for (ui32 index = 0; index < Args.size(); ++index) {
  589. auto& arg = Args[index];
  590. if (arg.HasAt) {
  591. ctx.Error(Pos) << "Temporary tables are not supported here";
  592. return nullptr;
  593. }
  594. if (!arg.View.empty()) {
  595. ctx.Error(Pos) << Func << " doesn't supports views";
  596. return nullptr;
  597. }
  598. ExtractTableName(ctx, arg);
  599. }
  600. auto folder = Y("MrFolder");
  601. folder = L(folder, Args[0].Id.Build());
  602. folder = L(folder, Args.size() > 1 ? Args[1].Id.Build() : BuildQuotedAtom(Pos, ""));
  603. return folder;
  604. }
  605. else if (func == "walkfolders") {
  606. const size_t minPositionalArgs = 1;
  607. const size_t maxPositionalArgs = 2;
  608. size_t positionalArgsCnt = 0;
  609. for (const auto& arg : Args) {
  610. if (!arg.Expr->GetLabel()) {
  611. positionalArgsCnt++;
  612. } else {
  613. break;
  614. }
  615. }
  616. if (positionalArgsCnt < minPositionalArgs || positionalArgsCnt > maxPositionalArgs) {
  617. ctx.Error(Pos) << Func << " requires from " << minPositionalArgs
  618. << " to " << maxPositionalArgs
  619. << " positional arguments, but got: " << positionalArgsCnt;
  620. return nullptr;
  621. }
  622. constexpr auto walkFoldersModuleName = "walk_folders_module";
  623. ctx.RequiredModules.emplace(walkFoldersModuleName, "/lib/yql/walk_folders.yql");
  624. auto& rootFolderArg = Args[0];
  625. if (rootFolderArg.HasAt) {
  626. ctx.Error(Pos) << "Temporary tables are not supported here";
  627. return nullptr;
  628. }
  629. if (!rootFolderArg.View.empty()) {
  630. ctx.Error(Pos) << Func << " doesn't supports views";
  631. return nullptr;
  632. }
  633. ExtractTableName(ctx, rootFolderArg);
  634. const auto initState =
  635. positionalArgsCnt > 1
  636. ? Args[1].Expr
  637. : Y("List", Y("ListType", Y("DataType", Q("String"))));
  638. TNodePtr rootAttributes;
  639. TNodePtr preHandler;
  640. TNodePtr resolveHandler;
  641. TNodePtr diveHandler;
  642. TNodePtr postHandler;
  643. for (auto it = Args.begin() + positionalArgsCnt; it != Args.end(); ++it) {
  644. auto& arg = *it;
  645. const auto label = arg.Expr->GetLabel();
  646. if (label == "RootAttributes") {
  647. ExtractTableName(ctx, arg);
  648. rootAttributes = arg.Id.Build();
  649. }
  650. else if (label == "PreHandler") {
  651. preHandler = arg.Expr;
  652. }
  653. else if (label == "ResolveHandler") {
  654. resolveHandler = arg.Expr;
  655. }
  656. else if (label == "DiveHandler") {
  657. diveHandler = arg.Expr;
  658. }
  659. else if (label == "PostHandler") {
  660. postHandler = arg.Expr;
  661. }
  662. else {
  663. ctx.Warning(Pos, DEFAULT_ERROR) << "Unsupported named argument: "
  664. << label << " in " << Func;
  665. }
  666. }
  667. if (rootAttributes == nullptr) {
  668. rootAttributes = BuildQuotedAtom(Pos, "");
  669. }
  670. if (preHandler != nullptr || postHandler != nullptr) {
  671. const auto makePrePostHandlerType = BuildBind(Pos, walkFoldersModuleName, "MakePrePostHandlersType");
  672. const auto prePostHandlerType = Y("EvaluateType", Y("TypeHandle", Y("Apply", makePrePostHandlerType, Y("TypeOf", initState))));
  673. if (preHandler != nullptr) {
  674. preHandler = Y("Callable", prePostHandlerType, preHandler);
  675. }
  676. if (postHandler != nullptr) {
  677. postHandler = Y("Callable", prePostHandlerType, postHandler);
  678. }
  679. }
  680. if (preHandler == nullptr) {
  681. preHandler = Y("Void");
  682. }
  683. if (postHandler == nullptr) {
  684. postHandler = Y("Void");
  685. }
  686. const auto makeResolveDiveHandlerType = BuildBind(Pos, walkFoldersModuleName, "MakeResolveDiveHandlersType");
  687. const auto resolveDiveHandlerType = Y("EvaluateType", Y("TypeHandle", Y("Apply", makeResolveDiveHandlerType, Y("TypeOf", initState))));
  688. if (resolveHandler == nullptr) {
  689. resolveHandler = BuildBind(Pos, walkFoldersModuleName, "AnyNodeDiveHandler");
  690. }
  691. if (diveHandler == nullptr) {
  692. diveHandler = BuildBind(Pos, walkFoldersModuleName, "AnyNodeDiveHandler");
  693. }
  694. resolveHandler = Y("Callable", resolveDiveHandlerType, resolveHandler);
  695. diveHandler = Y("Callable", resolveDiveHandlerType, diveHandler);
  696. const auto initStateType = Y("EvaluateType", Y("TypeHandle", Y("TypeOf", initState)));
  697. const auto pickledInitState = Y("Pickle", initState);
  698. const auto initPath = rootFolderArg.Id.Build();
  699. return Y("MrWalkFolders", initPath, rootAttributes, pickledInitState, initStateType,
  700. preHandler, resolveHandler, diveHandler, postHandler);
  701. }
  702. else if (func == "tables") {
  703. if (!Args.empty()) {
  704. ctx.Error(Pos) << Func << " doesn't accept arguments";
  705. return nullptr;
  706. }
  707. return L(Y("DataTables"));
  708. }
  709. else if (func == "object") {
  710. const size_t positionalArgs = 2;
  711. auto result = Y("MrObject");
  712. auto settings = Y();
  713. //TVector<TNodePtr> settings;
  714. size_t argc = 0;
  715. for (ui32 index = 0; index < Args.size(); ++index) {
  716. auto& arg = Args[index];
  717. if (arg.HasAt) {
  718. ctx.Error(arg.Expr->GetPos()) << "Temporary tables are not supported here";
  719. return nullptr;
  720. }
  721. if (!arg.View.empty()) {
  722. ctx.Error(Pos) << to_upper(Func) << " doesn't supports views";
  723. return nullptr;
  724. }
  725. if (!arg.Expr->GetLabel()) {
  726. ExtractTableName(ctx, arg);
  727. result = L(result, arg.Id.Build());
  728. ++argc;
  729. } else {
  730. settings = L(settings, Q(Y(BuildQuotedAtom(arg.Expr->GetPos(), arg.Expr->GetLabel()), arg.Expr)));
  731. }
  732. }
  733. if (argc != positionalArgs) {
  734. ctx.Error(Pos) << to_upper(Func) << " requires exacty " << positionalArgs << " positional args, but got " << argc;
  735. return nullptr;
  736. }
  737. result = L(result, Q(settings));
  738. return result;
  739. }
  740. ctx.Error(Pos) << "Unknown table name preprocessor: " << Func;
  741. return nullptr;
  742. }
  743. private:
  744. TString Service;
  745. TDeferredAtom Cluster;
  746. TString Func;
  747. TVector<TTableArg> Args;
  748. };
  749. TNodePtr BuildTableKeys(TPosition pos, const TString& service, const TDeferredAtom& cluster,
  750. const TString& func, const TVector<TTableArg>& args) {
  751. return new TPrepTableKeys(pos, service, cluster, func, args);
  752. }
  753. class TInputOptions final : public TAstListNode {
  754. public:
  755. TInputOptions(TPosition pos, const TTableHints& hints)
  756. : TAstListNode(pos)
  757. , Hints(hints)
  758. {
  759. }
  760. bool DoInit(TContext& ctx, ISource* src) override {
  761. for (auto& hint: Hints) {
  762. TString hintName = hint.first;
  763. TMaybe<TIssue> normalizeError = NormalizeName(Pos, hintName);
  764. if (!normalizeError.Empty()) {
  765. ctx.Error() << normalizeError->GetMessage();
  766. ctx.IncrementMonCounter("sql_errors", "NormalizeHintError");
  767. return false;
  768. }
  769. TNodePtr option = Y(BuildQuotedAtom(Pos, hintName));
  770. for (auto& x : hint.second) {
  771. if (!x->Init(ctx, src)) {
  772. return false;
  773. }
  774. option = L(option, x);
  775. }
  776. Nodes.push_back(Q(option));
  777. }
  778. return true;
  779. }
  780. TPtr DoClone() const final {
  781. return {};
  782. }
  783. private:
  784. TTableHints Hints;
  785. };
  786. TNodePtr BuildInputOptions(TPosition pos, const TTableHints& hints) {
  787. if (hints.empty()) {
  788. return nullptr;
  789. }
  790. return new TInputOptions(pos, hints);
  791. }
  792. class TIntoTableOptions : public TAstListNode {
  793. public:
  794. TIntoTableOptions(TPosition pos, const TVector<TString>& columns, const TTableHints& hints)
  795. : TAstListNode(pos)
  796. , Columns(columns)
  797. , Hints(hints)
  798. {
  799. }
  800. bool DoInit(TContext& ctx, ISource* src) override {
  801. Y_UNUSED(ctx);
  802. Y_UNUSED(src);
  803. TNodePtr options = Y();
  804. for (const auto& column: Columns) {
  805. options->Add(Q(column));
  806. }
  807. if (Columns) {
  808. Add(Q(Y(Q("erase_columns"), Q(options))));
  809. }
  810. for (const auto& hint : Hints) {
  811. TString hintName = hint.first;
  812. TMaybe<TIssue> normalizeError = NormalizeName(Pos, hintName);
  813. if (!normalizeError.Empty()) {
  814. ctx.Error() << normalizeError->GetMessage();
  815. ctx.IncrementMonCounter("sql_errors", "NormalizeHintError");
  816. return false;
  817. }
  818. TNodePtr option = Y(BuildQuotedAtom(Pos, hintName));
  819. for (auto& x : hint.second) {
  820. if (!x->Init(ctx, src)) {
  821. return false;
  822. }
  823. option = L(option, x);
  824. }
  825. Add(Q(option));
  826. }
  827. return true;
  828. }
  829. TNodePtr DoClone() const final {
  830. return new TIntoTableOptions(GetPos(), Columns, CloneContainer(Hints));
  831. }
  832. private:
  833. TVector<TString> Columns;
  834. TTableHints Hints;
  835. };
  836. TNodePtr BuildIntoTableOptions(TPosition pos, const TVector<TString>& eraseColumns, const TTableHints& hints) {
  837. return new TIntoTableOptions(pos, eraseColumns, hints);
  838. }
  839. class TInputTablesNode final : public TAstListNode {
  840. public:
  841. TInputTablesNode(TPosition pos, const TTableList& tables, bool inSubquery, TScopedStatePtr scoped)
  842. : TAstListNode(pos)
  843. , Tables(tables)
  844. , InSubquery(inSubquery)
  845. , Scoped(scoped)
  846. {
  847. }
  848. bool DoInit(TContext& ctx, ISource* src) override {
  849. THashSet<TString> processedTables;
  850. for (auto& tr: Tables) {
  851. if (!processedTables.insert(tr.RefName).second) {
  852. continue;
  853. }
  854. Scoped->UseCluster(tr.Service, tr.Cluster);
  855. auto tableKeys = tr.Keys->GetTableKeys();
  856. auto keys = tableKeys->BuildKeys(ctx, ITableKeys::EBuildKeysMode::INPUT);
  857. if (!keys || !keys->Init(ctx, src)) {
  858. return false;
  859. }
  860. auto fields = Y("Void");
  861. auto source = Y("DataSource", BuildQuotedAtom(Pos, tr.Service), Scoped->WrapCluster(tr.Cluster, ctx));
  862. auto options = tr.Options ? Q(tr.Options) : Q(Y());
  863. Add(Y("let", "x", keys->Y(TString(ReadName), "world", source, keys, fields, options)));
  864. if (IsIn({KikimrProviderName, YdbProviderName}, tr.Service) && InSubquery) {
  865. ctx.Error() << "Using of system '" << tr.Service << "' is not allowed in SUBQUERY";
  866. return false;
  867. }
  868. if (tr.Service != YtProviderName || ctx.Settings.SaveWorldDependencies) {
  869. Add(Y("let", "world", Y(TString(LeftName), "x")));
  870. }
  871. Add(Y("let", tr.RefName, Y(TString(RightName), "x")));
  872. }
  873. return TAstListNode::DoInit(ctx, src);
  874. }
  875. TPtr DoClone() const final {
  876. return {};
  877. }
  878. private:
  879. TTableList Tables;
  880. const bool InSubquery;
  881. TScopedStatePtr Scoped;
  882. };
  883. TNodePtr BuildInputTables(TPosition pos, const TTableList& tables, bool inSubquery, TScopedStatePtr scoped) {
  884. return new TInputTablesNode(pos, tables, inSubquery, scoped);
  885. }
  886. class TCreateTableNode final : public TAstListNode {
  887. public:
  888. TCreateTableNode(TPosition pos, const TTableRef& tr, bool existingOk, bool replaceIfExists, const TCreateTableParameters& params, TSourcePtr values, TScopedStatePtr scoped)
  889. : TAstListNode(pos)
  890. , Table(tr)
  891. , Params(params)
  892. , ExistingOk(existingOk)
  893. , ReplaceIfExists(replaceIfExists)
  894. , Values(std::move(values))
  895. , Scoped(scoped)
  896. {
  897. scoped->UseCluster(Table.Service, Table.Cluster);
  898. }
  899. bool DoInit(TContext& ctx, ISource* src) override {
  900. auto keys = Table.Keys->GetTableKeys()->BuildKeys(ctx, ITableKeys::EBuildKeysMode::CREATE);
  901. if (!keys || !keys->Init(ctx, src)) {
  902. return false;
  903. }
  904. if (!Params.PkColumns.empty()
  905. || !Params.PartitionByColumns.empty()
  906. || !Params.OrderByColumns.empty()
  907. || !Params.Indexes.empty()
  908. || !Params.Changefeeds.empty())
  909. {
  910. THashSet<TString> columnsSet;
  911. for (auto& col : Params.Columns) {
  912. columnsSet.insert(col.Name);
  913. }
  914. const bool allowUndefinedColumns = (Values != nullptr) && columnsSet.empty();
  915. THashSet<TString> pkColumns;
  916. for (auto& keyColumn : Params.PkColumns) {
  917. if (!allowUndefinedColumns && !columnsSet.contains(keyColumn.Name)) {
  918. ctx.Error(keyColumn.Pos) << "Undefined column: " << keyColumn.Name;
  919. return false;
  920. }
  921. if (!pkColumns.insert(keyColumn.Name).second) {
  922. ctx.Error(keyColumn.Pos) << "Duplicated column in PK: " << keyColumn.Name;
  923. return false;
  924. }
  925. }
  926. for (auto& keyColumn : Params.PartitionByColumns) {
  927. if (!allowUndefinedColumns && !columnsSet.contains(keyColumn.Name)) {
  928. ctx.Error(keyColumn.Pos) << "Undefined column: " << keyColumn.Name;
  929. return false;
  930. }
  931. }
  932. for (auto& keyColumn : Params.OrderByColumns) {
  933. if (!allowUndefinedColumns && !columnsSet.contains(keyColumn.first.Name)) {
  934. ctx.Error(keyColumn.first.Pos) << "Undefined column: " << keyColumn.first.Name;
  935. return false;
  936. }
  937. }
  938. THashSet<TString> indexNames;
  939. for (const auto& index : Params.Indexes) {
  940. if (!indexNames.insert(index.Name.Name).second) {
  941. ctx.Error(index.Name.Pos) << "Index " << index.Name.Name << " must be defined once";
  942. return false;
  943. }
  944. for (const auto& indexColumn : index.IndexColumns) {
  945. if (!allowUndefinedColumns && !columnsSet.contains(indexColumn.Name)) {
  946. ctx.Error(indexColumn.Pos) << "Undefined column: " << indexColumn.Name;
  947. return false;
  948. }
  949. }
  950. for (const auto& dataColumn : index.DataColumns) {
  951. if (!allowUndefinedColumns && !columnsSet.contains(dataColumn.Name)) {
  952. ctx.Error(dataColumn.Pos) << "Undefined column: " << dataColumn.Name;
  953. return false;
  954. }
  955. }
  956. }
  957. THashSet<TString> cfNames;
  958. for (const auto& cf : Params.Changefeeds) {
  959. if (!cfNames.insert(cf.Name.Name).second) {
  960. ctx.Error(cf.Name.Pos) << "Changefeed " << cf.Name.Name << " must be defined once";
  961. return false;
  962. }
  963. }
  964. }
  965. auto opts = Y();
  966. if (Table.Options) {
  967. if (!Table.Options->Init(ctx, src)) {
  968. return false;
  969. }
  970. opts = Table.Options;
  971. }
  972. if (ExistingOk) {
  973. opts = L(opts, Q(Y(Q("mode"), Q("create_if_not_exists"))));
  974. } else if (ReplaceIfExists) {
  975. opts = L(opts, Q(Y(Q("mode"), Q("create_or_replace"))));
  976. } else {
  977. opts = L(opts, Q(Y(Q("mode"), Q("create"))));
  978. }
  979. THashSet<TString> columnFamilyNames;
  980. if (Params.ColumnFamilies) {
  981. auto columnFamilies = Y();
  982. for (const auto& family : Params.ColumnFamilies) {
  983. if (!columnFamilyNames.insert(family.Name.Name).second) {
  984. ctx.Error(family.Name.Pos) << "Family " << family.Name.Name << " specified more than once";
  985. return false;
  986. }
  987. auto familyDesc = Y();
  988. familyDesc = L(familyDesc, Q(Y(Q("name"), BuildQuotedAtom(family.Name.Pos, family.Name.Name))));
  989. if (family.Data) {
  990. familyDesc = L(familyDesc, Q(Y(Q("data"), family.Data)));
  991. }
  992. if (family.Compression) {
  993. familyDesc = L(familyDesc, Q(Y(Q("compression"), family.Compression)));
  994. }
  995. if (family.CompressionLevel) {
  996. familyDesc = L(familyDesc, Q(Y(Q("compression_level"), family.CompressionLevel)));
  997. }
  998. columnFamilies = L(columnFamilies, Q(familyDesc));
  999. }
  1000. opts = L(opts, Q(Y(Q("columnFamilies"), Q(columnFamilies))));
  1001. }
  1002. auto columns = Y();
  1003. THashSet<TString> columnsWithDefaultValue;
  1004. auto columnsDefaultValueSettings = Y();
  1005. for (auto& col : Params.Columns) {
  1006. auto columnDesc = Y();
  1007. columnDesc = L(columnDesc, BuildQuotedAtom(Pos, col.Name));
  1008. auto type = col.Type;
  1009. if (type) {
  1010. if (col.Nullable) {
  1011. type = Y("AsOptionalType", type);
  1012. }
  1013. columnDesc = L(columnDesc, type);
  1014. auto columnConstraints = Y();
  1015. if (!col.Nullable) {
  1016. columnConstraints = L(columnConstraints, Q(Y(Q("not_null"))));
  1017. }
  1018. if (col.Serial) {
  1019. columnConstraints = L(columnConstraints, Q(Y(Q("serial"))));
  1020. }
  1021. if (col.DefaultExpr) {
  1022. if (!col.DefaultExpr->Init(ctx, src)) {
  1023. return false;
  1024. }
  1025. columnConstraints = L(columnConstraints, Q(Y(Q("default"), col.DefaultExpr)));
  1026. }
  1027. columnDesc = L(columnDesc, Q(Y(Q("columnConstrains"), Q(columnConstraints))));
  1028. auto familiesDesc = Y();
  1029. if (col.Families) {
  1030. for (const auto& family : col.Families) {
  1031. if (columnFamilyNames.find(family.Name) == columnFamilyNames.end()) {
  1032. ctx.Error(family.Pos) << "Unknown family " << family.Name;
  1033. return false;
  1034. }
  1035. familiesDesc = L(familiesDesc, BuildQuotedAtom(family.Pos, family.Name));
  1036. }
  1037. }
  1038. columnDesc = L(columnDesc, Q(familiesDesc));
  1039. }
  1040. columns = L(columns, Q(columnDesc));
  1041. }
  1042. opts = L(opts, Q(Y(Q("columns"), Q(columns))));
  1043. if (!columnsWithDefaultValue.empty()) {
  1044. opts = L(opts, Q(Y(Q("columnsDefaultValues"), Q(columnsDefaultValueSettings))));
  1045. }
  1046. if (Table.Service == RtmrProviderName) {
  1047. if (!Params.PkColumns.empty() && !Params.PartitionByColumns.empty()) {
  1048. ctx.Error() << "Only one of PRIMARY KEY or PARTITION BY constraints may be specified";
  1049. return false;
  1050. }
  1051. } else {
  1052. if (!Params.OrderByColumns.empty()) {
  1053. ctx.Error() << "ORDER BY is supported only for " << RtmrProviderName << " provider";
  1054. return false;
  1055. }
  1056. }
  1057. if (!Params.PkColumns.empty()) {
  1058. auto primaryKey = Y();
  1059. for (auto& col : Params.PkColumns) {
  1060. primaryKey = L(primaryKey, BuildQuotedAtom(col.Pos, col.Name));
  1061. }
  1062. opts = L(opts, Q(Y(Q("primarykey"), Q(primaryKey))));
  1063. if (!Params.OrderByColumns.empty()) {
  1064. ctx.Error() << "PRIMARY KEY cannot be used with ORDER BY, use PARTITION BY instead";
  1065. return false;
  1066. }
  1067. }
  1068. if (!Params.PartitionByColumns.empty()) {
  1069. auto partitionBy = Y();
  1070. for (auto& col : Params.PartitionByColumns) {
  1071. partitionBy = L(partitionBy, BuildQuotedAtom(col.Pos, col.Name));
  1072. }
  1073. opts = L(opts, Q(Y(Q("partitionby"), Q(partitionBy))));
  1074. }
  1075. if (!Params.OrderByColumns.empty()) {
  1076. auto orderBy = Y();
  1077. for (auto& col : Params.OrderByColumns) {
  1078. orderBy = L(orderBy, Q(Y(BuildQuotedAtom(col.first.Pos, col.first.Name), col.second ? Q("1") : Q("0"))));
  1079. }
  1080. opts = L(opts, Q(Y(Q("orderby"), Q(orderBy))));
  1081. }
  1082. for (const auto& index : Params.Indexes) {
  1083. const auto& desc = CreateIndexDesc(index, ETableSettingsParsingMode::Create, *this);
  1084. opts = L(opts, Q(Y(Q("index"), Q(desc))));
  1085. }
  1086. for (const auto& cf : Params.Changefeeds) {
  1087. const auto& desc = CreateChangefeedDesc(cf, *this);
  1088. opts = L(opts, Q(Y(Q("changefeed"), Q(desc))));
  1089. }
  1090. if (Params.TableSettings.IsSet()) {
  1091. opts = L(opts, Q(Y(Q("tableSettings"), Q(
  1092. CreateTableSettings(Params.TableSettings, ETableSettingsParsingMode::Create, *this)
  1093. ))));
  1094. }
  1095. switch (Params.TableType) {
  1096. case ETableType::TableStore:
  1097. opts = L(opts, Q(Y(Q("tableType"), Q("tableStore"))));
  1098. break;
  1099. case ETableType::ExternalTable:
  1100. opts = L(opts, Q(Y(Q("tableType"), Q("externalTable"))));
  1101. break;
  1102. case ETableType::Table:
  1103. break;
  1104. }
  1105. if (Params.Temporary) {
  1106. opts = L(opts, Q(Y(Q("temporary"))));
  1107. }
  1108. TNodePtr node = nullptr;
  1109. if (Values) {
  1110. if (!Values->Init(ctx, nullptr)) {
  1111. return false;
  1112. }
  1113. TTableList tableList;
  1114. Values->GetInputTables(tableList);
  1115. auto valuesSource = Values.Get();
  1116. auto values = Values->Build(ctx);
  1117. if (!Values) {
  1118. return false;
  1119. }
  1120. TNodePtr inputTables(BuildInputTables(Pos, tableList, false, Scoped));
  1121. if (!inputTables->Init(ctx, valuesSource)) {
  1122. return false;
  1123. }
  1124. node = inputTables;
  1125. node = L(node, Y("let", "values", values));
  1126. } else {
  1127. node = Y(Y("let", "values", Y("Void")));
  1128. }
  1129. auto write = Y(
  1130. Y("let", "sink", Y("DataSink", BuildQuotedAtom(Pos, Table.Service), Scoped->WrapCluster(Table.Cluster, ctx))),
  1131. Y("let", "world", Y(TString(WriteName), "world", "sink", keys, "values", Q(opts))),
  1132. Y("return", ctx.PragmaAutoCommit ? Y(TString(CommitName), "world", "sink") : AstNode("world"))
  1133. );
  1134. node = L(node, Y("let", "world", Y("block", Q(write))));
  1135. node = L(node, Y("return", "world"));
  1136. Add("block", Q(node));
  1137. return TAstListNode::DoInit(ctx, src);
  1138. }
  1139. TPtr DoClone() const final {
  1140. return {};
  1141. }
  1142. private:
  1143. const TTableRef Table;
  1144. const TCreateTableParameters Params;
  1145. const bool ExistingOk;
  1146. const bool ReplaceIfExists;
  1147. const TSourcePtr Values;
  1148. TScopedStatePtr Scoped;
  1149. };
  1150. TNodePtr BuildCreateTable(TPosition pos, const TTableRef& tr, bool existingOk, bool replaceIfExists, const TCreateTableParameters& params, TSourcePtr values, TScopedStatePtr scoped)
  1151. {
  1152. return new TCreateTableNode(pos, tr, existingOk, replaceIfExists, params, std::move(values), scoped);
  1153. }
  1154. class TAlterDatabaseNode final : public TAstListNode {
  1155. public:
  1156. TAlterDatabaseNode(
  1157. TPosition pos,
  1158. const TString& service,
  1159. const TDeferredAtom& cluster,
  1160. const TAlterDatabaseParameters& params,
  1161. TScopedStatePtr scoped
  1162. )
  1163. : TAstListNode(pos)
  1164. , Params(params)
  1165. , Scoped(scoped)
  1166. , Cluster(cluster)
  1167. , Service(service)
  1168. {
  1169. scoped->UseCluster(service, cluster);
  1170. }
  1171. bool DoInit(TContext& ctx, ISource* src) override {
  1172. TNodePtr cluster = Scoped->WrapCluster(Cluster, ctx);
  1173. auto options = Y(Q(Y(Q("mode"), Q("alterDatabase"))));
  1174. options = L(options, Q(Y(Q("dbPath"), Q(Params.DbPath))));
  1175. if (Params.Owner.has_value()) {
  1176. options = L(options, Q(Y(Q("owner"), Q(Params.Owner.value().Build()))));
  1177. }
  1178. Add("block", Q(Y(
  1179. Y("let", "sink", Y("DataSink", BuildQuotedAtom(Pos, Service), cluster)),
  1180. Y("let", "world", Y(TString(WriteName), "world", "sink", Q(options))),
  1181. Y("return", ctx.PragmaAutoCommit ? Y(TString(CommitName), "world", "sink") : AstNode("world"))
  1182. )));
  1183. return TAstListNode::DoInit(ctx, src);
  1184. }
  1185. TPtr DoClone() const final {
  1186. return {};
  1187. }
  1188. private:
  1189. const TAlterDatabaseParameters Params;
  1190. TScopedStatePtr Scoped;
  1191. TDeferredAtom Cluster;
  1192. TString Service;
  1193. };
  1194. TNodePtr BuildAlterDatabase(
  1195. TPosition pos,
  1196. const TString& service,
  1197. const TDeferredAtom& cluster,
  1198. const TAlterDatabaseParameters& params,
  1199. TScopedStatePtr scoped
  1200. ) {
  1201. return new TAlterDatabaseNode(
  1202. pos,
  1203. service,
  1204. cluster,
  1205. params,
  1206. scoped
  1207. );
  1208. }
  1209. class TAlterTableNode final : public TAstListNode {
  1210. public:
  1211. TAlterTableNode(TPosition pos, const TTableRef& tr, const TAlterTableParameters& params, TScopedStatePtr scoped)
  1212. : TAstListNode(pos)
  1213. , Table(tr)
  1214. , Params(params)
  1215. , Scoped(scoped)
  1216. {
  1217. scoped->UseCluster(Table.Service, Table.Cluster);
  1218. }
  1219. bool DoInit(TContext& ctx, ISource* src) override {
  1220. auto keys = Table.Keys->GetTableKeys()->BuildKeys(ctx, ITableKeys::EBuildKeysMode::CREATE);
  1221. if (!keys || !keys->Init(ctx, src)) {
  1222. return false;
  1223. }
  1224. auto actions = Y();
  1225. if (Params.AddColumns) {
  1226. auto columns = Y();
  1227. for (auto& col : Params.AddColumns) {
  1228. auto columnDesc = Y();
  1229. columnDesc = L(columnDesc, BuildQuotedAtom(Pos, col.Name));
  1230. auto type = col.Type;
  1231. if (col.Nullable) {
  1232. type = Y("AsOptionalType", type);
  1233. }
  1234. columnDesc = L(columnDesc, type);
  1235. auto columnConstraints = Y();
  1236. if (!col.Nullable) {
  1237. columnConstraints = L(columnConstraints, Q(Y(Q("not_null"))));
  1238. }
  1239. if (col.Serial) {
  1240. columnConstraints = L(columnConstraints, Q(Y(Q("serial"))));
  1241. }
  1242. if (col.DefaultExpr) {
  1243. if (!col.DefaultExpr->Init(ctx, src)) {
  1244. return false;
  1245. }
  1246. columnConstraints = L(columnConstraints, Q(Y(Q("default"), col.DefaultExpr)));
  1247. }
  1248. columnDesc = L(columnDesc, Q(Y(Q("columnConstrains"), Q(columnConstraints))));
  1249. auto familiesDesc = Y();
  1250. for (const auto& family : col.Families) {
  1251. familiesDesc = L(familiesDesc, BuildQuotedAtom(family.Pos, family.Name));
  1252. }
  1253. columnDesc = L(columnDesc, Q(familiesDesc));
  1254. columns = L(columns, Q(columnDesc));
  1255. }
  1256. actions = L(actions, Q(Y(Q("addColumns"), Q(columns))));
  1257. }
  1258. if (Params.DropColumns) {
  1259. auto columns = Y();
  1260. for (auto& colName : Params.DropColumns) {
  1261. columns = L(columns, BuildQuotedAtom(Pos, colName));
  1262. }
  1263. actions = L(actions, Q(Y(Q("dropColumns"), Q(columns))));
  1264. }
  1265. if (Params.AlterColumns) {
  1266. auto columns = Y();
  1267. for (auto& col : Params.AlterColumns) {
  1268. if (col.TypeOfChange == TColumnSchema::ETypeOfChange::DropNotNullConstraint) {
  1269. auto columnDesc = Y();
  1270. columnDesc = L(columnDesc, BuildQuotedAtom(Pos, col.Name));
  1271. auto columnConstraints = Y();
  1272. columnConstraints = L(columnConstraints, Q(Y(Q("drop_not_null"))));
  1273. columnDesc = L(columnDesc, Q(Y(Q("changeColumnConstraints"), Q(columnConstraints))));
  1274. columns = L(columns, Q(columnDesc));
  1275. } else if (col.TypeOfChange == TColumnSchema::ETypeOfChange::SetNotNullConstraint) {
  1276. // todo flown4qqqq
  1277. } else if (col.TypeOfChange == TColumnSchema::ETypeOfChange::SetFamily) {
  1278. auto columnDesc = Y();
  1279. columnDesc = L(columnDesc, BuildQuotedAtom(Pos, col.Name));
  1280. auto familiesDesc = Y();
  1281. for (const auto& family : col.Families) {
  1282. familiesDesc = L(familiesDesc, BuildQuotedAtom(family.Pos, family.Name));
  1283. }
  1284. columnDesc = L(columnDesc, Q(Y(Q("setFamily"), Q(familiesDesc))));
  1285. columns = L(columns, Q(columnDesc));
  1286. } else if (col.TypeOfChange == TColumnSchema::ETypeOfChange::Nothing) {
  1287. // do nothing
  1288. } else {
  1289. ctx.Error(Pos) << " action is not supported";
  1290. }
  1291. }
  1292. actions = L(actions, Q(Y(Q("alterColumns"), Q(columns))));
  1293. }
  1294. if (Params.AddColumnFamilies) {
  1295. auto columnFamilies = Y();
  1296. for (const auto& family : Params.AddColumnFamilies) {
  1297. auto familyDesc = Y();
  1298. familyDesc = L(familyDesc, Q(Y(Q("name"), BuildQuotedAtom(family.Name.Pos, family.Name.Name))));
  1299. if (family.Data) {
  1300. familyDesc = L(familyDesc, Q(Y(Q("data"), family.Data)));
  1301. }
  1302. if (family.Compression) {
  1303. familyDesc = L(familyDesc, Q(Y(Q("compression"), family.Compression)));
  1304. }
  1305. if (family.CompressionLevel) {
  1306. familyDesc = L(familyDesc, Q(Y(Q("compression_level"), family.CompressionLevel)));
  1307. }
  1308. columnFamilies = L(columnFamilies, Q(familyDesc));
  1309. }
  1310. actions = L(actions, Q(Y(Q("addColumnFamilies"), Q(columnFamilies))));
  1311. }
  1312. if (Params.AlterColumnFamilies) {
  1313. auto columnFamilies = Y();
  1314. for (const auto& family : Params.AlterColumnFamilies) {
  1315. auto familyDesc = Y();
  1316. familyDesc = L(familyDesc, Q(Y(Q("name"), BuildQuotedAtom(family.Name.Pos, family.Name.Name))));
  1317. if (family.Data) {
  1318. familyDesc = L(familyDesc, Q(Y(Q("data"), family.Data)));
  1319. }
  1320. if (family.Compression) {
  1321. familyDesc = L(familyDesc, Q(Y(Q("compression"), family.Compression)));
  1322. }
  1323. if (family.CompressionLevel) {
  1324. familyDesc = L(familyDesc, Q(Y(Q("compression_level"), family.CompressionLevel)));
  1325. }
  1326. columnFamilies = L(columnFamilies, Q(familyDesc));
  1327. }
  1328. actions = L(actions, Q(Y(Q("alterColumnFamilies"), Q(columnFamilies))));
  1329. }
  1330. if (Params.TableSettings.IsSet()) {
  1331. actions = L(actions, Q(Y(Q("setTableSettings"), Q(
  1332. CreateTableSettings(Params.TableSettings, ETableSettingsParsingMode::Alter, *this)
  1333. ))));
  1334. }
  1335. for (const auto& index : Params.AddIndexes) {
  1336. const auto& desc = CreateIndexDesc(index, ETableSettingsParsingMode::Alter, *this);
  1337. actions = L(actions, Q(Y(Q("addIndex"), Q(desc))));
  1338. }
  1339. for (const auto& index : Params.AlterIndexes) {
  1340. const auto& desc = CreateAlterIndex(index, *this);
  1341. actions = L(actions, Q(Y(Q("alterIndex"), Q(desc))));
  1342. }
  1343. for (const auto& id : Params.DropIndexes) {
  1344. auto indexName = BuildQuotedAtom(id.Pos, id.Name);
  1345. actions = L(actions, Q(Y(Q("dropIndex"), indexName)));
  1346. }
  1347. if (Params.RenameIndexTo) {
  1348. auto src = BuildQuotedAtom(Params.RenameIndexTo->first.Pos, Params.RenameIndexTo->first.Name);
  1349. auto dst = BuildQuotedAtom(Params.RenameIndexTo->second.Pos, Params.RenameIndexTo->second.Name);
  1350. auto desc = Y();
  1351. desc = L(desc, Q(Y(Q("src"), src)));
  1352. desc = L(desc, Q(Y(Q("dst"), dst)));
  1353. actions = L(actions, Q(Y(Q("renameIndexTo"), Q(desc))));
  1354. }
  1355. if (Params.RenameTo) {
  1356. auto destination = ctx.GetPrefixedPath(Scoped->CurrService, Scoped->CurrCluster,
  1357. TDeferredAtom(Params.RenameTo->Pos, Params.RenameTo->Name));
  1358. actions = L(actions, Q(Y(Q("renameTo"), destination)));
  1359. }
  1360. for (const auto& cf : Params.AddChangefeeds) {
  1361. const auto& desc = CreateChangefeedDesc(cf, *this);
  1362. actions = L(actions, Q(Y(Q("addChangefeed"), Q(desc))));
  1363. }
  1364. for (const auto& cf : Params.AlterChangefeeds) {
  1365. const auto& desc = CreateChangefeedDesc(cf, *this);
  1366. actions = L(actions, Q(Y(Q("alterChangefeed"), Q(desc))));
  1367. }
  1368. for (const auto& id : Params.DropChangefeeds) {
  1369. const auto name = BuildQuotedAtom(id.Pos, id.Name);
  1370. actions = L(actions, Q(Y(Q("dropChangefeed"), name)));
  1371. }
  1372. auto opts = Y();
  1373. opts = L(opts, Q(Y(Q("mode"), Q("alter"))));
  1374. opts = L(opts, Q(Y(Q("actions"), Q(actions))));
  1375. switch (Params.TableType) {
  1376. case ETableType::TableStore:
  1377. opts = L(opts, Q(Y(Q("tableType"), Q("tableStore"))));
  1378. break;
  1379. case ETableType::ExternalTable:
  1380. opts = L(opts, Q(Y(Q("tableType"), Q("externalTable"))));
  1381. break;
  1382. case ETableType::Table:
  1383. break;
  1384. }
  1385. Add("block", Q(Y(
  1386. Y("let", "sink", Y("DataSink", BuildQuotedAtom(Pos, Table.Service), Scoped->WrapCluster(Table.Cluster, ctx))),
  1387. Y("let", "world", Y(TString(WriteName), "world", "sink", keys, Y("Void"), Q(opts))),
  1388. Y("return", ctx.PragmaAutoCommit ? Y(TString(CommitName), "world", "sink") : AstNode("world"))
  1389. )));
  1390. return TAstListNode::DoInit(ctx, src);
  1391. }
  1392. TPtr DoClone() const final {
  1393. return {};
  1394. }
  1395. private:
  1396. TTableRef Table;
  1397. const TAlterTableParameters Params;
  1398. TScopedStatePtr Scoped;
  1399. };
  1400. TNodePtr BuildAlterTable(TPosition pos, const TTableRef& tr, const TAlterTableParameters& params, TScopedStatePtr scoped)
  1401. {
  1402. return new TAlterTableNode(pos, tr, params, scoped);
  1403. }
  1404. class TDropTableNode final : public TAstListNode {
  1405. public:
  1406. TDropTableNode(TPosition pos, const TTableRef& tr, bool missingOk, ETableType tableType, TScopedStatePtr scoped)
  1407. : TAstListNode(pos)
  1408. , Table(tr)
  1409. , TableType(tableType)
  1410. , Scoped(scoped)
  1411. , MissingOk(missingOk)
  1412. {
  1413. FakeSource = BuildFakeSource(pos);
  1414. scoped->UseCluster(Table.Service, Table.Cluster);
  1415. }
  1416. bool DoInit(TContext& ctx, ISource* src) override {
  1417. Y_UNUSED(src);
  1418. auto keys = Table.Keys->GetTableKeys()->BuildKeys(ctx, ITableKeys::EBuildKeysMode::DROP);
  1419. if (!keys || !keys->Init(ctx, FakeSource.Get())) {
  1420. return false;
  1421. }
  1422. auto opts = Y();
  1423. opts = L(opts, Q(Y(Q("mode"), Q(MissingOk ? "drop_if_exists" : "drop"))));
  1424. switch (TableType) {
  1425. case ETableType::TableStore:
  1426. opts = L(opts, Q(Y(Q("tableType"), Q("tableStore"))));
  1427. break;
  1428. case ETableType::ExternalTable:
  1429. opts = L(opts, Q(Y(Q("tableType"), Q("externalTable"))));
  1430. break;
  1431. case ETableType::Table:
  1432. break;
  1433. }
  1434. Add("block", Q(Y(
  1435. Y("let", "sink", Y("DataSink", BuildQuotedAtom(Pos, Table.Service), Scoped->WrapCluster(Table.Cluster, ctx))),
  1436. Y("let", "world", Y(TString(WriteName), "world", "sink", keys, Y("Void"), Q(opts))),
  1437. Y("return", ctx.PragmaAutoCommit ? Y(TString(CommitName), "world", "sink") : AstNode("world"))
  1438. )));
  1439. return TAstListNode::DoInit(ctx, FakeSource.Get());
  1440. }
  1441. TPtr DoClone() const final {
  1442. return {};
  1443. }
  1444. private:
  1445. TTableRef Table;
  1446. ETableType TableType;
  1447. TScopedStatePtr Scoped;
  1448. TSourcePtr FakeSource;
  1449. const bool MissingOk;
  1450. };
  1451. TNodePtr BuildDropTable(TPosition pos, const TTableRef& tr, bool missingOk, ETableType tableType, TScopedStatePtr scoped) {
  1452. return new TDropTableNode(pos, tr, missingOk, tableType, scoped);
  1453. }
  1454. static INode::TPtr CreateConsumerDesc(const TTopicConsumerDescription& desc, const INode& node, bool alter) {
  1455. auto settings = node.Y();
  1456. if (desc.Settings.Important) {
  1457. settings = node.L(settings, node.Q(node.Y(node.Q("important"), desc.Settings.Important)));
  1458. }
  1459. if (const auto& readFromTs = desc.Settings.ReadFromTs) {
  1460. if (readFromTs.IsSet()) {
  1461. settings = node.L(settings, node.Q(node.Y(node.Q("setReadFromTs"), readFromTs.GetValueSet())));
  1462. } else if (alter) {
  1463. settings = node.L(settings, node.Q(node.Y(node.Q("resetReadFromTs"), node.Q(node.Y()))));
  1464. } else {
  1465. YQL_ENSURE(false, "Cannot reset on create");
  1466. }
  1467. }
  1468. if (const auto& readFromTs = desc.Settings.SupportedCodecs) {
  1469. if (readFromTs.IsSet()) {
  1470. settings = node.L(settings, node.Q(node.Y(node.Q("setSupportedCodecs"), readFromTs.GetValueSet())));
  1471. } else if (alter) {
  1472. settings = node.L(settings, node.Q(node.Y(node.Q("resetSupportedCodecs"), node.Q(node.Y()))));
  1473. } else {
  1474. YQL_ENSURE(false, "Cannot reset on create");
  1475. }
  1476. }
  1477. return node.Y(
  1478. node.Q(node.Y(node.Q("name"), BuildQuotedAtom(desc.Name.Pos, desc.Name.Name))),
  1479. node.Q(node.Y(node.Q("settings"), node.Q(settings)))
  1480. );
  1481. }
  1482. class TCreateTopicNode final : public TAstListNode {
  1483. public:
  1484. TCreateTopicNode(TPosition pos, const TTopicRef& tr, const TCreateTopicParameters& params, TScopedStatePtr scoped)
  1485. : TAstListNode(pos)
  1486. , Topic(tr)
  1487. , Params(params)
  1488. , Scoped(scoped)
  1489. {
  1490. scoped->UseCluster(TString(KikimrProviderName), Topic.Cluster);
  1491. }
  1492. bool DoInit(TContext& ctx, ISource* src) override {
  1493. auto keys = Topic.Keys->GetTableKeys()->BuildKeys(ctx, ITableKeys::EBuildKeysMode::CREATE);
  1494. if (!keys || !keys->Init(ctx, src)) {
  1495. return false;
  1496. }
  1497. if (!Params.Consumers.empty())
  1498. {
  1499. THashSet<TString> consumerNames;
  1500. for (const auto& consumer : Params.Consumers) {
  1501. if (!consumerNames.insert(consumer.Name.Name).second) {
  1502. ctx.Error(consumer.Name.Pos) << "Consumer " << consumer.Name.Name << " defined more than once";
  1503. return false;
  1504. }
  1505. }
  1506. }
  1507. auto opts = Y();
  1508. TString mode = Params.ExistingOk ? "create_if_not_exists" : "create";
  1509. opts = L(opts, Q(Y(Q("mode"), Q(mode))));
  1510. for (const auto& consumer : Params.Consumers) {
  1511. const auto& desc = CreateConsumerDesc(consumer, *this, false);
  1512. opts = L(opts, Q(Y(Q("consumer"), Q(desc))));
  1513. }
  1514. if (Params.TopicSettings.IsSet()) {
  1515. auto settings = Y();
  1516. #define INSERT_TOPIC_SETTING(NAME) \
  1517. if (const auto& NAME##Val = Params.TopicSettings.NAME) { \
  1518. if (NAME##Val.IsSet()) { \
  1519. settings = L(settings, Q(Y(Q(Y_STRINGIZE(set##NAME)), NAME##Val.GetValueSet()))); \
  1520. } else { \
  1521. YQL_ENSURE(false, "Can't reset on create"); \
  1522. } \
  1523. }
  1524. INSERT_TOPIC_SETTING(MaxPartitions)
  1525. INSERT_TOPIC_SETTING(MinPartitions)
  1526. INSERT_TOPIC_SETTING(RetentionPeriod)
  1527. INSERT_TOPIC_SETTING(SupportedCodecs)
  1528. INSERT_TOPIC_SETTING(PartitionWriteSpeed)
  1529. INSERT_TOPIC_SETTING(PartitionWriteBurstSpeed)
  1530. INSERT_TOPIC_SETTING(MeteringMode)
  1531. INSERT_TOPIC_SETTING(AutoPartitioningStabilizationWindow)
  1532. INSERT_TOPIC_SETTING(AutoPartitioningUpUtilizationPercent)
  1533. INSERT_TOPIC_SETTING(AutoPartitioningDownUtilizationPercent)
  1534. INSERT_TOPIC_SETTING(AutoPartitioningStrategy)
  1535. #undef INSERT_TOPIC_SETTING
  1536. opts = L(opts, Q(Y(Q("topicSettings"), Q(settings))));
  1537. }
  1538. Add("block", Q(Y(
  1539. Y("let", "sink", Y("DataSink", BuildQuotedAtom(Pos, TString(KikimrProviderName)),
  1540. Scoped->WrapCluster(Topic.Cluster, ctx))),
  1541. Y("let", "world", Y(TString(WriteName), "world", "sink", keys, Y("Void"), Q(opts))),
  1542. Y("return", ctx.PragmaAutoCommit ? Y(TString(CommitName), "world", "sink") : AstNode("world"))
  1543. )));
  1544. return TAstListNode::DoInit(ctx, src);
  1545. }
  1546. TPtr DoClone() const final {
  1547. return {};
  1548. }
  1549. private:
  1550. const TTopicRef Topic;
  1551. const TCreateTopicParameters Params;
  1552. TScopedStatePtr Scoped;
  1553. };
  1554. TNodePtr BuildCreateTopic(
  1555. TPosition pos, const TTopicRef& tr, const TCreateTopicParameters& params, TScopedStatePtr scoped
  1556. ){
  1557. return new TCreateTopicNode(pos, tr, params, scoped);
  1558. }
  1559. class TAlterTopicNode final : public TAstListNode {
  1560. public:
  1561. TAlterTopicNode(TPosition pos, const TTopicRef& tr, const TAlterTopicParameters& params, TScopedStatePtr scoped)
  1562. : TAstListNode(pos)
  1563. , Topic(tr)
  1564. , Params(params)
  1565. , Scoped(scoped)
  1566. {
  1567. scoped->UseCluster(TString(KikimrProviderName), Topic.Cluster);
  1568. }
  1569. bool DoInit(TContext& ctx, ISource* src) override {
  1570. auto keys = Topic.Keys->GetTableKeys()->BuildKeys(ctx, ITableKeys::EBuildKeysMode::CREATE);
  1571. if (!keys || !keys->Init(ctx, src)) {
  1572. return false;
  1573. }
  1574. if (!Params.AddConsumers.empty())
  1575. {
  1576. THashSet<TString> consumerNames;
  1577. for (const auto& consumer : Params.AddConsumers) {
  1578. if (!consumerNames.insert(consumer.Name.Name).second) {
  1579. ctx.Error(consumer.Name.Pos) << "Consumer " << consumer.Name.Name << " defined more than once";
  1580. return false;
  1581. }
  1582. }
  1583. }
  1584. if (!Params.AlterConsumers.empty())
  1585. {
  1586. THashSet<TString> consumerNames;
  1587. for (const auto& [_, consumer] : Params.AlterConsumers) {
  1588. if (!consumerNames.insert(consumer.Name.Name).second) {
  1589. ctx.Error(consumer.Name.Pos) << "Consumer " << consumer.Name.Name << " altered more than once";
  1590. return false;
  1591. }
  1592. }
  1593. }
  1594. if (!Params.DropConsumers.empty())
  1595. {
  1596. THashSet<TString> consumerNames;
  1597. for (const auto& consumer : Params.DropConsumers) {
  1598. if (!consumerNames.insert(consumer.Name).second) {
  1599. ctx.Error(consumer.Pos) << "Consumer " << consumer.Name << " dropped more than once";
  1600. return false;
  1601. }
  1602. }
  1603. }
  1604. auto opts = Y();
  1605. TString mode = Params.MissingOk ? "alter_if_exists" : "alter";
  1606. opts = L(opts, Q(Y(Q("mode"), Q(mode))));
  1607. for (const auto& consumer : Params.AddConsumers) {
  1608. const auto& desc = CreateConsumerDesc(consumer, *this, false);
  1609. opts = L(opts, Q(Y(Q("addConsumer"), Q(desc))));
  1610. }
  1611. for (const auto& [_, consumer] : Params.AlterConsumers) {
  1612. const auto& desc = CreateConsumerDesc(consumer, *this, true);
  1613. opts = L(opts, Q(Y(Q("alterConsumer"), Q(desc))));
  1614. }
  1615. for (const auto& consumer : Params.DropConsumers) {
  1616. const auto name = BuildQuotedAtom(consumer.Pos, consumer.Name);
  1617. opts = L(opts, Q(Y(Q("dropConsumer"), name)));
  1618. }
  1619. if (Params.TopicSettings.IsSet()) {
  1620. auto settings = Y();
  1621. #define INSERT_TOPIC_SETTING(NAME) \
  1622. if (const auto& NAME##Val = Params.TopicSettings.NAME) { \
  1623. if (NAME##Val.IsSet()) { \
  1624. settings = L(settings, Q(Y(Q(Y_STRINGIZE(set##NAME)), NAME##Val.GetValueSet()))); \
  1625. } else { \
  1626. settings = L(settings, Q(Y(Q(Y_STRINGIZE(reset##NAME)), Y()))); \
  1627. } \
  1628. }
  1629. INSERT_TOPIC_SETTING(MaxPartitions)
  1630. INSERT_TOPIC_SETTING(MinPartitions)
  1631. INSERT_TOPIC_SETTING(RetentionPeriod)
  1632. INSERT_TOPIC_SETTING(SupportedCodecs)
  1633. INSERT_TOPIC_SETTING(PartitionWriteSpeed)
  1634. INSERT_TOPIC_SETTING(PartitionWriteBurstSpeed)
  1635. INSERT_TOPIC_SETTING(MeteringMode)
  1636. INSERT_TOPIC_SETTING(AutoPartitioningStabilizationWindow)
  1637. INSERT_TOPIC_SETTING(AutoPartitioningUpUtilizationPercent)
  1638. INSERT_TOPIC_SETTING(AutoPartitioningDownUtilizationPercent)
  1639. INSERT_TOPIC_SETTING(AutoPartitioningStrategy)
  1640. #undef INSERT_TOPIC_SETTING
  1641. opts = L(opts, Q(Y(Q("topicSettings"), Q(settings))));
  1642. }
  1643. Add("block", Q(Y(
  1644. Y("let", "sink", Y("DataSink", BuildQuotedAtom(Pos, TString(KikimrProviderName)),
  1645. Scoped->WrapCluster(Topic.Cluster, ctx))),
  1646. Y("let", "world", Y(TString(WriteName), "world", "sink", keys, Y("Void"), Q(opts))),
  1647. Y("return", ctx.PragmaAutoCommit ? Y(TString(CommitName), "world", "sink") : AstNode("world"))
  1648. )));
  1649. return TAstListNode::DoInit(ctx, src);
  1650. }
  1651. TPtr DoClone() const final {
  1652. return {};
  1653. }
  1654. private:
  1655. const TTopicRef Topic;
  1656. const TAlterTopicParameters Params;
  1657. TScopedStatePtr Scoped;
  1658. };
  1659. TNodePtr BuildAlterTopic(
  1660. TPosition pos, const TTopicRef& tr, const TAlterTopicParameters& params, TScopedStatePtr scoped
  1661. ){
  1662. return new TAlterTopicNode(pos, tr, params, scoped);
  1663. }
  1664. class TDropTopicNode final : public TAstListNode {
  1665. public:
  1666. TDropTopicNode(TPosition pos, const TTopicRef& tr, const TDropTopicParameters& params, TScopedStatePtr scoped)
  1667. : TAstListNode(pos)
  1668. , Topic(tr)
  1669. , Params(params)
  1670. , Scoped(scoped)
  1671. {
  1672. scoped->UseCluster(TString(KikimrProviderName), Topic.Cluster);
  1673. }
  1674. bool DoInit(TContext& ctx, ISource* src) override {
  1675. Y_UNUSED(src);
  1676. auto keys = Topic.Keys->GetTableKeys()->BuildKeys(ctx, ITableKeys::EBuildKeysMode::DROP);
  1677. if (!keys || !keys->Init(ctx, FakeSource.Get())) {
  1678. return false;
  1679. }
  1680. auto opts = Y();
  1681. TString mode = Params.MissingOk ? "drop_if_exists" : "drop";
  1682. opts = L(opts, Q(Y(Q("mode"), Q(mode))));
  1683. Add("block", Q(Y(
  1684. Y("let", "sink", Y("DataSink", BuildQuotedAtom(Pos, TString(KikimrProviderName)),
  1685. Scoped->WrapCluster(Topic.Cluster, ctx))),
  1686. Y("let", "world", Y(TString(WriteName), "world", "sink", keys, Y("Void"), Q(opts))),
  1687. Y("return", ctx.PragmaAutoCommit ? Y(TString(CommitName), "world", "sink") : AstNode("world"))
  1688. )));
  1689. return TAstListNode::DoInit(ctx, FakeSource.Get());
  1690. }
  1691. TPtr DoClone() const final {
  1692. return {};
  1693. }
  1694. private:
  1695. TTopicRef Topic;
  1696. TDropTopicParameters Params;
  1697. TScopedStatePtr Scoped;
  1698. TSourcePtr FakeSource;
  1699. };
  1700. TNodePtr BuildDropTopic(TPosition pos, const TTopicRef& tr, const TDropTopicParameters& params, TScopedStatePtr scoped) {
  1701. return new TDropTopicNode(pos, tr, params, scoped);
  1702. }
  1703. class TControlUser final : public TAstListNode {
  1704. public:
  1705. TControlUser(TPosition pos, const TString& service, const TDeferredAtom& cluster, const TDeferredAtom& name, const TMaybe<TUserParameters>& params, TScopedStatePtr scoped, bool IsCreateUser)
  1706. : TAstListNode(pos)
  1707. , Service(service)
  1708. , Cluster(cluster)
  1709. , Name(name)
  1710. , Params(params)
  1711. , Scoped(scoped)
  1712. , IsCreateUser(IsCreateUser)
  1713. {
  1714. FakeSource = BuildFakeSource(pos);
  1715. scoped->UseCluster(service, cluster);
  1716. }
  1717. bool DoInit(TContext& ctx, ISource*) override {
  1718. auto name = Name.Build();
  1719. TNodePtr password;
  1720. TNodePtr hash;
  1721. if (Params) {
  1722. if (Params->Password) {
  1723. password = Params->Password->Build();
  1724. } else if (Params->Hash) {
  1725. hash = Params->Hash->Build();
  1726. }
  1727. }
  1728. TNodePtr cluster = Scoped->WrapCluster(Cluster, ctx);
  1729. if (!name->Init(ctx, FakeSource.Get())
  1730. || !cluster->Init(ctx, FakeSource.Get())
  1731. || password && !password->Init(ctx, FakeSource.Get())
  1732. || hash && !hash->Init(ctx, FakeSource.Get())
  1733. )
  1734. {
  1735. return false;
  1736. }
  1737. auto options = Y(Q(Y(Q("mode"), Q(IsCreateUser ? "createUser" : "alterUser")))) ;
  1738. TVector<TNodePtr> roles;
  1739. if (Params && !Params->Roles.empty()) {
  1740. for (auto& item : Params->Roles) {
  1741. roles.push_back(item.Build());
  1742. if (!roles.back()->Init(ctx, FakeSource.Get())) {
  1743. return false;
  1744. }
  1745. }
  1746. options = L(options, Q(Y(Q("roles"), Q(new TAstListNodeImpl(Pos, std::move(roles))))));
  1747. }
  1748. if (Params) {
  1749. if (Params->IsPasswordEncrypted) {
  1750. options = L(options, Q(Y(Q("passwordEncrypted"))));
  1751. }
  1752. if (Params->Password) {
  1753. options = L(options, Q(Y(Q("password"), password)));
  1754. } else if (Params->Hash) {
  1755. options = L(options, Q(Y(Q("hash"), hash)));
  1756. } else {
  1757. options = L(options, Q(Y(Q("nullPassword"))));
  1758. }
  1759. if (Params->CanLogin.has_value()) {
  1760. options = L(options, Q(Y(Q(Params->CanLogin.value() ? "login" : "noLogin"))));
  1761. }
  1762. }
  1763. Add("block", Q(Y(
  1764. Y("let", "sink", Y("DataSink", BuildQuotedAtom(Pos, Service), cluster)),
  1765. Y("let", "world", Y(TString(WriteName), "world", "sink", Y("Key", Q(Y(Q("role"), Y("String", name)))), Y("Void"), Q(options))),
  1766. Y("return", ctx.PragmaAutoCommit ? Y(TString(CommitName), "world", "sink") : AstNode("world"))
  1767. )));
  1768. return TAstListNode::DoInit(ctx, FakeSource.Get());
  1769. }
  1770. TPtr DoClone() const final {
  1771. return {};
  1772. }
  1773. private:
  1774. const TString Service;
  1775. TDeferredAtom Cluster;
  1776. TDeferredAtom Name;
  1777. const TMaybe<TUserParameters> Params;
  1778. TScopedStatePtr Scoped;
  1779. TSourcePtr FakeSource;
  1780. bool IsCreateUser;
  1781. };
  1782. TNodePtr BuildControlUser( TPosition pos,
  1783. const TString& service,
  1784. const TDeferredAtom& cluster,
  1785. const TDeferredAtom& name,
  1786. const TMaybe<TUserParameters>& params,
  1787. TScopedStatePtr scoped,
  1788. bool isCreateUser)
  1789. {
  1790. return new TControlUser(pos, service, cluster, name, params, scoped, isCreateUser);
  1791. }
  1792. class TCreateGroup final : public TAstListNode {
  1793. public:
  1794. TCreateGroup(TPosition pos, const TString& service, const TDeferredAtom& cluster, const TDeferredAtom& name, const TMaybe<TCreateGroupParameters>& params, TScopedStatePtr scoped)
  1795. : TAstListNode(pos)
  1796. , Service(service)
  1797. , Cluster(cluster)
  1798. , Name(name)
  1799. , Params(params)
  1800. , Scoped(scoped)
  1801. {
  1802. FakeSource = BuildFakeSource(pos);
  1803. scoped->UseCluster(service, cluster);
  1804. }
  1805. bool DoInit(TContext& ctx, ISource*) override {
  1806. auto options = Y(Q(Y(Q("mode"), Q("createGroup"))));
  1807. TVector<TNodePtr> roles;
  1808. if (Params && !Params->Roles.empty()) {
  1809. for (auto& item : Params->Roles) {
  1810. roles.push_back(item.Build());
  1811. if (!roles.back()->Init(ctx, FakeSource.Get())) {
  1812. return false;
  1813. }
  1814. }
  1815. options = L(options, Q(Y(Q("roles"), Q(new TAstListNodeImpl(Pos, std::move(roles))))));
  1816. }
  1817. TNodePtr cluster = Scoped->WrapCluster(Cluster, ctx);
  1818. Add("block", Q(Y(
  1819. Y("let", "sink", Y("DataSink", BuildQuotedAtom(Pos, Service), cluster)),
  1820. Y("let", "world", Y(TString(WriteName), "world", "sink", Y("Key", Q(Y(Q("role"), Y("String", Name.Build())))), Y("Void"), Q(options))),
  1821. Y("return", ctx.PragmaAutoCommit ? Y(TString(CommitName), "world", "sink") : AstNode("world"))
  1822. )));
  1823. return TAstListNode::DoInit(ctx, FakeSource.Get());
  1824. }
  1825. TPtr DoClone() const final {
  1826. return {};
  1827. }
  1828. private:
  1829. const TString Service;
  1830. TDeferredAtom Cluster;
  1831. TDeferredAtom Name;
  1832. const TMaybe<TCreateGroupParameters> Params;
  1833. TScopedStatePtr Scoped;
  1834. TSourcePtr FakeSource;
  1835. };
  1836. TNodePtr BuildCreateGroup(TPosition pos, const TString& service, const TDeferredAtom& cluster, const TDeferredAtom& name, const TMaybe<TCreateGroupParameters>& params, TScopedStatePtr scoped) {
  1837. return new TCreateGroup(pos, service, cluster, name, params, scoped);
  1838. }
  1839. class TAlterSequence final : public TAstListNode {
  1840. public:
  1841. TAlterSequence(TPosition pos, const TString& service, const TDeferredAtom& cluster, const TString& id, const TSequenceParameters& params, TScopedStatePtr scoped)
  1842. : TAstListNode(pos)
  1843. , Service(service)
  1844. , Cluster(cluster)
  1845. , Id(id)
  1846. , Params(params)
  1847. , Scoped(scoped)
  1848. {
  1849. FakeSource = BuildFakeSource(pos);
  1850. scoped->UseCluster(service, cluster);
  1851. }
  1852. bool DoInit(TContext& ctx, ISource* src) override {
  1853. Y_UNUSED(src);
  1854. TNodePtr cluster = Scoped->WrapCluster(Cluster, ctx);
  1855. if (!cluster->Init(ctx, FakeSource.Get())) {
  1856. return false;
  1857. }
  1858. auto options = Y();
  1859. TString mode = Params.MissingOk ? "alter_if_exists" : "alter";
  1860. options = L(options, Q(Y(Q("mode"), Q(mode))));
  1861. if (Params.IsRestart) {
  1862. if (Params.RestartValue) {
  1863. TString strValue = Params.RestartValue->Build()->GetLiteralValue();
  1864. ui64 value = FromString<ui64>(strValue);
  1865. ui64 maxValue = ui64(std::numeric_limits<i64>::max());
  1866. ui64 minValue = 1;
  1867. if (value > maxValue) {
  1868. ctx.Error(Pos) << "Restart value: " << value << " cannot be greater than max value: " << maxValue;
  1869. return false;
  1870. }
  1871. if (value < minValue) {
  1872. ctx.Error(Pos) << "Restart value: " << value << " cannot be less than min value: " << minValue;
  1873. return false;
  1874. }
  1875. options = L(options, Q(Y(Q("restart"), Q(ToString(value)))));
  1876. } else {
  1877. options = L(options, Q(Y(Q("restart"), Q(TString()))));
  1878. }
  1879. }
  1880. if (Params.StartValue) {
  1881. TString strValue = Params.StartValue->Build()->GetLiteralValue();
  1882. ui64 value = FromString<ui64>(strValue);
  1883. ui64 maxValue = ui64(std::numeric_limits<i64>::max());
  1884. ui64 minValue = 1;
  1885. if (value > maxValue) {
  1886. ctx.Error(Pos) << "Start value: " << value << " cannot be greater than max value: " << maxValue;
  1887. return false;
  1888. }
  1889. if (value < minValue) {
  1890. ctx.Error(Pos) << "Start value: " << value << " cannot be less than min value: " << minValue;
  1891. return false;
  1892. }
  1893. options = L(options, Q(Y(Q("start"), Q(ToString(value)))));
  1894. }
  1895. if (Params.Increment) {
  1896. TString strValue = Params.Increment->Build()->GetLiteralValue();
  1897. ui64 value = FromString<ui64>(strValue);
  1898. ui64 maxValue = ui64(std::numeric_limits<i64>::max());
  1899. if (value > maxValue) {
  1900. ctx.Error(Pos) << "Increment: " << value << " cannot be greater than max value: " << maxValue;
  1901. return false;
  1902. }
  1903. if (value == 0) {
  1904. ctx.Error(Pos) << "Increment must not be zero";
  1905. return false;
  1906. }
  1907. options = L(options, Q(Y(Q("increment"), Q(ToString(value)))));
  1908. }
  1909. Add("block", Q(Y(
  1910. Y("let", "sink", Y("DataSink", BuildQuotedAtom(Pos, TString(KikimrProviderName)),
  1911. Scoped->WrapCluster(Cluster, ctx))),
  1912. Y("let", "world", Y(TString(WriteName), "world", "sink", Y("Key", Q(Y(Q("sequence"), Y("String", BuildQuotedAtom(Pos, Id))))), Y("Void"), Q(options))),
  1913. Y("return", ctx.PragmaAutoCommit ? Y(TString(CommitName), "world", "sink") : AstNode("world"))
  1914. )));
  1915. return TAstListNode::DoInit(ctx, src);
  1916. }
  1917. TPtr DoClone() const final {
  1918. return {};
  1919. }
  1920. private:
  1921. const TString Service;
  1922. TDeferredAtom Cluster;
  1923. TString Id;
  1924. const TSequenceParameters Params;
  1925. TScopedStatePtr Scoped;
  1926. TSourcePtr FakeSource;
  1927. };
  1928. TNodePtr BuildAlterSequence(TPosition pos, const TString& service, const TDeferredAtom& cluster, const TString& id, const TSequenceParameters& params, TScopedStatePtr scoped) {
  1929. return new TAlterSequence(pos, service, cluster, id, params, scoped);
  1930. }
  1931. class TRenameRole final : public TAstListNode {
  1932. public:
  1933. TRenameRole(TPosition pos, bool isUser, const TString& service, const TDeferredAtom& cluster, const TDeferredAtom& name, const TDeferredAtom& newName, TScopedStatePtr scoped)
  1934. : TAstListNode(pos)
  1935. , IsUser(isUser)
  1936. , Service(service)
  1937. , Cluster(cluster)
  1938. , Name(name)
  1939. , NewName(newName)
  1940. , Scoped(scoped)
  1941. {
  1942. FakeSource = BuildFakeSource(pos);
  1943. scoped->UseCluster(service, cluster);
  1944. }
  1945. bool DoInit(TContext& ctx, ISource* src) override {
  1946. Y_UNUSED(src);
  1947. auto name = Name.Build();
  1948. auto newName = NewName.Build();
  1949. TNodePtr cluster = Scoped->WrapCluster(Cluster, ctx);
  1950. if (!name->Init(ctx, FakeSource.Get()) ||
  1951. !newName->Init(ctx, FakeSource.Get()) ||
  1952. !cluster->Init(ctx, FakeSource.Get()))
  1953. {
  1954. return false;
  1955. }
  1956. auto options = Y(Q(Y(Q("mode"), Q(IsUser ? "renameUser" : "renameGroup"))));
  1957. options = L(options, Q(Y(Q("newName"), newName)));
  1958. Add("block", Q(Y(
  1959. Y("let", "sink", Y("DataSink", BuildQuotedAtom(Pos, Service), cluster)),
  1960. Y("let", "world", Y(TString(WriteName), "world", "sink", Y("Key", Q(Y(Q("role"), Y("String", name)))), Y("Void"), Q(options))),
  1961. Y("return", ctx.PragmaAutoCommit ? Y(TString(CommitName), "world", "sink") : AstNode("world"))
  1962. )));
  1963. return TAstListNode::DoInit(ctx, FakeSource.Get());
  1964. }
  1965. TPtr DoClone() const final {
  1966. return {};
  1967. }
  1968. private:
  1969. const bool IsUser;
  1970. const TString Service;
  1971. TDeferredAtom Cluster;
  1972. TDeferredAtom Name;
  1973. TDeferredAtom NewName;
  1974. TScopedStatePtr Scoped;
  1975. TSourcePtr FakeSource;
  1976. };
  1977. TNodePtr BuildRenameUser(TPosition pos, const TString& service, const TDeferredAtom& cluster, const TDeferredAtom& name, const TDeferredAtom& newName, TScopedStatePtr scoped) {
  1978. const bool isUser = true;
  1979. return new TRenameRole(pos, isUser, service, cluster, name, newName, scoped);
  1980. }
  1981. TNodePtr BuildRenameGroup(TPosition pos, const TString& service, const TDeferredAtom& cluster, const TDeferredAtom& name, const TDeferredAtom& newName, TScopedStatePtr scoped) {
  1982. const bool isUser = false;
  1983. return new TRenameRole(pos, isUser, service, cluster, name, newName, scoped);
  1984. }
  1985. class TAlterGroup final : public TAstListNode {
  1986. public:
  1987. TAlterGroup(TPosition pos, const TString& service, const TDeferredAtom& cluster, const TDeferredAtom& name, const TVector<TDeferredAtom>& toChange, bool isDrop, TScopedStatePtr scoped)
  1988. : TAstListNode(pos)
  1989. , Service(service)
  1990. , Cluster(cluster)
  1991. , Name(name)
  1992. , ToChange(toChange)
  1993. , IsDrop(isDrop)
  1994. , Scoped(scoped)
  1995. {
  1996. FakeSource = BuildFakeSource(pos);
  1997. scoped->UseCluster(service, cluster);
  1998. }
  1999. bool DoInit(TContext& ctx, ISource* src) override {
  2000. Y_UNUSED(src);
  2001. auto name = Name.Build();
  2002. TNodePtr cluster = Scoped->WrapCluster(Cluster, ctx);
  2003. if (!name->Init(ctx, FakeSource.Get()) || !cluster->Init(ctx, FakeSource.Get())) {
  2004. return false;
  2005. }
  2006. TVector<TNodePtr> toChange;
  2007. for (auto& item : ToChange) {
  2008. toChange.push_back(item.Build());
  2009. if (!toChange.back()->Init(ctx, FakeSource.Get())) {
  2010. return false;
  2011. }
  2012. }
  2013. auto options = Y(Q(Y(Q("mode"), Q(IsDrop ? "dropUsersFromGroup" : "addUsersToGroup"))));
  2014. options = L(options, Q(Y(Q("roles"), Q(new TAstListNodeImpl(Pos, std::move(toChange))))));
  2015. Add("block", Q(Y(
  2016. Y("let", "sink", Y("DataSink", BuildQuotedAtom(Pos, Service), cluster)),
  2017. Y("let", "world", Y(TString(WriteName), "world", "sink", Y("Key", Q(Y(Q("role"), Y("String", name)))), Y("Void"), Q(options))),
  2018. Y("return", ctx.PragmaAutoCommit ? Y(TString(CommitName), "world", "sink") : AstNode("world"))
  2019. )));
  2020. return TAstListNode::DoInit(ctx, FakeSource.Get());
  2021. }
  2022. TPtr DoClone() const final {
  2023. return {};
  2024. }
  2025. private:
  2026. const TString Service;
  2027. TDeferredAtom Cluster;
  2028. TDeferredAtom Name;
  2029. TVector<TDeferredAtom> ToChange;
  2030. const bool IsDrop;
  2031. TScopedStatePtr Scoped;
  2032. TSourcePtr FakeSource;
  2033. };
  2034. TNodePtr BuildAlterGroup(TPosition pos, const TString& service, const TDeferredAtom& cluster, const TDeferredAtom& name, const TVector<TDeferredAtom>& toChange, bool isDrop,
  2035. TScopedStatePtr scoped)
  2036. {
  2037. return new TAlterGroup(pos, service, cluster, name, toChange, isDrop, scoped);
  2038. }
  2039. class TDropRoles final : public TAstListNode {
  2040. public:
  2041. TDropRoles(TPosition pos, const TString& service, const TDeferredAtom& cluster, const TVector<TDeferredAtom>& toDrop, bool isUser, bool missingOk, TScopedStatePtr scoped)
  2042. : TAstListNode(pos)
  2043. , Service(service)
  2044. , Cluster(cluster)
  2045. , ToDrop(toDrop)
  2046. , IsUser(isUser)
  2047. , MissingOk(missingOk)
  2048. , Scoped(scoped)
  2049. {
  2050. FakeSource = BuildFakeSource(pos);
  2051. scoped->UseCluster(service, cluster);
  2052. }
  2053. bool DoInit(TContext& ctx, ISource* src) override {
  2054. Y_UNUSED(src);
  2055. TNodePtr cluster = Scoped->WrapCluster(Cluster, ctx);
  2056. if (!cluster->Init(ctx, FakeSource.Get())) {
  2057. return false;
  2058. }
  2059. const char* mode = IsUser ?
  2060. (MissingOk ? "dropUserIfExists" : "dropUser") :
  2061. (MissingOk ? "dropGroupIfExists" : "dropGroup");
  2062. auto options = Y(Q(Y(Q("mode"), Q(mode))));
  2063. auto block = Y(Y("let", "sink", Y("DataSink", BuildQuotedAtom(Pos, Service), cluster)));
  2064. for (auto& item : ToDrop) {
  2065. auto name = item.Build();
  2066. if (!name->Init(ctx, FakeSource.Get())) {
  2067. return false;
  2068. }
  2069. block = L(block, Y("let", "world", Y(TString(WriteName), "world", "sink", Y("Key", Q(Y(Q("role"), Y("String", name)))), Y("Void"), Q(options))));
  2070. }
  2071. block = L(block, Y("return", ctx.PragmaAutoCommit ? Y(TString(CommitName), "world", "sink") : AstNode("world")));
  2072. Add("block", Q(block));
  2073. return TAstListNode::DoInit(ctx, FakeSource.Get());
  2074. }
  2075. TPtr DoClone() const final {
  2076. return {};
  2077. }
  2078. private:
  2079. const TString Service;
  2080. TDeferredAtom Cluster;
  2081. TVector<TDeferredAtom> ToDrop;
  2082. const bool IsUser;
  2083. const bool MissingOk;
  2084. TScopedStatePtr Scoped;
  2085. TSourcePtr FakeSource;
  2086. };
  2087. TNodePtr BuildUpsertObjectOperation(TPosition pos, const TString& objectId, const TString& typeId,
  2088. std::map<TString, TDeferredAtom>&& features, const TObjectOperatorContext& context) {
  2089. return new TUpsertObject(pos, objectId, typeId, false, false, std::move(features), std::set<TString>(), context);
  2090. }
  2091. TNodePtr BuildCreateObjectOperation(TPosition pos, const TString& objectId, const TString& typeId,
  2092. bool existingOk, bool replaceIfExists, std::map<TString, TDeferredAtom>&& features, const TObjectOperatorContext& context) {
  2093. return new TCreateObject(pos, objectId, typeId, existingOk, replaceIfExists, std::move(features), std::set<TString>(), context);
  2094. }
  2095. TNodePtr BuildAlterObjectOperation(TPosition pos, const TString& secretId, const TString& typeId,
  2096. std::map<TString, TDeferredAtom>&& features, std::set<TString>&& featuresToReset, const TObjectOperatorContext& context)
  2097. {
  2098. return new TAlterObject(pos, secretId, typeId, false, false, std::move(features), std::move(featuresToReset), context);
  2099. }
  2100. TNodePtr BuildDropObjectOperation(TPosition pos, const TString& secretId, const TString& typeId,
  2101. bool missingOk, std::map<TString, TDeferredAtom>&& options, const TObjectOperatorContext& context)
  2102. {
  2103. return new TDropObject(pos, secretId, typeId, missingOk, false, std::move(options), std::set<TString>(), context);
  2104. }
  2105. TNodePtr BuildDropRoles(TPosition pos, const TString& service, const TDeferredAtom& cluster, const TVector<TDeferredAtom>& toDrop, bool isUser, bool missingOk, TScopedStatePtr scoped) {
  2106. return new TDropRoles(pos, service, cluster, toDrop, isUser, missingOk, scoped);
  2107. }
  2108. class TPermissionsAction final : public TAstListNode {
  2109. public:
  2110. struct TPermissionParameters {
  2111. TString PermissionAction;
  2112. TVector<TDeferredAtom> Permissions;
  2113. TVector<TDeferredAtom> SchemaPaths;
  2114. TVector<TDeferredAtom> RoleNames;
  2115. };
  2116. TPermissionsAction(TPosition pos, const TString& service, const TDeferredAtom& cluster, const TPermissionParameters& parameters, TScopedStatePtr scoped)
  2117. : TAstListNode(pos)
  2118. , Service(service)
  2119. , Cluster(cluster)
  2120. , Parameters(parameters)
  2121. , Scoped(scoped)
  2122. {
  2123. FakeSource = BuildFakeSource(pos);
  2124. scoped->UseCluster(service, cluster);
  2125. }
  2126. bool DoInit(TContext& ctx, ISource* src) override {
  2127. Y_UNUSED(src);
  2128. TNodePtr cluster = Scoped->WrapCluster(Cluster, ctx);
  2129. TNodePtr permissionAction = TDeferredAtom(Pos, Parameters.PermissionAction).Build();
  2130. if (!permissionAction->Init(ctx, FakeSource.Get()) ||
  2131. !cluster->Init(ctx, FakeSource.Get())) {
  2132. return false;
  2133. }
  2134. TVector<TNodePtr> paths;
  2135. paths.reserve(Parameters.SchemaPaths.size());
  2136. for (auto& item : Parameters.SchemaPaths) {
  2137. paths.push_back(item.Build());
  2138. if (!paths.back()->Init(ctx, FakeSource.Get())) {
  2139. return false;
  2140. }
  2141. }
  2142. auto options = Y(Q(Y(Q("paths"), Q(new TAstListNodeImpl(Pos, std::move(paths))))));
  2143. TVector<TNodePtr> permissions;
  2144. permissions.reserve(Parameters.Permissions.size());
  2145. for (auto& item : Parameters.Permissions) {
  2146. permissions.push_back(item.Build());
  2147. if (!permissions.back()->Init(ctx, FakeSource.Get())) {
  2148. return false;
  2149. }
  2150. }
  2151. options = L(options, Q(Y(Q("permissions"), Q(new TAstListNodeImpl(Pos, std::move(permissions))))));
  2152. TVector<TNodePtr> roles;
  2153. roles.reserve(Parameters.RoleNames.size());
  2154. for (auto& item : Parameters.RoleNames) {
  2155. roles.push_back(item.Build());
  2156. if (!roles.back()->Init(ctx, FakeSource.Get())) {
  2157. return false;
  2158. }
  2159. }
  2160. options = L(options, Q(Y(Q("roles"), Q(new TAstListNodeImpl(Pos, std::move(roles))))));
  2161. auto block = Y(Y("let", "sink", Y("DataSink", BuildQuotedAtom(Pos, Service), cluster)));
  2162. block = L(block, Y("let", "world", Y(TString(WriteName), "world", "sink", Y("Key", Q(Y(Q("permission"), Y("String", permissionAction)))), Y("Void"), Q(options))));
  2163. block = L(block, Y("return", ctx.PragmaAutoCommit ? Y(TString(CommitName), "world", "sink") : AstNode("world")));
  2164. Add("block", Q(block));
  2165. return TAstListNode::DoInit(ctx, FakeSource.Get());
  2166. }
  2167. TPtr DoClone() const final {
  2168. return {};
  2169. }
  2170. private:
  2171. const TString Service;
  2172. TDeferredAtom Cluster;
  2173. TPermissionParameters Parameters;
  2174. TScopedStatePtr Scoped;
  2175. TSourcePtr FakeSource;
  2176. };
  2177. TNodePtr BuildGrantPermissions(TPosition pos, const TString& service, const TDeferredAtom& cluster, const TVector<TDeferredAtom>& permissions, const TVector<TDeferredAtom>& schemaPaths, const TVector<TDeferredAtom>& roleNames, TScopedStatePtr scoped) {
  2178. return new TPermissionsAction(pos,
  2179. service,
  2180. cluster,
  2181. {.PermissionAction = "grant",
  2182. .Permissions = permissions,
  2183. .SchemaPaths = schemaPaths,
  2184. .RoleNames = roleNames},
  2185. scoped);
  2186. }
  2187. TNodePtr BuildRevokePermissions(TPosition pos, const TString& service, const TDeferredAtom& cluster, const TVector<TDeferredAtom>& permissions, const TVector<TDeferredAtom>& schemaPaths, const TVector<TDeferredAtom>& roleNames, TScopedStatePtr scoped) {
  2188. return new TPermissionsAction(pos,
  2189. service,
  2190. cluster,
  2191. {.PermissionAction = "revoke",
  2192. .Permissions = permissions,
  2193. .SchemaPaths = schemaPaths,
  2194. .RoleNames = roleNames},
  2195. scoped);
  2196. }
  2197. class TAsyncReplication
  2198. : public TAstListNode
  2199. , protected TObjectOperatorContext
  2200. {
  2201. protected:
  2202. virtual INode::TPtr FillOptions(INode::TPtr options) const = 0;
  2203. public:
  2204. explicit TAsyncReplication(TPosition pos, const TString& id, const TString& mode, const TObjectOperatorContext& context)
  2205. : TAstListNode(pos)
  2206. , TObjectOperatorContext(context)
  2207. , Id(id)
  2208. , Mode(mode)
  2209. {
  2210. }
  2211. bool DoInit(TContext& ctx, ISource* src) override {
  2212. Scoped->UseCluster(ServiceId, Cluster);
  2213. auto keys = Y("Key", Q(Y(Q("replication"), Y("String", BuildQuotedAtom(Pos, Id)))));
  2214. auto options = FillOptions(Y(Q(Y(Q("mode"), Q(Mode)))));
  2215. Add("block", Q(Y(
  2216. Y("let", "sink", Y("DataSink", BuildQuotedAtom(Pos, ServiceId), Scoped->WrapCluster(Cluster, ctx))),
  2217. Y("let", "world", Y(TString(WriteName), "world", "sink", keys, Y("Void"), Q(options))),
  2218. Y("return", ctx.PragmaAutoCommit ? Y(TString(CommitName), "world", "sink") : AstNode("world"))
  2219. )));
  2220. return TAstListNode::DoInit(ctx, src);
  2221. }
  2222. TPtr DoClone() const final {
  2223. return {};
  2224. }
  2225. private:
  2226. const TString Id;
  2227. const TString Mode;
  2228. }; // TAsyncReplication
  2229. class TCreateAsyncReplication final : public TAsyncReplication {
  2230. public:
  2231. explicit TCreateAsyncReplication(TPosition pos, const TString& id,
  2232. std::vector<std::pair<TString, TString>>&& targets,
  2233. std::map<TString, TNodePtr>&& settings,
  2234. const TObjectOperatorContext& context)
  2235. : TAsyncReplication(pos, id, "create", context)
  2236. , Targets(std::move(targets))
  2237. , Settings(std::move(settings))
  2238. {
  2239. }
  2240. protected:
  2241. INode::TPtr FillOptions(INode::TPtr options) const override {
  2242. if (!Targets.empty()) {
  2243. auto targets = Y();
  2244. for (auto&& [remote, local] : Targets) {
  2245. auto target = Y();
  2246. target = L(target, Q(Y(Q("remote"), Q(remote))));
  2247. target = L(target, Q(Y(Q("local"), Q(local))));
  2248. targets = L(targets, Q(target));
  2249. }
  2250. options = L(options, Q(Y(Q("targets"), Q(targets))));
  2251. }
  2252. if (!Settings.empty()) {
  2253. auto settings = Y();
  2254. for (auto&& [k, v] : Settings) {
  2255. if (v) {
  2256. settings = L(settings, Q(Y(BuildQuotedAtom(Pos, k), v)));
  2257. } else {
  2258. settings = L(settings, Q(Y(BuildQuotedAtom(Pos, k))));
  2259. }
  2260. }
  2261. options = L(options, Q(Y(Q("settings"), Q(settings))));
  2262. }
  2263. return options;
  2264. }
  2265. private:
  2266. std::vector<std::pair<TString, TString>> Targets; // (remote, local)
  2267. std::map<TString, TNodePtr> Settings;
  2268. }; // TCreateAsyncReplication
  2269. TNodePtr BuildCreateAsyncReplication(TPosition pos, const TString& id,
  2270. std::vector<std::pair<TString, TString>>&& targets,
  2271. std::map<TString, TNodePtr>&& settings,
  2272. const TObjectOperatorContext& context)
  2273. {
  2274. return new TCreateAsyncReplication(pos, id, std::move(targets), std::move(settings), context);
  2275. }
  2276. class TDropAsyncReplication final : public TAsyncReplication {
  2277. public:
  2278. explicit TDropAsyncReplication(TPosition pos, const TString& id, bool cascade, const TObjectOperatorContext& context)
  2279. : TAsyncReplication(pos, id, cascade ? "dropCascade" : "drop", context)
  2280. {
  2281. }
  2282. protected:
  2283. INode::TPtr FillOptions(INode::TPtr options) const override {
  2284. return options;
  2285. }
  2286. }; // TDropAsyncReplication
  2287. TNodePtr BuildDropAsyncReplication(TPosition pos, const TString& id, bool cascade, const TObjectOperatorContext& context) {
  2288. return new TDropAsyncReplication(pos, id, cascade, context);
  2289. }
  2290. class TAlterAsyncReplication final : public TAsyncReplication {
  2291. public:
  2292. explicit TAlterAsyncReplication(TPosition pos, const TString& id,
  2293. std::map<TString, TNodePtr>&& settings,
  2294. const TObjectOperatorContext& context)
  2295. : TAsyncReplication(pos, id, "alter", context)
  2296. , Settings(std::move(settings))
  2297. {
  2298. }
  2299. protected:
  2300. INode::TPtr FillOptions(INode::TPtr options) const override {
  2301. if (!Settings.empty()) {
  2302. auto settings = Y();
  2303. for (auto&& [k, v] : Settings) {
  2304. if (v) {
  2305. settings = L(settings, Q(Y(BuildQuotedAtom(Pos, k), v)));
  2306. } else {
  2307. settings = L(settings, Q(Y(BuildQuotedAtom(Pos, k))));
  2308. }
  2309. }
  2310. options = L(options, Q(Y(Q("settings"), Q(settings))));
  2311. }
  2312. return options;
  2313. }
  2314. private:
  2315. std::map<TString, TNodePtr> Settings;
  2316. }; // TAlterAsyncReplication
  2317. TNodePtr BuildAlterAsyncReplication(TPosition pos, const TString& id,
  2318. std::map<TString, TNodePtr>&& settings,
  2319. const TObjectOperatorContext& context)
  2320. {
  2321. return new TAlterAsyncReplication(pos, id, std::move(settings), context);
  2322. }
  2323. class TTransfer
  2324. : public TAstListNode
  2325. , protected TObjectOperatorContext
  2326. {
  2327. protected:
  2328. virtual INode::TPtr FillOptions(INode::TPtr options) const = 0;
  2329. public:
  2330. explicit TTransfer(TPosition pos, const TString& id, const TString& mode, const TObjectOperatorContext& context)
  2331. : TAstListNode(pos)
  2332. , TObjectOperatorContext(context)
  2333. , Id(id)
  2334. , Mode(mode)
  2335. {
  2336. }
  2337. bool DoInit(TContext& ctx, ISource* src) override {
  2338. Scoped->UseCluster(ServiceId, Cluster);
  2339. auto keys = Y("Key", Q(Y(Q("transfer"), Y("String", BuildQuotedAtom(Pos, Id)))));
  2340. auto options = FillOptions(Y(Q(Y(Q("mode"), Q(Mode)))));
  2341. Add("block", Q(Y(
  2342. Y("let", "sink", Y("DataSink", BuildQuotedAtom(Pos, ServiceId), Scoped->WrapCluster(Cluster, ctx))),
  2343. Y("let", "world", Y(TString(WriteName), "world", "sink", keys, Y("Void"), Q(options))),
  2344. Y("return", ctx.PragmaAutoCommit ? Y(TString(CommitName), "world", "sink") : AstNode("world"))
  2345. )));
  2346. return TAstListNode::DoInit(ctx, src);
  2347. }
  2348. TPtr DoClone() const final {
  2349. return {};
  2350. }
  2351. private:
  2352. const TString Id;
  2353. const TString Mode;
  2354. }; // TTransfer
  2355. class TCreateTransfer final: public TTransfer {
  2356. public:
  2357. explicit TCreateTransfer(TPosition pos, const TString& id, const TString&& source, const TString&& target,
  2358. const TString&& transformLambda,
  2359. std::map<TString, TNodePtr>&& settings,
  2360. const TObjectOperatorContext& context)
  2361. : TTransfer(pos, id, "create", context)
  2362. , Source(std::move(source))
  2363. , Target(std::move(target))
  2364. , TransformLambda(std::move(transformLambda))
  2365. , Settings(std::move(settings))
  2366. {
  2367. }
  2368. protected:
  2369. INode::TPtr FillOptions(INode::TPtr options) const override {
  2370. options = L(options, Q(Y(Q("source"), Q(Source))));
  2371. options = L(options, Q(Y(Q("target"), Q(Target))));
  2372. options = L(options, Q(Y(Q("transformLambda"), Q(TransformLambda))));
  2373. if (!Settings.empty()) {
  2374. auto settings = Y();
  2375. for (auto&& [k, v] : Settings) {
  2376. if (v) {
  2377. settings = L(settings, Q(Y(BuildQuotedAtom(Pos, k), v)));
  2378. } else {
  2379. settings = L(settings, Q(Y(BuildQuotedAtom(Pos, k))));
  2380. }
  2381. }
  2382. options = L(options, Q(Y(Q("settings"), Q(settings))));
  2383. }
  2384. return options;
  2385. }
  2386. private:
  2387. const TString Source;
  2388. const TString Target;
  2389. const TString TransformLambda;
  2390. std::map<TString, TNodePtr> Settings;
  2391. }; // TCreateTransfer
  2392. TNodePtr BuildCreateTransfer(TPosition pos, const TString& id, const TString&& source, const TString&& target,
  2393. const TString&& transformLambda,
  2394. std::map<TString, TNodePtr>&& settings,
  2395. const TObjectOperatorContext& context)
  2396. {
  2397. return new TCreateTransfer(pos, id, std::move(source), std::move(target), std::move(transformLambda), std::move(settings), context);
  2398. }
  2399. class TDropTransfer final: public TTransfer {
  2400. public:
  2401. explicit TDropTransfer(TPosition pos, const TString& id, bool cascade, const TObjectOperatorContext& context)
  2402. : TTransfer(pos, id, cascade ? "dropCascade" : "drop", context)
  2403. {
  2404. }
  2405. protected:
  2406. INode::TPtr FillOptions(INode::TPtr options) const override {
  2407. return options;
  2408. }
  2409. }; // TDropTransfer
  2410. TNodePtr BuildDropTransfer(TPosition pos, const TString& id, bool cascade, const TObjectOperatorContext& context) {
  2411. return new TDropTransfer(pos, id, cascade, context);
  2412. }
  2413. class TAlterTransfer final: public TTransfer {
  2414. public:
  2415. explicit TAlterTransfer(TPosition pos, const TString& id, std::optional<TString>&& transformLambda,
  2416. std::map<TString, TNodePtr>&& settings,
  2417. const TObjectOperatorContext& context)
  2418. : TTransfer(pos, id, "alter", context)
  2419. , TransformLambda(std::move(transformLambda))
  2420. , Settings(std::move(settings))
  2421. {
  2422. }
  2423. protected:
  2424. INode::TPtr FillOptions(INode::TPtr options) const override {
  2425. options = L(options, Q(Y(Q("transformLambda"), Q(TransformLambda ? TransformLambda.value() : ""))));
  2426. if (!Settings.empty()) {
  2427. auto settings = Y();
  2428. for (auto&& [k, v] : Settings) {
  2429. if (v) {
  2430. settings = L(settings, Q(Y(BuildQuotedAtom(Pos, k), v)));
  2431. } else {
  2432. settings = L(settings, Q(Y(BuildQuotedAtom(Pos, k))));
  2433. }
  2434. }
  2435. options = L(options, Q(Y(Q("settings"), Q(settings))));
  2436. }
  2437. return options;
  2438. }
  2439. private:
  2440. const std::optional<TString> TransformLambda;
  2441. std::map<TString, TNodePtr> Settings;
  2442. }; // TAlterTransfer
  2443. TNodePtr BuildAlterTransfer(TPosition pos, const TString& id, std::optional<TString>&& transformLambda,
  2444. std::map<TString, TNodePtr>&& settings,
  2445. const TObjectOperatorContext& context)
  2446. {
  2447. return new TAlterTransfer(pos, id, std::move(transformLambda), std::move(settings), context);
  2448. }
  2449. static const TMap<EWriteColumnMode, TString> columnModeToStrMapMR {
  2450. {EWriteColumnMode::Default, ""},
  2451. {EWriteColumnMode::Insert, "append"},
  2452. {EWriteColumnMode::Renew, "renew"}
  2453. };
  2454. static const TMap<EWriteColumnMode, TString> columnModeToStrMapStat {
  2455. {EWriteColumnMode::Upsert, "upsert"}
  2456. };
  2457. static const TMap<EWriteColumnMode, TString> columnModeToStrMapKikimr {
  2458. {EWriteColumnMode::Default, ""},
  2459. {EWriteColumnMode::Insert, "insert_abort"},
  2460. {EWriteColumnMode::InsertOrAbort, "insert_abort"},
  2461. {EWriteColumnMode::InsertOrIgnore, "insert_ignore"},
  2462. {EWriteColumnMode::InsertOrRevert, "insert_revert"},
  2463. {EWriteColumnMode::Upsert, "upsert"},
  2464. {EWriteColumnMode::Replace, "replace"},
  2465. {EWriteColumnMode::Update, "update"},
  2466. {EWriteColumnMode::UpdateOn, "update_on"},
  2467. {EWriteColumnMode::Delete, "delete"},
  2468. {EWriteColumnMode::DeleteOn, "delete_on"},
  2469. };
  2470. class TWriteTableNode final : public TAstListNode {
  2471. public:
  2472. TWriteTableNode(TPosition pos, const TString& label, const TTableRef& table, EWriteColumnMode mode,
  2473. TNodePtr options, TScopedStatePtr scoped)
  2474. : TAstListNode(pos)
  2475. , Label(label)
  2476. , Table(table)
  2477. , Mode(mode)
  2478. , Options(options)
  2479. , Scoped(scoped)
  2480. {
  2481. scoped->UseCluster(Table.Service, Table.Cluster);
  2482. }
  2483. bool DoInit(TContext& ctx, ISource* src) override {
  2484. auto keys = Table.Keys->GetTableKeys()->BuildKeys(ctx, ITableKeys::EBuildKeysMode::WRITE);
  2485. if (!keys || !keys->Init(ctx, src)) {
  2486. return false;
  2487. }
  2488. auto getModesMap = [] (const TString& serviceName) -> const TMap<EWriteColumnMode, TString>& {
  2489. if (serviceName == KikimrProviderName || serviceName == YdbProviderName) {
  2490. return columnModeToStrMapKikimr;
  2491. } else if (serviceName == StatProviderName) {
  2492. return columnModeToStrMapStat;
  2493. } else {
  2494. return columnModeToStrMapMR;
  2495. }
  2496. };
  2497. auto options = Y();
  2498. if (Options) {
  2499. if (!Options->Init(ctx, src)) {
  2500. return false;
  2501. }
  2502. options = L(Options);
  2503. }
  2504. if (Mode != EWriteColumnMode::Default) {
  2505. auto modeStr = getModesMap(Table.Service).FindPtr(Mode);
  2506. options->Add(Q(Y(Q("mode"), Q(modeStr ? *modeStr : "unsupported"))));
  2507. }
  2508. Add("block", Q((Y(
  2509. Y("let", "sink", Y("DataSink", BuildQuotedAtom(Pos, Table.Service), Scoped->WrapCluster(Table.Cluster, ctx))),
  2510. Y("let", "world", Y(TString(WriteName), "world", "sink", keys, Label, Q(options))),
  2511. Y("return", ctx.PragmaAutoCommit ? Y(TString(CommitName), "world", "sink") : AstNode("world"))
  2512. ))));
  2513. return TAstListNode::DoInit(ctx, src);
  2514. }
  2515. TPtr DoClone() const final {
  2516. return {};
  2517. }
  2518. private:
  2519. TString Label;
  2520. TTableRef Table;
  2521. EWriteColumnMode Mode;
  2522. TNodePtr Options;
  2523. TScopedStatePtr Scoped;
  2524. };
  2525. TNodePtr BuildWriteTable(TPosition pos, const TString& label, const TTableRef& table, EWriteColumnMode mode, TNodePtr options,
  2526. TScopedStatePtr scoped)
  2527. {
  2528. return new TWriteTableNode(pos, label, table, mode, std::move(options), scoped);
  2529. }
  2530. class TClustersSinkOperationBase : public TAstListNode {
  2531. protected:
  2532. TClustersSinkOperationBase(TPosition pos)
  2533. : TAstListNode(pos)
  2534. {}
  2535. virtual TPtr ProduceOperation() = 0;
  2536. bool DoInit(TContext& ctx, ISource* src) override {
  2537. auto block(Y());
  2538. auto op = ProduceOperation();
  2539. if (!op) {
  2540. return false;
  2541. }
  2542. block = L(block, op);
  2543. block = L(block, Y("return", "world"));
  2544. Add("block", Q(block));
  2545. return TAstListNode::DoInit(ctx, src);
  2546. }
  2547. TPtr DoClone() const final {
  2548. return {};
  2549. }
  2550. };
  2551. class TCommitClustersNode: public TClustersSinkOperationBase {
  2552. public:
  2553. TCommitClustersNode(TPosition pos)
  2554. : TClustersSinkOperationBase(pos)
  2555. {
  2556. }
  2557. TPtr ProduceOperation() override {
  2558. return Y("let", "world", Y("CommitAll!", "world"));
  2559. }
  2560. };
  2561. TNodePtr BuildCommitClusters(TPosition pos) {
  2562. return new TCommitClustersNode(pos);
  2563. }
  2564. class TRollbackClustersNode: public TClustersSinkOperationBase {
  2565. public:
  2566. TRollbackClustersNode(TPosition pos)
  2567. : TClustersSinkOperationBase(pos)
  2568. {
  2569. }
  2570. TPtr ProduceOperation() override {
  2571. return Y("let", "world", Y("CommitAll!", "world", Q(Y(Q(Y(Q("mode"), Q("rollback")))))));
  2572. }
  2573. };
  2574. TNodePtr BuildRollbackClusters(TPosition pos) {
  2575. return new TRollbackClustersNode(pos);
  2576. }
  2577. class TWriteResultNode final : public TAstListNode {
  2578. public:
  2579. TWriteResultNode(TPosition pos, const TString& label, TNodePtr settings)
  2580. : TAstListNode(pos)
  2581. , Label(label)
  2582. , Settings(settings)
  2583. , CommitClusters(BuildCommitClusters(Pos))
  2584. {}
  2585. bool DoInit(TContext& ctx, ISource* src) override {
  2586. auto block(Y(
  2587. Y("let", "result_sink", Y("DataSink", Q(TString(ResultProviderName)))),
  2588. Y("let", "world", Y(TString(WriteName), "world", "result_sink", Y("Key"), Label, Q(Settings)))
  2589. ));
  2590. if (ctx.PragmaAutoCommit) {
  2591. block = L(block, Y("let", "world", CommitClusters));
  2592. }
  2593. block = L(block, Y("return", Y(TString(CommitName), "world", "result_sink")));
  2594. Add("block", Q(block));
  2595. return TAstListNode::DoInit(ctx, src);
  2596. }
  2597. TPtr DoClone() const final {
  2598. return {};
  2599. }
  2600. private:
  2601. TString Label;
  2602. TNodePtr Settings;
  2603. TNodePtr CommitClusters;
  2604. };
  2605. TNodePtr BuildWriteResult(TPosition pos, const TString& label, TNodePtr settings) {
  2606. return new TWriteResultNode(pos, label, settings);
  2607. }
  2608. class TYqlProgramNode : public TAstListNode {
  2609. public:
  2610. TYqlProgramNode(TPosition pos, const TVector<TNodePtr>& blocks, bool topLevel, TScopedStatePtr scoped, bool useSeq)
  2611. : TAstListNode(pos)
  2612. , Blocks(blocks)
  2613. , TopLevel(topLevel)
  2614. , Scoped(scoped)
  2615. , UseSeq(useSeq)
  2616. {}
  2617. bool DoInit(TContext& ctx, ISource* src) override {
  2618. bool hasError = false;
  2619. INode::TPtr currentWorldsHolder;
  2620. INode::TPtr seqNode;
  2621. if (UseSeq) {
  2622. currentWorldsHolder = new TAstListNodeImpl(GetPos());
  2623. seqNode = new TAstListNodeImpl(GetPos());
  2624. seqNode->Add("Seq!","world");
  2625. }
  2626. INode* currentWorlds = UseSeq ? currentWorldsHolder.Get() : this;
  2627. auto flushCurrentWorlds = [&](bool changeSeq, bool finish) {
  2628. currentWorldsHolder->Add(Y("return","world"));
  2629. auto lambda = BuildLambda(GetPos(), Y("world"), Y("block", Q(currentWorldsHolder)));
  2630. seqNode->Add(lambda);
  2631. if (finish) {
  2632. Add(Y("let", "world", seqNode));
  2633. } else {
  2634. currentWorldsHolder = new TAstListNodeImpl(GetPos());
  2635. currentWorlds = currentWorldsHolder.Get();
  2636. }
  2637. if (changeSeq) {
  2638. Add(Y("let", "world", seqNode));
  2639. seqNode = new TAstListNodeImpl(GetPos());
  2640. seqNode->Add("Seq!","world");
  2641. }
  2642. };
  2643. if (TopLevel) {
  2644. for (auto& var: ctx.Variables) {
  2645. if (!var.second.second->Init(ctx, src)) {
  2646. hasError = true;
  2647. continue;
  2648. }
  2649. Add(Y(
  2650. "declare",
  2651. new TAstAtomNodeImpl(var.second.first, var.first, TNodeFlags::ArbitraryContent),
  2652. var.second.second));
  2653. }
  2654. for (const auto& overrideLibrary: ctx.OverrideLibraries) {
  2655. auto node = Y(
  2656. "override_library",
  2657. new TAstAtomNodeImpl(
  2658. std::get<TPosition>(overrideLibrary.second),
  2659. overrideLibrary.first, TNodeFlags::ArbitraryContent
  2660. ));
  2661. Add(node);
  2662. }
  2663. for (const auto& package: ctx.Packages) {
  2664. const auto& [url, urlPosition] = std::get<1U>(package.second);
  2665. auto node = Y(
  2666. "package",
  2667. new TAstAtomNodeImpl(
  2668. std::get<TPosition>(package.second), package.first,
  2669. TNodeFlags::ArbitraryContent
  2670. ),
  2671. new TAstAtomNodeImpl(urlPosition, url, TNodeFlags::ArbitraryContent));
  2672. if (const auto& tokenWithPosition = std::get<2U>(package.second)) {
  2673. const auto& [token, tokenPosition] = *tokenWithPosition;
  2674. node = L(node, new TAstAtomNodeImpl(tokenPosition, token, TNodeFlags::ArbitraryContent));
  2675. }
  2676. Add(node);
  2677. }
  2678. for (const auto& lib : ctx.Libraries) {
  2679. auto node = Y("library", new TAstAtomNodeImpl(std::get<TPosition>(lib.second), lib.first, TNodeFlags::ArbitraryContent));
  2680. if (const auto& first = std::get<1U>(lib.second)) {
  2681. node = L(node, new TAstAtomNodeImpl(first->second, first->first, TNodeFlags::ArbitraryContent));
  2682. if (const auto& second = std::get<2U>(lib.second)) {
  2683. node = L(node, new TAstAtomNodeImpl(second->second, second->first, TNodeFlags::ArbitraryContent));
  2684. }
  2685. }
  2686. Add(node);
  2687. }
  2688. for (const auto& p : ctx.PackageVersions) {
  2689. Add(Y("set_package_version", BuildQuotedAtom(Pos, p.first), BuildQuotedAtom(Pos, ToString(p.second))));
  2690. }
  2691. Add(Y("import", "aggregate_module", BuildQuotedAtom(Pos, "/lib/yql/aggregate.yqls")));
  2692. Add(Y("import", "window_module", BuildQuotedAtom(Pos, "/lib/yql/window.yqls")));
  2693. for (const auto& module : ctx.Settings.ModuleMapping) {
  2694. TString moduleName(module.first + "_module");
  2695. moduleName.to_lower();
  2696. Add(Y("import", moduleName, BuildQuotedAtom(Pos, module.second)));
  2697. }
  2698. for (const auto& moduleAlias : ctx.ImportModuleAliases) {
  2699. Add(Y("import", moduleAlias.second, BuildQuotedAtom(Pos, moduleAlias.first)));
  2700. }
  2701. for (const auto& x : ctx.SimpleUdfs) {
  2702. Add(Y("let", x.second, Y("Udf", BuildQuotedAtom(Pos, x.first))));
  2703. }
  2704. if (!ctx.CompactNamedExprs) {
  2705. for (auto& nodes: Scoped->NamedNodes) {
  2706. if (src || ctx.Exports.contains(nodes.first)) {
  2707. auto& item = nodes.second.front();
  2708. if (!item->Node->Init(ctx, src)) {
  2709. hasError = true;
  2710. continue;
  2711. }
  2712. // Some constants may be used directly by YQL code and need to be translated without reference from SQL AST
  2713. if (item->Node->IsConstant() || ctx.Exports.contains(nodes.first)) {
  2714. Add(Y("let", BuildAtom(item->Node->GetPos(), nodes.first), item->Node));
  2715. }
  2716. }
  2717. }
  2718. }
  2719. if (ctx.Settings.Mode != NSQLTranslation::ESqlMode::LIBRARY) {
  2720. auto configSource = Y("DataSource", BuildQuotedAtom(Pos, TString(ConfigProviderName)));
  2721. auto resultSink = Y("DataSink", BuildQuotedAtom(Pos, TString(ResultProviderName)));
  2722. for (const auto& warningPragma : ctx.WarningPolicy.GetRules()) {
  2723. currentWorlds->Add(Y("let", "world", Y(TString(ConfigureName), "world", configSource,
  2724. BuildQuotedAtom(Pos, "Warning"), BuildQuotedAtom(Pos, warningPragma.GetPattern()),
  2725. BuildQuotedAtom(Pos, to_lower(ToString(warningPragma.GetAction()))))));
  2726. }
  2727. if (ctx.ResultSizeLimit > 0) {
  2728. currentWorlds->Add(Y("let", "world", Y(TString(ConfigureName), "world", resultSink,
  2729. BuildQuotedAtom(Pos, "SizeLimit"), BuildQuotedAtom(Pos, ToString(ctx.ResultSizeLimit)))));
  2730. }
  2731. if (!ctx.PragmaPullUpFlatMapOverJoin) {
  2732. currentWorlds->Add(Y("let", "world", Y(TString(ConfigureName), "world", configSource,
  2733. BuildQuotedAtom(Pos, "DisablePullUpFlatMapOverJoin"))));
  2734. }
  2735. if (ctx.FilterPushdownOverJoinOptionalSide) {
  2736. currentWorlds->Add(Y("let", "world", Y(TString(ConfigureName), "world", configSource,
  2737. BuildQuotedAtom(Pos, "FilterPushdownOverJoinOptionalSide"))));
  2738. }
  2739. if (!ctx.RotateJoinTree) {
  2740. currentWorlds->Add(Y("let", "world", Y(TString(ConfigureName), "world", configSource,
  2741. BuildQuotedAtom(Pos, "RotateJoinTree"), BuildQuotedAtom(Pos, "false"))));
  2742. }
  2743. if (ctx.DiscoveryMode) {
  2744. currentWorlds->Add(Y("let", "world", Y(TString(ConfigureName), "world", configSource,
  2745. BuildQuotedAtom(Pos, "DiscoveryMode"))));
  2746. }
  2747. if (ctx.DqEngineEnable) {
  2748. TString mode = "auto";
  2749. if (ctx.PqReadByRtmrCluster && ctx.PqReadByRtmrCluster != "dq") {
  2750. mode = "disable";
  2751. } else if (ctx.DqEngineForce) {
  2752. mode = "force";
  2753. }
  2754. currentWorlds->Add(Y("let", "world", Y(TString(ConfigureName), "world", configSource,
  2755. BuildQuotedAtom(Pos, "DqEngine"), BuildQuotedAtom(Pos, mode))));
  2756. }
  2757. if (ctx.CostBasedOptimizer) {
  2758. currentWorlds->Add(Y("let", "world", Y(TString(ConfigureName), "world", configSource,
  2759. BuildQuotedAtom(Pos, "CostBasedOptimizer"), BuildQuotedAtom(Pos, ctx.CostBasedOptimizer))));
  2760. }
  2761. if (ctx.JsonQueryReturnsJsonDocument.Defined()) {
  2762. TString pragmaName = "DisableJsonQueryReturnsJsonDocument";
  2763. if (*ctx.JsonQueryReturnsJsonDocument) {
  2764. pragmaName = "JsonQueryReturnsJsonDocument";
  2765. }
  2766. currentWorlds->Add(Y("let", "world", Y(TString(ConfigureName), "world", configSource, BuildQuotedAtom(Pos, pragmaName))));
  2767. }
  2768. if (ctx.OrderedColumns) {
  2769. currentWorlds->Add(Y("let", "world", Y(TString(ConfigureName), "world", configSource,
  2770. BuildQuotedAtom(Pos, "OrderedColumns"))));
  2771. }
  2772. if (ctx.PqReadByRtmrCluster) {
  2773. auto pqSourceAll = Y("DataSource", BuildQuotedAtom(Pos, TString(PqProviderName)), BuildQuotedAtom(Pos, "$all"));
  2774. currentWorlds->Add(Y("let", "world", Y(TString(ConfigureName), "world", pqSourceAll,
  2775. BuildQuotedAtom(Pos, "Attr"), BuildQuotedAtom(Pos, "PqReadByRtmrCluster_"), BuildQuotedAtom(Pos, ctx.PqReadByRtmrCluster))));
  2776. auto rtmrSourceAll = Y("DataSource", BuildQuotedAtom(Pos, TString(RtmrProviderName)), BuildQuotedAtom(Pos, "$all"));
  2777. currentWorlds->Add(Y("let", "world", Y(TString(ConfigureName), "world", rtmrSourceAll,
  2778. BuildQuotedAtom(Pos, "Attr"), BuildQuotedAtom(Pos, "PqReadByRtmrCluster_"), BuildQuotedAtom(Pos, ctx.PqReadByRtmrCluster))));
  2779. if (ctx.PqReadByRtmrCluster != "dq") {
  2780. // set any dynamic settings for particular RTMR cluster for CommitAll!
  2781. auto rtmrSource = Y("DataSource", BuildQuotedAtom(Pos, TString(RtmrProviderName)), BuildQuotedAtom(Pos, ctx.PqReadByRtmrCluster));
  2782. currentWorlds->Add(Y("let", "world", Y(TString(ConfigureName), "world", rtmrSource,
  2783. BuildQuotedAtom(Pos, "Attr"), BuildQuotedAtom(Pos, "Dummy_"), BuildQuotedAtom(Pos, "1"))));
  2784. }
  2785. }
  2786. if (ctx.YsonCastToString.Defined()) {
  2787. const TString pragmaName = *ctx.YsonCastToString ? "YsonCastToString" : "DisableYsonCastToString";
  2788. currentWorlds->Add(Y("let", "world", Y(TString(ConfigureName), "world", configSource, BuildQuotedAtom(Pos, pragmaName))));
  2789. }
  2790. if (ctx.UseBlocks) {
  2791. currentWorlds->Add(Y("let", "world", Y(TString(ConfigureName), "world", configSource, BuildQuotedAtom(Pos, "UseBlocks"))));
  2792. }
  2793. if (ctx.BlockEngineEnable) {
  2794. TString mode = ctx.BlockEngineForce ? "force" : "auto";
  2795. currentWorlds->Add(Y("let", "world", Y(TString(ConfigureName), "world", configSource,
  2796. BuildQuotedAtom(Pos, "BlockEngine"), BuildQuotedAtom(Pos, mode))));
  2797. }
  2798. }
  2799. }
  2800. for (auto& block: Blocks) {
  2801. if (block->SubqueryAlias()) {
  2802. continue;
  2803. }
  2804. if (!block->Init(ctx, nullptr)) {
  2805. hasError = true;
  2806. continue;
  2807. }
  2808. }
  2809. for (const auto& x : Scoped->Local.ExprClusters) {
  2810. auto& data = Scoped->Local.ExprClustersMap[x.Get()];
  2811. auto& node = data.second;
  2812. if (!node->Init(ctx, nullptr)) {
  2813. hasError = true;
  2814. continue;
  2815. }
  2816. Add(Y("let", data.first, node));
  2817. }
  2818. if (UseSeq) {
  2819. flushCurrentWorlds(false, false);
  2820. }
  2821. for (auto& block: Blocks) {
  2822. const auto subqueryAliasPtr = block->SubqueryAlias();
  2823. if (subqueryAliasPtr) {
  2824. if (block->UsedSubquery()) {
  2825. if (UseSeq) {
  2826. flushCurrentWorlds(true, false);
  2827. }
  2828. const auto& ref = block->GetLabel();
  2829. YQL_ENSURE(!ref.empty());
  2830. Add(block);
  2831. currentWorlds->Add(Y("let", "world", Y("Nth", *subqueryAliasPtr, Q("0"))));
  2832. Add(Y("let", ref, Y("Nth", *subqueryAliasPtr, Q("1"))));
  2833. }
  2834. } else {
  2835. const auto& ref = block->GetLabel();
  2836. if (ref) {
  2837. Add(Y("let", ref, block));
  2838. } else {
  2839. currentWorlds->Add(Y("let", "world", block));
  2840. if (UseSeq) {
  2841. flushCurrentWorlds(false, false);
  2842. }
  2843. }
  2844. }
  2845. }
  2846. if (UseSeq) {
  2847. flushCurrentWorlds(false, true);
  2848. }
  2849. if (TopLevel) {
  2850. if (ctx.UniversalAliases) {
  2851. decltype(Nodes) preparedNodes;
  2852. preparedNodes.swap(Nodes);
  2853. for (const auto& [name, node] : ctx.UniversalAliases) {
  2854. Add(Y("let", name, node));
  2855. }
  2856. Nodes.insert(Nodes.end(), preparedNodes.begin(), preparedNodes.end());
  2857. }
  2858. decltype(Nodes) imports;
  2859. for (const auto& [alias, path]: ctx.RequiredModules) {
  2860. imports.push_back(Y("import", alias, BuildQuotedAtom(Pos, path)));
  2861. }
  2862. Nodes.insert(Nodes.begin(), std::make_move_iterator(imports.begin()), std::make_move_iterator(imports.end()));
  2863. for (const auto& symbol: ctx.Exports) {
  2864. if (ctx.CompactNamedExprs) {
  2865. auto node = Scoped->LookupNode(symbol);
  2866. YQL_ENSURE(node);
  2867. if (!node->Init(ctx, src)) {
  2868. hasError = true;
  2869. continue;
  2870. }
  2871. Add(Y("let", BuildAtom(node->GetPos(), symbol), node));
  2872. }
  2873. Add(Y("export", symbol));
  2874. }
  2875. }
  2876. if (!TopLevel || ctx.Settings.Mode != NSQLTranslation::ESqlMode::LIBRARY) {
  2877. Add(Y("return", "world"));
  2878. }
  2879. return !hasError;
  2880. }
  2881. TPtr DoClone() const final {
  2882. return {};
  2883. }
  2884. private:
  2885. TVector<TNodePtr> Blocks;
  2886. const bool TopLevel;
  2887. TScopedStatePtr Scoped;
  2888. const bool UseSeq;
  2889. };
  2890. TNodePtr BuildQuery(TPosition pos, const TVector<TNodePtr>& blocks, bool topLevel, TScopedStatePtr scoped, bool useSeq) {
  2891. return new TYqlProgramNode(pos, blocks, topLevel, scoped, useSeq);
  2892. }
  2893. class TPragmaNode final : public INode {
  2894. public:
  2895. TPragmaNode(TPosition pos, const TString& prefix, const TString& name, const TVector<TDeferredAtom>& values, bool valueDefault)
  2896. : INode(pos)
  2897. , Prefix(prefix)
  2898. , Name(name)
  2899. , Values(values)
  2900. , ValueDefault(valueDefault)
  2901. {
  2902. FakeSource = BuildFakeSource(pos);
  2903. }
  2904. bool DoInit(TContext& ctx, ISource* src) override {
  2905. Y_UNUSED(src);
  2906. TString serviceName;
  2907. TString cluster;
  2908. if (std::find(Providers.cbegin(), Providers.cend(), Prefix) != Providers.cend()) {
  2909. cluster = "$all";
  2910. serviceName = Prefix;
  2911. } else {
  2912. serviceName = *ctx.GetClusterProvider(Prefix, cluster);
  2913. }
  2914. auto datasource = Y("DataSource", BuildQuotedAtom(Pos, serviceName));
  2915. if (Prefix != ConfigProviderName) {
  2916. datasource = L(datasource, BuildQuotedAtom(Pos, cluster));
  2917. }
  2918. Node = Y();
  2919. Node = L(Node, AstNode(TString(ConfigureName)));
  2920. Node = L(Node, AstNode(TString(TStringBuf("world"))));
  2921. Node = L(Node, datasource);
  2922. if (Name == TStringBuf("flags")) {
  2923. for (ui32 i = 0; i < Values.size(); ++i) {
  2924. Node = L(Node, Values[i].Build());
  2925. }
  2926. }
  2927. else if (Name == TStringBuf("AddFileByUrl") || Name == TStringBuf("SetFileOption") || Name == TStringBuf("AddFolderByUrl") || Name == TStringBuf("ImportUdfs") || Name == TStringBuf("SetPackageVersion")) {
  2928. Node = L(Node, BuildQuotedAtom(Pos, Name));
  2929. for (ui32 i = 0; i < Values.size(); ++i) {
  2930. Node = L(Node, Values[i].Build());
  2931. }
  2932. }
  2933. else if (Name == TStringBuf("auth")) {
  2934. Node = L(Node, BuildQuotedAtom(Pos, "Auth"));
  2935. Node = L(Node, Values.empty() ? BuildQuotedAtom(Pos, TString()) : Values.front().Build());
  2936. }
  2937. else {
  2938. Node = L(Node, BuildQuotedAtom(Pos, "Attr"));
  2939. Node = L(Node, BuildQuotedAtom(Pos, Name));
  2940. if (!ValueDefault) {
  2941. Node = L(Node, Values.empty() ? BuildQuotedAtom(Pos, TString()) : Values.front().Build());
  2942. }
  2943. }
  2944. if (!Node->Init(ctx, FakeSource.Get())) {
  2945. return false;
  2946. }
  2947. return true;
  2948. }
  2949. TAstNode* Translate(TContext& ctx) const final {
  2950. return Node->Translate(ctx);
  2951. }
  2952. TPtr DoClone() const final {
  2953. return {};
  2954. }
  2955. private:
  2956. TString Prefix;
  2957. TString Name;
  2958. TVector<TDeferredAtom> Values;
  2959. bool ValueDefault;
  2960. TNodePtr Node;
  2961. TSourcePtr FakeSource;
  2962. };
  2963. TNodePtr BuildPragma(TPosition pos, const TString& prefix, const TString& name, const TVector<TDeferredAtom>& values, bool valueDefault) {
  2964. return new TPragmaNode(pos, prefix, name, values, valueDefault);
  2965. }
  2966. class TSqlLambda final : public TAstListNode {
  2967. public:
  2968. TSqlLambda(TPosition pos, TVector<TString>&& args, TVector<TNodePtr>&& exprSeq)
  2969. : TAstListNode(pos)
  2970. , Args(args)
  2971. , ExprSeq(exprSeq)
  2972. {
  2973. FakeSource = BuildFakeSource(pos);
  2974. }
  2975. bool DoInit(TContext& ctx, ISource* src) override {
  2976. Y_UNUSED(src);
  2977. for (auto& exprPtr: ExprSeq) {
  2978. if (!exprPtr->Init(ctx, FakeSource.Get())) {
  2979. return {};
  2980. }
  2981. }
  2982. YQL_ENSURE(!ExprSeq.empty());
  2983. auto body = Y();
  2984. auto end = ExprSeq.end() - 1;
  2985. for (auto iter = ExprSeq.begin(); iter != end; ++iter) {
  2986. auto exprPtr = *iter;
  2987. const auto& label = exprPtr->GetLabel();
  2988. YQL_ENSURE(label);
  2989. body = L(body, Y("let", label, exprPtr));
  2990. }
  2991. body = Y("block", Q(L(body, Y("return", *end))));
  2992. auto args = Y();
  2993. for (const auto& arg: Args) {
  2994. args = L(args, BuildAtom(GetPos(), arg));
  2995. }
  2996. Add("lambda", Q(args), body);
  2997. return TAstListNode::DoInit(ctx, src);
  2998. }
  2999. TPtr DoClone() const final {
  3000. return new TSqlLambda(Pos, TVector<TString>(Args), CloneContainer(ExprSeq));
  3001. }
  3002. void DoUpdateState() const override {
  3003. State.Set(ENodeState::Const);
  3004. }
  3005. private:
  3006. TVector<TString> Args;
  3007. TVector<TNodePtr> ExprSeq;
  3008. TSourcePtr FakeSource;
  3009. };
  3010. TNodePtr BuildSqlLambda(TPosition pos, TVector<TString>&& args, TVector<TNodePtr>&& exprSeq) {
  3011. return new TSqlLambda(pos, std::move(args), std::move(exprSeq));
  3012. }
  3013. class TWorldIf final : public TAstListNode {
  3014. public:
  3015. TWorldIf(TPosition pos, TNodePtr predicate, TNodePtr thenNode, TNodePtr elseNode, bool isEvaluate)
  3016. : TAstListNode(pos)
  3017. , Predicate(predicate)
  3018. , ThenNode(thenNode)
  3019. , ElseNode(elseNode)
  3020. , IsEvaluate(isEvaluate)
  3021. {
  3022. FakeSource = BuildFakeSource(pos);
  3023. }
  3024. bool DoInit(TContext& ctx, ISource* src) override {
  3025. if (!Predicate->Init(ctx, FakeSource.Get())) {
  3026. return{};
  3027. }
  3028. Add(IsEvaluate ? "EvaluateIf!" : "If!");
  3029. Add("world");
  3030. auto coalesced = Y("Coalesce", Predicate, Y("Bool", Q("false")));
  3031. Add(IsEvaluate ? Y("EvaluateExpr", Y("EnsureType", coalesced, Y("DataType", Q("Bool")))) : coalesced);
  3032. if (!ThenNode->Init(ctx, FakeSource.Get())) {
  3033. return{};
  3034. }
  3035. Add(ThenNode);
  3036. if (ElseNode) {
  3037. if (!ElseNode->Init(ctx, FakeSource.Get())) {
  3038. return{};
  3039. }
  3040. Add(ElseNode);
  3041. }
  3042. return TAstListNode::DoInit(ctx, src);
  3043. }
  3044. TPtr DoClone() const final {
  3045. return new TWorldIf(GetPos(), SafeClone(Predicate), SafeClone(ThenNode), SafeClone(ElseNode), IsEvaluate);
  3046. }
  3047. private:
  3048. TNodePtr Predicate;
  3049. TNodePtr ThenNode;
  3050. TNodePtr ElseNode;
  3051. bool IsEvaluate;
  3052. TSourcePtr FakeSource;
  3053. };
  3054. TNodePtr BuildWorldIfNode(TPosition pos, TNodePtr predicate, TNodePtr thenNode, TNodePtr elseNode, bool isEvaluate) {
  3055. return new TWorldIf(pos, predicate, thenNode, elseNode, isEvaluate);
  3056. }
  3057. class TWorldFor final : public TAstListNode {
  3058. public:
  3059. TWorldFor(TPosition pos, TNodePtr list, TNodePtr bodyNode, TNodePtr elseNode, bool isEvaluate, bool isParallel)
  3060. : TAstListNode(pos)
  3061. , List(list)
  3062. , BodyNode(bodyNode)
  3063. , ElseNode(elseNode)
  3064. , IsEvaluate(isEvaluate)
  3065. , IsParallel(isParallel)
  3066. {
  3067. FakeSource = BuildFakeSource(pos);
  3068. }
  3069. bool DoInit(TContext& ctx, ISource* src) override {
  3070. if (!List->Init(ctx, FakeSource.Get())) {
  3071. return{};
  3072. }
  3073. Add(TStringBuilder() << (IsEvaluate ? "Evaluate": "") << (IsParallel ? "Parallel" : "") << "For!");
  3074. Add("world");
  3075. Add(IsEvaluate ? Y("EvaluateExpr", List) : List);
  3076. if (!BodyNode->Init(ctx, FakeSource.Get())) {
  3077. return{};
  3078. }
  3079. Add(BodyNode);
  3080. if (ElseNode) {
  3081. if (!ElseNode->Init(ctx, FakeSource.Get())) {
  3082. return{};
  3083. }
  3084. Add(ElseNode);
  3085. }
  3086. return TAstListNode::DoInit(ctx, src);
  3087. }
  3088. TPtr DoClone() const final {
  3089. return new TWorldFor(GetPos(), SafeClone(List), SafeClone(BodyNode), SafeClone(ElseNode), IsEvaluate, IsParallel);
  3090. }
  3091. private:
  3092. TNodePtr List;
  3093. TNodePtr BodyNode;
  3094. TNodePtr ElseNode;
  3095. bool IsEvaluate;
  3096. bool IsParallel;
  3097. TSourcePtr FakeSource;
  3098. };
  3099. TNodePtr BuildWorldForNode(TPosition pos, TNodePtr list, TNodePtr bodyNode, TNodePtr elseNode, bool isEvaluate, bool isParallel) {
  3100. return new TWorldFor(pos, list, bodyNode, elseNode, isEvaluate, isParallel);
  3101. }
  3102. class TAnalyzeNode final : public TAstListNode {
  3103. public:
  3104. TAnalyzeNode(TPosition pos, const TString& service, const TDeferredAtom& cluster, const TAnalyzeParams& params, TScopedStatePtr scoped)
  3105. : TAstListNode(pos)
  3106. , Service(service)
  3107. , Cluster(cluster)
  3108. , Params(params)
  3109. , Scoped(scoped)
  3110. {
  3111. FakeSource = BuildFakeSource(pos);
  3112. scoped->UseCluster(Service, Cluster);
  3113. }
  3114. bool DoInit(TContext& ctx, ISource* src) override {
  3115. Y_UNUSED(src);
  3116. auto keys = Params.Table->Keys->GetTableKeys()->BuildKeys(ctx, ITableKeys::EBuildKeysMode::DROP);
  3117. if (!keys || !keys->Init(ctx, FakeSource.Get())) {
  3118. return false;
  3119. }
  3120. auto opts = Y();
  3121. auto columns = Y();
  3122. for (const auto& column: Params.Columns) {
  3123. columns->Add(Q(column));
  3124. }
  3125. opts->Add(Q(Y(Q("columns"), Q(columns))));
  3126. opts->Add(Q(Y(Q("mode"), Q("analyze"))));
  3127. Add("block", Q(Y(
  3128. Y("let", "sink", Y("DataSink", BuildQuotedAtom(Pos, Service), Scoped->WrapCluster(Cluster, ctx))),
  3129. Y("let", "world", Y(TString(WriteName), "world", "sink", keys, Y("Void"), Q(opts))),
  3130. Y("return", ctx.PragmaAutoCommit ? Y(TString(CommitName), "world", "sink") : AstNode("world"))
  3131. )));
  3132. return TAstListNode::DoInit(ctx, FakeSource.Get());
  3133. }
  3134. TPtr DoClone() const final {
  3135. return {};
  3136. }
  3137. private:
  3138. TString Service;
  3139. TDeferredAtom Cluster;
  3140. TAnalyzeParams Params;
  3141. TScopedStatePtr Scoped;
  3142. TSourcePtr FakeSource;
  3143. };
  3144. TNodePtr BuildAnalyze(TPosition pos, const TString& service, const TDeferredAtom& cluster, const TAnalyzeParams& params, TScopedStatePtr scoped) {
  3145. return new TAnalyzeNode(pos, service, cluster, params, scoped);
  3146. }
  3147. class TBaseBackupCollectionNode
  3148. : public TAstListNode
  3149. , public TObjectOperatorContext
  3150. {
  3151. using TBase = TAstListNode;
  3152. public:
  3153. TBaseBackupCollectionNode(
  3154. TPosition pos,
  3155. const TString& prefix,
  3156. const TString& objectId,
  3157. const TObjectOperatorContext& context)
  3158. : TBase(pos)
  3159. , TObjectOperatorContext(context)
  3160. , Prefix(prefix)
  3161. , Id(objectId)
  3162. {}
  3163. bool DoInit(TContext& ctx, ISource* src) final {
  3164. auto keys = Y("Key");
  3165. keys = L(keys, Q(Y(Q("backupCollection"), Y("String", BuildQuotedAtom(Pos, Id)), Y("String", BuildQuotedAtom(Pos, Prefix)))));
  3166. auto options = this->FillOptions(ctx, Y());
  3167. Add("block", Q(Y(
  3168. Y("let", "sink", Y("DataSink", BuildQuotedAtom(Pos, ServiceId), Scoped->WrapCluster(Cluster, ctx))),
  3169. Y("let", "world", Y(TString(WriteName), "world", "sink", keys, Y("Void"), Q(options))),
  3170. Y("return", ctx.PragmaAutoCommit ? Y(TString(CommitName), "world", "sink") : AstNode("world"))
  3171. )));
  3172. return TAstListNode::DoInit(ctx, src);
  3173. }
  3174. virtual INode::TPtr FillOptions(TContext& ctx, INode::TPtr options) const = 0;
  3175. protected:
  3176. TString Prefix;
  3177. TString Id;
  3178. };
  3179. class TCreateBackupCollectionNode
  3180. : public TBaseBackupCollectionNode
  3181. {
  3182. using TBase = TBaseBackupCollectionNode;
  3183. public:
  3184. TCreateBackupCollectionNode(
  3185. TPosition pos,
  3186. const TString& prefix,
  3187. const TString& objectId,
  3188. const TCreateBackupCollectionParameters& params,
  3189. const TObjectOperatorContext& context)
  3190. : TBase(pos, prefix, objectId, context)
  3191. , Params(params)
  3192. {}
  3193. virtual INode::TPtr FillOptions(TContext& ctx, INode::TPtr options) const final {
  3194. options->Add(Q(Y(Q("mode"), Q("create"))));
  3195. auto settings = Y();
  3196. for (auto& [key, value] : Params.Settings) {
  3197. settings->Add(Q(Y(BuildQuotedAtom(Pos, key), Y("String", value.Build()))));
  3198. }
  3199. options->Add(Q(Y(Q("settings"), Q(settings))));
  3200. auto entries = Y();
  3201. if (Params.Database) {
  3202. entries->Add(Q(Y(Q(Y(Q("type"), Q("database"))))));
  3203. }
  3204. for (auto& table : Params.Tables) {
  3205. auto path = ctx.GetPrefixedPath(ServiceId, Cluster, table);
  3206. entries->Add(Q(Y(Q(Y(Q("type"), Q("table"))), Q(Y(Q("path"), path)))));
  3207. }
  3208. options->Add(Q(Y(Q("entries"), Q(entries))));
  3209. return options;
  3210. }
  3211. TPtr DoClone() const final {
  3212. return new TCreateBackupCollectionNode(GetPos(), Prefix, Id, Params, *this);
  3213. }
  3214. private:
  3215. TCreateBackupCollectionParameters Params;
  3216. };
  3217. class TAlterBackupCollectionNode
  3218. : public TBaseBackupCollectionNode
  3219. {
  3220. using TBase = TBaseBackupCollectionNode;
  3221. public:
  3222. TAlterBackupCollectionNode(
  3223. TPosition pos,
  3224. const TString& prefix,
  3225. const TString& objectId,
  3226. const TAlterBackupCollectionParameters& params,
  3227. const TObjectOperatorContext& context)
  3228. : TBase(pos, prefix, objectId, context)
  3229. , Params(params)
  3230. {}
  3231. virtual INode::TPtr FillOptions(TContext& ctx, INode::TPtr options) const final {
  3232. options->Add(Q(Y(Q("mode"), Q("alter"))));
  3233. auto settings = Y();
  3234. for (auto& [key, value] : Params.Settings) {
  3235. settings->Add(Q(Y(BuildQuotedAtom(Pos, key), Y("String", value.Build()))));
  3236. }
  3237. options->Add(Q(Y(Q("settings"), Q(settings))));
  3238. auto resetSettings = Y();
  3239. for (auto& key : Params.SettingsToReset) {
  3240. resetSettings->Add(BuildQuotedAtom(Pos, key));
  3241. }
  3242. options->Add(Q(Y(Q("resetSettings"), Q(resetSettings))));
  3243. auto entries = Y();
  3244. if (Params.Database != TAlterBackupCollectionParameters::EDatabase::Unchanged) {
  3245. entries->Add(Q(Y(Q(Y(Q("type"), Q("database"))), Q(Y(Q("action"), Q(Params.Database == TAlterBackupCollectionParameters::EDatabase::Add ? "add" : "drop"))))));
  3246. }
  3247. for (auto& table : Params.TablesToAdd) {
  3248. auto path = ctx.GetPrefixedPath(ServiceId, Cluster, table);
  3249. entries->Add(Q(Y(Q(Y(Q("type"), Q("table"))), Q(Y(Q("path"), path)), Q(Y(Q("action"), Q("add"))))));
  3250. }
  3251. for (auto& table : Params.TablesToDrop) {
  3252. auto path = ctx.GetPrefixedPath(ServiceId, Cluster, table);
  3253. entries->Add(Q(Y(Q(Y(Q("type"), Q("table"))), Q(Y(Q("path"), path)), Q(Y(Q("action"), Q("drop"))))));
  3254. }
  3255. options->Add(Q(Y(Q("alterEntries"), Q(entries))));
  3256. return options;
  3257. }
  3258. TPtr DoClone() const final {
  3259. return new TAlterBackupCollectionNode(GetPos(), Prefix, Id, Params, *this);
  3260. }
  3261. private:
  3262. TAlterBackupCollectionParameters Params;
  3263. };
  3264. class TDropBackupCollectionNode
  3265. : public TBaseBackupCollectionNode
  3266. {
  3267. using TBase = TBaseBackupCollectionNode;
  3268. public:
  3269. TDropBackupCollectionNode(
  3270. TPosition pos,
  3271. const TString& prefix,
  3272. const TString& objectId,
  3273. const TDropBackupCollectionParameters&,
  3274. const TObjectOperatorContext& context)
  3275. : TBase(pos, prefix, objectId, context)
  3276. {}
  3277. virtual INode::TPtr FillOptions(TContext&, INode::TPtr options) const final {
  3278. options->Add(Q(Y(Q("mode"), Q("drop"))));
  3279. return options;
  3280. }
  3281. TPtr DoClone() const final {
  3282. TDropBackupCollectionParameters params;
  3283. return new TDropBackupCollectionNode(GetPos(), Prefix, Id, params, *this);
  3284. }
  3285. };
  3286. TNodePtr BuildCreateBackupCollection(
  3287. TPosition pos,
  3288. const TString& prefix,
  3289. const TString& id,
  3290. const TCreateBackupCollectionParameters& params,
  3291. const TObjectOperatorContext& context)
  3292. {
  3293. return new TCreateBackupCollectionNode(pos, prefix, id, params, context);
  3294. }
  3295. TNodePtr BuildAlterBackupCollection(
  3296. TPosition pos,
  3297. const TString& prefix,
  3298. const TString& id,
  3299. const TAlterBackupCollectionParameters& params,
  3300. const TObjectOperatorContext& context)
  3301. {
  3302. return new TAlterBackupCollectionNode(pos, prefix, id, params, context);
  3303. }
  3304. TNodePtr BuildDropBackupCollection(
  3305. TPosition pos,
  3306. const TString& prefix,
  3307. const TString& id,
  3308. const TDropBackupCollectionParameters& params,
  3309. const TObjectOperatorContext& context)
  3310. {
  3311. return new TDropBackupCollectionNode(pos, prefix, id, params, context);
  3312. }
  3313. class TBackupNode final
  3314. : public TAstListNode
  3315. , public TObjectOperatorContext
  3316. {
  3317. using TBase = TAstListNode;
  3318. public:
  3319. TBackupNode(
  3320. TPosition pos,
  3321. const TString& prefix,
  3322. const TString& id,
  3323. const TBackupParameters& params,
  3324. const TObjectOperatorContext& context)
  3325. : TBase(pos)
  3326. , TObjectOperatorContext(context)
  3327. , Prefix(prefix)
  3328. , Id(id)
  3329. , Params(params)
  3330. {
  3331. Y_UNUSED(Params);
  3332. }
  3333. bool DoInit(TContext& ctx, ISource* src) override {
  3334. auto keys = Y("Key");
  3335. keys = L(keys, Q(Y(Q("backup"), Y("String", BuildQuotedAtom(Pos, Id)), Y("String", BuildQuotedAtom(Pos, Prefix)))));
  3336. auto opts = Y();
  3337. if (Params.Incremental) {
  3338. opts->Add(Q(Y(Q("mode"), Q("backupIncremental"))));
  3339. } else {
  3340. opts->Add(Q(Y(Q("mode"), Q("backup"))));
  3341. }
  3342. Add("block", Q(Y(
  3343. Y("let", "sink", Y("DataSink", BuildQuotedAtom(Pos, ServiceId), Scoped->WrapCluster(Cluster, ctx))),
  3344. Y("let", "world", Y(TString(WriteName), "world", "sink", keys, Y("Void"), Q(opts))),
  3345. Y("return", ctx.PragmaAutoCommit ? Y(TString(CommitName), "world", "sink") : AstNode("world"))
  3346. )));
  3347. return TAstListNode::DoInit(ctx, src);
  3348. }
  3349. TPtr DoClone() const final {
  3350. return new TBackupNode(GetPos(), Prefix, Id, Params, *this);
  3351. }
  3352. private:
  3353. TString Prefix;
  3354. TString Id;
  3355. TBackupParameters Params;
  3356. };
  3357. TNodePtr BuildBackup(
  3358. TPosition pos,
  3359. const TString& prefix,
  3360. const TString& id,
  3361. const TBackupParameters& params,
  3362. const TObjectOperatorContext& context)
  3363. {
  3364. return new TBackupNode(pos, prefix, id, params, context);
  3365. }
  3366. class TRestoreNode final
  3367. : public TAstListNode
  3368. , public TObjectOperatorContext
  3369. {
  3370. using TBase = TAstListNode;
  3371. public:
  3372. TRestoreNode(
  3373. TPosition pos,
  3374. const TString& prefix,
  3375. const TString& id,
  3376. const TRestoreParameters& params,
  3377. const TObjectOperatorContext& context)
  3378. : TBase(pos)
  3379. , TObjectOperatorContext(context)
  3380. , Prefix(prefix)
  3381. , Id(id)
  3382. , Params(params)
  3383. {
  3384. Y_UNUSED(Params);
  3385. }
  3386. bool DoInit(TContext& ctx, ISource* src) override {
  3387. auto keys = Y("Key");
  3388. keys = L(keys, Q(Y(Q("restore"), Y("String", BuildQuotedAtom(Pos, Id)), Y("String", BuildQuotedAtom(Pos, Prefix)))));
  3389. auto opts = Y();
  3390. opts->Add(Q(Y(Q("mode"), Q("restore"))));
  3391. if (Params.At) {
  3392. opts->Add(Q(Y(Q("at"), BuildQuotedAtom(Pos, Params.At))));
  3393. }
  3394. Add("block", Q(Y(
  3395. Y("let", "sink", Y("DataSink", BuildQuotedAtom(Pos, ServiceId), Scoped->WrapCluster(Cluster, ctx))),
  3396. Y("let", "world", Y(TString(WriteName), "world", "sink", keys, Y("Void"), Q(opts))),
  3397. Y("return", ctx.PragmaAutoCommit ? Y(TString(CommitName), "world", "sink") : AstNode("world"))
  3398. )));
  3399. return TAstListNode::DoInit(ctx, src);
  3400. }
  3401. TPtr DoClone() const final {
  3402. return new TRestoreNode(GetPos(), Prefix, Id, Params, *this);
  3403. }
  3404. private:
  3405. TString Prefix;
  3406. TString Id;
  3407. TRestoreParameters Params;
  3408. };
  3409. TNodePtr BuildRestore(
  3410. TPosition pos,
  3411. const TString& prefix,
  3412. const TString& id,
  3413. const TRestoreParameters& params,
  3414. const TObjectOperatorContext& context)
  3415. {
  3416. return new TRestoreNode(pos, prefix, id, params, context);
  3417. }
  3418. } // namespace NSQLTranslationV1