Created on 01-13-2016 10:45 AM - edited 09-16-2022 02:57 AM
I am trying the sample impyla code from
http://blog.cloudera.com/blog/2014/04/a-new-python-client-for-impala/
And getting "impala.error.HiveServer2Error: Failed after retrying 3 times"
impyla is installed on the hadoop (CDH-5.3.2) node I log in to
Tried:
from impala.dbapi import connect
conn = connect(host='my.impala.host', port=21050)
cursor = conn.cursor()
cursor.execute('SELECT * FROM youval_db.accounts_info LIMIT 10')
print cursor.description # prints the result set's schema
results = cursor.fetchall()
Where for "my.impala.host" I used the the impala host I got from the cloudera manager.
(tried with host from the following groups: Impala Catalog Server Default Group, Impala Daemon Default Group and Impala StateStore Default Group)
got the same error for All.
Also tried with
conn = connect()
It did not work as well.
Any suggestion on how to make it work?
Thanks