HANA Calculated view query using Python

[Former Member]

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?

[venkateswaran_k]

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

[michael_eaton3 · Accepted solution]

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

[Former Member · Accepted solution]

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\"'