You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Gabriel Reid (JIRA)" <ji...@apache.org> on 2014/03/16 08:21:16 UTC
[jira] [Resolved] (PHOENIX-388) Execute the sql error
[ 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)