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-1375) a simple parser for hbase.
Date Thu, 05 Jul 2007 06:15:05 GMT

     [ https://issues.apache.org/jira/browse/HADOOP-1375?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

edward yoon updated HADOOP-1375:
--------------------------------

    Attachment: hbase_shell_base_v07.patch

 * I added column scan
 * I changed INSERT syntax

{code}
INSERT table_name ('columnfamily_name1:column_key[,'columnfamily_name2:column_key', ...])
VALUES('entry1'[,'entry2', ...])
WHERE row='row_key';
{code}

Test results.
{code}
HBase > select udanax;
+------+----------------------+----------------------+----------------------+
| No.  | Row Key              | ColumnFamily:Column  | Cell Data            | 
+------+----------------------+----------------------+----------------------+
| 1    | b                    | a:b                  | c                    |
+------+----------------------+----------------------+----------------------+
| 2    | c                    | a:                   | b3                   |
+------+----------------------+----------------------+----------------------+
| 3    | c                    | a:c                  | ee                   |
+------+----------------------+----------------------+----------------------+
| 4    | f                    | a:c                  | test                 |
+------+----------------------+----------------------+----------------------+
| 5    | xanadu               | a:                   | v1                   |
+------+----------------------+----------------------+----------------------+
| 6    | xanadu               | b:                   | v2                   |
+------+----------------------+----------------------+----------------------+

Successfully print out the selected data.(0.12 sec)

HBase > select udanax where column='a:c';
+------+----------------------+----------------------+----------------------+
| No.  | Row Key              | ColumnFamily:Column  | Cell Data            | 
+------+----------------------+----------------------+----------------------+
| 1    | c                    | a:c                  | ee                   |
+------+----------------------+----------------------+----------------------+
| 2    | f                    | a:c                  | test                 |
+------+----------------------+----------------------+----------------------+

Successfully print out the selected data.(0.05 sec)

HBase > insert udanax ('a','b') values('test1','test2') where row='hadoop';
org.apache.hadoop.hbase.InvalidColumnNameException: a is missing the colon family/qualifier
separator

HBase > insert udanax ('a:','b:insert_test') values('test1','test2') where row='hadoop';
1 row inserted successfully.(0.02 sec)

HBase > select udanax;
+------+----------------------+----------------------+----------------------+
| No.  | Row Key              | ColumnFamily:Column  | Cell Data            | 
+------+----------------------+----------------------+----------------------+
| 1    | b                    | a:b                  | c                    |
+------+----------------------+----------------------+----------------------+
| 2    | c                    | a:                   | b3                   |
+------+----------------------+----------------------+----------------------+
| 3    | c                    | a:c                  | ee                   |
+------+----------------------+----------------------+----------------------+
| 4    | f                    | a:c                  | test                 |
+------+----------------------+----------------------+----------------------+
| 5    | hadoop               | a:                   | test1                |
+------+----------------------+----------------------+----------------------+
| 6    | hadoop               | b:insert_test        | test2                |
+------+----------------------+----------------------+----------------------+
| 7    | xanadu               | a:                   | v1                   |
+------+----------------------+----------------------+----------------------+
| 8    | xanadu               | b:                   | v2                   |
+------+----------------------+----------------------+----------------------+

Successfully print out the selected data.(0.06 sec)
{code}

> a simple parser for hbase.
> --------------------------
>
>                 Key: HADOOP-1375
>                 URL: https://issues.apache.org/jira/browse/HADOOP-1375
>             Project: Hadoop
>          Issue Type: Improvement
>          Components: contrib/hbase
>    Affects Versions: 0.13.0
>         Environment: All environments 
>            Reporter: edward yoon
>            Priority: Minor
>             Fix For: 0.14.0
>
>         Attachments: hadoop1375-v12.patch, hbase_shell_base_v03.patch, hbase_shell_base_v04.patch,
hbase_shell_base_v05.patch, hbase_shell_base_v06.patch, hbase_shell_base_v07.patch, jline-0.9.91.jar
>
>
> http://wiki.apache.org/lucene-hadoop/HbaseShell (work in progress)
> HBase Shell is developed to achieve the following goals. 
>  * Generic Monitoring Function 
>  * A Simplified Import/Export/Migrate Functionality Between different data sources (Hadoop,
HBase) 
>  * A Simplified processing of a logical data model 
>  * A Simplified algebraic operations 
>    (Parallel Numerical Analysis by abstracting/numericalizing points, lines, or plane
data across multiple maps in HBase.)
> {code}
> [# root@localhost] ./bin/hadoop jar ./build/hadoop-hbase org.apache.hadoop.hbase.shell.HbaseShell
> Hbase > help;
> blah blah...
> Hbase > create webtable 
>      --> columnfamilies('anchors', 'language') limit=3;
> Hbase > set webtable values('anchors:http://www.udanax.org/','opensource') where row="http://www.hadoop.co.kr";
> Hbase > scan webtable where row="http://www.hadoop.co.kr";
> blah blah...
> Hbase > set webtable values('language:kr','euc-kr') where row="http://www.hadoop.co.kr";
> Hbase > scan webtable where row="http://www.hadoop.co.kr" and column="language:kr";
> blah blah...
> Hbase > scan webtable;
> Hbase > exit
> [# root@localhost] 
> {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