phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "JaeMyung Kim (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (PHOENIX-2953) some value is returned null when selecting query if phoenix table has a big length column
Date Fri, 03 Jun 2016 06:04:59 GMT

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

Mime
View raw message