We are having a big bottleneck issue in fetching large dataset say 2GB. The error I am getting is “query took too long”. And the Metabase UI is frozen.
And in background of metabase container stat, i could see the CPU usage reaching more than 200 and then flatten to 0.
I tried couple of work around like passing the parameter
-e “JAVA_TOOL_OPTIONS=-Xmx16g”, but still facing the same issue.
The container logs is below:
Mar 28, 2019 3:46:22 PM net.snowflake.client.jdbc.internal.apache.http.impl.execchain.RetryExec execute
INFO: I/O exception (net.snowflake.client.jdbc.internal.apache.http.NoHttpResponseException) caught when processing request to {s}->https://sfc-va-ds1-customer-stage.s3.amazonaws.com:443: The target server failed to respond
Mar 28, 2019 3:46:22 PM net.snowflake.client.jdbc.internal.apache.http.impl.execchain.RetryExec execute
INFO: Retrying request to {s}->https://sfc-va-ds1-customer-stage.s3.amazonaws.com:443
i have a feeling it s out of memory issue, however still can not find a workaround.
And could you please state the exact issue you are facing.
Like if the query taking to long is getting displayed on Metabase UI or the container is getting Killed all together.