PyHive
PyHive copied to clipboard
dropbox
Python interface to Hive and Presto. 🐝
The [current implementation of `DECIMAL` (/`NUMERIC`)](https://github.com/dropbox/PyHive/blob/master/pyhive/sqlalchemy_hive.py#L176-L178) does not support the precision and scale attribute which is supported [since hive 0.13](https://cwiki.apache.org/confluence/display/hive/languagemanual+types#LanguageManualTypes-NumericTypes). possible implementation solution: ``` python class HiveTypeCompiler(compiler.GenericTypeCompiler): # [..] def...
Why are presto timestamp/decimal(38,18) data types returned a string (enclosed in u'') instead of python datetime/numeric types? #presto jdbc: select typeof(col1),typeof(col2),typeof(col3),typeof(col4),typeof(col5),typeof(col6) from hive.x.y #result is timestamp timestamp bigint decimal(38,18) varchar...
The BINARY data type is already supported via [`GenericTypeCompiler`](https://github.com/sqlalchemy/sqlalchemy/blob/1dd0f23e8d74aa7edc8dd309093a95171e2e8f09/lib/sqlalchemy/sql/compiler.py#L6009-L6013) but it has an optional length parameter which is not supported in Hive (see [Hive docs](https://cwiki.apache.org/confluence/display/hive/languagemanual+types)). With this PR the length...
Hi For StrictVersion(sqlalchemy.__version__) >= StrictVersion('0.6.0'): visit_DATE is returning 'TIMESTAMP'. Shouldn't it be DATE ?
Hey! Thanks for a great library! So I see 0.7.0 is out -> https://pypi.org/project/PyHive/0.7.0/, but I can't seem to find the tag for it on this repo (https://github.com/dropbox/PyHive/releases).
This PR updates the Hive Thrift specification. In particular, this adds the TIMESTAMPLOCALTZ type. Fixes #285
I am trying to use pandas to insert a batch of data to a Hive table and it bombs after the first insert. PyHive seems to try to get a...
Where are these missing tags?... 
regex = r"Table\ \'.*{}\'\ does\ not\ exist".format(re.escape(table_name)) if msg and re.search(regex, msg): raise exc.NoSuchTableError(table_name) else: raise with presto and Oracle, Oracle has table name with upper case, but table name...
