[
https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Edward Yoon updated HADOOP-1720:
--------------------------------
Attachment: hql_v11.patch
{code}
CREATE TABLE movieLog_table (year, length, inColor, studioName, vote, producer);
CREATE TABLE webtable (contents in_memory max_versions=10 compression=block,
anchor max_length=256 bloomfilter=counting_bloomfilter vector_size=1000000
num_hash=4);
INSERT INTO movieLog_table (year:, length:, inColor:, studioName:, vote:udanax,
producer:) VALUES ('1977', '124', 'true', 'Fox', '5', 'George Lucas') WHERE
row='Star Wars';
INSERT INTO movieLog_table (year:, length:, inColor:, studioName:, vote:xanadu,
producer:) VALUES ('1991', '124', 'true', 'Disney', '2', 'Blair Peters') WHERE
row='Mighty Ducks';
INSERT INTO movieLog_table (year:, length:, inColor:, studioName:, "vote:user
1", producer:) VALUES ('1992', '95', 'true', 'Paramount', '3', 'Penelope
Spheeris') WHERE row='Wayne`s World';
Hbase > SELECT * FROM movieLog_table;
Hbase > SELECT "vote:user 1" FROM movieLog_table;
+------+----------------------+----------------------+----------------------+
| No. | Row | Column | Cell |
+------+----------------------+----------------------+----------------------+
| 1 | Wayne`s World | vote:user 1 | 3 |
+------+----------------------+----------------------+----------------------+
{code}
> [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
>
>
> 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.
