Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None

      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.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                shaoyong shaoyong.li
                Reporter:
                shaoyong shaoyong.li
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated: