Do you understand the following SQL statements in SAP HANA Platform?

Set 1:

CREATE DATABASE LV_DB0 SYSTEM USER PASSWORD Manager1;

ALTER SYSTEM STOP DATABASE LV_DB0;

DROP DATABASE LV_DB0;

Set 2:

CREATE TABLE “TIERING_DEMO”.“SalesOrderItems_WARM” (

     “ID”        integer NOT NULL

   ,“LineID”        smallint NOT NULL

   ,“ProductID”  integer NOT NULL

   ,“Quantity”    integer NOT NULL

      ,“ShipDate”    date NOT NULL

      , PRIMARY KEY (“ID”,“LineID”)

   ) USING EXTENDED STORAGE;

  ALTER TABLE “TIERING_DEMO”.“TEST_DT” USING extended storage;

Set 3:

CREATE INPUT STREAM MACHINEDATA SCHEMA (

         MACHINEID string ,

         EVENT_TIME msdate ,

         EVENT_NAME string ,

         EVENT_DESCRIPTION string ,

         EVENT_VALUEstring ) ;

CREATE REFERENCE
MACHINE_REF_reference1

     SCHEMA (

         MACHINEID string ,

         MACHINETYPE string ,

         MAX_TEMP integer ,

         MIN_TEMP integer ,

         LOCATION string ,

         TEMP_UNIT string )

         PRIMARY KEY ( MACHINEID )

         PROPERTIES service = ‘hdbdmm165’ ,

         source = ‘MACHINE_REF’ ,

        sourceSchema = ‘DMM165_0’ ,

        service = ‘hdbdmm165’ ;

CREATE OUTPUT STREAM ACTIVITY_HIST

AS SELECT *

FROM MACHINEDATA WHERE
MACHINEDATA.EVENT_NAME =
‘DOOR’ ;

ATTACH OUTPUT ADAPTER HANA_Output1 TYPE hana_out TO ACTIVITY_HIST

PROPERTIES service = ‘hdbdmm165’,

       sourceSchema = ‘DMM165_60’,

       table = ‘ACTIVITY_HIST’;

CREATE OUTPUT WINDOW AVG_TEMP

PRIMARY KEY DEDUCED

AS SELECT

  EVENTS.MACHINEID MACHINEID ,

       LAST( EVENTS.EVENT_TIME ) EVENT_TIME ,

       avg( to_integer(EVENTS.EVENT_VALUE) ) AVG_TEMP ,

       EVENTS.MAX_TEMP MAX_TEMP ,

       EVENTS.MIN_TEMP MIN_TEMP ,

       EVENTS.LOCATION LOCATION ,

       EVENTS.TEMP_UNIT TEMP_UNIT

FROM EVENTS KEEP 30 SEC

GROUP FILTER EVENTS.EVENT_NAME = ‘TEMP’

GROUP BY EVENTS.MACHINEID ;

Set 4:

USE WORKSPACE uri:genealogyWS;

RESULT uri:myResult

FROM $i : $NONTERMS

  WHERE $i@uri:firstname = ‘Hugo’ AND $i@core:type = uri:person;

Set 5:

START TASK “FV_TEST”.”Transformation::Suppliers”;

These are some of the innovations SAP HANA SPS 09!

Visit us at the show floor – PTS08 – SAP HANA Platform table to learn more about what these SQL statements are.

Learn how these innovations simplify landscape and application development and help you develop applications that were not possible before.

Topics covered at PTS08 – SAP HANA Platform table are:

  • Multitenant database containers
  • Dynamic tiering
  • Smart data streaming
  • Smart data integration & smart data quality
  • Graph
  • SAP Lumira Server
To report this post you need to login first.

4 Comments

You must be Logged on to comment or reply to a post.

  1. Andy Silvey

    Hi Saiprashanth,

    will anybody be blogging the

         Multitenant database containers


    I am very interested to hear innovations in that area,

    also if there is news on


         MCOS/MCOD


    please ask for that to be blogged too.


    Thanks and best regards,


    Andy.

    (0) 
    1. Saiprashanth Reddy Venumbaka Post author

      Please plan to attend live expert session by Ron & Joerg on Dec 9th.

      See complete list of topics at Blog: What is new in SAP HANA SPS 09 | SAP HANA

      December 9th

      11:00 AM –  12:00 PM

      SAP HANA multitenant database containers

      Ron Silberstein (presenter), Joerg Hoffmeister

      This is a new architectural option for SAP HANA, which provides enhanced ability to deploy various applications and/or use cases on singular, productive, SAP HANA hardware – in a manner that is effective and efficient

      (0) 
      1. J├╝rgen Modre

        Hi Saiprashanth,

        I attended the webcast but *none* of these new SQL statements have been explained…
        Would be great if you can share your SQL explanation to everyone in this blog?

        Thanks an best regards,
        Jürgen

        (0) 

Leave a Reply