dbt-hive icon indicating copy to clipboard operation
dbt-hive copied to clipboard

Connection error: module 'winkerberos' has no attribute 'authGSSClientUsername' on Windows

Open NicolasPA opened this issue 1 year ago • 3 comments

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?

NicolasPA avatar Feb 14 '24 07:02 NicolasPA