[
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 7:09 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 whether we use bytea or blob data
type for this column.
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
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)
