error when querying for specific columns
- 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.