hadoop-common-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Inchul Song (JIRA)" <j...@apache.org>
Subject [jira] Updated: (HADOOP-1720) [HbaseShell] Addition of HQL (Hbase Query Language) support in Hbase Shell
Date Wed, 29 Aug 2007 11:05:30 GMT

     [ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Inchul Song updated HADOOP-1720:
--------------------------------

    Attachment: hql_v08.patch

1. ALTER TABLE add implemented, and verified that it is working.

{noformat}
HBase > alter table webtable add length in_memory;
Disabling webtable... Please wait.
07/08/29 19:30:47 INFO hbase.HBaseAdmin: Disabled table webtable
Please wait. Adding length to webtable...
Enabling webtable... Please wait.
07/08/29 19:30:47 INFO hbase.HBaseAdmin: Enabled table webtable
Table altered successfully.
HBase > desc webtable;
+------+----------------------+
| No.  | ColumnFamily Name    |
+------+----------------------+
| 1    | anchor               |
+------+----------------------+
| 2    | contents             |
+------+----------------------+
| 3    | length               |
+------+----------------------+

3 columnfamilie(s) found.(0.07 sec)
{noformat}

2. ALTER TABLE DROP seems not working.
I've tested it several times and verified that HbaseAdmin.deleteColumn() 
actually is being called, but with no effect to the table.

Could somebody please test it in your environment for me?

{noformat}
HBase > alter table webtable drop contents;
Disabling webtable... Please wait.
07/08/29 19:42:45 INFO hbase.HBaseAdmin: Disabled table webtable
Dropping contents from webtable... Please wait.
Enabling webtable... Please wait.
07/08/29 19:42:45 INFO hbase.HBaseAdmin: Enabled table webtable
Table altered successfully.
HBase > desc webtable;                     
+------+----------------------+
| No.  | ColumnFamily Name    |
+------+----------------------+
| 1    | anchor               |
+------+----------------------+
| 2    | contents             |
+------+----------------------+
| 3    | length               |
+------+----------------------+

3 columnfamilie(s) found.(0.02 sec)
{noformat}

3. Progress report:

Things to do:
* Fix a bug in ALTER TABLE DROP.
* ALTER TABLE CHANGE
* DELETE * FROM
* DESCRIBE


> [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,
hql_v06.patch, hql_v07.patch, hql_v08.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