[ https://issues.apache.org/jira/browse/TRAFODION-3070?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16488595#comment-16488595 ]
ASF GitHub Bot commented on TRAFODION-3070: ------------------------------------------- GitHub user zlei929 opened a pull request: https://github.com/apache/trafodion/pull/1578 [TRAFODION-3070] we cannot comment on native hive table. You can merge this pull request into a Git repository by running: $ git pull https://github.com/zlei929/trafodion master Alternatively you can review and apply these changes as the patch at: https://github.com/apache/trafodion/pull/1578.patch To close this pull request, make a commit to your master/trunk branch with (at least) the following in the commit message: This closes #1578 ---- commit c24c712f926b99a38a55e14f6ecdff282525b124 Author: zlei929 <z_lei929@...> Date: 2018-05-23T03:45:23Z [TRAFODION-3070] we cannot comment on native hive table. ---- > Cannot create comment on HIVE table > ----------------------------------- > > Key: TRAFODION-3070 > URL: https://issues.apache.org/jira/browse/TRAFODION-3070 > Project: Apache Trafodion > Issue Type: Bug > Components: sql-general > Affects Versions: any > Reporter: zhang.lei > Assignee: zhang.lei > Priority: Major > Fix For: any > > > I cannot create comment on HIVE table. > SQL>comment on table hive.hive.test01 is 'test'; > ---ERROR[1389] Object HIVE.HIVE.TEST01 does not exist in Trafodion. > [2018-05-14 15:51:31] > Then I create an external table in trafci for the hive table. > SQL>create external table test01(a largeint,b varchar(4), c varchar(4)) for > hive.hive.test01; > — SQL operation complete. > And I found I can create comment on the external table. > SQL>comment on table "__HV_HIVE__".test01 is 'test'; > — SQL operation complete. > SQL>showddl "__HV_HIVE__".test01; > CREATE EXTERNAL TABLE TEST01 > ( > A LARGEINT DEFAULT NULL NOT SERIALIZED > , B VARCHAR(4) CHARACTER SET ISO88591 COLLATE > DEFAULT DEFAULT NULL NOT SERIALIZED > , C VARCHAR(4) CHARACTER SET ISO88591 COLLATE > DEFAULT DEFAULT NULL NOT SERIALIZED > ) > FOR HIVE.HIVE.TEST01 > ; > COMMENT ON TABLE TRAFODION."__HV_HIVE__".TEST01 IS 'test' ; > After that, I try to create comment on the HIVE table. > The comment statement completes and I check ddls of the HIVE table. > But the comment 'test0102' doesn't appear in the ddl. > And comment statement are in front of the semicolon that is the end sign for > external table ddl. > SQL>comment on table hive.hive.test01 is 'test0102'; > — SQL operation complete. > SQL>showddl hive.hive.test01; > /* Hive DDL */ > CREATE TABLE DEFAULT.TEST01 > ( > A bigint > , B char(4) > , C char(4) > ) > stored as textfile > ; > /* Trafodion DDL */ > REGISTER /*INTERNAL*/ HIVE TABLE HIVE.HIVE.TEST01; > /* ObjectUID = 1137319817757950657 */ > CREATE EXTERNAL TABLE TEST01 > ( > A LARGEINT DEFAULT NULL NOT SERIALIZED > , B VARCHAR(4) CHARACTER SET ISO88591 COLLATE > DEFAULT DEFAULT NULL NOT SERIALIZED > , C VARCHAR(4) CHARACTER SET ISO88591 COLLATE > DEFAULT DEFAULT NULL NOT SERIALIZED > ) > FOR HIVE.HIVE.TEST01 > COMMENT ON TABLE TRAFODION."__HV_HIVE__".TEST01 IS 'test' ; > ; -- This message was sent by Atlassian JIRA (v7.6.3#76005)