Hello Community!!In this series of blog posts I will share with you all how to connect to SAP HANA IQ store from a CAP (Cloud Application Programming Model) JAVA application.This will be series of blogs containing following topics:
HANA IQ store is a columnar store based relational database on top of HANA data lake file system. It is used for data warehousing and analytics.
Table can be created in IQ store using CREATE TABLE sql command. In this example I will be creating a table called KPI under schema DEMANDPLANNER.Login to your BTP account. Goto your sub account ->Dev spaces -> SAP HANA cloudGoto your Hana Datalake instance and click on Actions-> Open in SAP HANA Database Explorer. Enter the login credentials for your HDB user. This will open HANA database explorer.
In HANA database explorer right click on your HANA IQ instance and select 'Open SQL Console'.
In SQL console add the following CREATE TABLE statement and run it to create the table KPI.
In order to load data into the table from Azure Blob store following SQL statement needs to be executed in SQL console.Load Table <table name>(<field1>,<field2>)from '<Azureblobstore URL>'CONNECTION_STRING 'DefaultEndpointsProtocol=https;AccountName=<storageaccountname>;AccountKey=<StorageAccountKey>;EndpointSuffix=core.windows.net'escapes offformat parquet;commit;
Please note that the number and order of columns in your parquet file in blob store should be same as that of table in IQ store.
In this blog I have tried to explain how to create tables in HANA IQ store and load data into it from Azure bob Store. In the next blog we will see Creation of HANA Virtual Tables in HANA database Instance and connecting to IQ store using remote so.... Hope you found this blog useful, see you in the next one.If you have further questions, feel free to leave me a comment here. Best Regards,Swati.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.