dropbox / dropbox/PyHive

error when querying for specific columns

Open
#299 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
Python
Stars
1.7k
Forks
545
PR merge metrics
No merged PRs in 30d

Description

Hi,

I am new to PyHive and can connect and run a query that selects all columns, e.g.:

`SELECT * FROM mytable`

However, when I try to SELECT from specific columns,:

`SELECT col1, col2 FROM mytable`

I get a `pyhive.exc.NotSupportedError: Hive does not have transactions` error. I've doubled and tripled checked that the column names are in the table.

I see the same error posted on stackoverflow, but there was no solution provided:

[https://stackoverflow.com/questions/53128430/pyhive-issue-select-from-table-works-but-select-col-from-table-throws-err](https://stackoverflow.com/questions/53128430/pyhive-issue-select-from-table-works-but-select-col-from-table-throws-err)

perhaps related:
[https://stackoverflow.com/questions/34600351/hive-select-is-ok-but-select-a-column-fails?rq=1](https://stackoverflow.com/questions/34600351/hive-select-is-ok-but-select-a-column-fails?rq=1)

Any clues as to why this is happening?

thanks for any suggestions!
Steve

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.