[
https://issues.apache.org/jira/browse/HADOOP-2591?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Edward Yoon updated HADOOP-2591:
--------------------------------
Attachment: 2591.patch
{code}
bash-3.00# bin/hadoop dfs -cat udanax/queries.hql
create table udanax(
head,
arms,
legs
);
insert into udanax (head, arms, legs)
values ('big','short','very short')
where row='edward yoon';
...
hql > start udanax/queries.hql;
Creating table... Please wait.
Table created successfully.
1 row inserted successfully.
2 queries executed. (10.61 sec)
hql > select * from udanax;
08/01/15 19:02:00 INFO hbase.HTable: Creating scanner over udanax starting at
key
+-------------------------+-------------------------+-------------------------+
| Row | Column | Cell |
+-------------------------+-------------------------+-------------------------+
| edward yoon | arms: | short |
+-------------------------+-------------------------+-------------------------+
| edward yoon | head: | big |
+-------------------------+-------------------------+-------------------------+
| edward yoon | legs: | very short |
+-------------------------+-------------------------+-------------------------+
1 row(s) in set. (10.07 sec)
hql > _
{code}
> [HQL] Addition of start command for execute the *.hql query file
> ----------------------------------------------------------------
>
> Key: HADOOP-2591
> URL: https://issues.apache.org/jira/browse/HADOOP-2591
> Project: Hadoop
> Issue Type: New Feature
> Components: contrib/hbase
> Affects Versions: 0.16.0
> Reporter: Edward Yoon
> Assignee: Edward Yoon
> Priority: Minor
> Fix For: 0.17.0
>
> Attachments: 2591.patch
>
>
> {code}
> $ cat queries.hql
> 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 webtable (contents, anchor:Hadoop)
> VALUES ('html content', 'http://hadoop.apache.org')
> WHERE row='http://www.hadoop.co.kr';
> ...
> ----
> hql> start ./queries.hql;
> ...
> hql> desc webtable;
> ....
> {code}
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.