[
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?
{code}
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
{code}
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.
