Question Re: HANA Calculated view query using Python in Technology Q&A

HANA Calculated view query using Python

Former Member — Tue, 10 Mar 2020 03:49:36 GMT

Python

I am currently trying to access a calculated view on HANA through python using hdbcli library.

I have no problems with connecting, but when trying to query information it doesn't work.

My calculated view is hosted in a path such as this:

And I'm using this code to query:

from hdbcli import dbapi
conn = dbapi(connect(host,port,user,password)
query = "select * from HANA1.MAIN.OrdersReview.CV_Inbound_Orders"
cursor = conn.cursor()
try:
  res = cursor.execute(query)
  res = cursor.fetchall()
exception:
  print("Something went wrong")
conn.close()
cursor.close()

I think the problem is in the query string but haven't find what it is... any ideas?

Re: HANA Calculated view query using Python

michael_eaton3 — Tue, 10 Mar 2020 08:11:13 GMT

Hello

I would recommend that you use the data preview feature in the HANA Studio to obtain sample SQL.

To reference a calculation view you'll require a schema name, and quotes around the schema name and package/view reference, for example.

SELECT blah FROM "_SYS_BIC"."Package1.Package2.PushdownPoC/CA_WITH_STUFF"

Michael

Re: HANA Calculated view query using Python

venkateswaran_k — Tue, 10 Mar 2020 08:29:48 GMT

Dear Luis

Please provide the additional information.

Do you have the log of exception in try-catch caluse in the python - which shows what is the error.

1. May be authorization issue -

2. Generally the view should have prefix with the schema name. So you may need to add the schema name before the view name. ("_SYS_BIC").

Kindly confirm

Regards,

Venkat

Re: HANA Calculated view query using Python

Former Member — Tue, 10 Mar 2020 15:35:38 GMT

Hello Michael

Thank you! It worked perfectly.

I include the query string, just in case, anyone has the same issue:

query='select top 10 * from \"_SYS_BIC\".\"Package1.Package2.PushdownPoC/CA_WITH_STUFF\"'