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

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 2.3
• Component/s: sql-cmp
• Environment: All
• Assignee: Yang, Yongfeng
• Reporter: Dave Birdsall
• Created: 29/Aug/17 21:56
• Updated: 28/Sep/17 09:22

Description

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.

Note: The things in italics are supposed to be surrounded by underscores; unfortunately underscore seems to be a metacharacter meaning "italics font" in JIRA and I don't know how to escape them.