This is part of the HANA Data Strategy series of BLOGShttps://blogs.sap.com/2019/10/14/sap-hana-data-strategy/ OverviewRecently as customers are moving larger and larger tables from HANA into HANA Data Lake, I am being asked what the fastest way is ...
This is part of the HANA Data Strategy series of BLOGs
https://blogs.sap.com/2019/10/14/sap-hana-data-strategy/
HANA Data Ingestion
Product: SAP HANA 2.0 SP04/SP05 and SAP HANA Cloud
Feature: HANA EIM (SDA/SDI/SDQ), HANA SDS
HANA Data Ingestion
...
This is part of the HANA Data Strategy series of BLOGS
https://blogs.sap.com/2019/10/14/sap-hana-data-strategy/
Business Value
Immediate access to all the enterprise data,
Simple, easy and efficient harmonization of all enterprise data,
Sec...
This is part of the HANA Data Strategy series of BLOGS
https://blogs.sap.com/2019/10/14/sap-hana-data-strategy/
Business Value
Greatly increase HANA data volume while significantly lowering TCO.
Allow customers to do things they never thought p...
This is part of the HANA Data Strategy series of BLOGS
https://blogs.sap.com/2019/10/14/sap-hana-data-strategy/
Why talk about HANA Data Modeling?
HANA data modeling is what drives real-time analytics while lowering the total cost of ownership (TCO...
FYI
Special characters, like . in a table name, require ; syntax:
Example if HANA table name is "DOUG.REGION", you cannot use " in the at statement but you can use ;
create existing local temporary table REGION_PROXY (
R_REGIONKEY bigint ...
Yes, this is perfect for moving mass/large amounts of data but we all need to remember that HANA Cloud TEMP database/workspace is it's small amount of memory. A SELECT * in HANA will pull all of the data out of that nicely compressed columnar table ...
Hi YatendraThis could be part of the solution but it is not a complete solution yet.Have you seen this BLOG on replicating HANA on-prem Classic CVs to HANA Cloud?This would get the CVs into the cloud but no future development unless you go back to th...
So HANA is an in-memory database so when you do select * from table, it is uncompressing data and converting it to a binary format that it sends to IQ. I am guessing there are significantly more than 1,000 rows in this table. How much memory is in ...
In a word, no, not without raising the configuration values on the HANA side or the HDL side. The INSERT using a local temporary is already doing a parallel fetch from HANA (which is only a 4 vCPU configuration - a larger HANA config may run faster....