
- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Getting memory error while doing UNION in SAP HANA
The SQL UNION clause/operator is used to combine the results of two or more SELECT statements without returning any duplicate rows.
To use this UNION clause, each SELECT statement must have
- The same number of columns selected
- The same number of column expressions
- The same data type and
- Have them in the same order
While performing UNION you need to note that what data it will bring. To perform UNION ALL you need to ensure that views should be fully materialized.
To know more about SAP HANA Modeling, you can refer SAP Guide:
- Related Questions & Answers
- Getting error while using schema in SAP HANA Modeling
- Getting error while extracting data from SAP
- Getting error message while using SAP Scripting Tool
- Error while connection SAP HANA with .NET
- Getting more rows returned than expected on doing SUM in SAP HANA
- Getting an error on creating an Index in SAP HANA
- Getting error message: Scalar type not allowed in SAP HANA
- In-memory read in SAP HANA
- Getting an error- license key couldn’t be installed in SAP HANA
- Getting error while running SAP oData service “HTTP Open failed: PLUGIN_NOT_ACTIVE”
- Getting an error while previewing swf file from XML data in SAP Dashboard Designer
- Getting statistics details of SAP HANA system
- Getting age of tracefiles in SAP HANA database
- Getting License details, hardware key in SAP HANA
- Getting a syntax error unknown fields in SAP ABAP
Advertisements