通过Python访问Trino

2024-10-01 04:50:59 发布

您现在位置:Python中文网/ 问答频道 /正文

我正试图通过python访问trino,我不断地得到下面的错误。这是为了访问trino接口并从oracle检索数据。请告知如何解决此问题

HttpError                                 Traceback (most recent call last)
/tmp/ipykernel_166/2315044439.py in <module>
     10 )
     11 cur = conn.cursor()
---> 12 cur.execute('SELECT * FROM system.runtime.nodes')
     13 rows = cur.fetchall()
     14 print(cur)

~/.local/lib/python3.9/site-packages/trino/dbapi.py in execute(self, operation, params)
    394         else:
    395             self._query = trino.client.TrinoQuery(self._request, sql=operation)
--> 396             result = self._query.execute()
    397         self._iterator = iter(result)
    398         return result

~/.local/lib/python3.9/site-packages/trino/client.py in execute(self, additional_http_headers)
    505 
    506         response = self._request.post(self._sql, additional_http_headers)
--> 507         status = self._request.process(response)
    508         self.query_id = status.id
    509         self._stats.update({"queryId": self.query_id})

~/.local/lib/python3.9/site-packages/trino/client.py in process(self, http_response)
    382     def process(self, http_response) -> TrinoStatus:
    383         if not http_response.ok:
--> 384             self.raise_response_error(http_response)
    385 
    386         http_response.encoding = "utf-8"

~/.local/lib/python3.9/site-packages/trino/client.py in raise_response_error(self, http_response)
    373             raise exceptions.Http503Error("error 503: service unavailable")
    374 
--> 375         raise exceptions.HttpError(
    376             "error {}{}".format(
    377                 http_response.status_code,

HttpError: error 401: b'Unknown signing key ID'  ```


Tags: inpyselfclienthttpexecuteresponselib