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

Reply via email to