[
https://issues.apache.org/jira/browse/TAJO-233?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14173438#comment-14173438
]
Jihun Kang edited comment on TAJO-233 at 10/16/14 6:50 AM:
-----------------------------------------------------------
Hello, [~hyunsik].
It comes from the PostgreSQL JDBC Driver strictly check the data type of
columns. "expression_schema" column in "partition_methods" table stores data by
"VARCHAR(1024)" data type and "resultToPartitionMethodProto" function retrieves
this data by using "getBytes" function. On PostgreSQL server, "getBytes" and
other byte type related functions only work on bytea data type. Since
PostgreSQL 9, bytea format has been changed so we need to check if major
version of PostgreSQL is 9 or not for selecting "escape" format of bytea. I
would like to get your opinion on this issue.
was (Author: ykrips):
Hello, [~hyunsik].
It comes from the PostgreSQL JDBC Driver strictly check the data type of
columns. "expression_schema" column in "partition_methods" table stores data by
"VARCHAR(1024)" data type and "resultToPartitionMethodProto" function retrieves
this data by using "getBytes" function. On PostgreSQL server, "getBytes" and
other byte type related functions only work on bytea data type. Since
PostgreSQL 9, bytea format has been changed so we need to check if major
version of PostgreSQL is 9 or not for selecting "escape" format of bytea. I
think that we have two options to apply. One is that changes from VARCHAR(1024)
to BYTEA on expression_schema column, and other is that changes from getBytes
to getString.getBytes on "resultToPartitionMethodProto" function. I feel that
second one would be better for this issue, but I would like to get your opinion
on this issue.
> Support PostgreSQL CatalogStore
> -------------------------------
>
> Key: TAJO-233
> URL: https://issues.apache.org/jira/browse/TAJO-233
> Project: Tajo
> Issue Type: New Feature
> Components: catalog
> Reporter: Hyunsik Choi
> Assignee: Jihun Kang
> Labels: newbie
> Fix For: 0.9.1
>
> Attachments: postgresql.diff
>
>
> See the title. PostgreSQL is also an widely used open source DBMS. Like
> TAJO-179, we need to support postgresql catalog store.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
