Skip to content

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

@NicolasPA

Description

@NicolasPA

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?

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions