[
https://issues.apache.org/jira/browse/PHOENIX-388?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Gabriel Reid resolved PHOENIX-388.
----------------------------------
Resolution: Fixed
Bulk resolve of closed issues imported from GitHub. This status was reached by
first re-opening all closed imported issues and then resolving them in bulk.
> Execute the sql error
> ---------------------
>
> Key: PHOENIX-388
> URL: https://issues.apache.org/jira/browse/PHOENIX-388
> Project: Phoenix
> Issue Type: Task
> Reporter: szlwin
>
> First, I execute the create table schema like:
> CREATE TABLE IF NOT EXISTS USER_INFO{
> u_id VARCHAR(30) not null PRIMARY KEY,
> u_name VARCHAR(30) not null,
> u_atime TIMESTAMP,
> u_status INTEGER);
> Then I insert a row data and execute the shell like scan 'USER_INFO' under
> the hbase server,the result is:
> ROW COLUMN+CELL
>
>
> test0004 column=_0:U_ATIME,
> timestamp=1370529109150, value=\x00\x00\x01?\x18-\xA9\x9A\x08\xB3\xC8\x80
>
> test0004 column=_0:U_NAME,
> timestamp=1370529109150, value=test11
>
> test0004 column=_0:U_STATUS,
> timestamp=1370529109150, value=\x80\x00\x00\x01
>
> test0004 column=_0:_0,
> timestamp=1370529109150, value=
>
> 1 row(s) in 0.0320 seconds
> When I want to execute the query sql like:
> select * from USER_INFO where U_ID = 'test0004'
> It's occure an error: The column U_ID not fund
> Why this error will happen,how can I qyery the data by PRIMARY KEY?
> The phoenix version is 1.0, and the hbase version is 0.94.2.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
