Skip to Content

Hi,

You likely already heard that SAP HANA SPS08 is generally available?

The SAP HANA Academy produce hands-on video tutorials covering all aspects of SAP HANA and of course we’ve got SPS08 fully covered!

Here’s the main playlist: SAP HANA SPS 08 – What’s New

We’ve published a tutorial for each and every new SAP HANA predictive analysis library (PAL) algorithm as well as covering key enhancements to existing algorithms – so if you want to see how we enable predictive maintenance, distribution fitting, K-medoids clustering, ARIMA forecasting, FP-growth association analysis, CART decision tree, random number generation, or simply how to cancel long running algorithms – now you can!

Here are direct links to all of the new PAL videos currently published that feature SPS08:

Getting Started

PAL: 53. Getting Started with SPS08

Clustering

PAL: 54. Clustering – Kmeans Best K

PAL: 55. Clustering – Kmedoids

Time Series

PAL: 56. Time Series – ARIMA Model

PAL: 57. Time Series – ARIMA Predict

PAL: 58. Time Series – Forecast Smoothing Model Selection

Association Analysis

PAL: 59. Association – Apriori New Parameters

PAL: 60. Association – FP-growth

Classification

PAL: 61. Classification – Decision Tree CART Model

PAL: 62. Classification – Decision Tree CART Predict

PAL: 63. Classification – Logistic Regression Model Cancel

PAL: 64. Classification – Multinomial Logistic Regression Model

PAL: 65. Classification – Multinomial Logistic Regression Predict

Statistics

PAL: 66. Statistics – Univariate New Statistics

PAL: 67. Data Preparation – Random Distribution

PAL: 68. Statistics – Distribution Fit

PAL: 69. Statistics – Distribution Fit Censored

PAL: 70. Statistics – Distribution Probability

PAL: 71. Statistics – Distribution Quantile

Each tutorial is accompanied by the SQL script shown and you can also download the example data in order to try the algorithms out for yourself. You’ll find the github link in the playlist description or go there directly via: saphanaacademy/PAL


Here’s the full academy playlist for the PAL: Predictive Analysis Library

As always feedback is most welcome – in the YouTube comments section, below, tweet me @pmugglestone or mailto:HanaAcademy@sap.com.

Philip

To report this post you need to login first.

4 Comments

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

  1. RAJIV SRIVASTAVA

    Hi Philip,

    First …heaps of thanks for producing the series of videos , code snippets and sample data.

    Could you pl confirm that the link in this blog (github) https://github.com/saphanaacademy/PAL

    has all the related code snippets. For example I could not find the ARIMA related code snippets . In fact there are no codes for 53 to 59 and some others are also missing.

    The sample data also does not have the stocks table referred in the ARIMA video.

    cheers

    Rajiv

    (0) 
      1. RAJIV SRIVASTAVA

        Hi Philip,

        Great..

        Not sure whether this is a general problem or specific to our installation (we are using HANA on AWS SPS08).

        Whenever we create Local Table using “Type” tables as in  :

        CREATE LOCAL TEMPORARY COLUMN TABLE #TS_PARAMS LIKE PAL_T_TS_PARAMS;

        We get the following error

        Could not execute ‘CREATE LOCAL TEMPORARY COLUMN TABLE #TS_PARAMS LIKE PAL_T_TS_PARAMS’ in 386 ms 486 µs .

        SAP DBTech JDBC: [598]: failed to execute the external statement: InvalidHostNameException at Communication.cpp(01174):

          message: the hostname could not be resolved

          info:    host unknown

          param:  

        To Overcome this problem we use the following workaround and explicitly create the Local Table :

        CREATE LOCAL TEMPORARY COLUMN TABLE #TS_PARAMS (NAME VARCHAR(60), INTARGS INTEGER, DOUBLEARGS DOUBLE, STRINGARGS VARCHAR (100));

        The ARIMA script works well once we use this workaround, however it will be good to confirm that our installation is not the culprit.

        cheers

        Rajiv

        (0) 
        1. Philip MUGGLESTONE Post author

          Hi Rajiv,

          I’m unable to reproduce the issue on my side so it sounds like this is something more specific with your installation? I have not tested AWS.

          Thanks,

          Philip

          (0) 

Leave a Reply