summaryrefslogtreecommitdiffstats
path: root/yt/yql/tests/sql/suites/materialize
Commit message (Collapse)AuthorAgeFilesLines
* Change `MATERIALIZE` grammar to exclude `WITH` statement ambiguityudovichenko-r11 days4-9/+3
| | | | | | | | | | | | | #### Change MATERIALIZE grammar to exclude hints ambiguity ✎ - Restructured the MATERIALIZE statement grammar to resolve ambiguity between table hints and cluster specification by reordering clauses to place hints after the target cluster - Updated minimum language version requirement for the MATERIALIZE feature to 2026.02 - Modified format tests and validation logic to align with the new grammar structure - Added tests for single and multiple hints to ensure proper parsing and handling - Updated canonical test outputs to reflect the new syntax order with hints positioned after the INTO clause and before the ON clause <a href="https://nda.ya.ru/t/qa0kX64r7DqvtN"><font size="2">Autodescription by Yandex Code Assistant</font></a> commit_hash:0dec4e34cf45e66962a8e8884c6cee893ad3dfb2
* Support PruneUnusedColumns in Materializeudovichenko-r12 days16-13/+15
| | | | | | | | | | | | | | #### Support PruneUnusedColumns in Materialize ✎ - Adds support for the `prune_unused_columns` setting in Materialize operations, enabling optimization to remove unused columns from materialized tables - Extends the YtProvider to recognize and validate the new PruneUnusedColumns setting for both Materialize and Persist operations - Implements optimizations to handle column pruning in Materialize operations, including handling ExtractMembers over Materialize cases and multi-usage scenarios - Updates physical finalizing logic to properly handle Persist operations with PruneUnusedColumns setting - Adds new test cases to verify the functionality of column pruning in Materialize operations with various filtering scenarios - Modifies existing tests to reflect changes in behavior and ensure compatibility with the new optimization feature <a href="https://nda.ya.ru/t/qa0kX64r7DqvtN"><font size="2">Autodescription by Yandex Code Assistant</font></a> commit_hash:83c18981b8767ac2b789c1b1ae81aaa1ee164a92
* Support new Materialize in YT providerudovichenko-r2026-07-0332-0/+125
#### Support new Materialize in YT provider ✎ - Introduces support for the new Materialize operation in the YT provider, enabling materialization of query results into temporary tables - Adds necessary type annotations, constraint handling, and execution logic for the Materialize operation - Implements physical optimization rules to properly handle Materialize operations during query planning - Includes support for persisting materialized data and integrating it with existing YT operations like Publish and Copy - Adds comprehensive test cases covering various Materialize scenarios including basic usage, sorting preservation, and complex expressions - Updates SQL-to-YQL conversion to properly handle Materialize statements in SQL queries <a href="https://nda.ya.ru/t/qa0kX64r7DqvtN"><font size="2">Autodescription by Yandex Code Assistant</font></a> commit_hash:f915520020d0958e0e8c2a298b197564d3298675