If you’ve ever been stuck wondering how you can move data from your SAP HANA Cloud database to your SAP HANA Data Lake with minimal effort, this is for you. In fact, it might be the fastest way to move your data depending on your data lake’s configur...
This guide will show a methodical approach to finding data with a large memory footprint and calculating the memory storage savings after moving them to disk via Native Storage Extension. The TPC-H dataset is used in this guide.
Assumptions:
Read...
Today, I am building a Node.js application on top of an SAP HANA Data lake IQ instance (HDL). My goal with this application is to accomplish the following three items.Make a connection to my HDL instance Query the database and receive data Upload fil...
With SAP HANA Cloud, hybrid landscapes (on-premise systems working with cloud systems) have become easily attainable. However, when doing aggregate data analysis, it might be easier to have the data of interest in a single source to keep data types a...
Are you a Python enthusiast with an SAP HANA Cloud, data lake? Well, look no further because today I am writing about making a direct connection to an SAP HANA Cloud, data lake with the python package pyodbc. Currently, there are two ways to interact...
Hi Jens,
Thank you for your feedback!
The information on single-level range partitioning can be found here. Here you may find documented,
Range partitioning is similar to hash partitioning in that if the table has a primary key on it, the partition...
Hi Michael,
A page loadable table will not consume more memory than a column loadable table. This is because a page loadable table will exist partly on disk and partly in the buffer cache (in-memory). Where as a column loadable table/partition/colum...
Excellent suggestion! You are correct, the SAP HANA data lake file store does support storing unstructured data. I'll get to work on an example for working with this data.
Thank you for your suggestion,
Daniel
Hi Prince Joel,
From the screenshot provided it looks like our projects are a bit different. Instead of including the srv_api provider in the web module (as you have) I included it in the appRouter module. Then, I added the appRouter resource as a d...