-
Couldn't load subscription status.
- Fork 5
Description
When running a slow query (30+ seconds), I'm getting the following error:
pyarrow._flight.FlightInternalError: Flight returned internal error, with message: Received RST_STREAM with error code 2. gRPC client debug context: UNKNOWN:Error received from peer ipv4:54.174.236.48:443 {created_time:"2023-05-26T17:31:53.650218-06:00", grpc_status:13, grpc_message:"Received RST_STREAM with error code 2"}. Client context: OK
I'm storing stock market information in my database, and running this query:
SELECT
DATE_BIN(INTERVAL '5 minutes', time) as date,
symbol,
selector_first(open, time)['value'] as open,
selector_last(close, time)['value'] as close,
selector_max(high, time)['value'] as high,
selector_min(low, time)['value'] as low,
sum(volume) as volume
from minute_bar
GROUP BY symbol, date
ORDER BY symbol, date
When running using the influxdb data explorer, this query takes around 2 minutes to run. I consistently get this same error when using the flightsql-dbapi python library to run the query