Question

"How can I connect to Hadoop Hive using Python? I've tried using PyHive but always get the error:

...could not start SASL... no mechanism available: unable to find a callback: 2"

Answer 1

• I believe that the most easiest way is to use PyHive.
• To install PyHive you need some libraries:

  pip install sasl
  pip install thrift
  pip install thrift-sasl
  pip install PyHive

• Note- Please keep in mind, although you install the library as PyHive, you need to import the module as pyhive, all in lower-case.

1. For Linux- If you're on Linux, you may need to install SASL separately before running the above libraries.
2. For Windows- There are some options on GNU.org, you can download a binary installer.
3. For Mac- SASL should be available if you've installed xcode developer tools.

• After installation, you can connect to Hive like this:

  from pyhive import hive
  conn = hive.Connection(host="YOUR_HIVE_HOST", port=PORT, username="TIGER")

• Hive connection is made.
• Queries to be given after connection:

  cursor = conn.cursor()
  cursor.execute("SELECT cool_stuff FROM hive_table")
  for result in cursor.fetchall():
    use_result(result)