hadoop-common-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Edward Yoon (JIRA)" <j...@apache.org>
Subject [jira] Updated: (HADOOP-2557) [Hbase Shell] Count function
Date Wed, 09 Jan 2008 06:33:34 GMT

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


Mime
View raw message