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

Reply via email to