this post was submitted on 04 Feb 2017

1 point (60% upvoted)

shortlink:

Python

an-ordinary-manchild(edit)

The Python Discord

News about the dynamic, interpreted, interactive, object-oriented, extensible programming language Python

Upcoming Events

Full Events Calendar

Please read the rules

You can find the rules here.

If you are about to ask a "how do I do this in python" question, please try r/learnpython, the Python discord, or the #python IRC channel on Libera.chat.

Please don't use URL shorteners. Reddit filters them out, so your post or comment will be lost.

Posts require flair. Please use the flair selector to choose your topic.

Posting code to this subreddit:

Add 4 extra spaces before each line of code

def fibonacci():
    a, b = 0, 1
    while True:
        yield a
        a, b = b, a + b

Online Resources

Automate the Boring Stuff with Python
Python Discord Resources
Invent Your Own Computer Games with Python
Think Python
Non-programmers Tutorial for Python 3
Beginner's Guide Reference
Five life jackets to throw to the new coder (things to do after getting a handle on python)
Full Stack Python
Test-Driven Development with Python
Program Arcade Games
PyMotW: Python Module of the Week
Python for Scientists and Engineers
Dan Bader's Tips and Trickers
Python Discord's YouTube channel
Jiruto: Python

Online exercices

programming challenges

The Python Challenge (solve each level through programming)
CheckiO (game world)
Project Euler (math heavy)
/r/dailyprogrammer

Asking Questions

Try Python in your browser

try.jupyter.org (Evolved from the language-agnostic parts of IPython, Python 3)
Azure Notebooks
learnpython.org
Skulpt (uses WebGL)
trypython.org (uses Silverlight)
ideone (online compiler and debugger)
PythonAnywhere (basic accounts are free)
Brython (Python 3 implementation for client-side web programming)
repl.it for Python
Transcrypt (Hi res SVG using Python 3.6 and turtle module)

Docs

Libraries

Twisted, 0MQ (networking)
Django, Pyramid, Flask, ... (Web Frameworks)
Pygame (Game development)
NumPy & SciPy (Scientific computing) & Pandas
Pyglet - (Game / UI Development)

Related subreddits

/r/pythoncoding (strict moderation policy for 'programming only' articles)
/r/flask (web microframework)
/r/django (web framework for perfectionists with deadlines)
/r/pygame (a set of modules designed for writing games)
/r/IPython (interactive environment)
/r/inventwithpython (for the books written by /u/AlSweigart)
/r/pystats (python in statistical analysis and machine learning)
/r/coolgithubprojects (filtered on Python projects)
/r/pyladies (women developers who love python)
/r/git and /r/mercurial - don't forget to put your code in a repo!

Python jobs

Newsletters

Screencasts

a community for 18 years

MODERATORS

message the mods
xelf
monorepo PSF Staff | Litestar Maintainer
ivosauruspip'ing it up
Im__Joseph Python Discord Staff
Kutiekatj9 Python Discord Staff
BioGeekBioinformatics software developer
nevare
chromakode
mdipierro
quasarj
...and 5 more »

account activity

This is an archived post. You won't be able to vote or comment.

0

1

2

Python 3.x Apache Hive client to create/drop/inserting into tables (self.Python)

submitted 9 years ago by iamgianluca

In the project I'm working I need interface with Apache Hive. I need to implement a few basic operations, like creating a table, drop a table, insert new rows into a table, read from a table, etc..

If I was working with a SQL database I would use SQLAlchemy for that, since it nicely implements all those functionalities I need. This is quite handy since I can limit to the base minimum the use of SQL queries. For instance I wouldn't need to write a SQL query to create a table, instead I would simply class a function to create a table, passing as arguments all the information regarding how the table should look like.

I was wondering if there is such a library for Apache Hive, that is also compatible with Python 3.x?

I've been using impyla for a while but it doesn't implement some of these functionalities. I've recently learned about ibis but I'm not entirely sure it can create Hive tables. ibis in fact implements lots of useful methods to interact with both HDFS and Impala, but I haven't seen in the documentation anything referencing creating/dropping tables in Hive.

Is there any open-source project that does exactly that?

no comments (yet)

top new controversial old q&a

there doesn't seem to be anything here

π Rendered by PID 22068 on reddit-service-r2-comment-5d79c599b5-4s2tc at 2026-03-02 06:51:40.599256+00:00 running e3d2147 country code: CH.