[
https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12524946
]
udanax edited comment on HADOOP-1720 at 9/4/07 6:29 PM:
-------------------------------------------------------------
The string must be enclosed in single quotation marks, as in '...'.
The quoted identifier for table name and column name must be enclosed in double
quotation marks, as in "...".
ex) SELECT * FROM "Blanks in table name" where row = 'Row Key String';
{code}
Hbase > select 'inColor:true' from movieLog_table;
The quoted identifier for table name and column name must
be enclosed in double quotation marks, as in "...".
Hbase > select * from movieLog_table where row = "Star Wars";
The string must be enclosed in single quotation marks, as in '...'.
Hbase > select "vote:user 1" from movieLog_table;
+------+----------------------+----------------------+----------------------+
| No. | Row | Column | Cell |
+------+----------------------+----------------------+----------------------+
| 1 | Wayne`s World | vote:user 1 | 3 |
+------+----------------------+----------------------+----------------------+
Successfully print out the selected data.(0.04 sec)
Hbase >
{code}
@see : http://www.hadoop.co.kr/wiki/moin.cgi/Hbase/HbaseShell
was (Author: udanax):
The string must be enclosed in single quotation marks, as in '...'.
The quoted identifier for table name and column name must be enclosed in double
quotation marks, as in "...".
ex) SELECT * FROM "Blanks in table name" where row = 'Row Key String';
{code}
Hbase > select 'inColor:true' from movieLog_table;
The quoted identifier for table name and column name must
be enclosed in double quotation marks, as in "...".
Hbase > select * from movieLog_table where row = "Star Wars";
The string must be enclosed in single quotation marks, as in '...'.
Hbase > select "vote:user 1" from movieLog_table;
+------+----------------------+----------------------+----------------------+
| No. | Row | Column | Cell |
+------+----------------------+----------------------+----------------------+
| 1 | Wayne`s World | vote:user 1 | 3 |
+------+----------------------+----------------------+----------------------+
Successfully print out the selected data.(0.04 sec)
Hbase >
{code}
> [HbaseShell] Addition of HQL (Hbase Query Language) support in Hbase Shell
> --------------------------------------------------------------------------
>
> Key: HADOOP-1720
> URL: https://issues.apache.org/jira/browse/HADOOP-1720
> Project: Hadoop
> Issue Type: Improvement
> Components: contrib/hbase
> Affects Versions: 0.14.0
> Environment: all environments
> Reporter: Inchul Song
> Priority: Minor
> Fix For: 0.15.0
>
> Attachments: hql_v01.patch, hql_v02.patch, hql_v03.patch,
> hql_v04.patch, hql_v05.patch, hql_v06.patch, hql_v07.patch, hql_v08.patch,
> hql_v09.patch, hql_v10.patch, hql_v11.patch, hql_v12.patch, hql_v13.patch,
> hql_v14.patch
>
>
> We have defined the HQL (Hbase Query Language), which is a "more" SQL-like
> query language for Hbase, for use in Hbase Shell. HQL is not intended to
> fully support the SQL syntax and semantics. HQL, instead, is developed to
> make it easy to manipulate tables in Hbase through the Hbase Shell command
> line, without using programming APIs.
> You can find more information about HQL in
> http://wiki.apache.org/lucene-hadoop/Hbase/HbaseShell/HQL.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
