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] [Comment Edited] (PHOENIX-2953) some value is returned null when selecting query if phoenix table has a big length column
Date Tue, 07 Jun 2016 02:04:20 GMT

    [ https://issues.apache.org/jira/browse/PHOENIX-2953?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15317658#comment-15317658
] 

JaeMyung Kim edited comment on PHOENIX-2953 at 6/7/16 2:04 AM:
---------------------------------------------------------------

I tested in phoenix sqline.

create table PHOENIX_TEST2 (
	ID char(32) not null PRIMARY KEY,
	A.IMAGE_BYTE varbinary,
	B.COME_FROM varbinary
) SALT_BUCKETS=16 , DEFAULT_COLUMN_FAMILY = 'A'

two recoreds were inserted
  ID='0000485eea3b6f60e286ec06af70e22b',  IMAGE_BYTE=> 3MB sized image bytes, COME_FROM
=> not null value
  ID='0000552574a27ab4601df3615f236567',  IMAGE_BYTE=> 1.5MB sized image bytes, COME_FROM
=> not null value


0: jdbc:phoenix:localhost:2181:/hbase> select * from PHOENIX_TEST2;
|                ID                       |                IMAGE_BYTE                |   
            COME_FROM      |
| 0000485eea3b6f60e286ec06af70e22b | [B@3db6ca90           |                             
    |
| 0000552574a27ab4601df3615f236567 | [B@2bacd397            | [B@5f7774e7                
     |


0: jdbc:phoenix:localhost:2181:/hbase> select COME_FROM from PHOENIX_TEST2;
|                COME_FROM                 |
| [B@4cb3bba1                              |
| [B@2be36e5e                              |


COME_FROM value of 0000485eea3b6f60e286ec06af70e22b  was null  if it was queried "select *
.. " but was not null if it was queried "select COME_FROM .."



was (Author: windbird):
I tested in phoenix sqline.

create table PHOENIX_TEST2 (
	ID char(32) not null PRIMARY KEY,
	A.IMAGE_BYTE varbinary,
	B.COME_FROM varbinary
) SALT_BUCKETS=16 , DEFAULT_COLUMN_FAMILY = 'A'

two recoreds were inserted
  ID='0000485eea3b6f60e286ec06af70e22b',  IMAGE_BYTE=> 3MB sized image bytes
  ID='0000552574a27ab4601df3615f236567',  IMAGE_BYTE=> 1.5MB sized image bytes


0: jdbc:phoenix:localhost:2181:/hbase> select * from PHOENIX_TEST2;
|                ID                       |                IMAGE_BYTE                |   
            COME_FROM      |
| 0000485eea3b6f60e286ec06af70e22b | [B@3db6ca90           |                             
    |
| 0000552574a27ab4601df3615f236567 | [B@2bacd397            | [B@5f7774e7                
     |


0: jdbc:phoenix:localhost:2181:/hbase> select COME_FROM from PHOENIX_TEST2;
|                COME_FROM                 |
| [B@4cb3bba1                              |
| [B@2be36e5e                              |


COME_FROM value of 0000485eea3b6f60e286ec06af70e22b  was null  if it was queried "select *
.. " but was not null if it was queried "select COME_FROM .."


> 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