This app is an All-In-One package to provide everything to HANA Lovers.
It contains
1. Courses on SAP HANA - Basics, Modeling and Administration
2. Multiple Quizzes on Overview, Modelling, Architeture, and Administration
3. Most popular articles on SAP HANA
4. Series of Interview questions to brushup your HANA skills
This app is an All-In-One package to provide everything to Hadoop Lovers.
It contains
1. Courses on Hadoop - Basics and Advanced
2. Multiple Quizzes on Basics, MapReduce and HDFS
3. Most popular articles on Hadoop
4. Series of Interview questions to brushup your skills
In this article we will learn about SQLScript in SAP HANA.
Introduction of SQLScript:
The SAP HANA database has its own scripting language named SQLScript.
SQLScript is a collection of extensions to Structured Query Language (SQL).
It is used to push down data intensive logic into the database.
The extensions are:
Motivation & Goals of SQLScript:
Improve readability and structure of data-intensive logic
Pass results of one SQL statement to another
Break complex SQL into smaller parts
Bring data-intensive application logic close to database
Declarative Logic including SELECT queries, Built-In CalcEngine functions
Orchestration Logic including DDL, DML, assignment, imperative logic
Container for special-purpose operator logic
R script
Why Do We Need SQLScript?
The main goal of SQLScript is to allow the execution of data intensive calculations inside SAP HANA.
There are two reasons why this is required to achieve the best performance:
Moving calculations to the database layer eliminates the need to transfer large amounts of data from the database to the application
Calculations need to be executed in the database layer to get the maximum benefit from SAP HANA features such as fast column operations, query optimization and parallel execution. If applications fetch data as sets of rows for processing on application level they will not benefit from these features
Advantage of SQLScript:
Compared to plain SQL queries, SQLScript has the following advantages:
I am great fan of this HANA tutorial site. I have followed your documentation of creating procedure and attribute view . But I do get some issues with execution
of the view, I am getting privilege error. As background , I am using HANA Cloud trial instance and logged on with own user account.
Error: SAP DBTech JDBC: [258]: insufficient privilege: Not authorized sap hana trial instance
Please could you help me with necessary instructions to resolve the deadlock.
Although I found this site long back, but recently started practicing on system just following examples given in each chapter, all I can say kudos to the content you people created and continuous updates about new releases helps lot. Hope I’ll contribute in creating/adding new content here.
Hi Jonathan,
Thanks for the post. Very good details. Worked like a charm. Good directions.
I am working on web-ide for Hana and have a requirement where I need to read CSV files from shared point.
Since I am on HANA 2.0 SPS2.So, I thought of going by hdbvirtualtable concept means I can create design time artifacts from web-ide for HANA.
Could you please share your experience on hdbvirtualtable? Also, it would be great if you can put more lights on what would you use in remote source details while creating hdbvirtualtable?
Any input on the this would be appreciated. Thanks, Anyways great write up, your efforts are much appreciated.
Regards,
Kevin Samuel
This is one awesome blog. Much thanks again. Fantastic.
We are busying testing an upgrade to SAP9.3 PL02 and it failed on the 2 schemas we are testing on. This in a test environment.
I want to drop the schemas and try on a more recent backup as I did not get an error code reason or note for the failed upgrade.
However, when I try to drop those schema’s I get an error:
[129]: transaction rolled back by an internal error: Allocation failed; $size$=648; $name$=libhdbrskernal.so; $type$=pool; $inuse_count$=632593; $allocated_size$=530359301
I get the same error by trying to right click on the schema and delete(CASCADE) or if i use the drop schema cascade;
Does anyone know how to resolve this issue?
Anyways great write up, your efforts are much appreciated.
Apps
I am great fan of this HANA tutorial site. I have followed your documentation of creating procedure and attribute view . But I do get some issues with execution
of the view, I am getting privilege error. As background , I am using HANA Cloud trial instance and logged on with own user account.
Error: SAP DBTech JDBC: [258]: insufficient privilege: Not authorized sap hana trial instance
Please could you help me with necessary instructions to resolve the deadlock.
Thanks
Soumen
Hi Laru,
you don’t have access privileges for creating.please check for access privileges once in Users Tab.
Although I found this site long back, but recently started practicing on system just following examples given in each chapter, all I can say kudos to the content you people created and continuous updates about new releases helps lot. Hope I’ll contribute in creating/adding new content here.
Thanks & Regards,
Harish
Hi,
I really love this HANA tutorials.
I want to debug my procedure created in HANA Studio. Can you please tell me how to do that?
Thanks
Ok
Hi Jonathan,
Thanks for the post. Very good details. Worked like a charm. Good directions.
I am working on web-ide for Hana and have a requirement where I need to read CSV files from shared point.
Since I am on HANA 2.0 SPS2.So, I thought of going by hdbvirtualtable concept means I can create design time artifacts from web-ide for HANA.
Could you please share your experience on hdbvirtualtable? Also, it would be great if you can put more lights on what would you use in remote source details while creating hdbvirtualtable?
Any input on the this would be appreciated. Thanks, Anyways great write up, your efforts are much appreciated.
Regards,
Kevin Samuel
Hello There,
This is one awesome blog. Much thanks again. Fantastic.
We are busying testing an upgrade to SAP9.3 PL02 and it failed on the 2 schemas we are testing on. This in a test environment.
I want to drop the schemas and try on a more recent backup as I did not get an error code reason or note for the failed upgrade.
However, when I try to drop those schema’s I get an error:
[129]: transaction rolled back by an internal error: Allocation failed; $size$=648; $name$=libhdbrskernal.so; $type$=pool; $inuse_count$=632593; $allocated_size$=530359301
I get the same error by trying to right click on the schema and delete(CASCADE) or if i use the drop schema cascade;
Does anyone know how to resolve this issue?
Anyways great write up, your efforts are much appreciated.
Kind Regards,
Irene Hynes