[
https://issues.apache.org/jira/browse/PHOENIX-2953?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
JaeMyung Kim updated PHOENIX-2953:
----------------------------------
Description:
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
was:
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~1MB, 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
> 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)
