03-08-2023 2:48 AM - edited 03-08-2023 9:25 AM
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.
03-09-2023 1:41 AM - edited 03-09-2023 3:10 AM
Do we have to install the client?
For Python driver installs, use pip:?
pip install hdbcli
03-09-2023 3:58 AM - edited 03-09-2023 7:12 AM
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.
03-13-2023 3:52 AM - edited 03-13-2023 3:59 AM
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>
03-13-2023 12:36 AM
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.
03-13-2023 1:56 AM
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.
03-13-2023 12:02 PM
I see. I'll practice with the existing instance.
03-16-2023 11:07 PM
It said 'Operation succeed' but still am getting error. So I used user id and password.
03-17-2023 5:10 AM
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
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)?
03-20-2023 3:42 AM
03-20-2023 6:43 AM
@kyvraoaiml , are you using a free version of CoLab, or a paid Pro version with access to the terminal and own instances?
03-20-2023 11:44 PM
I am using free version. I did not pay anything.
03-27-2023 10:35 PM
I'm also facing the same issue, how did you resolved that??
03-27-2023 11:56 PM
I used the url, port, user id and pwd to connect to HANA db instance.
03-28-2023 1:41 AM
03-28-2023 2:48 AM - edited 03-28-2023 11:28 PM
Hi @Vitaliy-R ,
Yes, I'm using free version of colab.
FYI, it is resolved now, Thanks!!
03-17-2023 8:11 AM
I am unable to restart the instances.
Unable to figure out what is missing from my end.
5 days back I submitted the Week1, and it was working good.
Could you please help.
03-17-2023 8:22 AM
This is resolved.
Instances are starting now.
03-20-2023 3:58 AM
Hi Vitaliy ,
I am starting today , still i can submit my responses ?
03-20-2023 5:33 AM
@shivamshukla12 Sure! Everyone has time to submit any week before the end of the whole challenge.
03-20-2023 10:47 PM
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:
03-21-2023 3:43 AM - edited 03-21-2023 3:46 AM
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.
03-21-2023 7:56 AM
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.
04-09-2023 10:46 PM
When do we get the badge for participating in this challenge?
04-10-2023 1:30 AM
They should be assigned this week @MadhavKumar