R-algorithm runs infinitely on HANA table

[former_member186082]

Hi All,

I'm running R-algorithm on  HANA table, which has got only 2 fields - 1 varchar & 1 integer and just 100 rows. When I apply R and start running, it runs indefinitely, without results.

I'm running PA - 1.0.7

Can you help in this

Regards,
Chandu

[AndreasForster · Accepted solution]

Hi Chandra,

R-algorithms can be executed in different ways (HANA side or PA side). To help understand what is going on, can you please post
- what database source you chose in SAP PA (ie HANA Online or Offine)
- The exact name of the algorithm module you are using (ie HANA R-Triple Exponential Smoothing)

It would also help to get a log created, Support will probably ask for this anyway. See page 18 in
https://websmp104.sap-ag.de/~sapidb/011000358700001128302012E/pa_sp1_install_en.pdf

Just a heads up, the docu states to specify the log directory in this format: log_dir="C:\logs"
For me it would only work with a forward-slash though: log_dir="C:/logs"

Andreas

[former_member186082 · Accepted solution]

Hi Andreas,

I have choosen "HANA Online" and running "HANA Apriori" algorithm..

We are on HANA SP4 revision 32...is this the reason why we are not getting results...?

Regards,

Chandra

[AndreasForster · Accepted solution]

Hi Chandra,

when selecting "HANA Apriori" R ist not being used at all.

The predictive algorithms is executed within the SAP Predictive Analysis Library (PAL) straight within HANA. (so very performant)

I couldn't find any info on what exact version of HANA is supported with SAP PA but revision 32 sounds old. I have been using SAP PA happily with revision 48.

If you want to try this out, the HANA One Developer edition is on this version and can be accessed for a few dollars per hour.

http://scn.sap.com/docs/DOC-31722

Greetings

Andreas

[AndreasForster · Accepted solution]

Hi again,

I have just seen in the Product Availability Matrix that SAP PA supports HANA 1.0 SP5 Revision 45.

https://websmp108.sap-ag.de/~sapidb/011000358700001150282012E

So your assumption is right, the HANA version is not high enough.

Greetings

Andreas

[former_member186082 · Accepted solution]

Thank you Andreas, I had a doubt, now its clear

[lbreddemann]

Chandu,

as always with performance troubles, the question is 'where is the time spent'?

Do you see any activity in HANA or is PA running in circles or does the R process not let go of your data set?

- Lars

[former_member186082]

HiI Lars,

Time is spent on PA side. When I start running the algorithm, it shows EXECUTION IN PROGRESS. I've waited for hours, but no result.

Regards,
Chandu

[lbreddemann]

Hi Chandu,

and did PA already started the R runtime?

Guess this is the point in time to open a support message...

- Lars

[Former Member]

Are you sure your R-script works fine?  Then we can rule that one out.

[former_member186082]

I'm not sure if R-script is working fine or not, can you please help how to test the same.

[Former Member]

You can test it by running it in R.  R can be downloaded for free.

Of course you need data for your script.