Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Questions re: "EDA with SAP HANA" developer challenge

Vitaliy-R
Developer Advocate
Developer Advocate

This discussion thread is to ask your questions and discuss issues, if participating in the March 2023 developer challenge for SAP Community. The topic is "Exploratory Data Analysis with SAP HANA and Python".

Please use separate discussions created for the submission of your solutions. Keep this thread for your questions only.

24 REPLIES 24

Sergiu
Contributor
0 Kudos

Hi Vitaliy. 
https://tools.hana.ondemand.com/#hanatools
Do we have to install the client?
OR only
For Python driver installs, use pip:?

pip install hdbcli

Regards,
Sergiu 

 

Vitaliy-R
Developer Advocate
Developer Advocate

Hi Sergiu. Glad to see you are joining this one as well, even this time it will be super easy for you 🙂

The reason to install Client is that it comes with `hdbuserstore` used to store credentials on a client. That way participants should not think how to avoid sharing their endpoints, user names, and especially passwords, when sharing their notebooks.

Python's `hdbcli` still should be installed using pip, as then it is the latest version.

Regards.

Hi Vitaliy. Glad to join this challenge as well. 🙂

I share my tutorial about how to create a hana instance with trial account.
Quick steps to find <your.hana.instance.host> 

Regards,

Sergiu

 

Zejiong
Advisor
Advisor

According to the introduction of the “Setup your hana database in SAP HANA Cloud trial" section, it is recommended to use the trial account, but HANA Cloud instance not support Scriptserver due to CPU/MEM resource limited under the trail account and cannot execute PAL procedures. Any suggestions on find a ML available HANA Cloud instance?  Thanks in advance.

Vitaliy-R
Developer Advocate
Developer Advocate
0 Kudos

Thank you for your question. Indeed a ScriptServer is not available yet in the free BTP offering, but as well is not required for our exercises.

In this dev challenge we focus on DataFrame part of the ‘hana-ml’ package, and not on ML API. For our scope the ScriptServer is not required. 

Regards. 

I see. I'll practice with the existing instance.

Thanks!

kyvraoaiml
Explorer
0 Kudos

kyvraoaiml_0-1679032875249.png

It said 'Operation succeed' but still am getting error. So I used user id and password.

kyvraoaiml_1-1679033181676.png

0 Kudos

I see you added a user key on Windows machine. You can see a file where the user key is stored if you type just 

hdbuserstore list

But when you execute your notebook I see it tries to read the file `/root/.hdb/<name_of_machine>` from some Linux operating system using the `root` user. Are you running your notebooks in some kind of container (like Docker)? 

Hi, I am using Google Colab.

0 Kudos

@kyvraoaiml  , are you using a free version of CoLab, or a paid Pro version with access to the terminal and own instances?

0 Kudos

I am using free version. I did not pay anything.

0 Kudos

Hi,

I'm also facing the same issue, how did you resolved that??

0 Kudos

I used the url, port, user id and pwd to connect to HANA db instance.

0 Kudos

Do you use Google CoLab @richa_dwivedi ?

0 Kudos

Hi @Vitaliy-R ,

Yes, I'm using free version of colab.

FYI, it is resolved now, Thanks!!

MadhavKumar
Explorer
0 Kudos

Hi Vitaliy,

I am unable to restart the instances. 

Unable to figure out what is missing from my end.

MadhavKumar_0-1679065816131.png

 

5 days back I submitted the Week1, and it was working good.

Could you please help.

Week1 Submission link

Regards,

Madhav Kumar

This is resolved.

Instances are starting now.

MadhavKumar_0-1679066556578.png

Thank You

shivamshukla12
Contributor

Hi Vitaliy ,

I am starting today , still i can submit my responses ?

Thanks Shivam 

0 Kudos

@shivamshukla12  Sure! Everyone has time to submit any week before the end of the whole challenge. 
Good luck!

0 Kudos

Hi Vitaliy
I encountered an error while trying to access a URL and I'm not quite sure what it means. The error message I received is:

Salim_Nisar_0-1679377596444.png

 

@former_member122105 :

There are might be many reasons you are getting this error on your machine: https://www.easytechjunkie.com/what-are-the-common-causes-of-socket-error-10061.htm, incl. some anti-virus programs or a network configuration.

Can you simply download the file https://raw.githubusercontent.com/SAP-samples/hana-ml-samples/main/Python-API/pal/datasets/bike.csv to your machine's directory with the notebook, and then change it to

bikes_df = pd.io.parsers.read_csv("bike.csv")

to open a CSV file from your local file system?

As well, let me attach the file with the data here as `bike.txt` to download it from this reply and rename it to `bike.csv` on your Windows machine.

Hi Vitaliy-R

Thank you for your response and providing me with the helpful suggestions for resolving the socket error that I was experiencing. I tried both of the methods that you recommended and am pleased to report that both worked successfully. I was able to save the file locally and also successfully downloaded the file you attached as bike.txt and renamed it as bike.csv on my Windows machine.

Thank you for taking the time to assist me with this issue. Your help has been greatly appreciated.

Best regards, 

Salim Nisar

 

MadhavKumar
Explorer
0 Kudos

Hi Vitaliy,

When do we get the badge for participating in this challenge?

Regards,

Madhav Kumar

 

They should be assigned this week @MadhavKumar 

Best regards,

-Vitaliy