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 Mon, 27 Aug 2007 14:53: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_v07.patch

1. CREATE TABLE implemented.

{noformat}
HBase > create table webtable (
    --> contents in_memory max_versions=10 compression=block,
    --> anchor max_length=256 bloomfilter=counting                                  
    --> vector_size=1000000 num_hash=4);
Please wait. Creating table...
Table created successfully.
{noformat}

2. Help contents changed to reflect the changed syntax.

{noformat}
HBase > help create;
CREATE    Create tables

Syntax:
CREATE TABLE table_name
        column_family_spec [, column_family_spec] ...

column_family_spec:
        column_family_name
        [MAX_VERSIONS=n]
        [MAX_LENGTH=n]
        [COMPRESSION=NONE|RECORD|BLOCK]
        [IN_MEMORY]
        [BLOOMFILTER=NONE|BLOOM|COUNTING|RETOUCHED VECTOR_SIZE=n NUM_HASH=n]

HBase > 
{noformat}

3. Progress report

Things done:

* INSERT
* DELETE, except DELETE * FROM
* DROP
* ENABLE, DISABLE
* SELECT
* CREATE

Things to to:

* ALTER
* 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
>
>
> 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