sap data services connect starrocks issue

[#1]

Hello experts:

I need to use  data services to extract data from starrocks database, which is compatiable with mysql. then when creating  the datastore, I chose the mysql type, but it prompted an error :

WARNING: Cannot establish database connection.SQL submitted to database <information_schema> resulted in error<[MySQL][ODBC 8.0(w) Driver][mysqld-8.0.33]Getting analyzing error.Detail message: Set statement only support constant expr..>. The SQLsubmitted is <
SET SESSION sql_mode=(SELECT CONCAT(@@sql_mode,',ANSI_QUOTES'))
>.' (BODI-1111341)

it seems that the starrocks does not support the subquery to assign value.  but the connection is almost successful except the initial submitted sql statement.

I've tried serveral ways to fix it, as following:

1.  change the database type to odbc

2.  input something in the additional session parameters under "advanced"

3. tried to use data services 4.3 to establish the datastore

But so far no progress. it seems that the data services need to sent the initial statement SET SESSION sql_mode=(SELECT CONCAT(@@sql_mode,',ANSI_QUOTES')) ,  don't know how to skip this step.

Could anyone help? Thanks.

Allen

[xuhui_hu451b7b · Accepted solution]

Updates:

found a similar answer as below,  I have given up to use DS to connect starrocks. 

Solved: Is starrocks database supported with SAP Data Serv... - SAP Community

[jmuiruri]

@xuhui_hu451b7b  Which MYSQL Driver are you using ANSI or UNICODE?

[xuhui_hu451b7b]

Hello jmuiruri, I checked the sap help document, data services only support "PURE" mysql database, so I gave up to use DS to connect starrocks now. here is a simillar answer: https://community.sap.com/t5/technology-q-a/is-starrocks-database-supported-with-sap-data-services/q... Allen