[jira] [Created] (TRAFODION-3070) HIVE table should not create comment on

[zhang.lei (JIRA)]

zhang.lei created TRAFODION-3070:
------------------------------------

             Summary: HIVE table should not create comment on
                 Key: TRAFODION-3070
                 URL: https://issues.apache.org/jira/browse/TRAFODION-3070
             Project: Apache Trafodion
          Issue Type: Bug
          Components: sql-cmp
    Affects Versions: any
            Reporter: zhang.lei
             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)