dbt-hive
dbt-hive copied to clipboard
Connection error: module 'winkerberos' has no attribute 'authGSSClientUsername' on Windows
I want to run dbt-hive
on my Windows laptop in Git Bash against a local Hive running in Docker.
After installing it and configuring the profile, when running dbt debug
I get this error: module 'winkerberos' has no attribute 'authGSSClientUsername'
.
$ dbt debug
07:44:02 Running with dbt=1.4.9
dbt version: 1.4.9
python version: 3.10.4
python path: C:\Users\me\AppData\Local\pypoetry\Cache\virtualenvs\ppdwh-monitoring-GwRR549H-py3.10\Scripts\python.exe
os info: Windows-10-10.0.22621-SP0
Using profiles.yml file at C:\Users\me\.dbt\profiles.yml
Using dbt_project.yml file at C:\Users\me\Documents\work\code\ppdwh-monitoring\dbt_project.yml
Configuration:
profiles.yml file [OK found and valid]
dbt_project.yml file [OK found and valid]
Required dependencies:
- git [OK found]
Connection:
host: localhost
schema: default
user: None
07:44:03 Hive adapter: Connection error: module 'winkerberos' has no attribute 'authGSSClientUsername'
Connection test: [ERROR]
1 check failed:
dbt was unable to connect to the specified database.
The database returned the following error:
>Runtime Error
module 'winkerberos' has no attribute 'authGSSClientUsername'
Check your database credentials and try again. For more information, visit:
https://docs.getdbt.com/docs/configure-your-profile
Hive in Docker on Windows works perfectly fine, I used it in an other Python based project with package impyla
.
This same dbt install and dbt profile works fine on WSL2.
So there seems to be an issue specific to Windows + no Kerberos.
Any hint on how to debug it?