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 Thu, 30 Aug 2007 11:14:31 GMT

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

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

    Status: Patch Available  (was: Open)

We would like to submit the latest patch.

In the latest patch:

1. Several HQL statements implemented

* INSERT
* DELETE
* DROP
* ENABLE, DISABLE
* SELECT
* CREATE
* ALTER ADD

2. Not yet been tackled 

There are several statements that are not yet implemented due to
various problems. Each of these problems may become an issue 
by itself.

* DELETE * FROM
Due to the inconvenience in the API. There's no convenient way to delete
all values in a column family. For example, the method HTable.delete() 
only allows fully-qualified names, like HTable.delete("anchor").

* SELECT INTO
The issue [HADOOP-1789|https://issues.apache.org/jira/browse/HADOOP-1789] is 
tackling this issue. We'll come back to SELECT INTO after that issue has 
been completed. 

* ALTER DROP
We guess that there a problem in the HBaseAdmin.deleteColumn() method. 
A specified column is not deleted even if the method is certainly called. 
However, not yet been verified thoroughly.

* ALTER CHANGE
We think that there is no way to change a column family name 
without deleting all the values in the column family. The only way
to change a column family  is, first delete the column family and then 
add a new column family. We need a way to only change 
a column family name and its options without deleting the values
inside.

It's been long enough, and much code has been accumulated
through this issue, so let us submit this patch. We'll tackle down each of the 
remaining problems through later issues.

If there is any reason to delay submitting this patch, let us know, and 
we'll do our best to make things done as soon as possible.



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