[
https://issues.apache.org/jira/browse/TRAFODION-2728?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
David Wayne Birdsall updated TRAFODION-2728:
--------------------------------------------
Description:
When doing a SHOWSTATS on a native HBase table, the error message is strange if
the <code>"_HBASESTATS_"</code> 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.
was:
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.
> 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 <code>"_HBASESTATS_"</code> 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)
