[ https://issues.apache.org/jira/browse/TRAFODION-1740?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15088134#comment-15088134 ]
ASF GitHub Bot commented on TRAFODION-1740: ------------------------------------------- GitHub user DaveBirdsall opened a pull request: https://github.com/apache/incubator-trafodion/pull/253 [TRAFODION-1740] Add CQDs to UPDATE STATS for large tables You can merge this pull request into a Git repository by running: $ git pull https://github.com/DaveBirdsall/incubator-trafodion Trafodion1740 Alternatively you can review and apply these changes as the patch at: https://github.com/apache/incubator-trafodion/pull/253.patch To close this pull request, make a commit to your master/trunk branch with (at least) the following in the commit message: This closes #253 ---- commit 99a143f29910c7d3c8e02fb1bf101214568bf80a Author: Dave Birdsall <dbirds...@apache.org> Date: 2016-01-07T21:18:51Z [TRAFODION-1740] Add CQDs to UPDATE STATS for large tables ---- > Use CQDs to prevent time-outs and speed sampling in UPDATE STATS > ---------------------------------------------------------------- > > Key: TRAFODION-1740 > URL: https://issues.apache.org/jira/browse/TRAFODION-1740 > Project: Apache Trafodion > Issue Type: Bug > Components: sql-cmp > Affects Versions: 2.0-incubating, 1.3-incubating > Environment: All; however this is particularly noticeable in clusters > Reporter: David Wayne Birdsall > Assignee: David Wayne Birdsall > > When doing UPDATE STATISTICS on large tables (one example had 17.7 billion > rows), we sometimes time-out with an error like the following: > SQL>update statistics for table table1 on every column sample; > *** ERROR[9200] UPDATE STATISTICS for table TRAFODION.SEABASE.TABLE1 encounter > ed an error (8448) from statement Process_Query. [2015-12-15 12:18:45] > *** ERROR[8448] Unable to access Hbase interface. Call to > ExpHbaseInterface::nex > tRow returned error HBASE_ACCESS_ERROR(-706). Cause: > java.util.concurrent.ExecutionException: > org.apache.hadoop.hbase.client.RetriesE > xhaustedException: Failed after attempts=36, exceptions: > Tue Dec 15 17:18:19 GMT 2015, null, java.net.SocketTimeoutException: > callTimeout > =60000, callDuration=60303: row '?. [2015-12-15 12:18:45] -- This message was sent by Atlassian JIRA (v6.3.4#6332)