PyHive
PyHive copied to clipboard
dropbox
Python interface to Hive and Presto. 🐝
Is it possible to execute multiple hql's like 'CREATE TABLE TABLE1 (ITEM_KEY BIGINT );CREATE TABLE TABLE2 (ITEM_NAME BIGINT );'. Sample code ``` from pyhive import hive conn = hive.Connection(host=host ,...
Hi Guys, is there a way to specify Client Tags when connecting/submitting a query? From query details:
``` from pyhive import hive con = hive.Connection(host="10.8.8.8", port=21000, auth='KERBEROS', kerberos_service_name="hive") cursor = con.cursor() cursor.execute('show databases') datas = cursor.fetchall() print(datas) ``` thrift.transport.TTransport.TTransportException: Could not start SASL: b'Error in sasl_client_start (-1)...
pyhive version is 0.6.3 Installation successful，but run program error ：ImportError:cannot import name 'constants' from 'TCLIService' (unknown location) try a lot of methods, can't solve this problem, is pyhive encapsulation TCLIServices...
Hi, i'm not sure how to put an issue what I see correctly but here it is: When I qery single table with one of the columns containing VCARD I...
We are using pyhive to process data on both Hive and Presto. The async interface is currently designed in hive only, but not in presto. Can we add it in...
in pyhive do a: SELECT REAL'NaN'; Check the type of the return, it is not a float or a double but the string NaN.
This is the code ``` from pyhive import hive conn = hive.Connection(host='host_name_with_auth_none' , port=10000, auth='NONE' ) cursor = conn.cursor() cursor.execute("SHOW TABLES") for table in cursor.fetchall(): print table ``` I get...
Hi. I have a Hive connection where I insert tons of data and also run 'Insert Overwrite' queries. Here is my connection file: ``` from pyhive import hive from app.settings...
