[
https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Edward Yoon updated HADOOP-1720:
--------------------------------
Attachment: hql_v17.patch
* removed the clear of the screen on shell launch.
* added a ':' terminating colon auto-check
* can use either double quote ( " ) or single quote ( ' ) symbols to delimit
strings
{code}
Hbase > select year from movieLog_table;
+------+----------------------+----------------------+----------------------+
| No. | Row | Column | Cell |
+------+----------------------+----------------------+----------------------+
| 1 | Mighty Ducks | year: | 1991 |
+------+----------------------+----------------------+----------------------+
| 2 | Star Wars | year: | 1977 |
+------+----------------------+----------------------+----------------------+
| 3 | Wayne`s World | year: | 1992 |
+------+----------------------+----------------------+----------------------+
Successfully print out the selected data.(0.62 sec)
Hbase > select year: from movieLog_table;
+------+----------------------+----------------------+----------------------+
| No. | Row | Column | Cell |
+------+----------------------+----------------------+----------------------+
| 1 | Mighty Ducks | year: | 1991 |
+------+----------------------+----------------------+----------------------+
| 2 | Star Wars | year: | 1977 |
+------+----------------------+----------------------+----------------------+
| 3 | Wayne`s World | year: | 1992 |
+------+----------------------+----------------------+----------------------+
Hbase > select 'vote:user 1' from movieLog_table; or select "vote:user 1" from
movieLog_table;
+------+----------------------+----------------------+----------------------+
| No. | Row | Column | Cell |
+------+----------------------+----------------------+----------------------+
| 1 | Wayne`s World | vote:user 1 | 3 |
+------+----------------------+----------------------+----------------------+
{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, hql_v15.patch, hql_v16.patch, hql_v17.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.
