<feed xmlns='http://www.w3.org/2005/Atom'>
<title>ydb/yt/yql/tests/sql/suites/materialize/basic.yql, branch main</title>
<subtitle>Mirror of YDB github repos</subtitle>
<id>https://code.mastervirt.ru/ydb/atom?h=main</id>
<link rel='self' href='https://code.mastervirt.ru/ydb/atom?h=main'/>
<link rel='alternate' type='text/html' href='https://code.mastervirt.ru/ydb/'/>
<updated>2026-07-03T19:55:44Z</updated>
<entry>
<title>Support new Materialize in YT provider</title>
<updated>2026-07-03T19:55:44Z</updated>
<author>
<name>udovichenko-r</name>
<email>udovichenko-r@yandex-team.com</email>
</author>
<published>2026-07-03T19:30:07Z</published>
<link rel='alternate' type='text/html' href='https://code.mastervirt.ru/ydb/commit/?id=2672ec5d53dbb9e6e9fd2e20d92429d8b0ec455b'/>
<id>urn:sha1:2672ec5d53dbb9e6e9fd2e20d92429d8b0ec455b</id>
<content type='text'>
#### 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

&lt;a href="https://nda.ya.ru/t/qa0kX64r7DqvtN"&gt;&lt;font size="2"&gt;Autodescription by Yandex Code Assistant&lt;/font&gt;&lt;/a&gt;
commit_hash:f915520020d0958e0e8c2a298b197564d3298675
</content>
</entry>
</feed>
