[jira] [Updated] (PHOENIX-2953) some value is returned null when phoenix table has a big length(over 2MB) column and table is created with multiple column family

["JaeMyung Kim (JIRA)" <ji...@apache.org>]

     [ 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)