selectdb / dbt-doris

a dbt adapter for Apache Doris
20 stars 2 forks source link

Compatibility Issue with dbt-doris Plugin and dbt-core Version 1.5.10 #8

Open beneo opened 8 months ago

beneo commented 8 months ago

Hello dbt and dbt-doris Teams,

I am encountering a compatibility issue when trying to use the dbt-doris plugin with dbt-core. Below are the versions and system details:

Environment

Issue Description

While trying to connect dbt with Doris using the dbt-doris plugin, I receive an error indicating that the plugin is not compatible with my current dbt-core version. Additionally, when running dbt debug, it reports a connection error with the following message:

Connection test: [ERROR]
dbt was unable to connect to the specified database.
The database returned the following error:
  >Database Error
  2013: Lost connection to MySQL server during query

Doris Version

SHOW VARIABLES LIKE "%version%";

version,5.7.99,5.7.99,0
version_comment,Doris version doris-2.0.5-rc02-67c9ccfa5d,Doris version doris-2.0.5-rc02-67c9ccfa5d,0

Despite this, I am able to successfully connect to Doris using both Navicat and DataGrid, as well as through direct code connections, which suggests that the issue lies specifically with the dbt-doris plugin connection.

Thank you for your support and assistance.

Best regards,
beneo

beneo commented 8 months ago

bug fix by

pip install --upgrade mysql-connector-python