Django is unable to connect to StarRocks using mysqlclient

Working with Data Data Loading Tools & Integrations
1

Django application is unable to connect to StarRocks using mysqlclient

Django version : 5.0.2

DATABASES = {
“default”: {
“ENGINE”: “django.db.backends.mysql”,
“NAME”: “test_db”,
“USER”: “root”,
“PASSWORD”: “”,
“HOST”: “127.0.0.1”,
“PORT”: “9030”,
}
}

Error
_mysql.connection.query(self, query)
django.db.utils.ProgrammingError: (1064, “Getting analyzing error. Detail message: Unknown system variable ‘default_storage_engine’, the most similar variables are {‘default_rowset_type’, ‘default_table_compression’, ‘enable_sort_aggregate’}.”)

2

could you try this instead?

BTW, starrocks is an OLAP database, django may not be a typical usecase.

1 Like