[
https://issues.apache.org/jira/browse/HADOOP-2557?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12557142#action_12557142
]
Edward Yoon commented on HADOOP-2557:
-------------------------------------
Hbase table's column is variable as a movieLog_table 2D
{code}
- movieLog_table 2D
column
----------------
-----------
----
--------------
--------
-------------------
row
{code}
For example, below movieLog_table is a 2 by 10 Table.
{code}
- movieLog_table Data
row year length inColor studioName vote producer actor
==============================================================================================
Star Wars 1977 124 true Fox vote:user name <5> actor:hero
<Mark Hamill>
vote:user name 2 <5>
The moon 1987 114 true Paramount vote:user name <3> actor:heroine
<udanax>
vote:user name 4 <1>
vote:user name 2 <4>
year, length, inColor, studioName, vote:user name, vote:user name 2, vote:user
name 4, actor:hero, actor:heroine
.. .. .. .. .. .. Null
.. Null
.. .. .. .. .. .. ..
Null ..
{code}
But, current shell returns wrong row count.
Row count should be 2.
{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 name4 | 1 |
+-------------------------+-------------------------+-------------------------+
| The moon | year: | 1987 |
+-------------------------+-------------------------+-------------------------+
16 row(s) in set. (0.14 sec)
{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
>
>
> 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.
