hadoop-common-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Edward Yoon (JIRA)" <j...@apache.org>
Subject [jira] Updated: (HADOOP-1720) [HbaseShell] Addition of HQL (Hbase Query Language) support in Hbase Shell
Date Mon, 10 Sep 2007 05:28:30 GMT

     [ 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.


Mime
View raw message