| | 1 | {{{ |
| | 2 | #!html |
| | 3 | <div style="text-align: center; color:#151B8D"><big style="font-weight: bold;"><big><big> |
| | 4 | Hbase 使用方法 |
| | 5 | </big></big></big></div> <div style="text-align: center; color:#7E2217"><big style="font-weight: bold;"><big> |
| | 6 | HBase 0.20 + Hadoop 0.20 |
| | 7 | </big></big></div> |
| | 8 | }}} |
| | 9 | [[PageOutline]] |
| | 10 | |
| | 11 | = 列出所有 table = |
| | 12 | |
| | 13 | {{{ |
| | 14 | hbase(main):> list |
| | 15 | }}} |
| | 16 | |
| | 17 | = 新增 table = |
| | 18 | |
| | 19 | A. 直接增加一個表 t1 |
| | 20 | |
| | 21 | {{{ |
| | 22 | hbase(main):> create ‘t1’ |
| | 23 | }}} |
| | 24 | |
| | 25 | B. 增加一個擁有 ’f1’,’f2’,’fn’ 為 column family 的表: t2 |
| | 26 | |
| | 27 | {{{ |
| | 28 | hbase(main):> create ‘t2’,’f1’,’f2’,’fn’ |
| | 29 | }}} |
| | 30 | |
| | 31 | = 加入cell-value = |
| | 32 | |
| | 33 | 需先擁有表 t1 與column-family : f1 |
| | 34 | |
| | 35 | {{{ |
| | 36 | hbase(main):> put 't1', 'r1', 'f1:c1', 'value' |
| | 37 | }}} |
| | 38 | |
| | 39 | = 刪除 cell-value = |
| | 40 | |
| | 41 | {{{ |
| | 42 | hbase(main):> deleteall ‘t1’,’r1’ |
| | 43 | }}} |
| | 44 | |
| | 45 | |
| | 46 | |
| | 47 | = 列出cell-value = |
| | 48 | |
| | 49 | {{{ |
| | 50 | hbase(main):> get 't1', 'r1' |
| | 51 | }}} |
| | 52 | |
| | 53 | * 執行結果參考 |
| | 54 | |
| | 55 | {{{ |
| | 56 | #!text |
| | 57 | COLUMN CELL |
| | 58 | f1:c1 timestamp=1285041409509, value=value |
| | 59 | f1:c2 timestamp=1285041661078, value=9 |
| | 60 | get ‘t1’, ‘r1’, {column => ‘f1:c1’} |
| | 61 | }}} |
| | 62 | |
| | 63 | = 加入column family = |
| | 64 | |
| | 65 | {{{ |
| | 66 | hbase(main):> disable ‘t1’ |
| | 67 | hbase(main):> alter 't1', {NAME => 'f1'} |
| | 68 | hbase(main):> enable ‘t1’ |
| | 69 | }}} |
| | 70 | |
| | 71 | = 刪除column family = |
| | 72 | |
| | 73 | {{{ |
| | 74 | hbase(main):> alter 't1', {NAME => 'f1', METHOD => 'delete'} |
| | 75 | }}} |
| | 76 | |
| | 77 | = 節點狀態 = |
| | 78 | |
| | 79 | {{{ |
| | 80 | hbase(main):> status |
| | 81 | }}} |
| | 82 | |
| | 83 | = 刪除整張table = |
| | 84 | |
| | 85 | {{{ |
| | 86 | hbase(main):> truncate ‘t1’ |
| | 87 | hbase(main):> disable ‘t1’ |
| | 88 | hbase(main):> drop ‘t1’ |
| | 89 | }}} |