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