Hi! I’m a Python/SQL user, brand new to Hue. Is there a way to submit queries to Hive or Impala and get the results sent to a Python kernel, similar to pyodbc or SQLAlchemy?
Right now the API is not public (but REST will be with https://issues.cloudera.org/browse/HUE-1450 and the new Editor https://docs.gethue.com/latest/developer/api/), so it is not trivial to do what you want.
In the meantime, it can still be called:
http://gethue.com/login-into-hue-using-the-python-request-library/
Or the internal Python lib can also be reused:
http://gethue.com/hue-api-execute-some-builtin-commands/
http://gethue.com/quick-task-how-to-count-the-documents-of-a-user-via-the-shell/