How to solve EOF error in Python HIVE SQL?

I am using HIVE connections to connect to database. I ran the following code, while it works perfect for all databases except for database names starting with underscore (_)

cur.execute("show tables in __ibis_tmp")

I am getting the following error

HiveServer2Error: Error while compiling statement: FAILED: ParseException line 1:15 extraneous input '__ibis_tmp' expecting EOF near '<EOF>'

Any leads would be appreciated