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