on 07-12-2020 9:11 AM
With data models and calc views all set up, I am exploring potential predictive functionalities of SDWC with two options:
- Predictive functions through hana.ml & hana.ml.r packages
- SQL Script based PAL functions calls through JDBC connection
In both scenarios I was prompted privilege error. However, all of following SQL suggests SWDC tenant has AFL/PAL properly configured.
SELECT * FROM "SYS"."AFL_AREAS" WHERE AREA_NAME = 'AFLPAL';
SELECT * FROM "SYS"."AFL_PACKAGES" WHERE AREA_NAME = 'AFLPAL';
SELECT * FROM "SYS"."AFL_FUNCTIONS" WHERE AREA_NAME = 'AFLPAL';
I am wondering whether PAL functions are currently (July 2020) supported in SWDC or it is merely my misconfiguration?
Thanks.
Hi Thomas,
You can look this up in the SAP HANA Cloud documentation:
SAP HANA Predictive Analysis Library (PAL). This feature is planned but not initially available.
To be informed about future plans, you can check the road map. It is currently set for Q3 but keep in mind that plans can always change:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for the links Denys. They are spot on. And I trust PAL will be a feature that is highly sought after.
Hi Thomas,
DWC wave 2021.01 will provide the capability to enable the HANA Cloud script server on the DWC-Space level.
Once activated, you can connect using the DB-User to the openSQL-Schema and run HANA SQL commands / or external tooling (e.g. python) to leverage the HANA Cloud PAL/APL library functions. WebIDE and the accroding project setup is the other option to leverage the HANA Cloud PAL/APL library functions.
Thanks,
-Axel
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi All,
As of Sep 22 2021, I can't find any activation option in space level of my DWC (version 2021.19.67) with Database Release 4.00.000.00.1629881058 (2021.18.11)
However, found out the help portal about this topic below. Basically, you need to create an SAP ticket to request scriptserver enablement in your DWC tenant.
Using the Machine Learning Libraries (APL and PAL) in DWC https://help.sap.com/viewer/9f804b8efa8043539289f42f372c4862/cloud/en-US/287194276a7d4d778ec98fdde5f....
=>
"For a step-by-step guide to create an SAP ticket and enable the machine
learning libraries take a look at this SAP Knowledge Base Article:2994416 - Enablement of APL and PAL in DWC"
Kind Regards, Yatsea
Hi Yatsea,
yes - you need to request the script server to be enabled on your DWC tenant via SAP-ticket.
Once activated, you need to activate the checkbox in your SPACE to let DWC grant the according privileges to the according DB-User. You need to re-create an additional DB-User in your Space after the Script-server and checkbox has been activated to have the acording privileges granted.
Sorry for the confusion.
Hi all, notice that having the PAL/APL capabilities (related to the scriptserver) made available in HANA Cloud is not enough for them to be available in DWC. DWC is an application/SaaS and not a DBaaS like HANA - meaning that all necessary authorizations and infrastructure-related activities need to be available as APIs and added to the DWC CI/CD pipelines. This is to avoid having humans using the all-powerful DBADMIN user in a customer's DWC tenant - all operations in DWC are automated and/or triggered by a CF api, not on the DB level.
As such, it will take a little longer for the PAL/APL (and other scriptserver enabled libraries) to be available in DWC. The plan is to have it in Q4 (by the end of the year).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Update: PAL was added in the July update QRC 02/2020
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi, This question is getting a lot of attention / views.
Hence here is a summary of how APL/PAL has been working for me in DWC
You can now access the data by going through that view and apply APL / PAL, ie with hana_ml. This code should succeed now: conn.table("YOURVIEW", schema = "YOURSCHEMA").count()
And a simple example with PAL to split the data
df_remote = conn.table("YOURVIEW", schema = "YOURSCHEMA")
from hana_ml.algorithms.pal import partition
df_remote_train, df_remote_test, df_remote_ignore = partition.train_test_val_split(random_seed = 1972,
data = df_remote,
training_percentage = 0.7,
testing_percentage = 0.3,
validation_percentage = 0)
df_remote_train.count()
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you for the summary Andreas!
"Since the DWC trial comes only with 2 virtual CPUs APL / PAL cannot be used in the trial"
Do SAP have any plans to overcome this trial limitation of DWC? I see a lot of customer trial versions of DWC which are used for evaluation. And PAL/APL integration with Python/R would be at least something nice to show.
Apparently the feature has now been available by request. According to Note 2994416, opening an Incident to enable scriptserver on DWC tenant will do the trick. Another big tick!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Thomas,
SAP DWC is based on SAP HANA Cloud and we also provide an integration via WebIDE (full stack) with the underlying SAP HANA database.
In such a scenario could can then leverage model from DWC as part of scenarios for PAL / ML.
Best Regards
Ingo Hilgefort, SAP
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you Ingo for advising. From the conversion above between your colleagues Denys and Henrique, there seems to be some further complication to be resolved with the current set up in HANA Cloud in order for DWC users to consume PAL.
In addition, both Tim and myself found hana.ml package does not connect to DWC, which I believe is a separate issue of compatibility.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
96 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.