We try to connect to SAP HANA with session parameters
For example
select * from jdbc('hanaHAQ?sessionVariable:MY=MYmyapp', 'SELECT * FROM SYS.M_SESSION_CONTEXT where key =''MY''')
session variables "MY" is a dynamic variable known only on connection
we get exception
Code: 86. DB::Exception: Received error from remote server /columns_info?connection_string=hanaHAQ%3FsessionVariable%3AMY%3DMYmyapp&table=SELECT%20%2A%20FROM%20SYS.M_SESSION_CONTEXT%20%20where%20key%20%3D%27MY%27&external_table_functions_use_nulls=true. HTTP status code: 500 Internal Server Error, body: Unsupported type of NamedDataSource: hanaHAQ?sessionVariable. (RECEIVED_ERROR_FROM_REMOTE_IO_SERVER) (version 22.1.3.7 (official build))
how to pass character ":" ?
We try to connect to SAP HANA with session parameters For example
select * from jdbc('hanaHAQ?sessionVariable:MY=MYmyapp', 'SELECT * FROM SYS.M_SESSION_CONTEXT where key =''MY''')session variables "MY" is a dynamic variable known only on connection we get exceptionCode: 86. DB::Exception: Received error from remote server /columns_info?connection_string=hanaHAQ%3FsessionVariable%3AMY%3DMYmyapp&table=SELECT%20%2A%20FROM%20SYS.M_SESSION_CONTEXT%20%20where%20key%20%3D%27MY%27&external_table_functions_use_nulls=true. HTTP status code: 500 Internal Server Error, body: Unsupported type of NamedDataSource: hanaHAQ?sessionVariable. (RECEIVED_ERROR_FROM_REMOTE_IO_SERVER) (version 22.1.3.7 (official build))how to pass character ":" ?