[jira] [Resolved] (PHOENIX-48) upsert data into table,'select' result is correct, but 'scan' find a odd data

["James Taylor (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/PHOENIX-48?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

James Taylor resolved PHOENIX-48.
---------------------------------

    Resolution: Not A Problem

WAD. This empty key value is put in each row on purpose.

> upsert data into table,'select' result is correct, but 'scan' find a odd data
> -----------------------------------------------------------------------------
>
>                 Key: PHOENIX-48
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-48
>             Project: Phoenix
>          Issue Type: Test
>         Environment: phoenix-2.2.2-install
>            Reporter: hnucsbjd
>            Priority: Trivial
>
> phoenix version :phoenix-2.2.2-install,UPSERT INTO VALUES('row1','1','a') to a table,'select' is correct, but 'scan' find an odd data:' row1 column=A:_0, timestamp=1392107355805, value= ' ,the data is unnecessary?
> phoenix-2.2.2-install/bin$ ./sqlline.sh localhost
> 0: jdbc:phoenix:localhost> CREATE TABLE TEST(pk VARCHAR NOT NULL PRIMARY KEY, a.col VARCHAR(1),col2 VARCHAR(1));
> 0: jdbc:phoenix:localhost> UPSERT INTO TEST(pk,a.col,col2) VALUES('row1','1','a');
> 0: jdbc:phoenix:localhost> select * from TEST;
> +------------+------------+------------+
> | PK | COL | COL2 |
> +------------+------------+------------+
> | row1 | 1 | a |
> +------------+------------+------------+
> hbase(main):002:0> scan 'TEST'
> ROW COLUMN+CELL
> row1 column=A:COL, timestamp=1392107355805, value=1
> row1 column=A:_0, timestamp=1392107355805, value=
> row1 column=_0:COL2, timestamp=1392107355805, value=a
> 1 row(s) in 0.1350 seconds



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)