shaoyong.li created TRAFODION-3084:
--------------------------------------
Summary: Cannot create comment on HBASE table
Key: TRAFODION-3084
URL: https://issues.apache.org/jira/browse/TRAFODION-3084
Project: Apache Trafodion
Issue Type: Bug
Reporter: shaoyong.li
Assignee: shaoyong.li
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.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
