PyHive
                                
                                
                                
                                    PyHive copied to clipboard
                            
                            
                            
                        Python interface to Hive and Presto. 🐝
System Info: ``` Python 3.10.0 | packaged by conda-forge | (default, Nov 20 2021, 02:25:18) [GCC 9.4.0] pyhive 0.6.4 | pyhd8ed1ab_0 | conda-forge ``` Logs: ``` ~/anaconda3/envs/****/lib/python3.10/site-packages/pyhive/hive.py in execute(self, operation,...
This patch fixes queries that use wildcards (%) in SQLAlchemy. The params argument is an empty dict if no extra parameters are provided. This causes [line 256 of presto.py](https://github.com/esemeniuc/PyHive/blob/6ef94d12f0a53c6c35b60bf335a731e3b585c9e6/pyhive/presto.py#L256) to...
Hi, I'm getting this warning when using the dialect with sqlalchemy : 1.4+ > SAWarning: Dialect databricks:connector will not make use of SQL compilation caching as it does not set...
Add _parse_date function modeled off _parse_timestamp. Hive introduced the DATE_TYPE in 0.12.0, and we're already translate 0.8.0's TIMESTAMP_TYPE to datetime. It seems like a logical enhancement to translate dates into...
Hi. I am trying to connect Hive server using PyHive and SQLAlchemy API with SASL as below code: `ssl_args = {'ssl_cert': 'cacerts.pem'}` `engine = create_engine("hive://username:[email protected]:10000/default?auth=LDAP", connect_args=ssl_args)` `insp = inspect(engine)` But...
PR for #408
- Supports HTTP transport for Thrift protocol. - Three types of authentication supported: NONE, NOSASL, BASIC and KERBEROS. - BASIC authentication is useful when the Thrift HTTP interface is behind...
I've been experimenting how to retrieve Hive resultsets in a more efficient way than a list of python tuples. For efficient computation, we need columnar representation and preferrably in contiguous...