PyHive

PyHive copied to clipboard

fetch too many lines and need a better fetchmany

2

I use pyhive in my python code, but I found that, in pyhive, fetchmany just using fetchone. One case of my code , result has 6000000 lines, and need to...

darrkz

1. from pyhive import presto async_ not found on latest pyhive How to solve it 2. How to run multuple query in parallel with pyhive 0.6.5? share same cursor or...

freephys

# Issue Type [x] Bug (Typo) # Steps to Replicate and Expected Behaviour - Examine pyhive/presto.py and observe `queryes`, however expect to see `queries`. - Examine pyhive/presto.py and observe `authentiation`,...

timgates42

https://github.com/dropbox/PyHive/blob/b21c507a24ed2f2b0cf15b0b6abb1c43f31d3ee0/pyhive/common.py#L248

tirkarthi

Switch to using sasl3 (sasl doesn't work on newer versions of Python)

2

The `extras_require` dependencies for `hive` [currently install `sasl`](https://github.com/dropbox/PyHive/blob/1548ecc6fbd037012030f52ee2bcebf9c5bce7a6/setup.py#L47), though this package was last updated about [5 years ago](https://pypi.org/project/sasl/) and [has issues](https://github.com/cloudera/python-sasl/issues/21) when run against newer versions of Python. This could...

jamescurtin

Kerberos (hive/presto) access documentation

12

Hi Appently ( #47 #91 ) kerberized access is available. However there is no example on how to use it in the documention. That would be more than helpfull Thanks

parisni

Support for complex types

7

I was wondering why PyHive doesn't support [complex types](https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Types#LanguageManualTypes-ComplexTypes) like ARRAY, MAP, STRUCT, etc?

john-bodley

python3.7 pyhive:0.6.3 create hive tables cursor.fetchall() return "No result set" but select no error

nmgliangwei

get_table_names() returns incorrect list of table names when querying Spark SQL Thriftserver

15

Hi, I found out that the method `get_table_names()` in class HiveDialect in sqlalchemy_hive.py does not return correct names of tables. The result of query `show tables` are 3-tuples in the...

rezabaktash

"TSocket read 0 bytes" error while running SQL query in a docker container

3

We are running a long-ish SQL query in pyhive from inside a python 3.6 container. The query freezes up after 10-15 mins and the error mentioned above is thrown. We...

rkhilnani9