[
https://issues.apache.org/jira/browse/TRAFODION-3084?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16490183#comment-16490183
]
zhang.lei edited comment on TRAFODION-3084 at 5/25/18 3:44 AM:
---------------------------------------------------------------
Hi, [~anoopsharma] , I'm so happy that you told us the real reason for this
problem. as you said, I succeeded after registered it. then i do 'SHOWDDL' ,
but comments is not displayed, is this normal?
>>comment on table test03 is 'test03';
— SQL operation complete.
>>showddl test03;
/* Hive DDL */
CREATE TABLE DEFAULT.TEST03
(
A bigint
, B char(4)
, C char(4)
)
stored as textfile
;
/* Trafodion DDL */
REGISTER HIVE TABLE HIVE.HIVE.TEST03;
/* ObjectUID = 8608229581284533233 */
– GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON HIVE.HIVE.TEST03 TO
DB__HIVEROLE WITH GRANT OPTION;
— SQL operation complete.
>>
And i have a anther small question: After a HIVE/HBase table is deleted from
hbase shell, we also unregister it?
was (Author: zhang.lei):
Hi, [~anoopsharma] , I'm so happy that you told us the real reason for this
problem. as you said, I succeeded after registered it. then i do 'SHOWDDL' ,
but comments is not displayed, is this normal?
>>comment on table test03 is 'test03';
--- SQL operation complete.
>>showddl test03;
/* Hive DDL */
CREATE TABLE DEFAULT.TEST03
(
A bigint
, B char(4)
, C char(4)
)
stored as textfile
;
/* Trafodion DDL */
REGISTER HIVE TABLE HIVE.HIVE.TEST03;
/* ObjectUID = 8608229581284533233 */
-- GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON HIVE.HIVE.TEST03 TO
DB__HIVEROLE WITH GRANT OPTION;
--- SQL operation complete.
>>
And i have anther small question: After a HIVE/HBase table is deleted from
hbase shell, we also unregister it?
> 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)
