impyla - as_pandas - empty dataframe

Question

I have a simple impyla code, and I would like to create a pandas dataFrame from my cursor. My code is running but my dataframe is always an empty dataframe. If I run my query directly on impala, the result is not empty. This is how my code looks like:

from impala.dbapi import connect
from impala.util import as_pandas


conn = connect(host='impala_server', port=21051,
               user='user' , password='pass',
               use_ssl=True,
               auth_mechanism='PLAIN')
cursor = conn.cursor()
cursor.execute("SELECT * FROM TABLE")

results = cursor.fetchall()

df = as_pandas(cursor)

print(df.head())

Help me please, what am I doing wrong?

score 1 · Answer 1 · edited Nov 19 '18 at 12:41

1

Just remove:

results = cursor.fetchall()

from your code. It should work.

edited Nov 19 '18 at 12:41

timgeb

76,762
20
123
145

answered Nov 19 '18 at 12:21

priyank goel

11
3

score 1 · Answer 2 · edited Jul 21 '20 at 08:59

1

'results = cursor.fetchall()  ' delete this line and it will be ok.

    from impala.dbapi import connect
    from impala.util import as_pandas
    
    conn = connect(host='****.com', port=****, database='****')
    cursor = conn.cursor()
    cursor.execute('select * from table limit 10')
    df = as_pandas(cursor)
    df.head()

I run the code above, and it run well.

edited Jul 21 '20 at 08:59

Roberto Caboni

7,252
10
25
39

answered Jul 21 '20 at 08:40

L.Hunter

21
3

impyla - as_pandas - empty dataframe

2 Answers2