Cannot execute SQL HANA query in Python - syntax error

Question

I have problem executing SQL HANA query in Python. I established connection (in R I am able to connect to this HANA data table and it's working perfectly) but in Python I receive syntax error related to query -> I searched multiple sources how to deal with this query 'SELECT TOP 10 * FROM _SYS.TEMP_VALIDATION_09/TEMP_123' but I did not find answer. In R it looks like this ' SELECT TOP 10 * FROM "_SYS"."TEMP_VALIDATION_09/TEMP_123" '

from hdbcli import dbapi

#Initialize your connection
conn = dbapi.connect(address = '',
              port = , 
              user = '', 
              password = '')

print('connected')

cursor = conn.cursor()

query = 'SELECT TOP 10 * FROM _SYS.TEMP_VALIDATION_09/TEMP_123'
print(query)

result = cursor.execute(query)
for result in cursor:
    print(result)

Does this answer your question? sap hana - select top expression — shaik moeed
– shaik moeed, Commented Nov 20, 2019 at 10:59
have you tried to use double quotes around the table name like query = 'SELECT TOP 10 * FROM _SYS."TEMP_VALIDATION_09/TEMP_123"' — Abdel Dadouche
– Abdel Dadouche, Commented Nov 21, 2019 at 11:39

Mike · Accepted Answer · 2019-11-21 12:23:34Z

1

I did find the answer. It's related how identifiers are treated

There are two types Quotation mark for delimit: Single Quotation Mark (' ') – It is used to delimit the string. Double Quotation Mark (" ") – It is used for delimiting identifiers.

The solution:

query = ' SELECT TOP 10 * FROM "_SYS"."TEMP_VALIDATION_09/TEMP_123" '

answered Nov 21, 2019 at 12:23

Mike

736 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Cannot execute SQL HANA query in Python - syntax error

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related