Got `ResultSet is closed` error while iterating over cursor to fetch large result after 10 min

lalinsky / python-phoenixdb

Phoenix database adapter for Python (migrated to the Apache Phoenix repo)

Apache License 2.0

26 stars 24 forks source link

Open DeanThompson opened 4 years ago

DeanThompson commented 4 years ago

My Phoenix version is 4.14.0-cdh5.14.2.

I know that the default phoenix.query.timeoutMs is 10 minutes, so added the following configurations to the hbase-site.xml. But this didn't work.

property	value
`phoenix.query.timeoutMs`	3600000 (1 hour)
`hbase.client.scanner.timeout.period`	1200000 (20 minutes)
`hbase.rpc.timeout`	1200000 (20 minutes)
`hbase.client.scanner.timeout.period`	1200000 (20 minutes)

Is there any way to set the query timeout through the Python driver?