[jira] [Created] (PHOENIX-2953) some value is returned null when selecting query if phoenix table has a big length column

[JaeMyung Kim (JIRA)]

JaeMyung Kim created PHOENIX-2953:
-------------------------------------

             Summary: 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~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











--
This message was sent by Atlassian JIRA
(v6.3.4#6332)