DataLake IQTable

During this exercise you will create a table in Data Lake

Prerequisite

You have the EXECUTE permission on the REMOTE_EXECUTE procedure of the SAP HANA database relational container schema associated with the data lake IQ relational container (SYSHDL_HDLTA_CONTAINER).
Before you begin, please make sure you have completed the Preparation section of Exercise One.

We will create the table in the datalake with the same structure as the data in Amazon S3 bucket.

Right click on database connection and open the SQL Console by selecting Open SQL Console option:

Copy and paste the below SQL into SQL Console to create a table in the Data lake Relational Container.

Code Snippet

123456789101112131415161718
CALL SYSHDL_HDLTA_CONTAINER.REMOTE_EXECUTE
('CREATE TABLE TBL_XETRA_RE_{placeholder|userid} (
 
ISIN varchar(100) ,
MNEMONIC varchar(100) ,
SECURITYDESC varchar(500) ,
SECURITYTYPE varchar(100) ,
CURRENCY varchar(100) ,
SECURITYID INTEGER ,
aDate DATE ,
aTime TIME ,
STARTPRICE FLOAT ,
MAXPRICE FLOAT ,
MINPRICE FLOAT ,
ENDPRICE FLOAT ,
TRADEDVOLUME FLOAT ,
NUMBEROFTRADES FLOAT
)');

Run the sql by selecting the SQL and click on execute button

Now we will create a Virtual table in SAP HANA Cloud database representing the table created in datalake IQ

In the Remote sources, select remote source “SYSHDL_HDLTA_CONTAINER_SOURCE”. Search for schema “SYSHDL_HDLTA_CONTAINER”

Select the table “TBL_XETRA_RE_” you created in step2 , and create virtual Object.

Select the schema named , and click on Create.

To check the Virtual table , select schema under Tables and you can see the Virtual table that is created in the previous step.

Great! During this exercise you learned how to create a table in Data Lake. Let's move on to the next lesson.

Next lesson