title: How to connect in Python 3.7 to a hadoop/hive database (that requires authentication) and execute a simple SQL query?
body: <p>I need to connect to a hadoop (apache hive) database that requires authentication with user/password.
  I normally access it with DBeaver (JDBC drivers installed) but now I need to retrieve data using a simple query with a script in Python 3.7 (not Python 2.x).
  I tried several methods without success.
  Does someone have a solution that works? </p>
  
  <p>I tried pyhive, presto, pyhs2, impala, ibis</p>