[
https://issues.apache.org/jira/browse/PHOENIX-2953?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
JaeMyung Kim updated PHOENIX-2953:
----------------------------------
Summary: some value is returned null when phoenix table has a big
length(over 2MB) column and table is created with multiple column family (was:
some value is returned null when selecting query if phoenix table has a big
length column)
> some value is returned null when phoenix table has a big length(over 2MB)
> column and table is created with multiple column family
> ---------------------------------------------------------------------------------------------------------------------------------
>
> 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)
