Creating SQL Views in SAP HANA
Tutorials that teach this
- Tutorial View Data Across Both In-Memory and Dynamic Tiering Tables Using a SQL View
- Tutorial Improve Query Performance in a Multi-Source Data Landscape
- Tutorial SAP HANA XS Advanced, Creating an HDI Module
- Tutorial View Data Across Both In-Memory and Dynamic Tiering Tables Using a SQL View
- Tutorial Push Down a Spatial Workload to SAP HANA Database in SAP HANA Cloud
Prerequisites
- Concept SQL Aggregate Functions (COUNT, MAX, GROUP BY)
- Concept Converting Between In-Memory and Extended Tables in SAP HANA Dynamic Tiering
- Concept SAP HANA Multi-Store Tables (In-Memory + Extended Storage)
- Concept Creating HDBTABLE Artifacts in SAP HANA Database Projects
- Concept SAP HANA Database Explorer
- Concept SQL UNION ALL for Combining Table Results
Concepts that build on this
- Concept Querying Points of Interest in SAP HANA Spatial
- Concept SAP HANA Multi-Store Tables (In-Memory + Extended Storage)
- Concept Converting Between In-Memory and Extended Tables in SAP HANA Dynamic Tiering
- Concept Auto ARIMA Time Series Analysis with SAP HANA PAL
- Concept K-Anonymity Algorithm for Data Anonymization
- Concept Multi-Class Logistic Regression with SAP HANA Predictive Analysis Library (PAL)
- Concept Static Result Cache in SAP HANA (ALTER VIEW ADD CACHE RETENTION)
- Concept SQL Date Functions (ADD_YEARS, CURRENT_DATE) for Filtering
- Concept Spatial Aggregation Methods in SAP HANA (ST_UnionAggr, ST_EnvelopeAggr, ST_ConvexHullAggr)
- Concept Creating Anonymized Views in SAP HANA Cloud