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
4,662

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
4,614

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
4,606

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.

4,515

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
4,522

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
4,517

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. 

4,498

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

Thanks!

kyvraoaiml
Explorer
0 Kudos
4,415

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
4,404

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)? 

4,314

Hi, I am using Google Colab.

0 Kudos
4,297

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

0 Kudos
4,245

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

0 Kudos
4,029

Hi,

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

0 Kudos
4,026

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

0 Kudos
4,019

Do you use Google CoLab @richa_dwivedi ?

0 Kudos
4,014

Hi @Vitaliy-R ,

Yes, I'm using free version of colab.

FYI, it is resolved now, Thanks!!

MadhavKumar
Explorer
0 Kudos
4,390

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

4,386

This is resolved.

Instances are starting now.

MadhavKumar_0-1679066556578.png

Thank You

shivamshukla12
Contributor
4,308

Hi Vitaliy ,

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

Thanks Shivam 

0 Kudos
4,306

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

0 Kudos
4,251

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

 

4,232

@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.

4,220

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
3,788

Hi Vitaliy,

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

Regards,

Madhav Kumar

 

3,785

They should be assigned this week @MadhavKumar 

Best regards,

-Vitaliy