[
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*/