hadoop-common-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "stack (JIRA)" <j...@apache.org>
Subject [jira] Updated: (HADOOP-1720) [HbaseShell] Addition of HQL (Hbase Query Language) support in Hbase Shell
Date Tue, 11 Sep 2007 23:37:32 GMT

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

stack updated HADOOP-1720:

    Attachment: hql_v21.patch

Edward: v20 worked smoothly for me whatever you did and regards your remark that there is
no means of deleting all in a row on 10/Sep/07 02:03 AM, yes, that is true.  HADOOP-1550 will
fix this.

Edward/Inchul: In patch v20, you still have to specify single-quotes for rows and values when
doing an insert.  See output below.  This looks to me like the only thing in the way of this
patch getting committed (long ago its features exceeded the current shell facility.   The
'alter table' feature particularly is very nice). Would this be easy to fix?

Hbase > insert into "abc" ("abc:") values ('abcd') where row='abc';
1 row inserted successfully.(0.00 sec)
Hbase > insert into "abc" ("abc:") values ('abcd') where row="abc";
Syntax error : Type 'help' for usage: Encountered "\"abc\"" at line 1, column 55.
Hbase > insert into "abc" ("abc:") values ("abcd") where row='abc';
Mismatch between values list and columnfamilies list

ConsoleTable is also broken if column names or row names are longer than the 20 characters
but I do not see this as a blocker (and I think Izaak is going to make a patch for ConsoleTable
tomorrow that should help in this regard).

Otherwise, your patch looks good.  

This v21 does a little cleanup and adds unit tests for create, describe, drop, insert, etc.
The create, etc., test is commented out currently.  The test testInsertSelectDelete currently
fails because it tries to wrap row name in an insert in double quotes.  It'll start to pass
when you fix the above issue.  Feel free to add others (smile).

Thanks lads.

> [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.14.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, hql_v10.patch, hql_v11.patch,
hql_v12.patch, hql_v13.patch, hql_v14.patch, hql_v15.patch, hql_v16.patch, hql_v17.patch,
hql_v18.patch, hql_v19.patch, hql_v20.patch, hql_v21.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.

View raw message