How can I Execute a Query with API

[ighack]

CDH 6.3.2

import json
import pprint
import requests
import textwrap
import time

host = "http://bigdser5:8889"

header = {
    'User-agent': 'Mozilla/5.0 (Windows NT 10.0; WOW 64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.87 Safari/537.36 QIHU 360SE', 'Connection': 'keep-alive'}
session = requests.Session()
r = session.get(host + '/hue/accounts/login/?fromModal', headers=header)

form_data = {
    'username': 'jztwk',
    'password': '1111',
    'csrfmiddlewaretoken': session.cookies['csrftoken'],
    'next': '/'
}
login_url = host + "/accounts/login"
response = session.post(login_url, data=form_data,
                        cookies={}, headers={'Referer': login_url})

cookies = session.cookies
headers = session.headers

sql = textwrap.dedent("""
                      select * from hivetest.chinese_par
                      """)

impala_url = host + "/notebook/api/execute/impala"
impala_data = {
    'executable': '{"statement": "select * from hivetest.chinese_par","database": "default"}',
    'notebook': '{"type": "query-impala", "snippets": [{"id": 1, "statement_raw": "select * from hivetest.chinese_par", "type": "impala", "database": "default", "statementType": "text", "variables": []}], "name": "", "isSaved": false, "sessions": []}',
    'snippet': '{"id": 1, "type": "impala", "statementType": "text", "database": "default", "statement": "select * from hivetest.chinese_par", "properties": {}}'
}

_cookies = "csrftoken=" + cookies['csrftoken'] + \
    ";" + "sessionid=" + cookies['sessionid']

response_impala = session.post(impala_url, data=impala_data, cookies={}, headers={
    'Referer': impala_url, 'Cookie': _cookies, 'X-CSRFToken': cookies['csrftoken'],
    'Content-Type': 'application/x-www-form-urlencoded;charset=UTF-8'})

in response_impala .json() I get
{'status': -1, 'message': "'result'"}

response_impala.status_code is 200

[romainr]

Looks like the result key might be missing. Usually the best is to print what you get in have in the API server.

Good news though is that a much simpler API i on the way: #2155 and more

[ighack]

in response_impala.text is {'status': -1, 'message': "'result'"} yet

[github-actions[bot]]

This issue is stale because it has been open 30 days with no activity and is not "roadmap" labeled or part of any milestone. Remove stale label or comment or this will be closed in 5 days.

[romainr]

https://docs.gethue.com/developer/api/