[TRAFODION-3084] Cannot create comment on HBASE table

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Assignee: shaoyong.li
• Reporter: shaoyong.li
• Created: 24/May/18 08:02
• Updated: 12/Jun/18 01:25

Description

I found I cannot direct create comment on hbase table.
SQL>comment on table hbase."CELL"."cdr" is 'test'

ERROR[1389] Object HBASE."CELL"."cdr" does not exist in Trafodion. [2018-05-14 15:55:40]

But, after doing update statistics on hbase table successfully, comment statement runs successfully on hbase table.

SQL>update statistics for table hbase."CELL"."cdr" on every column;

— SQL operation complete.

SQL>comment on table hbase."CELL"."cdr" is 'test cdr';

— SQL operation complete.

SQL>showddl hbase."CELL"."cdr";

/*
CREATE TABLE HBASE."CELL"."cdr"
  (
    ROW_ID VARCHAR(100) CHARACTER SET ISO88591
      COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED
  , COL_FAMILY VARCHAR(100) CHARACTER SET ISO88591
      COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED
  , COL_NAME VARCHAR(100) CHARACTER SET ISO88591
      COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED
  , COL_TIMESTAMP LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE
      NOT SERIALIZED
  , COL_VALUE VARCHAR(1000) CHARACTER SET ISO88591
      COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED
  , PRIMARY KEY (ROW_ID ASC)
  )
;
*/

/* HBase DDL */
CREATE HBASE TABLE cdr ( COLUMN FAMILY '#1')

REGISTER /INTERNAL/ HBASE TABLE cdr;
/* ObjectUID = 6735857105763057363 */

COMMENT ON TABLE HBASE."CELL"."cdr" IS 'test cdr' ;

– GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON HBASE."CELL"."cdr" TO DB__HBASEROLE WITH GRANT OPTION;

— SQL operation complete.

Issue Links

• links to: GitHub Pull Request #1597