Utility function to connect to Pyhive on HTTP mode.

connect_to_pyhive_http_mode.py

from pyhive import hive

def connect_to_pyhive():
	""" Connects to Pyhive with HTTP mode
	"""
	conn = hive.connect(thrift_transport=add_http_mode_support())
	cursor = conn.cursor()
	cursor.execute("show databases")
	print cursor.fetchone()

def add_http_mode_support(username="xxx", password="xxx", port=10001, httpPath="/cliservice", host="127.0.0.1", transportMode="http"):
	""" Utility function which geenrate Transport client object which in turn can be passwd to hive connection to 
	establish the HTTP mode connection. 
	"""
   	 ap = "%s:%s" % (username, password)
    import base64
    from thrift.transport.THttpClient import THttpClient 
    _transport = THttpClient(host, port=port, path=httpPath)
    _transport.setCustomHeaders({"Authorization": "Basic "+base64.b64encode(ap).strip()})
    return _transport

if __name__ == '__main__':
	connect_to_pyhive()

were you able to connect to the hive server which transport mode configured as "http"?

why username and password is base64encode?