[
https://issues.apache.org/jira/browse/HADOOP-2557?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Edward Yoon updated HADOOP-2557:
--------------------------------
Attachment: 2557.patch
Here's a patch for count function.
{code}
hql > select * from movieLog_table;
+-------------------------+-------------------------+-------------------------+
| Row | Column | Cell |
+-------------------------+-------------------------+-------------------------+
| Star Wars | actor:hero | Mark Hamill |
+-------------------------+-------------------------+-------------------------+
| Star Wars | inColor: | true |
+-------------------------+-------------------------+-------------------------+
| Star Wars | length: | 124 |
+-------------------------+-------------------------+-------------------------+
| Star Wars | producer: | George Lucas |
+-------------------------+-------------------------+-------------------------+
| Star Wars | studioName: | Fox |
+-------------------------+-------------------------+-------------------------+
| Star Wars | vote:user name | 5 |
+-------------------------+-------------------------+-------------------------+
| Star Wars | vote:user name 2 | 5 |
+-------------------------+-------------------------+-------------------------+
| Star Wars | year: | 1977 |
+-------------------------+-------------------------+-------------------------+
| The moon | actor:heroine | udanax |
+-------------------------+-------------------------+-------------------------+
| The moon | inColor: | true |
+-------------------------+-------------------------+-------------------------+
| The moon | length: | 114 |
+-------------------------+-------------------------+-------------------------+
| The moon | producer: | Edward yoon |
+-------------------------+-------------------------+-------------------------+
| The moon | studioName: | Paramount |
+-------------------------+-------------------------+-------------------------+
| The moon | vote:user name | 3 |
+-------------------------+-------------------------+-------------------------+
| The moon | vote:user name2 | 4 |
+-------------------------+-------------------------+-------------------------+
| The moon | vote:user name4 | 1 |
+-------------------------+-------------------------+-------------------------+
| The moon | year: | 1987 |
+-------------------------+-------------------------+-------------------------+
2 row(s) in set. (0.38 sec)
hql > select count(*) from movieLog_table;
2 row(s) in set. (0.11 sec)
hql > select count(length) from movieLog_table;
2 row(s) in set. (0.04 sec)
hql > select count(length, inColor) from movieLog_table;
2 row(s) in set. (0.05 sec)
hql > select count(vote) from movieLog_table;
0 row(s) in set. (0.04 sec)
hql > select count(length, inColor) from movieLog_table;
2 row(s) in set. (0.05 sec)
hql > select count('vote:user name4') from movieLog_table;
1 row(s) in set. (0.04 sec)
hql > select count(*) from movieLog_table starting from 'The moon';
1 row(s) in set. (0.37 sec)
hql > exit;
{code}
> [Hbase Shell] Count function
> ----------------------------
>
> Key: HADOOP-2557
> URL: https://issues.apache.org/jira/browse/HADOOP-2557
> Project: Hadoop
> Issue Type: New Feature
> Components: contrib/hbase
> Affects Versions: 0.16.0
> Environment: All
> Reporter: Edward Yoon
> Assignee: Edward Yoon
> Priority: Minor
> Fix For: 0.16.0
>
> Attachments: 2557.patch
>
>
> This will return the number of entries in the selected range of rows as
> describe below.
> {code}
> hql > select count(*) from table_name starting from 'aa' until 'az';
> -> result here.
> {code}
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
