Top 7 Python Hive Projects

sqlglot

55 5,441 9.9 Python

Python SQL Parser and Transpiler

Project mention: Transpile Any SQL to PostgreSQL Dialect | news.ycombinator.com | 2024-03-18

Recommend checking out https://github.com/tobymao/sqlglot if you are interested in this capability for other SQL dialects
Tools like this are helpful for:
- Rendering SQL in a consistent way, eg for snapshot testing

PyHive

1 1,665 3.5 Python

Python interface to Hive and Presto. 🐝
InfluxDB

www.influxdata.com sponsored

Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
jupysql

8 598 9.3 Python

Better SQL in Jupyter. 📊

Project mention: Show HN: JupySQL – a SQL client for Jupyter (ipython-SQL successor) | news.ycombinator.com | 2023-12-06

Hey, HN community!
We're stoked to launch JupySQL today! JupySQL is an open-source library that brings a modern SQL experience to Jupyter. JupySQL is compatible with all major databases, such as Snowflake, Redshift, PostgreSQL, MySQL, MariaDB, DuckDB, SQL Server, Clickhouse, Trino, and more!
To get started, check out our tutorial: https://jupysql.ploomber.io/en/latest/quick-start.html
SQL is the defacto language for data analysis; however, analysis often requires a mix of SQL and Python. JupySQL bridges this gap, allowing users to execute SQL queries seamlessly in Jupyter and continue their analysis in Python. Add %%sql to the top of your cell and start writing SQL.
Here are some of JupySQL's main features:
- Syntax highlighting

emr-serverless-samples

4 139 6.5 Python

Example code for running Spark and Hive jobs on EMR Serverless.
data-profiling

1 67 4.9 Python

a set of scripts to pull meta data and data profiling metrics from relational database systems
ExcelToDatabase

2 45 7.7 Python

import excel into database automatically

Project mention: Merging data from multiple Excel files | dev.to | 2024-03-28

ExcelToDatabase - Automation tool for batch importing Excel files into MySQL/Oracle/SQL Server/PostgreSQL/Access/Hive/SQLite/Dameng database

hivetools

1 12 1.8 Python

A collection of python scripts to work with Windows Hives.
WorkOS

workos.com sponsored

The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

NOTE: The open source projects on this list are ordered by number of github stars. The number of mentions indicates repo mentiontions in the last 12 Months or since we started tracking (Dec 2020).