[
https://issues.apache.org/jira/browse/PHOENIX-2953?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15313636#comment-15313636
]
JaeMyung Kim commented on PHOENIX-2953:
---------------------------------------
I tested more cases.
1) inserted one record with 50KB sized image and ran application, then it
works fine
2) inserted one record with 3MB sized image and ran application, then it
returns null
3) created table with 1-column family table like this
create table PHOENIX_TEST (
ID char(32) not null PRIMARY KEY,
IMAGE_BYTE varbinary,
COME_FROM varbinary
) SALT_BUCKETS=16
and inserted one record with 3MB sized image, then it works fine.
I think that there is a problem when it is used both multiple column families
in phoenix table and big-sized data (over 2MB)
> some value is returned null when selecting query if phoenix table has a big
> length column
> -----------------------------------------------------------------------------------------
>
> Key: PHOENIX-2953
> URL: https://issues.apache.org/jira/browse/PHOENIX-2953
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 4.5.2
> Environment: cloudera hadoop - 5.5.2
> phoenix-4.5.2
> Reporter: JaeMyung Kim
>
> I created table
> create table PHOENIX_TEST (
> ID char(32) not null PRIMARY KEY,
> A.IMAGE_BYTE varbinary,
> B.COME_FROM varbinary
> )SALT_BUCKETS=16
> IMAGE_BYTE can be 50KB~10MB, and 200 records are inserted
> Every column value of record in PHOENIX_TEST is not null, but
> PhoenixResultSet sometimes returns null column value.
> Here is my test code.
> val lookupStatement = phoenixConnection.prepareStatement("select ID,
> IMAGE_BYTE, COME_FROM from PHOENIX_TEST")
> lookupStatement.setQueryTimeout(60000)
> val rs = lookupStatement.executeQuery()
> while (rs.next()) {
> val id = rs.getString("ID")
> val s = rs.getBytes("COME_FROM")
> if (s == null) {
> println(s"Something is wrong, every value of COME_FROM is not
> NULL, id=$id")
> }
> }
> rs.close()
> lookupStatement.close()
> if I exclude IMAGE_BYTE, it was OK.
> select ID, COME_FROM from PHOENIX_TEST
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
