Uploaded image for project: 'Apache Trafodion'
  1. Apache Trafodion
  2. TRAFODION-3070

Cannot create comment on HIVE table

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: any
    • Fix Version/s: any
    • Component/s: sql-general
    • Labels:
      None
    • Flags:
      Patch

      Description

      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' ;

      ;

        Attachments

          Activity

            People

            • Assignee:
              zhang.lei zhang.lei
              Reporter:
              zhang.lei zhang.lei
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:

                Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 0.5h
                0.5h