[
https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Edward Yoon updated HADOOP-1720:
--------------------------------
Attachment: hql_v05.patch
I edited the select syntax.
{code}
HBase > select inColor:, length: from movieLog_table;
+------+----------------------+----------------------+----------------------+
| No. | Row | Column | Cell |
+------+----------------------+----------------------+----------------------+
| 1 | Mighty Ducks | inColor: | true |
+------+----------------------+----------------------+----------------------+
| 1 | Mighty Ducks | length: | 124 |
+------+----------------------+----------------------+----------------------+
| 2 | Star Wars | inColor: | true |
+------+----------------------+----------------------+----------------------+
| 2 | Star Wars | length: | 124 |
+------+----------------------+----------------------+----------------------+
| 3 | Wayne`s World | inColor: | true |
+------+----------------------+----------------------+----------------------+
| 3 | Wayne`s World | length: | 95 |
+------+----------------------+----------------------+----------------------+
Successfully print out the selected data.(0.02 sec)
HBase > select * from movieLog_table starting from 'Star Wars';
+------+----------------------+----------------------+----------------------+
| No. | Row | Column | Cell |
+------+----------------------+----------------------+----------------------+
| 1 | Star Wars | inColor: | true |
+------+----------------------+----------------------+----------------------+
| 1 | Star Wars | length: | 124 |
+------+----------------------+----------------------+----------------------+
| 1 | Star Wars | producer: | George Lucas |
+------+----------------------+----------------------+----------------------+
| 1 | Star Wars | studioName: | Fox |
+------+----------------------+----------------------+----------------------+
| 1 | Star Wars | vote:user_1 | 5 |
+------+----------------------+----------------------+----------------------+
| 1 | Star Wars | year: | 1977 |
+------+----------------------+----------------------+----------------------+
| 2 | Wayne`s World | inColor: | true |
+------+----------------------+----------------------+----------------------+
| 2 | Wayne`s World | length: | 95 |
+------+----------------------+----------------------+----------------------+
| 2 | Wayne`s World | producer: | Penelope Spheeris |
+------+----------------------+----------------------+----------------------+
| 2 | Wayne`s World | studioName: | Paramount |
+------+----------------------+----------------------+----------------------+
| 2 | Wayne`s World | vote:user_1 | 3 |
+------+----------------------+----------------------+----------------------+
| 2 | Wayne`s World | year: | 1992 |
+------+----------------------+----------------------+----------------------+
Successfully print out the selected data.(0.01 sec)
HBase > exit;
{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.15.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
>
>
> 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.
