PyHive - Python interface to Hive and Presto. 🐝

  •        280

PyHive is a collection of Python DB-API and SQLAlchemy interfaces for Presto and Hive.First install this package to register it with SQLAlchemy (see setup.py).

https://github.com/dropbox/PyHive

Tags
Implementation
License
Platform

   




Related Projects

impyla - Python DB API 2.0 client for Impala and Hive (HiveServer2 protocol)

  •    Python

Python client for HiveServer2 implementations (e.g., Impala, Hive) for distributed query engines. For higher-level Impala functionality, including a Pandas-like interface over distributed data sets, see the Ibis project.

hadoop-ansible - Ansible playbook that installs a Hadoop cluster, with HBase, Hive, Presto for analytics, and Ganglia, Smokeping, Fluentd, Elasticsearch and Kibana for monitoring and centralized log indexing

  •    Shell

Ansible playbook that installs a CDH 4.6.0 Hadoop cluster (running on Java 7, supported from CDH 4.4), with HBase, Hive, Presto for analytics, and Ganglia, Smokeping, Fluentd, Elasticsearch and Kibana for monitoring and centralized log indexing. Follow @analytically. Browse the CI build screenshots.

genie - Distributed Big Data Orchestration Service

  •    Java

Genie is a federated job orchestration engine developed by Netflix. Genie provides REST-ful APIs to run a variety of big data jobs like Hadoop, Pig, Hive, Spark, Presto, Sqoop and more. It also provides APIs for managing the metadata of many distributed processing clusters and the commands and applications which run on them.See the official website to find documentation about Genie and specific documentation for various releases.


presto-ethereum - Presto Ethereum Connector -- SQL on Ethereum

  •    Java

Presto is a powerful interactive querying engine that enables running SQL queries on anything -- be it MySQL, HDFS, local file, Kafka -- as long as there exist a connector to the source. This is a Presto connector to the Ethereum blockchain data. With this connector, one can get hands on with Ethereum blockchain analytics work without having to know how to play with the nitty gritty Javascript API.

PyDAL

  •    Python

PyDal is a pure Python database abstraction layer. It provides a DBAPI 2.0 wrapper for DBAPI 2.0 drivers. Sounds strange, but even drivers that fully conform to the API can differ enough to make building database independent applications difficult.

Presto - Distributed SQL query engine for big data

  •    Java

Presto is an open source distributed SQL query engine for running interactive analytic queries against data sources of all sizes ranging from gigabytes to petabytes. It allows querying data from relational / nosql databases. A single Presto query can combine data from multiple sources, allowing for analytics across your entire organization. It is developed by Facebook.

Hive-JSON-Serde - Read - Write JSON SerDe for Apache Hive.

  •    Java

This library enables Apache Hive to read and write in JSON format. It includes support for serialization and deserialization (SerDe) as well as JSON conversion UDF. Download the latest binaries (json-serde-X.Y.Z-jar-with-dependencies.jar and json-udf-X.Y.Z-jar-with-dependencies.jar) from congiu.net/hive-json-serde. Choose the correct verson for CDH 4, CDH 5 or Hadoop 2.3. Place the JARs into hive/lib or use ADD JAR in Hive.

Shark - Hive on Spark

  •    Scala

Shark is an open source distributed SQL query engine for Hadoop data. It brings state-of-the-art performance and advanced analytics to Hive users. It runs Hive queries up to 100x faster in memory, or 10x on disk. it is a large-scale data warehouse system for Spark designed to be compatible with Apache Hive.

sqlalchemy-migrate - Database schema migration for SQLAlchemy

  •    Python

Fork from http://code.google.com/p/sqlalchemy-migrate/ to get it working with SQLAlchemy 0.8.Inspired by Ruby on Rails' migrations, Migrate provides a way to deal with database schema changes in SQLAlchemy projects.

Apache Hive - The Apache Hive (TM) data warehouse software facilitates querying and managing large d

  •    Java

The Apache Hive (TM) data warehouse software facilitates querying and managing large datasets residing in distributed storage.

awesome-sqlalchemy - A curated list of awesome tools for SQLAlchemy

  •    Python

Licensed under a Creative Commons Attribution-ShareAlike 4.0 International License. Versioning and auditing extension for SQLAlchemy.

git-remote-dropbox - A transparent bridge between Git and Dropbox - use a Dropbox (shared) folder as a Git remote! :gift:

  •    Python

This Git remote helper makes Dropbox act like a true Git remote. It maintains all guarantees that are provided by a traditional Git remote while using Dropbox as a backing store. This means that it works correctly even when there are multiple people operating on the repository at once, making it possible to use a Dropbox shared folder as a Git remote for collaboration.Once the helper is installed, using it is as simple as adding a remote like dropbox:///path/to/repo.

Presto Web

  •    PHP

Presto Web provides a complete content management system with a packages system that let you build your website as you want (only what you need)

Presto Poll

  •    PHP

Presto Poll is an excellent addition to any website. It supports several different databases, using SimpleXML, PHP, and flatfiles. It has an administration module where modification of all of the settings is possible. The poll result itself includes both

Presto

  •    Java

Presto is a music notation program aimed at making it easy for a composer to rapidly convert a musical sketch (melody, counterpoint, harmonic support and bass) into a complete musical arrangement.

slivu-presto

  •    Ruby

Presto - a Classy Web Framework aimed at Speed and Simplicity

Nuage - A Dropbox-like interface for your existing data (with support for many backends)

  •    Javascript

A Dropbox-like file manager that let you manage your data anywhere it is located. It could be FTP, SFTP, WebDAV, Git, S3, Minio, Dropbox, Google Drive. It helps to manage your files from a browser, Upload files and folders, Audio player, Video player, Image viewer and lot more.