search

selectdb / dbt-doris

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

[Bug] dbt can not connect to doris #10

Open zhengjiaao opened 1 month ago

zhengjiaao commented 1 month ago

安装：

pip install dbt-doris

版本： 企业微信截图_17248992726224

配置：

jaffle_shop:
  target: dev
  outputs:
    dev:
      type: doris
      host: 127.0.0.1
      port: 9030
      schema: test
      username: root
      password: "123456"

运行：

dbt debug

Connection ERROR 错误：

02:45:01  Connection:
02:45:01    host: 127.0.0.1
02:45:01    port: 9030
02:45:01    schema: test
02:45:01  Registered adapter: doris=0.3.4
02:45:02    Connection test: [ERROR]

02:45:02  1 check failed:
02:45:02  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

Check your database credentials and try again. For more information, visit:
https://docs.getdbt.com/docs/configure-your-profile

请问，这个如何解决？

zhengjiaao commented 1 month ago

已经尝试，在mysql客户端中，可以连接成功doris，但是在dbt不能连接到doris

zhengjiaao commented 1 month ago

另外，dbt-doris 针对dbt-core适配依旧是旧的dbt-core=1.5，可以把dbt-doris 适配dbt-core1.8 新版本吗？

jeeinn commented 3 weeks ago

你的配置结构看着没啥问题，确定下host配置项的网络互通性，试试用localhost

上面的检查都通过了吗？

04:03:16  Running with dbt=1.5.11
04:03:16  dbt version: 1.5.11
04:03:16  python version: 3.10.14
04:03:16  python path: /data/bi_wharehouse/dbt-env/bin/python3.10                                                          
04:03:16  os info: Linux-5.10.134-17.2.al8.x86_64-x86_64-with-glibc2.32                                                                  
04:03:16  Using profiles.yml file at /data/bi_wharehouse/boss/profiles.yml                                                 
04:03:16  Using dbt_project.yml file at /data/bi_wharehouse/boss/dbt_project.yml                                           
04:03:16  Configuration:
04:03:16    profiles.yml file [OK found and valid]
04:03:16    dbt_project.yml file [OK found and valid]
04:03:16  Required dependencies:
04:03:16   - git [OK found]

04:03:16  Connection:
04:03:16    host: 127.0.0.1
04:03:16    port: 9030
04:03:16    schema: test
04:03:16  Registered adapter: doris=0.3.4
04:03:16    Connection test: [OK connection ok]
jeeinn commented 3 weeks ago

另外，dbt-doris 针对dbt-core适配依旧是旧的dbt-core=1.5，可以把dbt-doris 适配dbt-core1.8 新版本吗？

这个应该要等官方更新，有类似的包依赖