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
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
Hi Rajiv,
Thanks for the feedback and apologies for the delay.
Github has now been updated to include the SPS08 content.
Thanks,
Philip
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
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