summaryrefslogtreecommitdiffstats
path: root/yql/essentials/sql
Commit message (Collapse)AuthorAgeFilesLines
...
* SeqMode supportudovichenko-r2025-09-181-1/+1
| | | | commit_hash:3d0e8bfb46470e6ac36b0d198cfa1723c665f643
* YQL-20339 expr types & reflectionvvvv2025-09-181-0/+5
| | | | | init commit_hash:1c72053b3785a26cfde418f28a9d054b5a624627
* Add new ASYNC REPLICATION's & TRANSFER's optionsilnaz2025-09-171-0/+8
| | | | | | | Related to - https://github.com/ydb-platform/ydb/pull/25090 - https://github.com/ydb-platform/ydb/issues/21470 commit_hash:f97a6414f95b706c34a086d4431367909dfd35a4
* Pass index settings as iskungasc2025-09-155-160/+46
| | | | | | | It seems that there is no much sence in parsing (vector) index settings, and it is much easier to pass them as is It will much help in adding fulltext index with dozens of parameters commit_hash:ba3d7b32d60f54dd6c8f0aba116a10450455d68b
* YQL-20410 not nullvvvv2025-09-104-11/+48
| | | | commit_hash:95bd6eff4013fca11cfe9e941b6175d93c310bdd
* YQL-20258 sql syntaxvvvv2025-09-081-0/+37
| | | | commit_hash:c2440ce49cc8c7637134ddf8081b32251ff75fd4
* YQL-20381: Infer columns from indirect named nodevitya-smirnov2025-09-082-40/+92
| | | | commit_hash:05d53dee40119ad1d756d90775e6056fbebd99d2
* YQL-20379: Fix columns at subqueryvitya-smirnov2025-09-082-6/+32
| | | | | | | Thet top-level source was always selected for column inference, even when the cursor is at a subquery. commit_hash:c0eb00b98b23d52079aea5eb8d646887ff2fbbdd
* YQL-20297: Make generated regexes more stablevitya-smirnov2025-09-051-1/+5
| | | | commit_hash:b3270397329599800d4e7b1f92b8e0f18e94cfd6
* Move vector index settings validation out of YQL (ydb/issues/22345)kungasc2025-09-056-86/+91
| | | | | | | перенос валидации параметров векторного индекса из YQL в YDB (https://github.com/ydb-platform/ydb/pull/23204), потому что аналогичные создания индекса могут происходить и из SDK, и делать бы две разных валидации было бы странно соответственно тут остался только фикс параметров не того типа, а валидация убрана совсем (все параметры опциональные, провалидируются дальше) commit_hash:5418e97f75e30ea8acdfe99243c0a96ef79be5d1
* YQL-20234: Remove predicate argument on middle aggregation phasesvitya-smirnov2025-09-054-2/+48
| | | | | | | | | | | Also added tests for: - max_by - agg_list - some - avg_if - sum_if - count_if commit_hash:0da4f3b9b1767850e65c914b727bc362cf4cc125
* KIKIMR-23992: Add secret SQL operations – create, alter, dropyurikiselev2025-09-0513-0/+889
| | | | commit_hash:3b74a89e67fd29fdced780847365861db726b687
* YQL-20375: Fix emit of SqlCall external typesimunkin2025-09-045-46/+45
| | | | | Follows up ydb-platform/ydb@34fcd78a2d18d9846fd68339c8e240702857e1e5 commit_hash:08520ae8b837c69f6b92e575882da4786aa441fd
* cleared world dependency for streaming queriesgrigoriypisar2025-09-046-16/+36
| | | | | | | Cleared world dependency for streaming queries Supported top level pragmas for streaming queries commit_hash:2bf7256ee9ff7bba724c76acf7086db014a96afd
* YQL-20367: Add DisableExceptIntersectBefore202503 feature flagvitya-smirnov2025-09-045-3/+29
| | | | commit_hash:a8645f7215087df3309048de31a7f0b3dc802a11
* YQL-20368: Fix unsupported literal error positionvitya-smirnov2025-09-041-8/+8
| | | | commit_hash:7007950c8dbbf4d1c8edd5c275eaea723e29e56b
* fixed parsing for BEGIN / END in streaming queriesgrigoriypisar2025-09-045-29/+135
| | | | | | | Добавлена возможность отключения отложенного применения '\\n' и '\\r' в TextWalker, чтобы позиции генерируемые им были в точности равны позициям токенов от antlr4 лексера: <https://nda.ya.ru/t/hmKq_iWN7JVCGe> commit_hash:15049d23b9ac1232b9e1d281d86d6b51d5822f85
* YQL-20365 ConvertTo, warn for Ensurevvvv2025-09-031-1/+1
| | | | commit_hash:39b07bbc84e57d9df02c839273366c28442b789f
* YQL-20189: Track warnings as errorsvitya-smirnov2025-09-0314-105/+346
| | | | | | There was an issue that a query with warnings as errors passed translation. commit_hash:890d18853380b5ad669e9684553cdb6991827cff
* YQL-20368: Improve unimplemented literal errorvitya-smirnov2025-09-031-5/+21
| | | | commit_hash:27dc40f323e5d24af0dae4f3917a63248f8f8386
* YQL-20345: Disable EXCEPT/INTERSECT/DISTINCT before 2025.03vitya-smirnov2025-09-014-3/+39
| | | | | | Added absent checks for `langVer` at `EXCEPT/INTERSECT/DISTINCT` translation. In next PR will get rid of `.sqlx` file extensions. commit_hash:699cc8f6084d1d2fc19ecd53c35a56496dc842f4
* added sql syntax for CREATE / ALTER DROP STREAMING QUERYgrigoriypisar2025-08-2816-105/+1053
| | | | | | | | | | | | | | | | | | | | | | | Добавлен синтаксис (переиспользован код для inline action): ``` CREATE [OR REPLACE] STREAMING QUERY [IF NOT EXISTS] query_name [WITH ( key = value ... )] AS DO BEGIN ... END DO; ALTER STREAMING QUERY [IF EXISTS] query_name [SET( key = value ... )] [AS DO BEGIN ... END DO]; DROP STREAMING QUERY [IF EXISTS] query_name; ``` commit_hash:29fa6aa7e61ecf45112480fe3c1df8fab542354e
* YQL-19747: Replicate unambiguous columns and fix rankingvitya-smirnov2025-08-268-40/+263
| | | | | | | | | | | | | | This is an improvement for column suggestions. Even when user made a source aliased, he still is able to reference a column with both unqualified and qualified name, so we should provide both candidates, but with unqualified more relevant. As this patch required non trivial `NameResponse` modifications at the `CompletionEngine`, ranking should be used properly, so a way to pass it to the engine was introduced. commit_hash:1f2b90e2f6fbb7d33d9fc8479f43349a7f08c320
* YQL-20332: Fix error messagemaxkovalev2025-08-261-1/+1
| | | | commit_hash:2fc8e4b885a4426726d34aa7a80bb62e747462e2
* Add external_data_channels_count create table feature (SQL part)Anton Romanov2025-08-224-1/+35
| | | | | | | | | | | | | | | Can I use your `soroka` for push YQL part of a new feature for YDB, please? [There](https://github.com/ydb-platform/ydb/pull/21672) is the original PR approved by Fomichev an Puchin which can't be committed directly to YDB github. Type: feature Component: yql --- Co-authored-by: Tony-Romanov [[email protected]] Pull Request resolved: https://github.com/ytsaurus/ytsaurus/pull/1414 commit_hash:c98a7b656a050b09976f22f1470ba0ab5bbb52c2
* Add new option CACHE_MODE in FAMILY settingsivannik2025-08-225-3/+115
| | | | | | RFC: https://nda.ya.ru/t/vPsncOoC7HttdF GitHub Issue: https://github.com/ydb-platform/ydb/issues/18695 commit_hash:96445a9aef7b1fede372b9e4c60b30eb9ef5fdc1
* YQL-19747: Fix YQL autocomplete configurationvitya-smirnov2025-08-191-8/+10
| | | | | | | Fixed an absence of candidates at `$x = (sel#)` as of `subselect_stmt` ignorance at the `YQLConfiguration`. commit_hash:5a841d63fad104599a791953f2f89b8791816115
* YQL-19747: Fix some autocomplete issuesvitya-smirnov2025-08-193-15/+85
| | | | | | - Collect only named node definitions - Fix qualified column after WHERE commit_hash:641977921329199e645c3ac45ae8053a5d0e8b13
* YQL-19747: Infer table path from CONCAT and RANGEvitya-smirnov2025-08-1911-54/+146
| | | | | | | Table function `RANGE` is commonly used, so some support for a table path inference is required. It is done by doing ``` `prefix` || '/' || `min` ```. commit_hash:4bec2a84a0ee8f6d97c92a46b4c4ebc7b41c4d7c
* Watermarks: add time extractor to HoppingWindowvokayndzop2025-08-143-50/+232
| | | | commit_hash:d54496a7e3d9bd72e53ce880691a59490a34a138
* YQL-18878: Introduce Re2::IsValidRegexpatarasov52025-08-141-1/+1
| | | | commit_hash:44a39f94ad6f9407cb9e493cbf88ef28b320586e
* YQL-20257: Parse cluster at simple_table_ref bind_parametervitya-smirnov2025-08-136-32/+63
| | | | | | | - Add `cluster_expr` to `simple_table_ref_core` alternative. - Added `Sql2Yql` unit test with a statement that is not parsed on trunk: https://nda.ya.ru/t/qHRri7r57HK3r2. commit_hash:eada89e88e3f2bc03c47cd22b73ba58b75f20681
* YQL-20301: Map unsupported object to UnknownNamevitya-smirnov2025-08-139-13/+64
| | | | | | | Before this PR unsupported objects were filtered, but we would like to show even unsupported object types as unknown name candidates. commit_hash:04c64b6e28717c3c19927d49eeedec7515608c22
* YQL-19747: Improve and fix completon enginevitya-smirnov2025-08-1214-29/+236
| | | | | | | | | | | | | | Played with the autocomplete and found some issues: https://nda.ya.ru/t/1F9ioYe37HVwo2. - Supported `min`, `max` parameters of the `RANGE` table function, respecting `prefix`. - Supported cluster detecton at table function, e.g. `SELECT * FROM plato.RANGE(Input1, Input2)`. - Made column filter not to ignore a table alias. - Supported keyword as identifier parsing. - Supported `ID_QUOTED` as table alias. commit_hash:9e9ff13373cd059e6a240ddff0ae18f599d790c0
* YQL-20280: Warn on ASSUME ORDER BY usage after UNIONvitya-smirnov2025-08-112-0/+49
| | | | commit_hash:a9c400c784ed04924390abb11509664e6576a3b7
* YQL-19747: Fix an absent column after WHEREvitya-smirnov2025-08-082-2/+13
| | | | | | | | Fixed an absence of column candidates at `SELECT * FROM t WHERE a#`. The problem was with a `IsEnclosing` procedure, because here the cursor is actually outside the `select_core` now there is a `_` symbol that enlarge this rule text range. commit_hash:0b493cb469333f9a37c923b06267ac026efeb2c9
* Watermarks: DDLvokayndzop2025-08-0810-5/+110
| | | | commit_hash:64ad6b4138ee27f474b440e8ef3e07fac1935346
* YQL-19616: Generate Monarch Configurationvitya-smirnov2025-08-061-4/+4
| | | | | | | - Generated Monarch configuration as a JSON. - Added test files for `*.yql` and `*.yqls`. - Screenshots: https://nda.ya.ru/t/LgOjOxcs7HJQyS. commit_hash:dddf747c54780332b54fca3e9e9b52c88a9736f5
* YQL-20247 Depends for Udf functionvvvv2025-08-054-7/+27
| | | | commit_hash:4ee9d9b9079b90e8eeb91accc41d6a3a30c3a18c
* YQL-19747: Partially concat and resolve symbolsvitya-smirnov2025-08-0414-164/+520
| | | | | | | | | - Migrated GetId to a Partial Evaluation function. - Centeralized named expressions collection. - Centeralized query parameters resolution. - Supported symbols resolution and concatenation. - Migrated USE and Columns Syntesis on the evaluation. commit_hash:fafedc4330bcd4a7ab607ae1d5f2691a2f5a60f2
* YQL-19616: Enumerate types DRYvitya-smirnov2025-08-043-39/+18
| | | | | | Replaced hardcoded types list at highlighting generator with core enumerator. commit_hash:68fa56ed73fabf015a2469ed6bcc4e2481456647
* YQL-19616: Generate YQLs syntax highlightingvitya-smirnov2025-08-013-11/+29
| | | | | | | | | | | | | | | | | | | | - Support `Before` at core `TRegexPattern` and `IGenericLexer`. - Added `Name` and `Extension` to core `THighlighting`. - Added `Tighlighting` for `YQLs` factory method. - Added `--language` option to `yql_highlight`. - Added `artifact` targets for `YQLs`. Yes, using the `NSQLTranslation::THighlighting` for `YQLs` is not correct, but much simplier than generalize this infrastructure just for a `YQLs`. So here is a trade-off between development time and a clean code. Results: - JetBrains: https://nda.ya.ru/t/PXkZVE8m7H5wHS. - Vim: https://nda.ya.ru/t/Am-6ZHQa7H5wJi. - TextMate: https://nda.ya.ru/t/wH0YggAf7H5wKw. - yql_highlight: https://nda.ya.ru/t/3FaCm57q7H7QSF. commit_hash:f0e1abb8e7f1b083df531d761b357330bd514cb0
* YQL-19616: Generate YQL TextMate Bundlevitya-smirnov2025-07-312-3/+3
| | | | | | | | - Introduced the Generator interface. - Made tool to generate content to stdout and file. - Supported TextMate Bundle, tested on IDEA and TextMate. - Fixed UDF highlighting priority. commit_hash:bcbc446a2fe58da3400f0e981a03d821b8f77dae
* Added directory to transfer settingstesseract2025-07-311-0/+1
| | | | commit_hash:b807590d35f109a7e66e6f2fc86bed811e1b8890
* Intermediate changesrobot-piglet2025-07-301-2/+3
| | | | commit_hash:c0ba1e1b769fc35ecc458fc556b00493f26f75d1
* YQL-20112: Improve dramatically yql/utils/docsvitya-smirnov2025-07-302-3/+3
| | | | | | | | | Introduced `links.json` format to link names to documentation sections. Implement general links verification framework. Also fixed two small typos. Extended Description: https://nda.ya.ru/t/zR4voivb7GzD9r. commit_hash:e72db0e202b4ff612374c73fa384f70d029f0ef0
* YQL-20216 position aware csse nodesvvvv2025-07-284-1/+9
| | | | commit_hash:78445e1b3b0bb001e0d08b36fd4d31bcd9e37eb4
* YQL-19200: Return persistable expression from FLATTEN BY clauselambda-delta2025-07-253-5/+18
| | | | | Return persistable expression from FLATTEN BY clause commit_hash:8b19ad7f7ddf436c2741f9aa1c5402732fc31f06
* YQL-20165: Refactor pragma handling in TSqlQuerylambda-delta2025-07-252-800/+682
| | | | | | | Move complex handlers to the table Extract simple pragma implementations commit_hash:cb0ebc041fd6d848e9d7701b0ca7db19965cd314
* YQL-20112: Enable type candidates documentationvitya-smirnov2025-07-241-1/+1
| | | | | I forgot to add it. commit_hash:d4829c1e1b23f65d0e8673874e622af4aaa3c9d3