Snowflake inc. (20250068605). SCHEMA EVOLUTION SUPPORT IN HYBRID TRANSACTIONAL/ANALYTICAL PROCESSING (HTAP) WORKLOADS
SCHEMA EVOLUTION SUPPORT IN HYBRID TRANSACTIONAL/ANALYTICAL PROCESSING (HTAP) WORKLOADS
Organization Name
Inventor(s)
Christian Diaconu of Kirkland WA (US)
Corbin Mcelhanney of San Mateo CA (US)
Wumengjian Zhu of Cupertino CA (US)
SCHEMA EVOLUTION SUPPORT IN HYBRID TRANSACTIONAL/ANALYTICAL PROCESSING (HTAP) WORKLOADS
This abstract first appeared for US patent application 20250068605 titled 'SCHEMA EVOLUTION SUPPORT IN HYBRID TRANSACTIONAL/ANALYTICAL PROCESSING (HTAP) WORKLOADS
Original Abstract Submitted
the subject technology receives a request to perform a table scan operation of a table. the subject technology determines that the table is being accessed for an initial time. the subject technology populates a columnar cache with data of the table provided by the table scan operation. the subject technology determines a set of schema versions of a set of rows from the data of the table. the subject technology determines schema information of each schema from the set of schema versions. the subject technology generates a result rowset and a second rowset comprising a union of columns that have appeared at least once in each row. the subject technology performs deserialization of rows from the result rowset and the second rowset. the subject technology provides the rows from the result rowset and the second rowset to write to a file in a particular format.