[
https://issues.apache.org/jira/browse/TAJO-1360?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14392292#comment-14392292
]
Hudson commented on TAJO-1360:
------------------------------
ABORTED: Integrated in Tajo-master-CODEGEN-build #282 (See
[https://builds.apache.org/job/Tajo-master-CODEGEN-build/282/])
TAJO-1360: VALUES_ field in OPTIONS table of catalog store should be longer.
(jihun: rev d6735fb929daf86df3c8adb729a4e64bce95462b)
* tajo-catalog/tajo-catalog-server/src/main/resources/schemas/derby/derby.xml
*
tajo-catalog/tajo-catalog-server/src/main/resources/schemas/mariadb/table_properties.sql
* tajo-catalog/tajo-catalog-server/src/main/resources/schemas/oracle/oracle.xml
* CHANGES
*
tajo-catalog/tajo-catalog-server/src/main/resources/schemas/postgresql/postgresql.xml
*
tajo-catalog/tajo-catalog-server/src/main/resources/schemas/mysql/table_properties.sql
> VALUES_ field in OPTIONS table of catalog store should be longer.
> -----------------------------------------------------------------
>
> Key: TAJO-1360
> URL: https://issues.apache.org/jira/browse/TAJO-1360
> Project: Tajo
> Issue Type: Bug
> Components: catalog
> Reporter: Hyunsik Choi
> Assignee: DaeMyung Kang
> Fix For: 0.11.0
>
>
> 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:
> {code}
> 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
> )
> {code}
> 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.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
