[ https://issues.apache.org/jira/browse/TRAFODION-3084?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
shaoyong.li updated TRAFODION-3084: ----------------------------------- 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. was: 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. > 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 > Priority: Major > > 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)