Uploaded image for project: 'Tajo (Retired)'
  1. Tajo (Retired)
  2. TAJO-1360

VALUES_ field in OPTIONS table of catalog store should be longer.

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • 0.11.0, 0.10.1
    • Catalog
    • None

    Description

      Table properties for each table are maintained in OPTIONS table in catalog store. Each key and value for each table property use KEY_ and VALUE_ fields as follows:

      CREATE TABLE OPTIONS (
        TID INT NOT NULL,
        KEY_ VARCHAR(255) BINARY NOT NULL,
        VALUE_ VARCHAR(255) NOT NULL,
        PRIMARY KEY (TID, KEY_),
        FOREIGN KEY (TID) REFERENCES TABLES (TID) ON DELETE CASCADE
      )
      

      Newly adopted Hbase storage uses the table property columns to maintain the column map between a HBase table and Tajo table. VALUE_ is likely to cause 'Data too long' exception because its maximum length is just 256.

      So, we need to increase the maximum size. I think that 8000 would be proper because some RDBMSs supports VARCHAR types up to 8000 chars as far as I know.

      Attachments

        Activity

          People

            charsyam DaeMyung Kang
            hyunsik Hyunsik Choi
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: