RedShift COPY Command Timeouts in DataGrip When Using "diststyle all" Table Option
Hi all,
I am trying to use the COPY command in RedShift on a table that is using the "diststyle all" distribution key option (copy table data duplicates across all RedShift cluster slices). When the query command executes in DataGrip, it spins indefinitely without ever completing. However, I can see in the AWS RedShift Console web app that the COPY commands ARE in fact actually completing successfully, so I believe the issue may be with DataGrip (or the RedShift JDBC driver).
I was at one point thinking this was a more generic timeout issue due to larger COPY command data loads (500 million records), but I've had other "normal" (non distyle all tables) run successfully in the 6 minute range.
I set the TcpTimeoutKeepalive JDBC option back to 1 minute (versus the default of 5 minutes). That didn't seem to resolve the distyle all COPY DataGrip timeout issue.
Pertinent version info:
RedShift JDBC driver version RedshiftJDBC42-1.2.7.1003.jar
DataGrip 2017.2.1
Java(TM) SE Runtime Environment (build 1.8.0_141-b15)
Java HotSpot(TM) 64-Bit Server VM (build 25.141-b15, mixed mode)
MacOS Sierra v 10.12.4
Thanks,
David
请先登录再写评论。