SQL UNION ALL for Combining Result Sets
A SQL View in SAP HANA is a virtual table defined by a SQL query that allows developers to retrieve and display data from one or more underlying tables without storing the data separately. Developers use it to view data across both in-memory and Dynamic Tiering tables in a unified result set, as described in the tutorial View Data Across Both In-Memory and Dynamic Tiering Tables Using a SQL View. Similarly, a Calculation View can be created from the union of in-memory and extended tables to combine data sources into a single analytical model.
Tutorials that teach this
Prerequisites
- Concept SAP HANA Dynamic Tiering (Extended Tables) The concept name was not provided, so a precise definition cannot be written. Based on the available sources, the tutorials collectively cover SAP HANA topics such as dynamic tiering, system replication, SQL views, and query plan analysis — but without a specific concept to define, no accurate, source-grounded prose definition can be produced. Please supply the concept name so a proper definition can be written.
- Concept SQL Querying Fundamentals (SELECT, WHERE, GROUP BY, ORDER BY) The concept name was not provided, so a precise definition cannot be generated. Please supply a valid concept name along with supporting source snippets so that an accurate, grounded definition can be written.