SapHanaTutorial.Com HOME     Learning-Materials Interview-Q&A Certifications Quiz Online-Courses Forum Jobs Trendz FAQs  
     Explore The World of Hana With Us     
About Us
Contact Us
 Apps
X
HANA App
>>>
Hadoop App
>>>
Tutorial App on SAP HANA
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
Tutorial App on Hadoop
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
Apps
HANA App
Hadoop App
';
Search
Stay Connected
Search Topics
Topic Index
+
-
SQLScript
+
-
Tables in SAP HANA
+
-
Procedure
+
-
Examples of Procedure
SQLScript - A New Avatar of SQL in HANA


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:

SAP HANA Modeling

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

SAP HANA SQLScript

Advantage of SQLScript:

Compared to plain SQL queries, SQLScript has the following advantages:

SAP HANA Modeling

Continue reading:


Support us by sharing this article.



Explore More
Close X
Close X

7 thoughts on “SAP HANA SQLScript

  1. soumen laru says:

    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

  2. Harish says:

    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

  3. Hari Kumar says:

    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

  4. kevin says:

    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

  5. Irene Hynes says:

    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

Leave a Reply

Your email address will not be published. Required fields are marked *

Current day month ye@r *

 © 2017 : saphanatutorial.com, All rights reserved.  Privacy Policy