Submissions for "SAP HANA Cloud multi-model" developer challenge: Week 1 - Setup

[Vitaliy-R]

This discussion thread is to submit your solution for Week 1 "Setup" if you are participating in the June 2024 developer challenge "Multi-model in SAP HANA Cloud".

👉 Please use this separate thread to ask your questions and discuss issues. Keep this thread for your submissions only.

2️⃣ Post your Week 2 "Words as Vectors" submissions here: https://community.sap.com/t5/application-development-discussions/submissions-for-quot-sap-hana-cloud... 

3️⃣ Post your Week 3 "Image Embeddings" submissions here: https://community.sap.com/t5/application-development-discussions/submissions-for-quot-sap-hana-cloud... 

[Cocquerel]

done

[Vitaliy-R]

Thank you for being the first @Cocquerel !

Was there any part that was in any way difficult?

Btw, I know that I mostly published steps to execute, but I think about adding more explanations and references to that too.

[Cocquerel]

Just one comment, the step to create myDevChallenger user store entry is missing

[Vitaliy-R]

Indeed, step 9 was missing 😖

Fixed now. Thank you!

Please let me know, if there is any other feedback.

[MioYasutake]

My week1 submission here.

In Step8, I first executed the command as-is (`sh ~/sap/hdbclient/hdbsql -U myDBAdmin`), and got an error:

After reviewing the screenshot below the instructions, I realized that 'sh' was not required.

[Vitaliy-R]

Thank you for joining, and thank you for reporting the typo in Step 8. Fixed.

Have you had any other problems with commands or systems?

[MioYasutake]

@Vitaliy-R 

I had no other problems while executing the exercise.

[sagarsv]

Done week 1 😃 
Very smooth documentation and clearly understood the steps.

[abhijitmoholkar]

My week1 submission

I raised an issue earlier but when I followed the steps second time, it worked. I think in the background HANA Cloud was not running that might have caused the issue.

[gphadnis2000]

My Week1 Submission.Thanks for Help Vitaliy.

[DirkO]

My week1 submission here.

The issues I had were not comming from exercise description, they were 100% PICNIC. 😀

Many thanks Witalij for this awesome developer challenge. 👍

[Alpesa1990]

My submission:

The challenge is very well explained!

Congrats!

[M-K]

My submission:

[ajmaradiaga]

Here is my submission for this week...

[moh_ali_square]

Hi, 

Thanks for the challenge. Here is my submission. two parts due to screen size 💻

[christof_m]

Hi Vitaliy, here is my submission.
Everything worked very well, I like the red numbered markers on the screenshots.
Thanks again also for the great Code Jam ("Getting started in Machine learning") last monday in Mannheim 

[geek61]

Yesterday, the keystore just wouldn't respond and threw errors, today, no issues:

[satyasundar3]

Here is my submission for this week.

[tobiasz_h]

Hello,
Great instructions, my submission:

[johna69]

Thank you

[Vitaliy-R]

Hi John. I see you pasted all the separate Python statements into a single IPython execution.

Was it on purpose? 🤓 

[chirag_makwana]

Hi Team, here is my submission. Thanks.

[CameronWilson]

Hi Vitality!

Here is my week 1 submission!

[VS_Chandu]

Here is my week 1 Submission

 

[SushmitaG98]

Finally with little bit of struggle I am able to complete the challenge.

[Vitaliy-R]

Thank you @SushmitaG98  🤓 What part(s) did you struggle with, if I may ask?

[SushmitaG98]

Hi @Vitaliy-R , I was facing authentication error while creating DB user. Finally it is resolved after receiving so many inputs from you and from the fellow developers 😀.

[JerryW]

Here is my week 1 submission - thanks!

[mvinci]

Done

[Vitaliy-R]

Week 2 exercise is available now: https://github.com/SAP-samples/sap-community-developer-challenge-hana-multimodel/blob/main/challenge...

[reachdebopriya]

Hello,

Issue resolved.

Done.

Regards,

Debopriya Ghosh

[Vitaliy-R]

Hi @reachdebopriya From what I can read "... path '/home/user/.hdb/workspaces-ws-mjlvr' failed, rc=2:No such file or directory")"

What is the output of the following commands in the BAS terminal for you?

ls -la /home/user/.hdb/

and

echo ${WORKSPACE_ID}

?

[reachdebopriya]

Issue resolved.

Done now.

[Srijani]

Hi ,

I have done the Week 1 Excercise.

Thanks and Best Regards

[Vitaliy-R]

Hi @Srijani As I can see from your screenshots, the setup was not done correctly and you were not able to connect from Python to your SAP HANA db with the user key.

I see you are getting error when connecting and the error returns the correlation-id.

Check the error reason behind this correlation id using the suggestions from https://community.sap.com/t5/application-development-discussions/questions-re-quot-multi-model-with-...

and fix it.

Resubmit your screenshot with the fixed situation after that, please.

[Srijani]

Hi,

Sorry, I did not notice it. My Credentials were wrong somehow for DBAdmin. At step 7 I received error yesterday, but then tried with the SQL Endpoint , it worked there but the saved credential was wrong maybe.

I rectified it.. please find the  correct Screenshot

Thanks and Regards,

Srijani

[mwn]

In [5]: %sql hana://userkey=myDevChallenger

In [6]: %sql SELECT Current_User FROM DUMMY
* hana://userkey=myDevChallenger
Done.
Out[6]: [('DEVCHALLENGER',)]

In [7]: %sql hana://userkey=mydbadmin

In [8]: %sql
...: hana_db_info = %sql SELECT "KEY", "VALUE" FROM "M_HOST_INFORMATION" WHERE "KEY" IN ('build_cloud_edition', 'start_time')
hana://userkey=myDevChallenger
* hana://userkey=mydbadmin
hana://userkey=myDevChallenger
* hana://userkey=mydbadmin
Done.

In [9]: type
Out[9]: type

In [10]: type(hana_db_info)
Out[10]: sql.run.ResultSet

In [11]: hana_db_info.DataFrame()
Out[11]:
key value
0 build_cloud_edition 2024.2.16
1 start_time 2024-06-16 09:19:51.482

In [12]: print("That's the end of the setup exercise!")
That's the end of the setup exercise!

In [13]: quit

[emiliocampo]

My Week 1 Submission

[jens_borau]