[ https://issues.apache.org/jira/browse/TRAFODION-2728?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Yang, Yongfeng reassigned TRAFODION-2728: ----------------------------------------- Assignee: Yang, Yongfeng (was: David Wayne Birdsall) > 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: Yang, Yongfeng > 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. > 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. -- This message was sent by Atlassian JIRA (v6.4.14#64029)