PyHive
PyHive copied to clipboard
dropbox
Python interface to Hive and Presto. 🐝
Using Anaconda2 with sasl from: http://www.lfd.uci.edu/~gohlke/pythonlibs/ allows the package to install and load, but establishing a connection fails: ``` In [1]: from pyhive import hive In [2]: connection = hive.connect(xxxxx)...
Hi, when use hive.connect, could config timeout? `cursor = hive.connect(host='xxx', port=xxx, database=xxx, auth='KERBEROS', kerberos_service_name=xxx).cursor() cursor.execute('SELECT * FROM xxx')` I didn't see the timeout parameter,thanks `class Connection(object): """Wraps a Thrift session"""...
New additions: ``` 3644a97 (origin/master, origin/HEAD, master) feat: add HTTP and HTTPS to hive (#385) d6e7140 Add support for Trino (#381) 1548ecc Update poll_interval documentation (#369) ```
Presto SQL commands typically require a semicolon in multiline queries to mark completion (and is also good practice for single-line queries): ``` SHOW CATALOGS; ``` However, this does not currently...
Using a JDBC connection I could set up a read-only connection to Hive. Is there a way to do this with Python and PyHive? Let's assume that creating a read-only...
Support for Trino was added with #381 but no release has been cut yet. Could we release? I see @bkyryliuk had opened #387 but it was never merged in.... Thanks...
my hive table comment contain '\n' hive schema: CREATE EXTERNAL TABLE `test`.`test_01`( `name` string COMMENT 'aa bb\ncc'); pyhive rows: ['name', 'string', 'aa bb cc'] TypeError: expected string or bytes-like object...
Dots in column names get counted as separators between db name, table name and column name. Reason is code ``` dot_count = result.count('.') assert dot_count in (0, 1, 2), "Unexpected...
