query.cpp 145 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782178317841785178617871788178917901791179217931794179517961797179817991800180118021803180418051806180718081809181018111812181318141815181618171818181918201821182218231824182518261827182818291830183118321833183418351836183718381839184018411842184318441845184618471848184918501851185218531854185518561857185818591860186118621863186418651866186718681869187018711872187318741875187618771878187918801881188218831884188518861887188818891890189118921893189418951896189718981899190019011902190319041905190619071908190919101911191219131914191519161917191819191920192119221923192419251926192719281929193019311932193319341935193619371938193919401941194219431944194519461947194819491950195119521953195419551956195719581959196019611962196319641965196619671968196919701971197219731974197519761977197819791980198119821983198419851986198719881989199019911992199319941995199619971998199920002001200220032004200520062007200820092010201120122013201420152016201720182019202020212022202320242025202620272028202920302031203220332034203520362037203820392040204120422043204420452046204720482049205020512052205320542055205620572058205920602061206220632064206520662067206820692070207120722073207420752076207720782079208020812082208320842085208620872088208920902091209220932094209520962097209820992100210121022103210421052106210721082109211021112112211321142115211621172118211921202121212221232124212521262127212821292130213121322133213421352136213721382139214021412142214321442145214621472148214921502151215221532154215521562157215821592160216121622163216421652166216721682169217021712172217321742175217621772178217921802181218221832184218521862187218821892190219121922193219421952196219721982199220022012202220322042205220622072208220922102211221222132214221522162217221822192220222122222223222422252226222722282229223022312232223322342235223622372238223922402241224222432244224522462247224822492250225122522253225422552256225722582259226022612262226322642265226622672268226922702271227222732274227522762277227822792280228122822283228422852286228722882289229022912292229322942295229622972298229923002301230223032304230523062307230823092310231123122313231423152316231723182319232023212322232323242325232623272328232923302331233223332334233523362337233823392340234123422343234423452346234723482349235023512352235323542355235623572358235923602361236223632364236523662367236823692370237123722373237423752376237723782379238023812382238323842385238623872388238923902391239223932394239523962397239823992400240124022403240424052406240724082409241024112412241324142415241624172418241924202421242224232424242524262427242824292430243124322433243424352436243724382439244024412442244324442445244624472448244924502451245224532454245524562457245824592460246124622463246424652466246724682469247024712472247324742475247624772478247924802481248224832484248524862487248824892490249124922493249424952496249724982499250025012502250325042505250625072508250925102511251225132514251525162517251825192520252125222523252425252526252725282529253025312532253325342535253625372538253925402541254225432544254525462547254825492550255125522553255425552556255725582559256025612562256325642565256625672568256925702571257225732574257525762577257825792580258125822583258425852586258725882589259025912592259325942595259625972598259926002601260226032604260526062607260826092610261126122613261426152616261726182619262026212622262326242625262626272628262926302631263226332634263526362637263826392640264126422643264426452646264726482649265026512652265326542655265626572658265926602661266226632664266526662667266826692670267126722673267426752676267726782679268026812682268326842685268626872688268926902691269226932694269526962697269826992700270127022703270427052706270727082709271027112712271327142715271627172718271927202721272227232724272527262727272827292730273127322733273427352736273727382739274027412742274327442745274627472748274927502751275227532754275527562757275827592760276127622763276427652766276727682769277027712772277327742775277627772778277927802781278227832784278527862787278827892790279127922793279427952796279727982799280028012802280328042805280628072808280928102811281228132814281528162817281828192820282128222823282428252826282728282829283028312832283328342835283628372838283928402841284228432844284528462847284828492850285128522853285428552856285728582859286028612862286328642865286628672868286928702871287228732874287528762877287828792880288128822883288428852886288728882889289028912892289328942895289628972898289929002901290229032904290529062907290829092910291129122913291429152916291729182919292029212922292329242925292629272928292929302931293229332934293529362937293829392940294129422943294429452946294729482949295029512952295329542955295629572958295929602961296229632964296529662967296829692970297129722973297429752976297729782979298029812982298329842985298629872988298929902991299229932994299529962997299829993000300130023003300430053006300730083009301030113012301330143015301630173018301930203021302230233024302530263027302830293030303130323033303430353036303730383039304030413042304330443045304630473048304930503051305230533054305530563057305830593060306130623063306430653066306730683069307030713072307330743075307630773078307930803081308230833084308530863087308830893090309130923093309430953096309730983099310031013102310331043105310631073108310931103111311231133114311531163117311831193120312131223123312431253126312731283129313031313132313331343135313631373138313931403141314231433144314531463147314831493150315131523153315431553156315731583159316031613162316331643165316631673168316931703171317231733174317531763177317831793180318131823183318431853186318731883189319031913192319331943195319631973198319932003201320232033204320532063207320832093210321132123213321432153216321732183219322032213222322332243225322632273228322932303231323232333234323532363237323832393240324132423243324432453246324732483249325032513252325332543255325632573258325932603261326232633264326532663267326832693270327132723273327432753276327732783279328032813282328332843285328632873288328932903291329232933294329532963297329832993300330133023303330433053306330733083309331033113312331333143315331633173318331933203321332233233324332533263327332833293330333133323333333433353336333733383339334033413342334333443345334633473348334933503351335233533354335533563357335833593360336133623363336433653366336733683369337033713372337333743375337633773378337933803381338233833384338533863387338833893390339133923393339433953396339733983399340034013402340334043405340634073408340934103411341234133414341534163417341834193420342134223423342434253426342734283429343034313432343334343435343634373438343934403441344234433444344534463447344834493450345134523453345434553456345734583459346034613462346334643465346634673468346934703471347234733474347534763477347834793480348134823483348434853486348734883489349034913492349334943495349634973498349935003501350235033504350535063507350835093510351135123513351435153516351735183519352035213522352335243525352635273528352935303531353235333534353535363537353835393540354135423543354435453546354735483549355035513552355335543555355635573558355935603561356235633564356535663567356835693570357135723573357435753576357735783579358035813582358335843585358635873588358935903591359235933594359535963597359835993600360136023603360436053606360736083609361036113612361336143615361636173618361936203621362236233624362536263627362836293630363136323633363436353636363736383639364036413642364336443645364636473648364936503651365236533654365536563657365836593660366136623663366436653666366736683669367036713672367336743675367636773678367936803681368236833684368536863687368836893690369136923693369436953696369736983699370037013702370337043705370637073708370937103711371237133714371537163717371837193720372137223723372437253726372737283729373037313732373337343735373637373738373937403741374237433744374537463747374837493750375137523753375437553756375737583759376037613762376337643765376637673768376937703771377237733774377537763777377837793780378137823783378437853786378737883789379037913792379337943795379637973798379938003801380238033804380538063807380838093810381138123813381438153816381738183819382038213822382338243825382638273828382938303831383238333834383538363837383838393840384138423843384438453846384738483849385038513852385338543855385638573858385938603861386238633864386538663867386838693870387138723873387438753876387738783879388038813882388338843885388638873888388938903891389238933894389538963897389838993900390139023903390439053906390739083909391039113912391339143915391639173918391939203921392239233924392539263927392839293930393139323933393439353936393739383939394039413942394339443945394639473948394939503951395239533954395539563957395839593960396139623963396439653966396739683969397039713972397339743975397639773978397939803981398239833984398539863987398839893990
  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. if (ctx.Engine) {
  2799. Add(Y("let", "world", Y(TString(ConfigureName), "world", configSource,
  2800. BuildQuotedAtom(Pos, "Engine"), BuildQuotedAtom(Pos, *ctx.Engine))));
  2801. }
  2802. }
  2803. }
  2804. for (auto& block: Blocks) {
  2805. if (block->SubqueryAlias()) {
  2806. continue;
  2807. }
  2808. if (!block->Init(ctx, nullptr)) {
  2809. hasError = true;
  2810. continue;
  2811. }
  2812. }
  2813. for (const auto& x : Scoped->Local.ExprClusters) {
  2814. auto& data = Scoped->Local.ExprClustersMap[x.Get()];
  2815. auto& node = data.second;
  2816. if (!node->Init(ctx, nullptr)) {
  2817. hasError = true;
  2818. continue;
  2819. }
  2820. Add(Y("let", data.first, node));
  2821. }
  2822. if (UseSeq) {
  2823. flushCurrentWorlds(false, false);
  2824. }
  2825. for (auto& block: Blocks) {
  2826. const auto subqueryAliasPtr = block->SubqueryAlias();
  2827. if (subqueryAliasPtr) {
  2828. if (block->UsedSubquery()) {
  2829. if (UseSeq) {
  2830. flushCurrentWorlds(true, false);
  2831. }
  2832. const auto& ref = block->GetLabel();
  2833. YQL_ENSURE(!ref.empty());
  2834. Add(block);
  2835. currentWorlds->Add(Y("let", "world", Y("Nth", *subqueryAliasPtr, Q("0"))));
  2836. Add(Y("let", ref, Y("Nth", *subqueryAliasPtr, Q("1"))));
  2837. }
  2838. } else {
  2839. const auto& ref = block->GetLabel();
  2840. if (ref) {
  2841. Add(Y("let", ref, block));
  2842. } else {
  2843. currentWorlds->Add(Y("let", "world", block));
  2844. if (UseSeq) {
  2845. flushCurrentWorlds(false, false);
  2846. }
  2847. }
  2848. }
  2849. }
  2850. if (UseSeq) {
  2851. flushCurrentWorlds(false, true);
  2852. }
  2853. if (TopLevel) {
  2854. if (ctx.UniversalAliases) {
  2855. decltype(Nodes) preparedNodes;
  2856. preparedNodes.swap(Nodes);
  2857. for (const auto& [name, node] : ctx.UniversalAliases) {
  2858. Add(Y("let", name, node));
  2859. }
  2860. Nodes.insert(Nodes.end(), preparedNodes.begin(), preparedNodes.end());
  2861. }
  2862. decltype(Nodes) imports;
  2863. for (const auto& [alias, path]: ctx.RequiredModules) {
  2864. imports.push_back(Y("import", alias, BuildQuotedAtom(Pos, path)));
  2865. }
  2866. Nodes.insert(Nodes.begin(), std::make_move_iterator(imports.begin()), std::make_move_iterator(imports.end()));
  2867. for (const auto& symbol: ctx.Exports) {
  2868. if (ctx.CompactNamedExprs) {
  2869. auto node = Scoped->LookupNode(symbol);
  2870. YQL_ENSURE(node);
  2871. if (!node->Init(ctx, src)) {
  2872. hasError = true;
  2873. continue;
  2874. }
  2875. Add(Y("let", BuildAtom(node->GetPos(), symbol), node));
  2876. }
  2877. Add(Y("export", symbol));
  2878. }
  2879. }
  2880. if (!TopLevel || ctx.Settings.Mode != NSQLTranslation::ESqlMode::LIBRARY) {
  2881. Add(Y("return", "world"));
  2882. }
  2883. return !hasError;
  2884. }
  2885. TPtr DoClone() const final {
  2886. return {};
  2887. }
  2888. private:
  2889. TVector<TNodePtr> Blocks;
  2890. const bool TopLevel;
  2891. TScopedStatePtr Scoped;
  2892. const bool UseSeq;
  2893. };
  2894. TNodePtr BuildQuery(TPosition pos, const TVector<TNodePtr>& blocks, bool topLevel, TScopedStatePtr scoped, bool useSeq) {
  2895. return new TYqlProgramNode(pos, blocks, topLevel, scoped, useSeq);
  2896. }
  2897. class TPragmaNode final : public INode {
  2898. public:
  2899. TPragmaNode(TPosition pos, const TString& prefix, const TString& name, const TVector<TDeferredAtom>& values, bool valueDefault)
  2900. : INode(pos)
  2901. , Prefix(prefix)
  2902. , Name(name)
  2903. , Values(values)
  2904. , ValueDefault(valueDefault)
  2905. {
  2906. FakeSource = BuildFakeSource(pos);
  2907. }
  2908. bool DoInit(TContext& ctx, ISource* src) override {
  2909. Y_UNUSED(src);
  2910. TString serviceName;
  2911. TString cluster;
  2912. if (std::find(Providers.cbegin(), Providers.cend(), Prefix) != Providers.cend()) {
  2913. cluster = "$all";
  2914. serviceName = Prefix;
  2915. } else {
  2916. serviceName = *ctx.GetClusterProvider(Prefix, cluster);
  2917. }
  2918. auto datasource = Y("DataSource", BuildQuotedAtom(Pos, serviceName));
  2919. if (Prefix != ConfigProviderName) {
  2920. datasource = L(datasource, BuildQuotedAtom(Pos, cluster));
  2921. }
  2922. Node = Y();
  2923. Node = L(Node, AstNode(TString(ConfigureName)));
  2924. Node = L(Node, AstNode(TString(TStringBuf("world"))));
  2925. Node = L(Node, datasource);
  2926. if (Name == TStringBuf("flags")) {
  2927. for (ui32 i = 0; i < Values.size(); ++i) {
  2928. Node = L(Node, Values[i].Build());
  2929. }
  2930. }
  2931. else if (Name == TStringBuf("AddFileByUrl") || Name == TStringBuf("SetFileOption") || Name == TStringBuf("AddFolderByUrl") || Name == TStringBuf("ImportUdfs") || Name == TStringBuf("SetPackageVersion")) {
  2932. Node = L(Node, BuildQuotedAtom(Pos, Name));
  2933. for (ui32 i = 0; i < Values.size(); ++i) {
  2934. Node = L(Node, Values[i].Build());
  2935. }
  2936. }
  2937. else if (Name == TStringBuf("auth")) {
  2938. Node = L(Node, BuildQuotedAtom(Pos, "Auth"));
  2939. Node = L(Node, Values.empty() ? BuildQuotedAtom(Pos, TString()) : Values.front().Build());
  2940. }
  2941. else {
  2942. Node = L(Node, BuildQuotedAtom(Pos, "Attr"));
  2943. Node = L(Node, BuildQuotedAtom(Pos, Name));
  2944. if (!ValueDefault) {
  2945. Node = L(Node, Values.empty() ? BuildQuotedAtom(Pos, TString()) : Values.front().Build());
  2946. }
  2947. }
  2948. if (!Node->Init(ctx, FakeSource.Get())) {
  2949. return false;
  2950. }
  2951. return true;
  2952. }
  2953. TAstNode* Translate(TContext& ctx) const final {
  2954. return Node->Translate(ctx);
  2955. }
  2956. TPtr DoClone() const final {
  2957. return {};
  2958. }
  2959. private:
  2960. TString Prefix;
  2961. TString Name;
  2962. TVector<TDeferredAtom> Values;
  2963. bool ValueDefault;
  2964. TNodePtr Node;
  2965. TSourcePtr FakeSource;
  2966. };
  2967. TNodePtr BuildPragma(TPosition pos, const TString& prefix, const TString& name, const TVector<TDeferredAtom>& values, bool valueDefault) {
  2968. return new TPragmaNode(pos, prefix, name, values, valueDefault);
  2969. }
  2970. class TSqlLambda final : public TAstListNode {
  2971. public:
  2972. TSqlLambda(TPosition pos, TVector<TString>&& args, TVector<TNodePtr>&& exprSeq)
  2973. : TAstListNode(pos)
  2974. , Args(args)
  2975. , ExprSeq(exprSeq)
  2976. {
  2977. FakeSource = BuildFakeSource(pos);
  2978. }
  2979. bool DoInit(TContext& ctx, ISource* src) override {
  2980. Y_UNUSED(src);
  2981. for (auto& exprPtr: ExprSeq) {
  2982. if (!exprPtr->Init(ctx, FakeSource.Get())) {
  2983. return {};
  2984. }
  2985. }
  2986. YQL_ENSURE(!ExprSeq.empty());
  2987. auto body = Y();
  2988. auto end = ExprSeq.end() - 1;
  2989. for (auto iter = ExprSeq.begin(); iter != end; ++iter) {
  2990. auto exprPtr = *iter;
  2991. const auto& label = exprPtr->GetLabel();
  2992. YQL_ENSURE(label);
  2993. body = L(body, Y("let", label, exprPtr));
  2994. }
  2995. body = Y("block", Q(L(body, Y("return", *end))));
  2996. auto args = Y();
  2997. for (const auto& arg: Args) {
  2998. args = L(args, BuildAtom(GetPos(), arg));
  2999. }
  3000. Add("lambda", Q(args), body);
  3001. return TAstListNode::DoInit(ctx, src);
  3002. }
  3003. TPtr DoClone() const final {
  3004. return new TSqlLambda(Pos, TVector<TString>(Args), CloneContainer(ExprSeq));
  3005. }
  3006. void DoUpdateState() const override {
  3007. State.Set(ENodeState::Const);
  3008. }
  3009. private:
  3010. TVector<TString> Args;
  3011. TVector<TNodePtr> ExprSeq;
  3012. TSourcePtr FakeSource;
  3013. };
  3014. TNodePtr BuildSqlLambda(TPosition pos, TVector<TString>&& args, TVector<TNodePtr>&& exprSeq) {
  3015. return new TSqlLambda(pos, std::move(args), std::move(exprSeq));
  3016. }
  3017. class TWorldIf final : public TAstListNode {
  3018. public:
  3019. TWorldIf(TPosition pos, TNodePtr predicate, TNodePtr thenNode, TNodePtr elseNode, bool isEvaluate)
  3020. : TAstListNode(pos)
  3021. , Predicate(predicate)
  3022. , ThenNode(thenNode)
  3023. , ElseNode(elseNode)
  3024. , IsEvaluate(isEvaluate)
  3025. {
  3026. FakeSource = BuildFakeSource(pos);
  3027. }
  3028. bool DoInit(TContext& ctx, ISource* src) override {
  3029. if (!Predicate->Init(ctx, FakeSource.Get())) {
  3030. return{};
  3031. }
  3032. Add(IsEvaluate ? "EvaluateIf!" : "If!");
  3033. Add("world");
  3034. auto coalesced = Y("Coalesce", Predicate, Y("Bool", Q("false")));
  3035. Add(IsEvaluate ? Y("EvaluateExpr", Y("EnsureType", coalesced, Y("DataType", Q("Bool")))) : coalesced);
  3036. if (!ThenNode->Init(ctx, FakeSource.Get())) {
  3037. return{};
  3038. }
  3039. Add(ThenNode);
  3040. if (ElseNode) {
  3041. if (!ElseNode->Init(ctx, FakeSource.Get())) {
  3042. return{};
  3043. }
  3044. Add(ElseNode);
  3045. }
  3046. return TAstListNode::DoInit(ctx, src);
  3047. }
  3048. TPtr DoClone() const final {
  3049. return new TWorldIf(GetPos(), SafeClone(Predicate), SafeClone(ThenNode), SafeClone(ElseNode), IsEvaluate);
  3050. }
  3051. private:
  3052. TNodePtr Predicate;
  3053. TNodePtr ThenNode;
  3054. TNodePtr ElseNode;
  3055. bool IsEvaluate;
  3056. TSourcePtr FakeSource;
  3057. };
  3058. TNodePtr BuildWorldIfNode(TPosition pos, TNodePtr predicate, TNodePtr thenNode, TNodePtr elseNode, bool isEvaluate) {
  3059. return new TWorldIf(pos, predicate, thenNode, elseNode, isEvaluate);
  3060. }
  3061. class TWorldFor final : public TAstListNode {
  3062. public:
  3063. TWorldFor(TPosition pos, TNodePtr list, TNodePtr bodyNode, TNodePtr elseNode, bool isEvaluate, bool isParallel)
  3064. : TAstListNode(pos)
  3065. , List(list)
  3066. , BodyNode(bodyNode)
  3067. , ElseNode(elseNode)
  3068. , IsEvaluate(isEvaluate)
  3069. , IsParallel(isParallel)
  3070. {
  3071. FakeSource = BuildFakeSource(pos);
  3072. }
  3073. bool DoInit(TContext& ctx, ISource* src) override {
  3074. if (!List->Init(ctx, FakeSource.Get())) {
  3075. return{};
  3076. }
  3077. Add(TStringBuilder() << (IsEvaluate ? "Evaluate": "") << (IsParallel ? "Parallel" : "") << "For!");
  3078. Add("world");
  3079. Add(IsEvaluate ? Y("EvaluateExpr", List) : List);
  3080. if (!BodyNode->Init(ctx, FakeSource.Get())) {
  3081. return{};
  3082. }
  3083. Add(BodyNode);
  3084. if (ElseNode) {
  3085. if (!ElseNode->Init(ctx, FakeSource.Get())) {
  3086. return{};
  3087. }
  3088. Add(ElseNode);
  3089. }
  3090. return TAstListNode::DoInit(ctx, src);
  3091. }
  3092. TPtr DoClone() const final {
  3093. return new TWorldFor(GetPos(), SafeClone(List), SafeClone(BodyNode), SafeClone(ElseNode), IsEvaluate, IsParallel);
  3094. }
  3095. private:
  3096. TNodePtr List;
  3097. TNodePtr BodyNode;
  3098. TNodePtr ElseNode;
  3099. bool IsEvaluate;
  3100. bool IsParallel;
  3101. TSourcePtr FakeSource;
  3102. };
  3103. TNodePtr BuildWorldForNode(TPosition pos, TNodePtr list, TNodePtr bodyNode, TNodePtr elseNode, bool isEvaluate, bool isParallel) {
  3104. return new TWorldFor(pos, list, bodyNode, elseNode, isEvaluate, isParallel);
  3105. }
  3106. class TAnalyzeNode final : public TAstListNode {
  3107. public:
  3108. TAnalyzeNode(TPosition pos, const TString& service, const TDeferredAtom& cluster, const TAnalyzeParams& params, TScopedStatePtr scoped)
  3109. : TAstListNode(pos)
  3110. , Service(service)
  3111. , Cluster(cluster)
  3112. , Params(params)
  3113. , Scoped(scoped)
  3114. {
  3115. FakeSource = BuildFakeSource(pos);
  3116. scoped->UseCluster(Service, Cluster);
  3117. }
  3118. bool DoInit(TContext& ctx, ISource* src) override {
  3119. Y_UNUSED(src);
  3120. auto keys = Params.Table->Keys->GetTableKeys()->BuildKeys(ctx, ITableKeys::EBuildKeysMode::DROP);
  3121. if (!keys || !keys->Init(ctx, FakeSource.Get())) {
  3122. return false;
  3123. }
  3124. auto opts = Y();
  3125. auto columns = Y();
  3126. for (const auto& column: Params.Columns) {
  3127. columns->Add(Q(column));
  3128. }
  3129. opts->Add(Q(Y(Q("columns"), Q(columns))));
  3130. opts->Add(Q(Y(Q("mode"), Q("analyze"))));
  3131. Add("block", Q(Y(
  3132. Y("let", "sink", Y("DataSink", BuildQuotedAtom(Pos, Service), Scoped->WrapCluster(Cluster, ctx))),
  3133. Y("let", "world", Y(TString(WriteName), "world", "sink", keys, Y("Void"), Q(opts))),
  3134. Y("return", ctx.PragmaAutoCommit ? Y(TString(CommitName), "world", "sink") : AstNode("world"))
  3135. )));
  3136. return TAstListNode::DoInit(ctx, FakeSource.Get());
  3137. }
  3138. TPtr DoClone() const final {
  3139. return {};
  3140. }
  3141. private:
  3142. TString Service;
  3143. TDeferredAtom Cluster;
  3144. TAnalyzeParams Params;
  3145. TScopedStatePtr Scoped;
  3146. TSourcePtr FakeSource;
  3147. };
  3148. TNodePtr BuildAnalyze(TPosition pos, const TString& service, const TDeferredAtom& cluster, const TAnalyzeParams& params, TScopedStatePtr scoped) {
  3149. return new TAnalyzeNode(pos, service, cluster, params, scoped);
  3150. }
  3151. class TBaseBackupCollectionNode
  3152. : public TAstListNode
  3153. , public TObjectOperatorContext
  3154. {
  3155. using TBase = TAstListNode;
  3156. public:
  3157. TBaseBackupCollectionNode(
  3158. TPosition pos,
  3159. const TString& prefix,
  3160. const TString& objectId,
  3161. const TObjectOperatorContext& context)
  3162. : TBase(pos)
  3163. , TObjectOperatorContext(context)
  3164. , Prefix(prefix)
  3165. , Id(objectId)
  3166. {}
  3167. bool DoInit(TContext& ctx, ISource* src) final {
  3168. auto keys = Y("Key");
  3169. keys = L(keys, Q(Y(Q("backupCollection"), Y("String", BuildQuotedAtom(Pos, Id)), Y("String", BuildQuotedAtom(Pos, Prefix)))));
  3170. auto options = this->FillOptions(ctx, Y());
  3171. Add("block", Q(Y(
  3172. Y("let", "sink", Y("DataSink", BuildQuotedAtom(Pos, ServiceId), Scoped->WrapCluster(Cluster, ctx))),
  3173. Y("let", "world", Y(TString(WriteName), "world", "sink", keys, Y("Void"), Q(options))),
  3174. Y("return", ctx.PragmaAutoCommit ? Y(TString(CommitName), "world", "sink") : AstNode("world"))
  3175. )));
  3176. return TAstListNode::DoInit(ctx, src);
  3177. }
  3178. virtual INode::TPtr FillOptions(TContext& ctx, INode::TPtr options) const = 0;
  3179. protected:
  3180. TString Prefix;
  3181. TString Id;
  3182. };
  3183. class TCreateBackupCollectionNode
  3184. : public TBaseBackupCollectionNode
  3185. {
  3186. using TBase = TBaseBackupCollectionNode;
  3187. public:
  3188. TCreateBackupCollectionNode(
  3189. TPosition pos,
  3190. const TString& prefix,
  3191. const TString& objectId,
  3192. const TCreateBackupCollectionParameters& params,
  3193. const TObjectOperatorContext& context)
  3194. : TBase(pos, prefix, objectId, context)
  3195. , Params(params)
  3196. {}
  3197. virtual INode::TPtr FillOptions(TContext& ctx, INode::TPtr options) const final {
  3198. options->Add(Q(Y(Q("mode"), Q("create"))));
  3199. auto settings = Y();
  3200. for (auto& [key, value] : Params.Settings) {
  3201. settings->Add(Q(Y(BuildQuotedAtom(Pos, key), Y("String", value.Build()))));
  3202. }
  3203. options->Add(Q(Y(Q("settings"), Q(settings))));
  3204. auto entries = Y();
  3205. if (Params.Database) {
  3206. entries->Add(Q(Y(Q(Y(Q("type"), Q("database"))))));
  3207. }
  3208. for (auto& table : Params.Tables) {
  3209. auto path = ctx.GetPrefixedPath(ServiceId, Cluster, table);
  3210. entries->Add(Q(Y(Q(Y(Q("type"), Q("table"))), Q(Y(Q("path"), path)))));
  3211. }
  3212. options->Add(Q(Y(Q("entries"), Q(entries))));
  3213. return options;
  3214. }
  3215. TPtr DoClone() const final {
  3216. return new TCreateBackupCollectionNode(GetPos(), Prefix, Id, Params, *this);
  3217. }
  3218. private:
  3219. TCreateBackupCollectionParameters Params;
  3220. };
  3221. class TAlterBackupCollectionNode
  3222. : public TBaseBackupCollectionNode
  3223. {
  3224. using TBase = TBaseBackupCollectionNode;
  3225. public:
  3226. TAlterBackupCollectionNode(
  3227. TPosition pos,
  3228. const TString& prefix,
  3229. const TString& objectId,
  3230. const TAlterBackupCollectionParameters& params,
  3231. const TObjectOperatorContext& context)
  3232. : TBase(pos, prefix, objectId, context)
  3233. , Params(params)
  3234. {}
  3235. virtual INode::TPtr FillOptions(TContext& ctx, INode::TPtr options) const final {
  3236. options->Add(Q(Y(Q("mode"), Q("alter"))));
  3237. auto settings = Y();
  3238. for (auto& [key, value] : Params.Settings) {
  3239. settings->Add(Q(Y(BuildQuotedAtom(Pos, key), Y("String", value.Build()))));
  3240. }
  3241. options->Add(Q(Y(Q("settings"), Q(settings))));
  3242. auto resetSettings = Y();
  3243. for (auto& key : Params.SettingsToReset) {
  3244. resetSettings->Add(BuildQuotedAtom(Pos, key));
  3245. }
  3246. options->Add(Q(Y(Q("resetSettings"), Q(resetSettings))));
  3247. auto entries = Y();
  3248. if (Params.Database != TAlterBackupCollectionParameters::EDatabase::Unchanged) {
  3249. entries->Add(Q(Y(Q(Y(Q("type"), Q("database"))), Q(Y(Q("action"), Q(Params.Database == TAlterBackupCollectionParameters::EDatabase::Add ? "add" : "drop"))))));
  3250. }
  3251. for (auto& table : Params.TablesToAdd) {
  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("add"))))));
  3254. }
  3255. for (auto& table : Params.TablesToDrop) {
  3256. auto path = ctx.GetPrefixedPath(ServiceId, Cluster, table);
  3257. entries->Add(Q(Y(Q(Y(Q("type"), Q("table"))), Q(Y(Q("path"), path)), Q(Y(Q("action"), Q("drop"))))));
  3258. }
  3259. options->Add(Q(Y(Q("alterEntries"), Q(entries))));
  3260. return options;
  3261. }
  3262. TPtr DoClone() const final {
  3263. return new TAlterBackupCollectionNode(GetPos(), Prefix, Id, Params, *this);
  3264. }
  3265. private:
  3266. TAlterBackupCollectionParameters Params;
  3267. };
  3268. class TDropBackupCollectionNode
  3269. : public TBaseBackupCollectionNode
  3270. {
  3271. using TBase = TBaseBackupCollectionNode;
  3272. public:
  3273. TDropBackupCollectionNode(
  3274. TPosition pos,
  3275. const TString& prefix,
  3276. const TString& objectId,
  3277. const TDropBackupCollectionParameters&,
  3278. const TObjectOperatorContext& context)
  3279. : TBase(pos, prefix, objectId, context)
  3280. {}
  3281. virtual INode::TPtr FillOptions(TContext&, INode::TPtr options) const final {
  3282. options->Add(Q(Y(Q("mode"), Q("drop"))));
  3283. return options;
  3284. }
  3285. TPtr DoClone() const final {
  3286. TDropBackupCollectionParameters params;
  3287. return new TDropBackupCollectionNode(GetPos(), Prefix, Id, params, *this);
  3288. }
  3289. };
  3290. TNodePtr BuildCreateBackupCollection(
  3291. TPosition pos,
  3292. const TString& prefix,
  3293. const TString& id,
  3294. const TCreateBackupCollectionParameters& params,
  3295. const TObjectOperatorContext& context)
  3296. {
  3297. return new TCreateBackupCollectionNode(pos, prefix, id, params, context);
  3298. }
  3299. TNodePtr BuildAlterBackupCollection(
  3300. TPosition pos,
  3301. const TString& prefix,
  3302. const TString& id,
  3303. const TAlterBackupCollectionParameters& params,
  3304. const TObjectOperatorContext& context)
  3305. {
  3306. return new TAlterBackupCollectionNode(pos, prefix, id, params, context);
  3307. }
  3308. TNodePtr BuildDropBackupCollection(
  3309. TPosition pos,
  3310. const TString& prefix,
  3311. const TString& id,
  3312. const TDropBackupCollectionParameters& params,
  3313. const TObjectOperatorContext& context)
  3314. {
  3315. return new TDropBackupCollectionNode(pos, prefix, id, params, context);
  3316. }
  3317. class TBackupNode final
  3318. : public TAstListNode
  3319. , public TObjectOperatorContext
  3320. {
  3321. using TBase = TAstListNode;
  3322. public:
  3323. TBackupNode(
  3324. TPosition pos,
  3325. const TString& prefix,
  3326. const TString& id,
  3327. const TBackupParameters& params,
  3328. const TObjectOperatorContext& context)
  3329. : TBase(pos)
  3330. , TObjectOperatorContext(context)
  3331. , Prefix(prefix)
  3332. , Id(id)
  3333. , Params(params)
  3334. {
  3335. Y_UNUSED(Params);
  3336. }
  3337. bool DoInit(TContext& ctx, ISource* src) override {
  3338. auto keys = Y("Key");
  3339. keys = L(keys, Q(Y(Q("backup"), Y("String", BuildQuotedAtom(Pos, Id)), Y("String", BuildQuotedAtom(Pos, Prefix)))));
  3340. auto opts = Y();
  3341. if (Params.Incremental) {
  3342. opts->Add(Q(Y(Q("mode"), Q("backupIncremental"))));
  3343. } else {
  3344. opts->Add(Q(Y(Q("mode"), Q("backup"))));
  3345. }
  3346. Add("block", Q(Y(
  3347. Y("let", "sink", Y("DataSink", BuildQuotedAtom(Pos, ServiceId), Scoped->WrapCluster(Cluster, ctx))),
  3348. Y("let", "world", Y(TString(WriteName), "world", "sink", keys, Y("Void"), Q(opts))),
  3349. Y("return", ctx.PragmaAutoCommit ? Y(TString(CommitName), "world", "sink") : AstNode("world"))
  3350. )));
  3351. return TAstListNode::DoInit(ctx, src);
  3352. }
  3353. TPtr DoClone() const final {
  3354. return new TBackupNode(GetPos(), Prefix, Id, Params, *this);
  3355. }
  3356. private:
  3357. TString Prefix;
  3358. TString Id;
  3359. TBackupParameters Params;
  3360. };
  3361. TNodePtr BuildBackup(
  3362. TPosition pos,
  3363. const TString& prefix,
  3364. const TString& id,
  3365. const TBackupParameters& params,
  3366. const TObjectOperatorContext& context)
  3367. {
  3368. return new TBackupNode(pos, prefix, id, params, context);
  3369. }
  3370. class TRestoreNode final
  3371. : public TAstListNode
  3372. , public TObjectOperatorContext
  3373. {
  3374. using TBase = TAstListNode;
  3375. public:
  3376. TRestoreNode(
  3377. TPosition pos,
  3378. const TString& prefix,
  3379. const TString& id,
  3380. const TRestoreParameters& params,
  3381. const TObjectOperatorContext& context)
  3382. : TBase(pos)
  3383. , TObjectOperatorContext(context)
  3384. , Prefix(prefix)
  3385. , Id(id)
  3386. , Params(params)
  3387. {
  3388. Y_UNUSED(Params);
  3389. }
  3390. bool DoInit(TContext& ctx, ISource* src) override {
  3391. auto keys = Y("Key");
  3392. keys = L(keys, Q(Y(Q("restore"), Y("String", BuildQuotedAtom(Pos, Id)), Y("String", BuildQuotedAtom(Pos, Prefix)))));
  3393. auto opts = Y();
  3394. opts->Add(Q(Y(Q("mode"), Q("restore"))));
  3395. if (Params.At) {
  3396. opts->Add(Q(Y(Q("at"), BuildQuotedAtom(Pos, Params.At))));
  3397. }
  3398. Add("block", Q(Y(
  3399. Y("let", "sink", Y("DataSink", BuildQuotedAtom(Pos, ServiceId), Scoped->WrapCluster(Cluster, ctx))),
  3400. Y("let", "world", Y(TString(WriteName), "world", "sink", keys, Y("Void"), Q(opts))),
  3401. Y("return", ctx.PragmaAutoCommit ? Y(TString(CommitName), "world", "sink") : AstNode("world"))
  3402. )));
  3403. return TAstListNode::DoInit(ctx, src);
  3404. }
  3405. TPtr DoClone() const final {
  3406. return new TRestoreNode(GetPos(), Prefix, Id, Params, *this);
  3407. }
  3408. private:
  3409. TString Prefix;
  3410. TString Id;
  3411. TRestoreParameters Params;
  3412. };
  3413. TNodePtr BuildRestore(
  3414. TPosition pos,
  3415. const TString& prefix,
  3416. const TString& id,
  3417. const TRestoreParameters& params,
  3418. const TObjectOperatorContext& context)
  3419. {
  3420. return new TRestoreNode(pos, prefix, id, params, context);
  3421. }
  3422. } // namespace NSQLTranslationV1