[jira] [Commented] (TRAFODION-2529) Update stats on cell or row access to a Trafodion table raises error 9252

["David Wayne Birdsall (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/TRAFODION-2529?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15903326#comment-15903326 ] 

David Wayne Birdsall commented on TRAFODION-2529:
-------------------------------------------------

An example of the error:

>>update statistics for table hbase."_CELL_"."TRAFODION.MYSCH.MYTABLE" on every column sample random 10 percent;

*** ERROR[9252] Unable to get row count estimate: Error code 68, detail 4. Exception info (if any): org.apache.hadoop.hbase.TableNotFoundException: HBASE._CELL_.TRAFODION.MYSCH.MYTABLE
org.apache.hadoop.hbase.client.HTable.getTableDescriptor(HTable.java:651)
org.trafodion.sql.HBaseClient.estimateRowCountBody(HBaseClient.java:1367)
org.trafodion.sql.HBaseClient.estimateRowCount(HBaseClient.java:1164)

--- SQL operation failed with errors.
>>

The following script reproduces the problem:

log mytest.log clear;
create schema trafodion.mysch;
set schema trafodion.mysch;

create table trafodion.mysch.mytable (a int, b int);

update statistics for table hbase."_CELL_"."TRAFODION.MYSCH.MYTABLE" on every column sample random 10 percent;

update statistics for table hbase."_ROW_"."TRAFODION.MYSCH.MYTABLE" on every column sample random 10 percent;

drop schema trafodion.mysch cascade;

> Update stats on cell or row access to a Trafodion table raises error 9252
> -------------------------------------------------------------------------
>
>                 Key: TRAFODION-2529
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-2529
>             Project: Apache Trafodion
>          Issue Type: Bug
>          Components: sql-cmp
>    Affects Versions: 2.2-incubating
>            Reporter: David Wayne Birdsall
>            Assignee: David Wayne Birdsall
>




--
This message was sent by Atlassian JIRA
(v6.3.15#6346)