| 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 | }}} |