| 53 | |
| 54 | {{{ |
| 55 | #!html |
| 56 | <div style="text-align: center; color:#151B8D"><big style="font-weight: bold;"><big><big> |
| 57 | Hbase 使用方法 |
| 58 | </big></big></big></div> <div style="text-align: center; color:#7E2217"><big style="font-weight: bold;"><big> |
| 59 | HBase 0.20 + Hadoop 0.20 |
| 60 | </big></big></div> |
| 61 | }}} |
| 62 | |
| 63 | = 列出所有 table = |
| 64 | |
| 65 | {{{ |
| 66 | hbase(main):> list |
| 67 | }}} |
| 68 | |
| 69 | = 新增 table = |
| 70 | |
| 71 | A . 直接增加一個表 t2 |
| 72 | |
| 73 | {{{ |
| 74 | hbase(main):> create 't2' |
| 75 | }}} |
| 76 | |
| 77 | B . 增加一個擁有 'f1','f2','fn' 為 column family 的表: t1 |
| 78 | |
| 79 | {{{ |
| 80 | hbase(main):> create 't1','f1','f2','fn' |
| 81 | }}} |
| 82 | |
| 83 | = 查詢 Table 欄位 = |
| 84 | |
| 85 | {{{ |
| 86 | hbase(main):> describe 't1' |
| 87 | }}} |
| 88 | |
| 89 | 執行結果參考 |
| 90 | |
| 91 | {{{ |
| 92 | #!text |
| 93 | hbase(main):> describe 't1' |
| 94 | DESCRIPTION ENABLED |
| 95 | {NAME => 't1', FAMILIES => [{NAME => 'f1', COMPRESSION => 'NONE', VERS true |
| 96 | IONS => '3', TTL => '2147483647', BLOCKSIZE => '65536', IN_MEMORY => ' |
| 97 | false', BLOCKCACHE => 'true'}, {NAME => 'f2', COMPRESSION => 'NONE', V |
| 98 | ERSIONS => '3', TTL => '2147483647', BLOCKSIZE => '65536', IN_MEMORY = |
| 99 | > 'false', BLOCKCACHE => 'true'}, {NAME => 'fn', COMPRESSION => 'NONE' |
| 100 | , VERSIONS => '3', TTL => '2147483647', BLOCKSIZE => '65536', IN_MEMOR |
| 101 | Y => 'false', BLOCKCACHE => 'true'}]} |
| 102 | }}} |
| 103 | |
| 104 | = 加入cell-value = |
| 105 | |
| 106 | 需先擁有表 t1 與column-family : f1 |
| 107 | 並且加入一個 column-quantifier c1 |
| 108 | |
| 109 | {{{ |
| 110 | hbase(main):> put 't1', 'r1', 'f1', 'v1' |
| 111 | hbase(main):> put 't1', 'r1', 'f1:c1', 'v2' |
| 112 | hbase(main):> put 't1', 'r2', 'f2', 'v3' |
| 113 | hbase(main):> put 't1', 'r2', 'f2:c2', 'v4' |
| 114 | }}} |
| 115 | |
| 116 | {{{ |
| 117 | #!html |
| 118 | <table border='1'> |
| 119 | <tr><td colspan='7'>Table: 't1'</td></tr> |
| 120 | <tr><td rowspan='2'>row-key</td><td colspan='2'>'f1'</td><td colspan='2'>'f2'</td><td>'fn'</td><td>column-family</td></tr> |
| 121 | <tr><td>*</td><td>'c1'</td><td>*</td><td>'c2'</td><td>*</td><td>column-quantifier</td></tr> |
| 122 | <tr><td rowspan='2'>r1</td><td>v1</td><td></td><td></td><td></td><td></td></tr> |
| 123 | <tr><td></td><td>v2</td><td></td><td></td><td></td></tr> |
| 124 | <tr><td rowspan='2'>r2</td><td></td><td></td><td>v3</td><td></td><td></td></tr> |
| 125 | <tr><td></td><td></td><td></td><td>v4</td><td></td></tr> |
| 126 | </table> |
| 127 | }}} |
| 128 | |
| 129 | = 列出cell-value = |
| 130 | |
| 131 | A . 列出一列(row) |
| 132 | |
| 133 | {{{ |
| 134 | hbase(main):> get 't1', 'r1' |
| 135 | }}} |
| 136 | |
| 137 | 執行結果參考 |
| 138 | |
| 139 | {{{ |
| 140 | #!text |
| 141 | COLUMN CELL |
| 142 | f1: timestamp=1285737082689, value=v1 |
| 143 | f1:c1 timestamp=1285737085874, value=v2 |
| 144 | }}} |
| 145 | |
| 146 | {{{ |
| 147 | #!html |
| 148 | <table border='1'> |
| 149 | <tr><td colspan='7'>Table: 't1'</td></tr> |
| 150 | <tr><td rowspan='2'>row-key</td><td colspan='2'>'f1'</td><td colspan='2'>'f2'</td><td>'fn'</td><td>column-family</td></tr> |
| 151 | <tr><td>*</td><td>'c1'</td><td>*</td><td>'c2'</td><td>*</td><td>column-quantifier</td></tr> |
| 152 | <tr><td rowspan='2' bgcolor='red'>r1</td><td bgcolor='red'>v1</td><td></td><td></td><td></td><td></td></tr> |
| 153 | <tr><td></td><td bgcolor='red'>v2</td><td></td><td></td><td></td></tr> |
| 154 | <tr><td rowspan='2'>r2</td><td></td><td></td><td>v3</td><td></td><td></td></tr> |
| 155 | <tr><td></td><td></td><td></td><td>v4</td><td></td></tr> |
| 156 | </table> |
| 157 | }}} |
| 158 | |
| 159 | B . 列出一個 cell 的值 |
| 160 | |
| 161 | {{{ |
| 162 | hbase(main):> get 't1', 'r1', {COLUMN => 'f1:c1'} |
| 163 | }}} |
| 164 | |
| 165 | 執行結果參考 |
| 166 | |
| 167 | {{{ |
| 168 | #!text |
| 169 | COLUMN CELL |
| 170 | f1:c1 timestamp=1285737085874, value=v2 |
| 171 | }}} |
| 172 | |
| 173 | {{{ |
| 174 | #!html |
| 175 | <table border='1'> |
| 176 | <tr><td colspan='7'>Table: 't1'</td></tr> |
| 177 | <tr><td rowspan='2'>row-key</td><td colspan='2' bgcolor='red'>'f1'</td><td colspan='2'>'f2'</td><td>'fn'</td><td>column-family</td></tr> |
| 178 | <tr><td>*</td><td bgcolor='red'>'c1'</td><td>*</td><td>'c2'</td><td>*</td><td>column-quantifier</td></tr> |
| 179 | <tr><td rowspan='2' bgcolor='red'>r1</td><td>v1</td><td></td><td></td><td></td><td></td></tr> |
| 180 | <tr><td></td><td bgcolor='red'>v2</td><td></td><td></td><td></td></tr> |
| 181 | <tr><td rowspan='2'>r2</td><td></td><td></td><td>v3</td><td></td><td></td></tr> |
| 182 | <tr><td></td><td></td><td></td><td>v4</td><td></td></tr> |
| 183 | </table> |
| 184 | }}} |
| 185 | |
| 186 | = 刪除 cell-value = |
| 187 | |
| 188 | {{{ |
| 189 | hbase(main):> deleteall 't1','r1' |
| 190 | }}} |
| 191 | |
| 192 | 執行結果:會把 row-key 是 '!r1' 的所有紀錄。此時資料表 't1' 會變成如下表所示。 |
| 193 | {{{ |
| 194 | hbase(main):> scan 't1' |
| 195 | ROW COLUMN+CELL |
| 196 | r2 column=f2:, timestamp=1285737091644, value=v3 |
| 197 | r2 column=f2:c2, timestamp=1285737094157, value=v4 |
| 198 | }}} |
| 199 | |
| 200 | {{{ |
| 201 | #!html |
| 202 | <table border='1'> |
| 203 | <tr><td colspan='7'>Table: 't1'</td></tr> |
| 204 | <tr><td rowspan='2'>row-key</td><td colspan='2'>'f1'</td><td colspan='2'>'f2'</td><td>'fn'</td><td>column-family</td></tr> |
| 205 | <tr><td>*</td><td>'c1'</td><td>*</td><td>'c2'</td><td>*</td><td>column-quantifier</td></tr> |
| 206 | <tr><td bgcolor='red'> </td><td bgcolor='red'></td><td bgcolor='red'></td><td bgcolor='red'></td><td bgcolor='red'></td><td bgcolor='red'></td></tr> |
| 207 | <tr><td rowspan='2'>r2</td><td></td><td></td><td>v3</td><td></td><td></td></tr> |
| 208 | <tr><td></td><td></td><td></td><td>v4</td><td></td></tr> |
| 209 | </table> |
| 210 | }}} |
| 211 | |
| 212 | = 加入column family = |
| 213 | |
| 214 | {{{ |
| 215 | hbase(main):> disable 't1' |
| 216 | hbase(main):> alter 't1', {NAME => 'f3'} |
| 217 | hbase(main):> enable 't1' |
| 218 | }}} |
| 219 | |
| 220 | 執行結果:多了一個 column-family 'f3' 可以用 describe 指令查詢,結果示意如下表: |
| 221 | |
| 222 | {{{ |
| 223 | hbase(main):021:0> describe 't1' |
| 224 | DESCRIPTION ENABLED |
| 225 | {NAME => 't1', FAMILIES => [{NAME => 'f1', COMPRESSION => 'NONE', VERS true |
| 226 | IONS => '3', TTL => '2147483647', BLOCKSIZE => '65536', IN_MEMORY => ' |
| 227 | false', BLOCKCACHE => 'true'}, {NAME => 'f2', COMPRESSION => 'NONE', V |
| 228 | ERSIONS => '3', TTL => '2147483647', BLOCKSIZE => '65536', IN_MEMORY = |
| 229 | > 'false', BLOCKCACHE => 'true'}, {NAME => 'f3', VERSIONS => '3', COMP |
| 230 | RESSION => 'NONE', TTL => '2147483647', BLOCKSIZE => '65536', IN_MEMOR |
| 231 | Y => 'false', BLOCKCACHE => 'true'}, {NAME => 'fn', COMPRESSION => 'NO |
| 232 | NE', VERSIONS => '3', TTL => '2147483647', BLOCKSIZE => '65536', IN_ME |
| 233 | MORY => 'false', BLOCKCACHE => 'true'}]} |
| 234 | }}} |
| 235 | |
| 236 | |
| 237 | {{{ |
| 238 | #!html |
| 239 | <table border='1'> |
| 240 | <tr><td colspan='8'>Table: 't1'</td></tr> |
| 241 | <tr><td rowspan='2'>row-key</td><td colspan='2'>'f1'</td><td colspan='2'>'f2'</td><td bgcolor='red'>'f3'</td><td>'fn'</td><td>column-family</td></tr> |
| 242 | <tr><td>*</td><td>'c1'</td><td>*</td><td>'c2'</td><td bgcolor='red'>*</td><td>*</td><td>column-quantifier</td></tr> |
| 243 | <tr><td rowspan='2'>r2</td><td></td><td></td><td>v3</td><td></td><td bgcolor='red'></td><td></td></tr> |
| 244 | <tr><td></td><td></td><td></td><td>v4</td><td bgcolor='red'></td><td></td></tr> |
| 245 | </table> |
| 246 | }}} |
| 247 | |
| 248 | = 刪除column family = |
| 249 | |
| 250 | {{{ |
| 251 | hbase(main):> disable 't1' |
| 252 | hbase(main):> alter 't1', {NAME => 'f1', METHOD => 'delete'} |
| 253 | hbase(main):> enable 't1' |
| 254 | }}} |
| 255 | |
| 256 | 執行結果:會移除 column family 為 'f1' 的所有欄位,可用 describe 指令確認,結果如下表所示。 |
| 257 | |
| 258 | {{{ |
| 259 | hbase(main):053:0> describe 't1' |
| 260 | DESCRIPTION ENABLED |
| 261 | {NAME => 't1', FAMILIES => [{NAME => 'f2', COMPRESSION => 'NONE', VERS true |
| 262 | IONS => '3', TTL => '2147483647', BLOCKSIZE => '65536', IN_MEMORY => ' |
| 263 | false', BLOCKCACHE => 'true'}, {NAME => 'f3', COMPRESSION => 'NONE', V |
| 264 | ERSIONS => '3', TTL => '2147483647', BLOCKSIZE => '65536', IN_MEMORY = |
| 265 | > 'false', BLOCKCACHE => 'true'}, {NAME => 'fn', COMPRESSION => 'NONE' |
| 266 | , VERSIONS => '3', TTL => '2147483647', BLOCKSIZE => '65536', IN_MEMOR |
| 267 | Y => 'false', BLOCKCACHE => 'true'}]} |
| 268 | 1 row(s) in 0.0200 seconds |
| 269 | }}} |
| 270 | |
| 271 | {{{ |
| 272 | #!html |
| 273 | <table border='1'> |
| 274 | <tr><td colspan='8'>Table: 't1'</td></tr> |
| 275 | <tr><td rowspan='2'>row-key</td><td bgcolor='red'> </td><td colspan='2'>'f2'</td><td>'f3'</td><td>'fn'</td><td>column-family</td></tr> |
| 276 | <tr><td bgcolor='red'></td><td>*</td><td>'c2'</td><td>*</td><td>*</td><td>column-quantifier</td></tr> |
| 277 | <tr><td rowspan='2'>r2</td><td bgcolor='red'></td><td>v3</td><td></td><td></td><td></td></tr> |
| 278 | <tr><td bgcolor='red'></td><td></td><td>v4</td><td></td><td></td></tr> |
| 279 | </table> |
| 280 | }}} |
| 281 | |
| 282 | |
| 283 | |
| 284 | = 節點狀態 = |
| 285 | |
| 286 | {{{ |
| 287 | hbase(main):> status |
| 288 | }}} |
| 289 | |
| 290 | = 刪除整張table = |
| 291 | |
| 292 | {{{ |
| 293 | hbase(main):> truncate 't1' |
| 294 | }}} |
| 295 | |
| 296 | * 執行完 truncate 後,所有 't1' 的內容都會被移除。但此時,下 list 還會有 't1' 這個表格存在。 |
| 297 | |
| 298 | {{{ |
| 299 | hbase(main):> disable 't1' |
| 300 | hbase(main):> drop 't1' |
| 301 | }}} |
| 302 | |
| 303 | * 要完整移除 't1' 資料表,必須使用 disable 先將 't1' 停用,再用 drop 指令把 't1' 完全刪除。 |