AttributeError: 'Cursor' object has no attribute 'poll' about pyhive HOT 5 CLOSED

Could you please upgrade to the latest version?

from pyhive.

Jing,

I did the upgrade and still have the issue:

[root@hdpmaster3 ~]# sudo pip install --upgrade pyhive
Collecting pyhive
Downloading PyHive-0.2.1.tar.gz (42kB)
100% |████████████████████████████████| 51kB 2.5MB/s
Requirement already up-to-date: future in /usr/lib/python2.7/site-packages (from pyhive)
Installing collected packages: pyhive
Found existing installation: PyHive 0.1.8
Uninstalling PyHive-0.1.8:
Successfully uninstalled PyHive-0.1.8
Running setup.py install for pyhive ... done
Successfully installed pyhive-0.2.1
[root@hdpmaster3 ~]#

import pyhive
cursor.execute(sql, async=True)
Traceback (most recent call last):
File "", line 1, in
TypeError: execute() got an unexpected keyword argument 'async'

regards,
Austin D. Trombley, MBA
Senior Manager – Business Intelligence
cell: 415-767-6179
[cid:[email protected]]http://www.prosper.com/

From: Jing Wang [email protected]
Reply-To: dropbox/PyHive [email protected]
Date: Thursday, June 30, 2016 at 11:03 AM
To: dropbox/PyHive [email protected]
Cc: Austin Trombley [email protected], Author [email protected]
Subject: Re: [dropbox/PyHive] AttributeError: 'Cursor' object has no attribute 'poll' (#64)

Could you please upgrade to the latest version?

—
You are receiving this because you authored the thread.
Reply to this email directly, view it on GitHubhttps://github.com//issues/64#issuecomment-229740244, or mute the threadhttps://github.com/notifications/unsubscribe/AKrx0LXp95uIGmg2tPfOSFqxNI7-C-Vvks5qRATjgaJpZM4JCahY.

CONFIDENTIALITY STATEMENT: This email message, together with all attachments, is intended only for the individual or entity to which it is addressed and may contain legally privileged or confidential information. Any dissemination, distribution or copying of this communication by persons or entities other than the intended recipient, is strictly prohibited, and may be unlawful. If you have received this communication in error please contact the sender immediately and delete the transmitted material and all copies from your system, or if received in hard copy format, return the material to us via the United States Postal Service. Thank you.

from pyhive.

Try checking if your PYTHONPATH is correct. I'm quite sure this argument exists in 0.2 onwards :)

print pyhive.__version__
print pyhive.__file__

and maybe try deleting pyc files.

from pyhive.

You are right, I rebooted my system – and it now executes but I never see any of the statuses to see if it is running etc? it just immediately completes?

cursor.execute(sql, async=True)

status = cursor.poll().operationState
while status in (TOperationState.INITIALIZED_STATE, TOperationState.RUNNING_STATE):
... logs = cursor.fetch_logs()
... for message in logs:
... print message
... status = cursor.poll().operationState
... print status
...

regards,
Austin D. Trombley, MBA
Senior Manager – Business Intelligence
cell: 415-767-6179
[cid:[email protected]]http://www.prosper.com/

From: Jing Wang [email protected]
Reply-To: dropbox/PyHive [email protected]
Date: Thursday, June 30, 2016 at 11:18 AM
To: dropbox/PyHive [email protected]
Cc: Austin Trombley [email protected], Author [email protected]
Subject: Re: [dropbox/PyHive] AttributeError: 'Cursor' object has no attribute 'poll' (#64)

Try checking if your PYTHONPATH is correct. I'm quite sure this argument exists in 0.2 onwards :)

print pyhive.version

print pyhive.file

and maybe try deleting pyc files.

—
You are receiving this because you authored the thread.
Reply to this email directly, view it on GitHubhttps://github.com//issues/64#issuecomment-229744472, or mute the threadhttps://github.com/notifications/unsubscribe/AKrx0Ct5-kQdtiaRiOW72WWK8kHLA1Hsks5qRAhzgaJpZM4JCahY.

CONFIDENTIALITY STATEMENT: This email message, together with all attachments, is intended only for the individual or entity to which it is addressed and may contain legally privileged or confidential information. Any dissemination, distribution or copying of this communication by persons or entities other than the intended recipient, is strictly prohibited, and may be unlawful. If you have received this communication in error please contact the sender immediately and delete the transmitted material and all copies from your system, or if received in hard copy format, return the material to us via the United States Postal Service. Thank you.

from pyhive.

I believe Hive only generates logs for non-trivial jobs that trigger a mapreduce. If you run something that triggers the fetch task optimization (e.g. select f(columns) from table where {some partition col}) then I think it doesn't log anything.

from pyhive.