hadoop-common-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "stack (JIRA)" <j...@apache.org>
Subject [jira] Commented: (HADOOP-1720) [HbaseShell] Addition of HQL (Hbase Query Language) support in Hbase Shell
Date Wed, 22 Aug 2007 18:06:30 GMT

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


Mime
View raw message