[jira] [Created] (TRAFODION-2728) SHOWSTATS sometimes gives strange message when stats don't exist

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

David Wayne Birdsall created TRAFODION-2728:
-----------------------------------------------

             Summary: SHOWSTATS sometimes gives strange message when stats don't exist
                 Key: TRAFODION-2728
                 URL: https://issues.apache.org/jira/browse/TRAFODION-2728
             Project: Apache Trafodion
          Issue Type: Bug
          Components: sql-cmp
    Affects Versions: 2.3-incubating
         Environment: All
            Reporter: David Wayne Birdsall
            Assignee: David Wayne Birdsall
            Priority: Minor


When doing a SHOWSTATS on a native HBase table, the error message is strange if the "_HBASESTATS_" histogram tables do not exist. For example, in a fresh instance where that schema has not been created yet:

>>showstats for table hbase."_ROW_"."xyz" on existing columns;                    

*** ERROR[9200] UPDATE STATISTICS for table HBASE._ROW_.xyz encountered an error (4082) from statement .

*** ERROR[4082] Object TRAFODION."_HBASESTATS_".SB_HISTOGRAMS does not exist or is inaccessible.

*** ERROR[8822] The statement was not prepared.

--- SQL operation failed with errors.

However, if the "_HBASESTATS_" schema and histogram tables exist, we get a more friendly and normal looking error:

>>showstats for table hbase."_CELL_"."xyz" on existing columns;

Histogram data for Table HBASE."_CELL_"."xyz"
Table ID: 0

   Hist ID # Ints    Rowcount         UEC Colname(s)
========== ====== =========== =========== ===========================

No Histograms exist for the requested columns or groups


--- SQL operation complete.
>>

The objective of this JIRA is to give the latter error message even if the "_HBASESTATS_" histograms tables do not exist.




--
This message was sent by Atlassian JIRA
(v6.4.14#64029)