Metadata-Version: 2.1
Name: hiveqlKernel
Version: 1.0.0
Summary: HiveQL Kernel
Home-page: https://github.com/EDS-APHP/HiveQLKernel
Author: APHP - EDS
Author-email: UNKNOWN
License: MIT
Keywords: Hive HiveQL PyHive Kernel Ipykernel
Platform: UNKNOWN
Requires-Dist: ipykernel (==4.*)
Requires-Dist: jupyter-client (==5.*)
Requires-Dist: jupyter-core (==4.*)
Requires-Dist: pandas (==0.23.*)
Requires-Dist: pyhive (==0.6.*)
Requires-Dist: sasl (==0.2.*)
Requires-Dist: thrift-sasl (==0.3.*)

# HiveQL Kernel

If you are going to connect using kerberos:

```
sudo apt-get install python3-dev libsasl2-dev libsasl2-2 libsasl2-modules-gssapi-mit
```


To install the kernel:

```
pip install .
jupyter hiveql install --user
```


How to use in Notebooks:


First create your connection, inside a Notebook cell configure the connection:

```
$$ url=hive://<kerberos-username>@<hive-host>:<hive-port>/<db-name>
$$ connect_args={"auth": "KERBEROS","kerberos_service_name": "hive"}
$$ pool_size=5
$$ max_overflow=10
```

These args are passed to sqlalchemy, who registered pyHive as the 'hive' SQL back-end.
See [github.com/dropbox/PyHive](https://github.com/dropbox/PyHive/#sqlalchemy).


You can now type HiveQL inside the next Notebook cells:

```
SHOW TABLES
```

Have fun!

