You are viewing a plain text version of this content. The canonical link for it is here.
Posted to common-dev@hadoop.apache.org by "Inchul Song (JIRA)" <ji...@apache.org> on 2007/08/16 09:15:30 UTC
[jira] Created: (HADOOP-1720) Addition of support for HQL (Hbase
Query Language)
Addition of support for HQL (Hbase Query Language)
--------------------------------------------------
Key: HADOOP-1720
URL: https://issues.apache.org/jira/browse/HADOOP-1720
Project: Hadoop
Issue Type: Task
Components: contrib/hbase
Affects Versions: 0.15.0
Environment: all environments
Reporter: Inchul Song
Priority: Minor
Fix For: 0.15.0
We have defined the HQL (Hbase Query Language), which is a more SQL-like query language for Hbase, to be used
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.
[jira] Updated: (HADOOP-1720) [HbaseShell] Addition of HQL (Hbase
Query Language) support in Hbase Shell
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Edward Yoon updated HADOOP-1720:
--------------------------------
Attachment: hql_v17.patch
* removed the clear of the screen on shell launch.
* added a ':' terminating colon auto-check
* can use either double quote ( " ) or single quote ( ' ) symbols to delimit strings
{code}
Hbase > select year from movieLog_table;
+------+----------------------+----------------------+----------------------+
| No. | Row | Column | Cell |
+------+----------------------+----------------------+----------------------+
| 1 | Mighty Ducks | year: | 1991 |
+------+----------------------+----------------------+----------------------+
| 2 | Star Wars | year: | 1977 |
+------+----------------------+----------------------+----------------------+
| 3 | Wayne`s World | year: | 1992 |
+------+----------------------+----------------------+----------------------+
Successfully print out the selected data.(0.62 sec)
Hbase > select year: from movieLog_table;
+------+----------------------+----------------------+----------------------+
| No. | Row | Column | Cell |
+------+----------------------+----------------------+----------------------+
| 1 | Mighty Ducks | year: | 1991 |
+------+----------------------+----------------------+----------------------+
| 2 | Star Wars | year: | 1977 |
+------+----------------------+----------------------+----------------------+
| 3 | Wayne`s World | year: | 1992 |
+------+----------------------+----------------------+----------------------+
Hbase > select 'vote:user 1' from movieLog_table; or 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, hql_v12.patch, hql_v13.patch, hql_v14.patch, hql_v15.patch, hql_v16.patch, hql_v17.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.
[jira] Issue Comment Edited: (HADOOP-1720) [HbaseShell] Addition of
HQL (Hbase Query Language) support in Hbase Shell
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12526101 ]
udanax edited comment on HADOOP-1720 at 9/10/07 2:04 AM:
--------------------------------------------------------------
* fixed "delete * from"
{code}
Hbase > delete * from movieLog_table where row='Wayne`s World';
Column(s) deleted successfully.(0.02 sec)
Hbase >
{code}
was (Author: udanax):
* fixed "delete * from"
{code}
Hbase > delete * from movieLog_table where row='Wayne`s World';
Column(s) deleted successfully.(0.02 sec)
Hbase >
{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, hql_v12.patch, hql_v13.patch, hql_v14.patch, hql_v15.patch, hql_v16.patch, hql_v17.patch, hql_v18.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.
[jira] Commented: (HADOOP-1720) [HbaseShell] Addition of HQL (Hbase
Query Language) support in Hbase Shell
Posted by "Inchul Song (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12521754 ]
Inchul Song commented on HADOOP-1720:
-------------------------------------
You should see the entry about CSV in Wikipedia.
http://en.wikipedia.org/wiki/Comma-separated_values
You may find useful links in there.
You can also consult the source code of MySQL,
especially the part where the select, or load syntaxes
are implemented.
> [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
>
>
> 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.
[jira] Commented: (HADOOP-1720) [HbaseShell] Addition of HQL (Hbase
Query Language) support in Hbase Shell
Posted by "stack (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12525450 ]
stack commented on HADOOP-1720:
-------------------------------
Good stuff... Does v15 of the patch include this change? (FYI: This patch again is filled mostly with just differences in line-endings).
> [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
>
>
> 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.
[jira] Commented: (HADOOP-1720) [HbaseShell] Addition of HQL (Hbase
Query Language) support in Hbase Shell
Posted by "stack (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12524966 ]
stack commented on HADOOP-1720:
-------------------------------
Edward: Don't you think two quoting mechanisms confusing?
Also, thinking on it on my way home, my adding in parens around column names in the help contents was retrograde; you and Inchul have done a bunch of work to move hql closer to sql. My adding parens revived the old hbase shell syntax so rather its the parser that needs fixing, not the help.
It looks like patch version 14 has the same issue as v12 in that the bulk of it is just reporting difference in line endings (check it out yourself).
> [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
>
>
> 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.
[jira] Commented: (HADOOP-1720) [HbaseShell] Addition of HQL (Hbase
Query Language) support in Hbase Shell
Posted by "stack (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12523880 ]
stack commented on HADOOP-1720:
-------------------------------
Here's some comments on the patch lads:
This is a large amount of new functionality but it is without unit tests. Regression in something as complicated as a shell is a real danger. Do you have any objection to adding at least a basic test that does a setup of a minihbasecluster adding a table using your create command (with assertion that add was successful, and that all options specified were enabled, perhaps using your describe command), and then disable, enable, input, select, and drop asserting each of the steps has happened as you go? (I can help out if you'd like).
The 'fs -ls' issue remains. Do you want to fix that before committing or do you want to make a new issue to fix this? (I tried setting the command back to 'dfs' from 'fs' but it is still broken. Did I commit a broken feature?)
The describe command does not list out the properties that are advertised as settable in the create command. Is this intentional? (this is a minor item I'd say)
I tried to create a table:
{code}
HBase > create testing ma_versions=3 compression=none in_memory bloomfilter=none;
Syntax error: Type 'help' for usage: Encountered "testing" at line 1, column 9.
HBase > create table testing ma_versions=3 compression=none in_memory bloomfilter=none;
Syntax error: Type 'help' for usage: Encountered "ma_versions" at line 1, column 23.
HBase > create table testing max_versions=3 compression=none in_memory bloomfilter=none;
Syntax error: Type 'help' for usage: Encountered "max_versions" at line 1, column 23.
HBase > create table testing family max_versions=3 compression=none in_memory bloomfilter=none;
Syntax error: Type 'help' for usage: Encountered "family" at line 1, column 23.
HBase > create table testing 'family' max_versions=3 compression=none in_memory bloomfilter=none;
Syntax error: Type 'help' for usage: Encountered "\'family\'" at line 1, column 23.
HBase > create table testing 'family:' max_versions=3 compression=none in_memory bloomfilter=none;
Syntax error: Type 'help' for usage: Encountered "\'family:\'" at line 1, column 23.
HBase > create table testing family: max_versions=3 compression=none in_memory bloomfilter=none;
Syntax error: Type 'help' for usage: Encountered "family:" at line 1, column 23.
HBase > create table 'testing' 'family:' max_versions=3 compression=none in_memory bloomfilter=none;
Syntax error: Type 'help' for usage: Encountered "\'testing\'" at line 1, column 15.
HBase > create table "testing" "family:" max_versions=3 compression=none in_memory bloomfilter=none;
Syntax error: Type 'help' for usage: Encountered "\"testing\"" at line 1, column 15.
HBase > create table testing family: max_versions=3 compression=none in_memory bloomfilter=none;
Syntax error: Type 'help' for usage: Encountered "family:" at line 1, column 23.
HBase > create table testing test;
Syntax error: Type 'help' for usage: Encountered "test" at line 1, column 23.
{code}
I'm not sure what I'm doing wrong in the above.
It does not look as though I can put quotes around family names. I would think I'd need to if a column qualifier had a space. For example:
{code}
HBase > select repo:url;
Syntax error: Type 'help' for usage: Encountered ";" at line 1, column 17.
HBase > select 'repo:url' from hbaserepository;
Syntax error: Type 'help' for usage: Encountered "\'repo:url\'" at line 1, column 9.
HBase > select "repo:url" from hbaserepository;
Syntax error: Type 'help' for usage: Encountered "\"repo:url\"" at line 1, column 9.
HBase > select repo:url from hbaserepository;
{code}
(The last one above worked).
Trying to select a column from a specified row, the below happens:
{code}
HBase > select repo:url from hbaserepository where row=PPFW-00SOmohQD4kQcyk==;
Syntax error: Type 'help' for usage: Encountered "PPFW-00SOmohQD4kQcyk" at line 1, column 49.
HBase > select repo:url from hbaserepository where row="PPFW-00SOmohQD4kQcyk==";
Exception in thread "main" java.lang.NullPointerException
at org.apache.hadoop.io.Text.encode(Text.java:375)
at org.apache.hadoop.io.Text.set(Text.java:165)
at org.apache.hadoop.io.Text.<init>(Text.java:71)
at org.apache.hadoop.hbase.shell.SelectCommand.setRowKey(SelectCommand.java:215)
at org.apache.hadoop.hbase.shell.generated.Parser.selectCommand(Parser.java:593)
at org.apache.hadoop.hbase.shell.generated.Parser.cmdStatement(Parser.java:137)
at org.apache.hadoop.hbase.shell.generated.Parser.terminatedCommand(Parser.java:85)
at org.apache.hadoop.hbase.Shell.main(Shell.java:60)
{code}
Digging further, it looks like I need to quote using single-quotes only -- is that right? If so, we should put this fact into the help and perhaps into the shell preamble.
Regards the patch, it looks good. I would suggest that error output be put on System.err rather than on System.out (In general you probably want to keep the errors and informational output on one stream and your generated output on the other). You have an assert in DeleteCommand. Why not make this throw an actual exception if passed value is null?
> [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, hql_v08.patch, hql_v09.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.
[jira] Issue Comment Edited: (HADOOP-1720) [HbaseShell] Addition of
HQL (Hbase Query Language) support in Hbase Shell
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12524476 ]
udanax edited comment on HADOOP-1720 at 9/3/07 2:43 AM:
-------------------------------------------------------------
I mean just about series or parallel collaborative works.
with more than two people working on one same issue,
we can't find out who's working on which part nor who's more available to work.
but, ...
I'll submit just after reported bug fixes.
was (Author: udanax):
I mean just about series or parallel collaboration of code implementation. (by each sub-issue)
with more than two people working on one same issue,
we can't find out who's working on which part nor who's more available to work.
but, ...
I'll submit just after reported bug fixes.
> [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, hql_v08.patch, hql_v09.patch, hql_v10.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.
[jira] Commented: (HADOOP-1720) [HbaseShell] Addition of HQL (Hbase
Query Language) support in Hbase Shell
Posted by "Hadoop QA (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12525019 ]
Hadoop QA commented on HADOOP-1720:
-----------------------------------
+1
http://issues.apache.org/jira/secure/attachment/12365129/hql_v14.patch applied and successfully tested against trunk revision r572826.
Test results: http://lucene.zones.apache.org:8080/hudson/job/Hadoop-Patch/687/testReport/
Console output: http://lucene.zones.apache.org:8080/hudson/job/Hadoop-Patch/687/console
> [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
>
>
> 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.
[jira] Updated: (HADOOP-1720) [HbaseShell] Addition of HQL (Hbase
Query Language) support in Hbase Shell
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ 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.
[jira] Commented: (HADOOP-1720) [HbaseShell] Addition of HQL (Hbase
Query Language) support in Hbase Shell
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12523797 ]
Edward Yoon commented on HADOOP-1720:
-------------------------------------
Thank you, Inchul. it works nicely.
let's implement things by create each sub-task for more convenient collaboration.
So, I would like to submit v09.patch.
> [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, hql_v08.patch, hql_v09.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.
[jira] Issue Comment Edited: (HADOOP-1720) [HbaseShell] Addition of
HQL (Hbase Query Language) support in Hbase Shell
Posted by "Inchul Song (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12521754 ]
icsong edited comment on HADOOP-1720 at 8/23/07 3:37 AM:
--------------------------------------------------------------
You may see the entry about CSV in Wikipedia.
http://en.wikipedia.org/wiki/Comma-separated_values
You may find useful links in there.
You can also consult the source code of MySQL,
especially the part where the select, or load syntaxes
are implemented.
was (Author: icsong):
You should see the entry about CSV in Wikipedia.
http://en.wikipedia.org/wiki/Comma-separated_values
You may find useful links in there.
You can also consult the source code of MySQL,
especially the part where the select, or load syntaxes
are implemented.
> [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
>
>
> 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.
[jira] Issue Comment Edited: (HADOOP-1720) [HbaseShell] Addition of
HQL (Hbase Query Language) support in Hbase Shell
Posted by "stack (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12521219 ]
stack edited comment on HADOOP-1720 at 8/20/07 1:11 PM:
--------------------------------------------------------
Version that applies against TRUNK (HBaseShell.jj changed over the weekend in a path that broke v3 of this patch).
Otherwise Inchul, the patch looks good but incomplete. For example, you have not changed the help in line with new additions/changes. Is your tactic adding a patch per piece of implementation? (If so, please add a description of what each patch adds beyond the previous -- helps when reading the patch).
Good stuff.
was (Author: stack):
Version that applies against TRUNK (HBaseShell.jj changed over the weekend in a path that broke v3 of this patch).
Otherwise Inchol, the patch looks good but incomplete. For example, you have not changed the help in line with new additions/changes. Is your tactic adding a patch per piece of implementation? (If so, please add a description of what each patch adds beyond the previous -- helps when reading the patch).
Good stuff.
> [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
>
>
> 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.
[jira] Commented: (HADOOP-1720) [HbaseShell] Addition of HQL (Hbase
Query Language) support in Hbase Shell
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12521751 ]
Edward Yoon commented on HADOOP-1720:
-------------------------------------
Have you any good ideas for writing the results of a select statement into a text file on the hadoop dfs?
(I think just tab delimited file, now)
> [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
>
>
> 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.
[jira] Updated: (HADOOP-1720) [HbaseShell] Addition of HQL (Hbase
Query Language) support in Hbase Shell
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Edward Yoon updated HADOOP-1720:
--------------------------------
Attachment: hql_v12.patch
> [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
>
>
> 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.
[jira] Updated: (HADOOP-1720) [HbaseShell] Addition of HQL (Hbase
Query Language) support in Hbase Shell
Posted by "Inchul Song (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Inchul Song updated HADOOP-1720:
--------------------------------
Summary: [HbaseShell] Addition of HQL (Hbase Query Language) support in Hbase Shell (was: Addition of support for HQL (Hbase Query Language) in Hbase Shell)
> [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
>
>
> 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.
[jira] Commented: (HADOOP-1720) [HbaseShell] Addition of HQL (Hbase
Query Language) support in Hbase Shell
Posted by "stack (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12525266 ]
stack commented on HADOOP-1720:
-------------------------------
IMO, it will be less confusing to users if they can use either single or double quotes. It would be their choice (Later, double-quotes would allow interpolations. Single-quotes would not). Otherwise, HQL should use single quotes or double quotes exclusively. What do you think Edward?
> [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
>
>
> 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.
[jira] Commented: (HADOOP-1720) [HbaseShell] Addition of HQL (Hbase
Query Language) support in Hbase Shell
Posted by "Inchul Song (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12522744 ]
Inchul Song commented on HADOOP-1720:
-------------------------------------
A bunch of interesting ideas, Stack.
We should definitely create an issue for this: input and output methods
in HQL and Hbase Shell.
> [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
>
>
> 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.
[jira] Commented: (HADOOP-1720) [HbaseShell] Addition of HQL (Hbase
Query Language) support in Hbase Shell
Posted by "stack (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12521881 ]
stack commented on HADOOP-1720:
-------------------------------
The select syntax looks great. Can I quote the column names in the select statement as in:
{code}
select "inColor:", "length:" from "movieLog_table";
{code}
... in case column name qualifiers contain spaces?
Regards output, I like the idea of leveraging hadoop filesystem for target so dependent on how the shell is configured, the output lands on local filesystem or up in hdfs (or in amz) dependent on shell client config (Or, if folks include an URL scheme, that should work too as in '...into hdfs://namenode:8888/hbase/output/dump.txt)
Regards output format, I like the noises about modeling output on how mysql does it. In order of importance, I can imagine folks wanting output unadorned (e.g. 'select page:content from repository where row="http://apache.com/index.html"' to get JUST the apache home page content), ascii tables, mapfiles keyed by row with columns for values, csv, xml, html, etc. If you can figure a means of allowing output formatter plugins (or using an existing formatting system if such a thing exists) whether invocation of velocity templates, etc., that'd be sweet.
> [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
>
>
> 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.
[jira] Updated: (HADOOP-1720) [HbaseShell] Addition of HQL (Hbase
Query Language) support in Hbase Shell
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Edward Yoon updated HADOOP-1720:
--------------------------------
Attachment: hql_v19.patch
attached v19.patch.
I just used getRow() method for "delete * from ... "
{code}
columnList = hTable.getRow(new Text(this.rowKey)).keySet().toArray(new Text[] {});
for (Text column : columnList) {
hTable.delete(lockID, new Text(column));
}
{code}
If it's okay with you, i would like to submit this patch.
and, If you are not sure about committing this patch, let me know.
> [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
>
>
> 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.
[jira] Updated: (HADOOP-1720) [HbaseShell] Addition of HQL (Hbase
Query Language) support in Hbase Shell
Posted by "Inchul Song (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Inchul Song updated HADOOP-1720:
--------------------------------
Attachment: hql_v09.patch
I made some changes for the code to use the updated API.
But, ALTER TABLE DROP still isn't working.
Edward, would you please check it again with this patch applied?
> [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, hql_v08.patch, hql_v09.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.
[jira] Commented: (HADOOP-1720) [HbaseShell] Addition of HQL (Hbase
Query Language) support in Hbase Shell
Posted by "Inchul Song (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12521007 ]
Inchul Song commented on HADOOP-1720:
-------------------------------------
Sure, go ahead.
> [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
>
>
> 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.
[jira] Updated: (HADOOP-1720) [HbaseShell] Addition of HQL (Hbase
Query Language) support in Hbase Shell
Posted by "stack (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
stack updated HADOOP-1720:
--------------------------
Attachment: hql_v04.patch
Version that applies against TRUNK (HBaseShell.jj changed over the weekend in a path that broke v3 of this patch).
Otherwise Inchol, the patch looks good but incomplete. For example, you have not changed the help in line with new additions/changes. Is your tactic adding a patch per piece of implementation? (If so, please add a description of what each patch adds beyond the previous -- helps when reading the patch).
Good stuff.
> [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
>
>
> 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.
[jira] Updated: (HADOOP-1720) [HbaseShell] Addition of HQL (Hbase
Query Language) support in Hbase Shell
Posted by "stack (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
stack updated HADOOP-1720:
--------------------------
Attachment: hql_v13.patch
Version 13. Fixes to help contents removing duplicate listing, adding ';' after all usage outputs, and removing the initial clear console.
> [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
>
>
> 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.
[jira] Commented: (HADOOP-1720) [HbaseShell] Addition of HQL (Hbase
Query Language) support in Hbase Shell
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12521002 ]
Edward Yoon commented on HADOOP-1720:
-------------------------------------
Inchul,
If you can think of any even better way to output results, let me know on this issue.
and, I suggest u to fix output class on this issue.
May I suggest u to fix output class on this issue?
> [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
>
>
> 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.
[jira] Issue Comment Edited: (HADOOP-1720) Addition of support for
HQL (Hbase Query Language) in Hbase Shell
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12520190 ]
udanax edited comment on HADOOP-1720 at 8/16/07 2:56 AM:
--------------------------------------------------------------
I edited the insert syntax.
{code}
Hbase > INSERT INTO movieLog_table
-> ( year:, length:, inColor:, studioName:, vote:user_1, producer: )
-> VALUES ('1991', '124', 'true', 'Disney', '2', 'Blair Peters')
-> WHERE row='Mighty Ducks';
{code}
was (Author: udanax):
I edited the insert syntax.
{code}
Hbase > INSERT INTO movieLog_table
-> ( year:, length:, inColor:, studioName:, vote:user_1, producer: )
-> VALUES ('1991', '124', 'true', 'Disney', '2', 'Blair Peters')
-> WHERErow='Mighty Ducks';
{code}
> Addition of support for HQL (Hbase Query Language) 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
>
>
> 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.
[jira] Issue Comment Edited: (HADOOP-1720) [HbaseShell] Addition of
HQL (Hbase Query Language) support in Hbase Shell
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12522924 ]
udanax edited comment on HADOOP-1720 at 8/26/07 7:06 PM:
--------------------------------------------------------------
Here's a trivial clean-up patch for HQL.
was (Author: udanax):
Here's a trivial clean-up patch for FsCommand.
> [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
>
>
> 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.
[jira] Updated: (HADOOP-1720) [HbaseShell] Addition of HQL (Hbase
Query Language) support in Hbase Shell
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Edward Yoon updated HADOOP-1720:
--------------------------------
Attachment: hql_v24.patch
Sorry, some mistake.
re-upload.
> [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, hql_v22.patch, hql_v23.patch, hql_v24.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.
[jira] Commented: (HADOOP-1720) [HbaseShell] Addition of HQL (Hbase
Query Language) support in Hbase Shell
Posted by "Inchul Song (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12520840 ]
Inchul Song commented on HADOOP-1720:
-------------------------------------
The delete() method in HTable seems not working.
After implementing the DELETE syntax, I've tested if it works. However,
the deleted cells still show up in the result of SELECT.
Need further investigation.
{noformat}
HBase > select movie;
+------+----------------------+----------------------+----------------------+
| No. | Row | Column | Cell |
+------+----------------------+----------------------+----------------------+
| 1 | Star Wars | length: | 124 |
+------+----------------------+----------------------+----------------------+
| 2 | Star Wars | year: | 1977 |
+------+----------------------+----------------------+----------------------+
Successfully print out the selected data.(30.22 sec)
HBase > delete length: from movie where row='Star Wars';
07/08/16 22:26:54 INFO shell.DeleteCommand: Deleting length:...
Column(s) deleted successfully.(0.01 sec)
HBase > select movie;
+------+----------------------+----------------------+----------------------+
| No. | Row | Column | Cell |
+------+----------------------+----------------------+----------------------+
| 1 | Star Wars | length: | 124 |
+------+----------------------+----------------------+----------------------+
| 2 | Star Wars | year: | 1977 |
+------+----------------------+----------------------+----------------------+
Successfully print out the selected data.(0.05 sec)
HBase >
{noformat}
> [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
>
>
> 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.
[jira] Commented: (HADOOP-1720) [HbaseShell] Addition of HQL (Hbase
Query Language) support in Hbase Shell
Posted by "Inchul Song (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12523816 ]
Inchul Song commented on HADOOP-1720:
-------------------------------------
Yes, it's been long enough. I'll submit the latest patch,
and let's tackle down each of the problems in a series of
sub-tasks or issues.
> [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, hql_v08.patch, hql_v09.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.
[jira] Updated: (HADOOP-1720) Addition of support for HQL (Hbase
Query Language) in Hbase Shell
Posted by "Inchul Song (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Inchul Song updated HADOOP-1720:
--------------------------------
Comment: was deleted
> Addition of support for HQL (Hbase Query Language) 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
>
>
> 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.
[jira] Commented: (HADOOP-1720) [HbaseShell] Addition of HQL (Hbase
Query Language) support in Hbase Shell
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12523734 ]
Edward Yoon commented on HADOOP-1720:
-------------------------------------
{code}
[javac] C:\cygwin\home\Administrator\workspace\hadoop\src\contrib\hbase\src\
java\org\apache\hadoop\hbase\shell\SchemaModificationCommand.java:95: cannot fin
d symbol
{code}
I think you used a old-BloomFilterDescriptor class for a SchemaModificationCommand.
Before implementing, you first need to check out the project from the repository.
Check, Please!
> [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, hql_v08.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.
[jira] Commented: (HADOOP-1720) [HbaseShell] Addition of HQL (Hbase
Query Language) support in Hbase Shell
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12525267 ]
Edward Yoon commented on HADOOP-1720:
-------------------------------------
Thank you, Stack.
and now ....
I think delimident environment variable as described below.
{code}
<!-- HbaseShell Configurations -->
<property>
<name>hbaseshell.jline.bell.enabled</name>
<value>true</value>
<description>
if true, enable audible keyboard bells if an alert is required.
</description>
</property>
<property>
<name>hbaseshell.delimident.environment</name>
<value>false</value>
<description>
The delimident environment variable specifies that ......
{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, hql_v12.patch, hql_v13.patch, hql_v14.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.
[jira] Updated: (HADOOP-1720) Addition of support for HQL (Hbase
Query Language) in Hbase Shell
Posted by "Inchul Song (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Inchul Song updated HADOOP-1720:
--------------------------------
Attachment: hql_v02.patch
apply changes for drop table syntax
DROP TABLE table_name [, table_name] ...
> Addition of support for HQL (Hbase Query Language) 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
>
>
> 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.
[jira] Updated: (HADOOP-1720) Addition of support for HQL (Hbase
Query Language) in Hbase Shell
Posted by "Inchul Song (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Inchul Song updated HADOOP-1720:
--------------------------------
Status: Open (was: Patch Available)
> Addition of support for HQL (Hbase Query Language) 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
>
>
> 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.
[jira] Commented: (HADOOP-1720) [HbaseShell] Addition of HQL (Hbase
Query Language) support in Hbase Shell
Posted by "Inchul Song (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12524975 ]
Inchul Song commented on HADOOP-1720:
-------------------------------------
Stack, it was my mistake that the parens were omitted in the help for CREATE.
We designed CREATE with parens in it, and implemented CREATE with that in mind,
but I mistakenly missed to add the parens to the help for CREATE.
So, let's not remove them, but just put those parens in there.
> [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
>
>
> 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.
[jira] Commented: (HADOOP-1720) [HbaseShell] Addition of HQL (Hbase
Query Language) support in Hbase Shell
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12526663 ]
Edward Yoon commented on HADOOP-1720:
-------------------------------------
>>> 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).
>>> 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).
Thank you, Stack.
I appreciate your contribution and your code has been very helpful
and it's been helping me learn a great deal about how to code better.
> [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, hql_v22.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.
[jira] Updated: (HADOOP-1720) [HbaseShell] Addition of HQL (Hbase
Query Language) support in Hbase Shell
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Edward Yoon updated HADOOP-1720:
--------------------------------
Attachment: hql_v20.patch
Here's a clean-up patch.
> [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
>
>
> 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.
[jira] Issue Comment Edited: (HADOOP-1720) [HbaseShell] Addition of
HQL (Hbase Query Language) support in Hbase Shell
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12524946 ]
udanax edited comment on HADOOP-1720 at 9/4/07 6:29 PM:
-------------------------------------------------------------
The string must be enclosed in single quotation marks, as in '...'.
The quoted identifier for table name and column name must be enclosed in double quotation marks, as in "...".
ex) SELECT * FROM "Blanks in table name" where row = 'Row Key String';
{code}
Hbase > select 'inColor:true' from movieLog_table;
The quoted identifier for table name and column name must
be enclosed in double quotation marks, as in "...".
Hbase > select * from movieLog_table where row = "Star Wars";
The string must be enclosed in single quotation marks, as in '...'.
Hbase > select "vote:user 1" from movieLog_table;
+------+----------------------+----------------------+----------------------+
| No. | Row | Column | Cell |
+------+----------------------+----------------------+----------------------+
| 1 | Wayne`s World | vote:user 1 | 3 |
+------+----------------------+----------------------+----------------------+
Successfully print out the selected data.(0.04 sec)
Hbase >
{code}
@see : http://www.hadoop.co.kr/wiki/moin.cgi/Hbase/HbaseShell
was (Author: udanax):
The string must be enclosed in single quotation marks, as in '...'.
The quoted identifier for table name and column name must be enclosed in double quotation marks, as in "...".
ex) SELECT * FROM "Blanks in table name" where row = 'Row Key String';
{code}
Hbase > select 'inColor:true' from movieLog_table;
The quoted identifier for table name and column name must
be enclosed in double quotation marks, as in "...".
Hbase > select * from movieLog_table where row = "Star Wars";
The string must be enclosed in single quotation marks, as in '...'.
Hbase > select "vote:user 1" from movieLog_table;
+------+----------------------+----------------------+----------------------+
| No. | Row | Column | Cell |
+------+----------------------+----------------------+----------------------+
| 1 | Wayne`s World | vote:user 1 | 3 |
+------+----------------------+----------------------+----------------------+
Successfully print out the selected data.(0.04 sec)
Hbase >
{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, hql_v12.patch, hql_v13.patch, hql_v14.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.
[jira] Updated: (HADOOP-1720) [HbaseShell] Addition of HQL (Hbase
Query Language) support in Hbase Shell
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Edward Yoon updated HADOOP-1720:
--------------------------------
Affects Version/s: (was: 0.15.0)
0.14.0
Status: Patch Available (was: Open)
Please commit this patch.
> [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.
[jira] Commented: (HADOOP-1720) [HbaseShell] Addition of HQL (Hbase
Query Language) support in Hbase Shell
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12526108 ]
Edward Yoon commented on HADOOP-1720:
-------------------------------------
delete * from table_name where row='row_key' ....
I think we need to have a delete marking feature (API) that can take out All the data in a row.
> [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
>
>
> 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.
[jira] Commented: (HADOOP-1720) [HbaseShell] Addition of HQL (Hbase
Query Language) support in Hbase Shell
Posted by "Inchul Song (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12523756 ]
Inchul Song commented on HADOOP-1720:
-------------------------------------
Thank you for your help, Edward.
I am working on it.
> [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, hql_v08.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.
[jira] Commented: (HADOOP-1720) [HbaseShell] Addition of HQL (Hbase
Query Language) support in Hbase Shell
Posted by "Hudson (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12527079 ]
Hudson commented on HADOOP-1720:
--------------------------------
Integrated in Hadoop-Nightly #235 (See [http://lucene.zones.apache.org:8080/hudson/job/Hadoop-Nightly/235/])
> [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
> Assignee: stack
> 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, hql_v22.patch, hql_v23.patch, hql_v24.patch, hql_v25.patch, hql_v26.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.
[jira] Updated: (HADOOP-1720) [HbaseShell] Addition of HQL (Hbase
Query Language) support in Hbase Shell
Posted by "stack (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
stack updated HADOOP-1720:
--------------------------
Status: In Progress (was: Patch Available)
Moving issue status back to 'resume progress' (Otherwise, it would seem to trigger a hudson build on each new patch upload).
Edward: Help me out. I'm having difficulty distinguishing where 'string literals' and 'identifiers' should be used. Your example above confuses me. Row name is a 'string literal' but i'd think that a users would be inclined to group row name with column and table names and therefore classify row name an 'identifier' and therefore worthy of double-quotes.
Inchul: I took a look at other sql create syntax and indeed column specification are wrapped in parens.
> [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
>
>
> 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.
[jira] Issue Comment Edited: (HADOOP-1720) Addition of support for
HQL (Hbase Query Language) in Hbase Shell
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12520160 ]
udanax edited comment on HADOOP-1720 at 8/16/07 12:56 AM:
---------------------------------------------------------------
Thanks, Inchul
was (Author: udanax):
Thanks, Inchul.
I actually like it.
> Addition of support for HQL (Hbase Query Language) 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
>
>
> 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.
[jira] Updated: (HADOOP-1720) [HbaseShell] Addition of HQL (Hbase
Query Language) support in Hbase Shell
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Edward Yoon updated HADOOP-1720:
--------------------------------
Attachment: hql_v06.patch
Here's a trivial clean-up patch for FsCommand.
> [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
>
>
> 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.
[jira] Updated: (HADOOP-1720) [HbaseShell] Addition of HQL (Hbase
Query Language) support in Hbase Shell
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Edward Yoon updated HADOOP-1720:
--------------------------------
Attachment: hql_v10.patch
I edited the literal tokens in HBaseShell.jj and the Select Command for UTF-8 output.
Patch's are somewhat complicated.
So, I would like to implement other things by creating each sub-task for more convenient collaboration.
> [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, hql_v08.patch, hql_v09.patch, hql_v10.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.
[jira] Updated: (HADOOP-1720) [HbaseShell] Addition of HQL (Hbase
Query Language) support in Hbase Shell
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Edward Yoon updated HADOOP-1720:
--------------------------------
Attachment: hql_v23.patch
* fixed the quoting issue
{code}
Hbase > insert into "abc" ("abc:") values ('abcd') where row='abc';
1 row inserted successfully.(0.01 sec)
Hbase > insert into "abc" ("abc:") values ('abcd') where row="abc";
1 row inserted successfully.(0.01 sec)
Hbase > insert into "abc" ("abc:") values ("abcd") where row='abc';
1 row inserted successfully.(0.01 sec)
{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, 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, hql_v22.patch, hql_v23.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.
[jira] Commented: (HADOOP-1720) [HbaseShell] Addition of HQL (Hbase
Query Language) support in Hbase Shell
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12526106 ]
Edward Yoon commented on HADOOP-1720:
-------------------------------------
but, I think "delete command" syntax seems some strange. (semantically)
> [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
>
>
> 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.
[jira] Issue Comment Edited: (HADOOP-1720) [HbaseShell] Addition of
HQL (Hbase Query Language) support in Hbase Shell
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12524476 ]
udanax edited comment on HADOOP-1720 at 9/3/07 2:15 AM:
-------------------------------------------------------------
I mean just about series or parallel collaboration of code implementation. (by each sub-issue)
with more than two people working on one same issue,
we can't find out who's working on which part nor who's more available to work.
but, ...
I'll submit just after reported bug fixes.
was (Author: udanax):
I mean just about series or parallel collaboration of code implementation.
with more than two people working on one same issue,
we can't find out who's working on which part nor who's more available to work.
but, ...
I'll submit just after reported bug fixes.
> [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, hql_v08.patch, hql_v09.patch, hql_v10.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.
[jira] Updated: (HADOOP-1720) [HbaseShell] Addition of HQL (Hbase
Query Language) support in Hbase Shell
Posted by "Inchul Song (JIRA)" <ji...@apache.org>.
[ 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.
[jira] Updated: (HADOOP-1720) [HbaseShell] Addition of HQL (Hbase
Query Language) support in Hbase Shell
Posted by "stack (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
stack updated HADOOP-1720:
--------------------------
Status: Patch Available (was: In Progress)
Trying against hudson.
> [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
> Assignee: stack
> 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, hql_v22.patch, hql_v23.patch, hql_v24.patch, hql_v25.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.
[jira] Issue Comment Edited: (HADOOP-1720) [HbaseShell] Addition of
HQL (Hbase Query Language) support in Hbase Shell
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12521002 ]
udanax edited comment on HADOOP-1720 at 8/19/07 7:37 PM:
--------------------------------------------------------------
Inchul,
If you can think of any even better way to output results, let me know on this issue.
May I suggest u to fix output class on this issue?
was (Author: udanax):
Inchul,
If you can think of any even better way to output results, let me know on this issue.
and, I suggest u to fix output class on this issue.
May I suggest u to fix output class on this issue?
> [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
>
>
> 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.
[jira] Commented: (HADOOP-1720) [HbaseShell] Addition of HQL (Hbase
Query Language) support in Hbase Shell
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12524476 ]
Edward Yoon commented on HADOOP-1720:
-------------------------------------
I mean just about series or parallel collaboration of code implementation.
with more than two people working on one same issue,
we can't find out who's working on which part nor who's more available to work.
but, ...
I'll submit just after reported bug fixes.
> [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, hql_v08.patch, hql_v09.patch, hql_v10.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.
[jira] Commented: (HADOOP-1720) [HbaseShell] Addition of HQL (Hbase
Query Language) support in Hbase Shell
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12525259 ]
Edward Yoon commented on HADOOP-1720:
-------------------------------------
Tell me what you want.
> [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
>
>
> 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.
[jira] Commented: (HADOOP-1720) [HbaseShell] Addition of HQL (Hbase
Query Language) support in Hbase Shell
Posted by "Inchul Song (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12522965 ]
Inchul Song commented on HADOOP-1720:
-------------------------------------
Progress report:
Things already done:
* INSERT
* DELETE, except DELETE * FROM
* DROP
* ENABLE, DISABLE
* SELECT
Things to to:
* CREATE
* ALTER
* Various formatting methods in SELECT
> [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
>
>
> 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.
[jira] Updated: (HADOOP-1720) [HbaseShell] Addition of HQL (Hbase
Query Language) support in Hbase Shell
Posted by "Inchul Song (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Inchul Song updated HADOOP-1720:
--------------------------------
Attachment: hql_v08.patch
1. ALTER TABLE add implemented, and verified that it is working.
{noformat}
HBase > alter table webtable add length in_memory;
Disabling webtable... Please wait.
07/08/29 19:30:47 INFO hbase.HBaseAdmin: Disabled table webtable
Please wait. Adding length to webtable...
Enabling webtable... Please wait.
07/08/29 19:30:47 INFO hbase.HBaseAdmin: Enabled table webtable
Table altered successfully.
HBase > desc webtable;
+------+----------------------+
| No. | ColumnFamily Name |
+------+----------------------+
| 1 | anchor |
+------+----------------------+
| 2 | contents |
+------+----------------------+
| 3 | length |
+------+----------------------+
3 columnfamilie(s) found.(0.07 sec)
{noformat}
2. ALTER TABLE DROP seems not working.
I've tested it several times and verified that HbaseAdmin.deleteColumn()
actually is being called, but with no effect to the table.
Could somebody please test it in your environment for me?
{noformat}
HBase > alter table webtable drop contents;
Disabling webtable... Please wait.
07/08/29 19:42:45 INFO hbase.HBaseAdmin: Disabled table webtable
Dropping contents from webtable... Please wait.
Enabling webtable... Please wait.
07/08/29 19:42:45 INFO hbase.HBaseAdmin: Enabled table webtable
Table altered successfully.
HBase > desc webtable;
+------+----------------------+
| No. | ColumnFamily Name |
+------+----------------------+
| 1 | anchor |
+------+----------------------+
| 2 | contents |
+------+----------------------+
| 3 | length |
+------+----------------------+
3 columnfamilie(s) found.(0.02 sec)
{noformat}
3. Progress report:
Things to do:
* Fix a bug in ALTER TABLE DROP.
* ALTER TABLE CHANGE
* DELETE * FROM
* 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, hql_v08.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.
[jira] Commented: (HADOOP-1720) [HbaseShell] Addition of HQL (Hbase
Query Language) support in Hbase Shell
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12523137 ]
Edward Yoon commented on HADOOP-1720:
-------------------------------------
I suspect some collision between <STRING> and <ID>.
{code}
HBase > fs -ls;
Syntax error: Type 'help' for usage: Encountered "-ls" at line 1, column 5.
{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.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.
[jira] Updated: (HADOOP-1720) [HbaseShell] Addition of HQL (Hbase
Query Language) support in Hbase Shell
Posted by "Inchul Song (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Inchul Song updated HADOOP-1720:
--------------------------------
Status: Patch Available (was: Open)
We would like to submit the latest patch.
In the latest patch:
1. Several HQL statements implemented
* INSERT
* DELETE
* DROP
* ENABLE, DISABLE
* SELECT
* CREATE
* ALTER ADD
2. Not yet been tackled
There are several statements that are not yet implemented due to
various problems. Each of these problems may become an issue
by itself.
* DELETE * FROM
Due to the inconvenience in the API. There's no convenient way to delete
all values in a column family. For example, the method HTable.delete()
only allows fully-qualified names, like HTable.delete("anchor").
* SELECT INTO
The issue [HADOOP-1789|https://issues.apache.org/jira/browse/HADOOP-1789] is
tackling this issue. We'll come back to SELECT INTO after that issue has
been completed.
* ALTER DROP
We guess that there a problem in the HBaseAdmin.deleteColumn() method.
A specified column is not deleted even if the method is certainly called.
However, not yet been verified thoroughly.
* ALTER CHANGE
We think that there is no way to change a column family name
without deleting all the values in the column family. The only way
to change a column family is, first delete the column family and then
add a new column family. We need a way to only change
a column family name and its options without deleting the values
inside.
It's been long enough, and much code has been accumulated
through this issue, so let us submit this patch. We'll tackle down each of the
remaining problems through later issues.
If there is any reason to delay submitting this patch, let us know, and
we'll do our best to make things done as soon as possible.
> [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, hql_v08.patch, hql_v09.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.
[jira] Commented: (HADOOP-1720) [HbaseShell] Addition of HQL (Hbase
Query Language) support in Hbase Shell
Posted by "stack (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12526048 ]
stack commented on HADOOP-1720:
-------------------------------
Thanks Edward. What else does v16 have? Does it have the single or double quotes around Strings? Does it fix other issues raised in the comment above on 04/Sep/07 11:35 AM?
> [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
>
>
> 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.
[jira] Commented: (HADOOP-1720) [HbaseShell] Addition of HQL (Hbase
Query Language) support in Hbase Shell
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12521766 ]
Edward Yoon commented on HADOOP-1720:
-------------------------------------
Well, I think it would be better to exporting results to Hadoop File format or <K,V> map structure rather than CSV.
More thinking.......
> [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
>
>
> 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.
[jira] Updated: (HADOOP-1720) [HbaseShell] Addition of HQL (Hbase
Query Language) support in Hbase Shell
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Edward Yoon updated HADOOP-1720:
--------------------------------
Attachment: hql_v18.patch
* fixed "delete * from"
{code}
Hbase > delete * from movieLog_table where row='Wayne`s World';
Column(s) deleted successfully.(0.02 sec)
Hbase >
{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, hql_v12.patch, hql_v13.patch, hql_v14.patch, hql_v15.patch, hql_v16.patch, hql_v17.patch, hql_v18.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.
[jira] Commented: (HADOOP-1720) [HbaseShell] Addition of HQL (Hbase
Query Language) support in Hbase Shell
Posted by "stack (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12526341 ]
stack commented on HADOOP-1720:
-------------------------------
Edward: How are you making these patches? They don't apply for me. Do they for you? Looking at the patch I cannot see anything obviously wrong. Here is the complaint:
{code}
durruti:~/Documents/checkouts/hadoop-trunk stack$ patch -p0 < ~/Desktop/hql_v19.patch
(Stripping trailing CRs from patch.)
patching file src/contrib/hbase/src/java/org/apache/hadoop/hbase/Shell.java
patching file src/contrib/hbase/src/java/org/apache/hadoop/hbase/shell/DeleteCommand.java
Hunk #1 FAILED at 20.
1 out of 1 hunk FAILED -- saving rejects to file src/contrib/hbase/src/java/org/apache/hadoop/hbase/shell/DeleteCommand.java.rej
(Stripping trailing CRs from patch.)
patching file src/contrib/hbase/src/java/org/apache/hadoop/hbase/shell/CreateCommand.java
patching file src/contrib/hbase/src/java/org/apache/hadoop/hbase/shell/HelpManager.java
Hunk #1 succeeded at 40 with fuzz 2 (offset -1 lines).
missing header for unified diff at line 258 of patch
can't find file to patch at input line 258
Perhaps you used the wrong -p or --strip option?
The text leading up to this was:
--------------------------
| + "licensed to Apache Software Foundation.\n"
--------------------------
File to patch:
{code}
... which is a strange complaint when I stare at the supposed problematic line. It seems fine to me.
I was in the middle of hand-fixing v18. Let me start now on v19 and try and give you some feedback.
> [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
>
>
> 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.
[jira] Updated: (HADOOP-1720) [HbaseShell] Addition of HQL (Hbase
Query Language) support in Hbase Shell
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Edward Yoon updated HADOOP-1720:
--------------------------------
Attachment: hql_v14.patch
The string must be enclosed in single quotation marks, as in '...'.
The quoted identifier for table name and column name must be enclosed in double quotation marks, as in "...".
ex) SELECT * FROM "Blanks in table name" where row = 'Row Key String';
{code}
Hbase > select 'inColor:true' from movieLog_table;
The quoted identifier for table name and column name must
be enclosed in double quotation marks, as in "...".
Hbase > select * from movieLog_table where row = "Star Wars";
The string must be enclosed in single quotation marks, as in '...'.
Hbase > select "vote:user 1" from movieLog_table;
+------+----------------------+----------------------+----------------------+
| No. | Row | Column | Cell |
+------+----------------------+----------------------+----------------------+
| 1 | Wayne`s World | vote:user 1 | 3 |
+------+----------------------+----------------------+----------------------+
Successfully print out the selected data.(0.04 sec)
Hbase >
{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, hql_v12.patch, hql_v13.patch, hql_v14.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.
[jira] Assigned: (HADOOP-1720) [HbaseShell] Addition of HQL (Hbase
Query Language) support in Hbase Shell
Posted by "stack (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
stack reassigned HADOOP-1720:
-----------------------------
Assignee: stack
> [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
> Assignee: stack
> 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, hql_v22.patch, hql_v23.patch, hql_v24.patch, hql_v25.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.
[jira] Updated: (HADOOP-1720) Addition of support for HQL (Hbase
Query Language)
Posted by "Inchul Song (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Inchul Song updated HADOOP-1720:
--------------------------------
Description:
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.
was:
We have defined the HQL (Hbase Query Language), which is a more SQL-like query language for Hbase, to be used
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.
Issue Type: Improvement (was: Task)
> Addition of support for HQL (Hbase Query Language)
> --------------------------------------------------
>
> 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
>
>
> 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.
[jira] Commented: (HADOOP-1720) [HbaseShell] Addition of HQL (Hbase
Query Language) support in Hbase Shell
Posted by "stack (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12524431 ]
stack commented on HADOOP-1720:
-------------------------------
Hey Edward: Does the patch fix/address any of the issues I raise above? If so, which? And I'm not sure I understand your comment correctly: Are you suggesting that issues w/ the patch be addressed as sub-issues? Or does 'other things' mean something else?
> [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, hql_v08.patch, hql_v09.patch, hql_v10.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.
[jira] Commented: (HADOOP-1720) [HbaseShell] Addition of HQL (Hbase
Query Language) support in Hbase Shell
Posted by "stack (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12526035 ]
stack commented on HADOOP-1720:
-------------------------------
Edward: Take a look at the patch. See how it first removes all the lines for a bunch of classes followed immediately by an adding back of lines? For example, see the first class Shell.java in v15. See how patches I put up are nearly half the size (though they include all you've changed?). How are you generating the patches?
> [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
>
>
> 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.
[jira] Commented: (HADOOP-1720) [HbaseShell] Addition of HQL (Hbase
Query Language) support in Hbase Shell
Posted by "Hadoop QA (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12523911 ]
Hadoop QA commented on HADOOP-1720:
-----------------------------------
+1
http://issues.apache.org/jira/secure/attachment/12364822/hql_v09.patch applied and successfully tested against trunk revision r571211.
Test results: http://lucene.zones.apache.org:8080/hudson/job/Hadoop-Patch/656/testReport/
Console output: http://lucene.zones.apache.org:8080/hudson/job/Hadoop-Patch/656/console
> [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, hql_v08.patch, hql_v09.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.
[jira] Commented: (HADOOP-1720) [HbaseShell] Addition of HQL (Hbase
Query Language) support in Hbase Shell
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12526344 ]
Edward Yoon commented on HADOOP-1720:
-------------------------------------
Thank you for your review, Stack.
Patches was edited by manually altering the code. (but, I had no problem with these.)
I'll clean this up.
> [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
>
>
> 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.
[jira] Commented: (HADOOP-1720) [HbaseShell] Addition of HQL (Hbase
Query Language) support in Hbase Shell
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12525004 ]
Edward Yoon commented on HADOOP-1720:
-------------------------------------
Stack : I want simple syntax, too.
but, i don't want to use either single and double quotes for string literals and identifier delimiters.
So, i make a distinction between single and double quotes.
Here we can see one of the semantic differences between single and double quotes.
{code}
SELECT "c1:blanks in column key_1" FROM table_name WHERE row = 'c1:blanks in column key_1';
{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, hql_v12.patch, hql_v13.patch, hql_v14.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.
[jira] Updated: (HADOOP-1720) [HbaseShell] Addition of HQL (Hbase
Query Language) support in Hbase Shell
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Edward Yoon updated HADOOP-1720:
--------------------------------
Attachment: hql_v15.patch
inchul and me jus decided to use either single and double quotes for strings.
> [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
>
>
> 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.
[jira] Issue Comment Edited: (HADOOP-1720) [HbaseShell] Addition of
HQL (Hbase Query Language) support in Hbase Shell
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12525004 ]
udanax edited comment on HADOOP-1720 at 9/5/07 12:23 AM:
--------------------------------------------------------------
Stack : I want simple syntax, too.
but, i don't want to use either single and double quotes for string literals and identifier delimiters.
So, i made a distinction between single and double quotes.
Here we can see one of the semantic differences between single and double quotes.
{code}
SELECT "c1:blanks in column key_1" FROM table_name WHERE row = 'c1:blanks in column key_1';
{code}
was (Author: udanax):
Stack : I want simple syntax, too.
but, i don't want to use either single and double quotes for string literals and identifier delimiters.
So, i make a distinction between single and double quotes.
Here we can see one of the semantic differences between single and double quotes.
{code}
SELECT "c1:blanks in column key_1" FROM table_name WHERE row = 'c1:blanks in column key_1';
{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, hql_v12.patch, hql_v13.patch, hql_v14.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.
[jira] Updated: (HADOOP-1720) [HbaseShell] Addition of HQL (Hbase
Query Language) support in Hbase Shell
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Edward Yoon updated HADOOP-1720:
--------------------------------
Attachment: hql_v16.patch
Fixed it.
> [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
>
>
> 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.
[jira] Updated: (HADOOP-1720) [HbaseShell] Addition of HQL (Hbase
Query Language) support in Hbase Shell
Posted by "stack (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
stack updated HADOOP-1720:
--------------------------
Resolution: Fixed
Status: Resolved (was: Patch Available)
Thanks Inchul and Edward for persevering with this one. Its a nice addition to hbase.
Committed. Resolving...
> [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
> Assignee: stack
> 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, hql_v22.patch, hql_v23.patch, hql_v24.patch, hql_v25.patch, hql_v26.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.
[jira] Updated: (HADOOP-1720) [HbaseShell] Addition of HQL (Hbase
Query Language) support in Hbase Shell
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Edward Yoon updated HADOOP-1720:
--------------------------------
Attachment: hql_v05.patch
I edited the select syntax.
{code}
HBase > select inColor:, length: from movieLog_table;
+------+----------------------+----------------------+----------------------+
| No. | Row | Column | Cell |
+------+----------------------+----------------------+----------------------+
| 1 | Mighty Ducks | inColor: | true |
+------+----------------------+----------------------+----------------------+
| 1 | Mighty Ducks | length: | 124 |
+------+----------------------+----------------------+----------------------+
| 2 | Star Wars | inColor: | true |
+------+----------------------+----------------------+----------------------+
| 2 | Star Wars | length: | 124 |
+------+----------------------+----------------------+----------------------+
| 3 | Wayne`s World | inColor: | true |
+------+----------------------+----------------------+----------------------+
| 3 | Wayne`s World | length: | 95 |
+------+----------------------+----------------------+----------------------+
Successfully print out the selected data.(0.02 sec)
HBase > select * from movieLog_table starting from 'Star Wars';
+------+----------------------+----------------------+----------------------+
| No. | Row | Column | Cell |
+------+----------------------+----------------------+----------------------+
| 1 | Star Wars | inColor: | true |
+------+----------------------+----------------------+----------------------+
| 1 | Star Wars | length: | 124 |
+------+----------------------+----------------------+----------------------+
| 1 | Star Wars | producer: | George Lucas |
+------+----------------------+----------------------+----------------------+
| 1 | Star Wars | studioName: | Fox |
+------+----------------------+----------------------+----------------------+
| 1 | Star Wars | vote:user_1 | 5 |
+------+----------------------+----------------------+----------------------+
| 1 | Star Wars | year: | 1977 |
+------+----------------------+----------------------+----------------------+
| 2 | Wayne`s World | inColor: | true |
+------+----------------------+----------------------+----------------------+
| 2 | Wayne`s World | length: | 95 |
+------+----------------------+----------------------+----------------------+
| 2 | Wayne`s World | producer: | Penelope Spheeris |
+------+----------------------+----------------------+----------------------+
| 2 | Wayne`s World | studioName: | Paramount |
+------+----------------------+----------------------+----------------------+
| 2 | Wayne`s World | vote:user_1 | 3 |
+------+----------------------+----------------------+----------------------+
| 2 | Wayne`s World | year: | 1992 |
+------+----------------------+----------------------+----------------------+
Successfully print out the selected data.(0.01 sec)
HBase > exit;
{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.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
>
>
> 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.
[jira] Commented: (HADOOP-1720) [HbaseShell] Addition of HQL (Hbase
Query Language) support in Hbase Shell
Posted by "stack (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12524819 ]
stack commented on HADOOP-1720:
-------------------------------
Hey Edward: A few things before committing the patch:
You made the patch on a machine that has different line-ending settings from that of the source you were making the patch against. To the patch program, it looks as though every line has changed though most of the time it is only the line-endings that differ. This makes it hard distingushing legitimate changes.
I fixed up the patch and regenerated a new v13 that has changes only including a few of my own:
+ DESC and DESCRIBE were present in the help listings (I removed DESC).
+ I removed the clear of the screen on shell launch. I hope you do not mind. I've found the automatic clearing of screen a little annoying. Usually I need something from the screen such as a command to copy.
+ I fixed the help for create tables to add parens around column families (Looks like they are needed going by the below).
{code}
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 > create table x y;
Syntax error : Type 'help;' for usage.
org.apache.hadoop.hbase.shell.generated.ParseException: Encountered "y" at line 1, column 17.
Was expecting:
"(" ...
{code}
Other issues:
+ Naming column families, it looks like the ':' terminating colon is optional. Is this intentional? Would be less confusing if it just required them or not especially as later when I try to insert values, its required:
{code}
Hbase > insert into x (y) values ('xxx') where row='z';
org.apache.hadoop.hbase.InvalidColumnNameException: y is missing the colon family/qualifier separator
{code}
+ The console table formatting seems broken (Try doing a select on the '-ROOT-' table.
+ Single vs. double quotes is inconsistent:
{code}
Hbase > insert into x (y) values ('xxx') where row="z";
Syntax error : Type 'help;' for usage.
org.apache.hadoop.hbase.shell.generated.ParseException: Encountered "\"z\"" at line 1, column 45.
Was expecting:
<STRING_LITERAL> ...
{code}
Above you have example of column names having double quotes but when I try to use them on a row name I get the above complaint.
Here is another example where I try to double quote a column name making an insert:
{code}
Hbase > insert into x ("y:y") values ('xxx') where row="z";
Syntax error : Type 'help;' for usage.
org.apache.hadoop.hbase.shell.generated.ParseException: Encountered "\"z\"" at line 1, column 49.
Was expecting:
<STRING_LITERAL> ...
{code}
I'd suggest that double-quotes are either allowed everywhere or they are allowed nowhere.
Why is it complaining about the following:
{code}
Hbase > insert into x ('y:y') values ('xxx') where row='z';
Syntax error : Type 'help;' for usage.
org.apache.hadoop.hbase.shell.generated.ParseException: Encountered "\'y:y\'" at line 1, column 17.
Was expecting one of:
"*" ...
<ID> ...
<QUOTED_ID> ...
{code}
'y:' is a column family for table 'x' (It looks like INSERT does not want quotes around the column which makes it so if column name has spaces, I cannot insert values).
> [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
>
>
> 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.
[jira] Updated: (HADOOP-1720) Addition of support for HQL (Hbase
Query Language) in Hbase Shell
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Edward Yoon updated HADOOP-1720:
--------------------------------
Attachment: hql_v01.patch
I edited the insert syntax.
{code}
Hbase > INSERT INTO movieLog_table
-> ( year:, length:, inColor:, studioName:, vote:user_1, producer: )
-> VALUES ('1991', '124', 'true', 'Disney', '2', 'Blair Peters')
-> WHERErow='Mighty Ducks';
{code}
> Addition of support for HQL (Hbase Query Language) 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
>
>
> 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.
[jira] Updated: (HADOOP-1720) [HbaseShell] Addition of HQL (Hbase
Query Language) support in Hbase Shell
Posted by "Inchul Song (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Inchul Song updated HADOOP-1720:
--------------------------------
Status: Open (was: Patch Available)
to reflect the suggestions to the previously submitted patch.
> [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, hql_v08.patch, hql_v09.patch, hql_v10.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.
[jira] Issue Comment Edited: (HADOOP-1720) [HbaseShell] Addition of
HQL (Hbase Query Language) support in Hbase Shell
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12526106 ]
udanax edited comment on HADOOP-1720 at 9/10/07 2:29 AM:
--------------------------------------------------------------
but, I think something(semantically) is wrong with delete command syntax.
was (Author: udanax):
but, I think "delete command" syntax seems some strange. (semantically)
> [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
>
>
> 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.
[jira] Commented: (HADOOP-1720) [HbaseShell] Addition of HQL (Hbase
Query Language) support in Hbase Shell
Posted by "Hadoop QA (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12526968 ]
Hadoop QA commented on HADOOP-1720:
-----------------------------------
+1
http://issues.apache.org/jira/secure/attachment/12365667/hql_v26.patch applied and successfully tested against trunk revision r575114.
Test results: http://lucene.zones.apache.org:8080/hudson/job/Hadoop-Patch/747/testReport/
Console output: http://lucene.zones.apache.org:8080/hudson/job/Hadoop-Patch/747/console
> [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
> Assignee: stack
> 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, hql_v22.patch, hql_v23.patch, hql_v24.patch, hql_v25.patch, hql_v26.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.
[jira] Commented: (HADOOP-1720) Addition of support for HQL (Hbase
Query Language)
Posted by "edward yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12520160 ]
edward yoon commented on HADOOP-1720:
-------------------------------------
Thanks, Inchul.
I actually like it.
> Addition of support for HQL (Hbase Query Language)
> --------------------------------------------------
>
> 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
>
>
> 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.
[jira] Commented: (HADOOP-1720) [HbaseShell] Addition of HQL (Hbase
Query Language) support in Hbase Shell
Posted by "stack (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12526343 ]
stack commented on HADOOP-1720:
-------------------------------
Looking more at your patch, the offsets are wrong. For example, look at this snippet from the HelpManager portion of the patch:
{code}
@@ -41,7 +41,6 @@
/** Print out the program version. */
public void printVersion() {
- ClearCommand.clear();
System.out.println(APP_NAME + ", " + APP_VERSION + " version.\n"
+ "Copyright (c) 2007 by udanax, "
+ "licensed to Apache Software Foundation.\n"
{code}
It says that 7 lines starting at 41 are to be replaced with 6 lines (w/ ClearCommand removed) but there are 8 lines provided. If I manually change line numbers I can get it apply. How are you generating the patches Edward?
> [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
>
>
> 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.
[jira] Commented: (HADOOP-1720) [HbaseShell] Addition of HQL (Hbase
Query Language) support in Hbase Shell
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12521003 ]
Edward Yoon commented on HADOOP-1720:
-------------------------------------
May I proceed with a new issue?
> [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
>
>
> 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.
[jira] Updated: (HADOOP-1720) [HbaseShell] Addition of HQL (Hbase
Query Language) support in Hbase Shell
Posted by "stack (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
stack updated HADOOP-1720:
--------------------------
Attachment: hql_v25.patch
v25 adds:
+ Unit tests for select and delete (w/ quotes around rows and column family tests)
+ Fixed missing imports on testhbaseshell
+ Fixed some help descriptions
+ added back some of my little formatting changes that were lost.
+ Fixed delete so that the row doesn't have to be a 'STRINGLITERAL' only.
> [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, hql_v22.patch, hql_v23.patch, hql_v24.patch, hql_v25.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.
[jira] Updated: (HADOOP-1720) Addition of support for HQL (Hbase
Query Language) in Hbase Shell
Posted by "Inchul Song (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Inchul Song updated HADOOP-1720:
--------------------------------
Description:
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.
was:
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.
Summary: Addition of support for HQL (Hbase Query Language) in Hbase Shell (was: Addition of support for HQL (Hbase Query Language))
> Addition of support for HQL (Hbase Query Language) 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
>
>
> 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.
[jira] Updated: (HADOOP-1720) [HbaseShell] Addition of HQL (Hbase
Query Language) support in Hbase Shell
Posted by "stack (JIRA)" <ji...@apache.org>.
[ 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.
[jira] Commented: (HADOOP-1720) [HbaseShell] Addition of HQL (Hbase
Query Language) support in Hbase Shell
Posted by "Inchul Song (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12521325 ]
Inchul Song commented on HADOOP-1720:
-------------------------------------
Yes, Edward and I am making changes together. Each takes
different part of the language.
We'll let others know what changes are made for every new patch.
> [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
>
>
> 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.
[jira] Commented: (HADOOP-1720) [HbaseShell] Addition of HQL (Hbase
Query Language) support in Hbase Shell
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12525614 ]
Edward Yoon commented on HADOOP-1720:
-------------------------------------
line-endings?
> [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
>
>
> 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.
[jira] Commented: (HADOOP-1720) [HbaseShell] Addition of HQL (Hbase
Query Language) support in Hbase Shell
Posted by "Hadoop QA (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12526901 ]
Hadoop QA commented on HADOOP-1720:
-----------------------------------
-1, build or testing failed
2 attempts failed to build and test the latest attachment http://issues.apache.org/jira/secure/attachment/12365651/hql_v25.patch against trunk revision r575016.
Test results: http://lucene.zones.apache.org:8080/hudson/job/Hadoop-Patch/743/testReport/
Console output: http://lucene.zones.apache.org:8080/hudson/job/Hadoop-Patch/743/console
Please note that this message is automatically generated and may represent a problem with the automation system and not the patch.
> [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
> Assignee: stack
> 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, hql_v22.patch, hql_v23.patch, hql_v24.patch, hql_v25.patch, hql_v26.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.
[jira] Updated: (HADOOP-1720) [HbaseShell] Addition of HQL (Hbase
Query Language) support in Hbase Shell
Posted by "stack (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
stack updated HADOOP-1720:
--------------------------
Status: Patch Available (was: In Progress)
Resubmitting with v26 with fix for TestToString (All tests pass locally).
> [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
> Assignee: stack
> 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, hql_v22.patch, hql_v23.patch, hql_v24.patch, hql_v25.patch, hql_v26.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.
[jira] Updated: (HADOOP-1720) [HbaseShell] Addition of HQL (Hbase
Query Language) support in Hbase Shell
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Edward Yoon updated HADOOP-1720:
--------------------------------
Attachment: hql_v22.patch
* edited the help string for "drop" command. ( DROP TABLE table_name[, table_name]...; )
{code}
Hbase > help drop;
Syntax:
DROP table_name [, table_name] ...;
Hbase > drop movieLog_table;
Syntax error : Type 'help' for usage: Encountered "movieLog_table" at line 1, column 7.
{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, 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, hql_v22.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.
[jira] Updated: (HADOOP-1720) Addition of support for HQL (Hbase
Query Language) in Hbase Shell
Posted by "Inchul Song (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Inchul Song updated HADOOP-1720:
--------------------------------
Status: Patch Available (was: Open)
drop table syntax
> Addition of support for HQL (Hbase Query Language) 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
>
>
> 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.
[jira] Updated: (HADOOP-1720) [HbaseShell] Addition of HQL (Hbase
Query Language) support in Hbase Shell
Posted by "Inchul Song (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Inchul Song updated HADOOP-1720:
--------------------------------
Attachment: hql_v03.patch
Apply changes for the syntax of DELETE, ENABLE and DISABLE statements.
{noformat}
DELETE column_name, [, column_name] ...
FROM table_name
WHERE row = 'row-key'
ENABLE table_name
DISABLE table_name
{noformat}
> [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
>
>
> 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.
[jira] Updated: (HADOOP-1720) [HbaseShell] Addition of HQL (Hbase
Query Language) support in Hbase Shell
Posted by "stack (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
stack updated HADOOP-1720:
--------------------------
Status: In Progress (was: Patch Available)
Resuming progress. Waiting on hudson fail before resubmitting.
> [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
> Assignee: stack
> 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, hql_v22.patch, hql_v23.patch, hql_v24.patch, hql_v25.patch, hql_v26.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.
[jira] Updated: (HADOOP-1720) [HbaseShell] Addition of HQL (Hbase
Query Language) support in Hbase Shell
Posted by "stack (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
stack updated HADOOP-1720:
--------------------------
Attachment: hql_v26.patch
v25 fails TestToString (I'd changed the HColumnDescriptor.toString()). Here's a fix (though I'm too late for Hudson. Its already started in on v25).
I forgot to add that v25 also makes the describe more interesting printing out all column family properties, not just column family name.
> [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
> Assignee: stack
> 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, hql_v22.patch, hql_v23.patch, hql_v24.patch, hql_v25.patch, hql_v26.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.
[jira] Commented: (HADOOP-1720) [HbaseShell] Addition of HQL (Hbase
Query Language) support in Hbase Shell
Posted by "Inchul Song (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12520942 ]
Inchul Song commented on HADOOP-1720:
-------------------------------------
The current version of delete() method in trunk is working well.
Must've been my mistake. I'll check it out.
> [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
>
>
> 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.