index.html 5.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101
  1. <html>
  2. <h1>HBase Browser</h1>
  3. <p>We'll take a look at the new <a href="http://gethue.tumblr.com/post/59071544309/the-web-ui-for-hbase-hbase-browser">HBase Browser App</a>
  4. added in Hue 2.5 and improved significantly since.</p>
  5. <iframe frameborder="0" height="495" src="http://player.vimeo.com/video/72357888" width="900"></iframe>
  6. <p>Prerequisites before using the app:</p>
  7. <p>1. Have HBase and Thrift Service 1 initiated (Thrift can be configured)</p>
  8. <p>2. Configure your list of HBase Clusters in
  9. <a href="https://github.com/cloudera/hue/blob/master/desktop/conf.dist/hue.ini#L467">hue.ini</a>
  10. to point to your Thrift IP/Port</p>
  11. <h2>SmartView</h2>
  12. <p>The smartview is the view that you land on when you first enter a table.
  13. On the left hand side are the row keys and hovering over a row reveals a
  14. list of controls on the right. Click a row to select it, and once
  15. selected you can perform batch operations, sort columns, or do any
  16. amount of standard database operations. To explore a row, simple scroll
  17. to the right. By scrolling, the row should continue to lazily-load cells
  18. until the end.</p>
  19. <h3>Adding Data</h3>
  20. <p>To initially populate the table, you can insert a new row or bulk upload
  21. CSV/TSV/etc. type data into your table.</p>
  22. <p>On the right hand side of a row is a '+' sign that lets you insert
  23. columns into your
  24. row</p>
  25. <h3>Mutating Data</h3>
  26. <p>To edit a cell, simply click to edit inline.</p>
  27. <p>If you need more control or data about your cell, click “Full Editor” to
  28. edit.</p>
  29. <p>In the full editor, you can view cell history or upload binary data to
  30. the cell. Binary data of certain MIME Types are detected, meaning you
  31. can view and edit images, PDFs, JSON, XML, and other types directly in
  32. your browser!</p>
  33. <p>Hovering over a cell also reveals some more controls (such as the delete
  34. button or the timestamp). Click the title to select a few and do batch
  35. operations:</p>
  36. <p>If you need some sample data to get started and explore, check out this
  37. howto create <a href="http://gethue.tumblr.com/post/58181985680/hadoop-tutorial-how-to-create-example-tables-in-hbase">HBase table
  38. tutorial</a>.</p>
  39. <h3>Smart Searchbar</h3>
  40. <p>The "Smart Searchbar" is a sophisticated tool that helps you zero-in on
  41. your data. The smart search supports a number of operations. The most
  42. basic ones include finding and scanning row keys. Here I am selecting
  43. two row keys with:</p>
  44. <pre><code>domain.100, domain.200
  45. </code></pre>
  46. <p>Submitting this query gives me the two rows I was looking for. If I want
  47. to fetch rows after one of these, I have to do a scan. This is as easy
  48. as writing a '+' followed by the number of rows you want to fetch.</p>
  49. <pre><code>domain.100, domain.200 +5
  50. </code></pre>
  51. <p>Fetches domain.100 and domain.200 followed by the next 5 rows. If you're
  52. ever confused about your results, you can look down below and the query
  53. bar and also click in to edit your query.</p>
  54. <p>The Smart Search also supports column filtering. On any row, I can
  55. specify the specific columns or families I want to retrieve. With:</p>
  56. <pre><code>domain.100[column_family:]
  57. </code></pre>
  58. <p>I can select a bare family, or mix columns from different families like
  59. so:</p>
  60. <pre><code>domain.100[family1:, family2:, family3:column_a]
  61. </code></pre>
  62. <p>Doing this will restrict my results from one row key to the columns I
  63. specified. If you want to restrict column families only, the same effect
  64. can be achieved with the filters on the right. Just click to toggle a
  65. filter.</p>
  66. <p>Finally, let's try some more complex column filters. I can query for
  67. bare columns:</p>
  68. <pre><code>domain.100[column_a]
  69. </code></pre>
  70. <p>This will multiply my query over all column families. I can also do
  71. prefixes and scans:</p>
  72. <p>domain.100[family: prefix* +3]</p>
  73. <p>This will fetch me all columns that start with prefix* limited to 3
  74. results. Finally, I can filter on range:</p>
  75. <pre><code>domain.100[family: column1 to column100]
  76. </code></pre>
  77. <p>This will fetch me all columns in 'family:' that are lexicographically
  78. &gt;= column1 but &lt;= column100. The first column ('column1') must be a
  79. valid column, but the second can just be any string for comparison.</p>
  80. <p>The Smart Search also supports prefix filtering on rows. To select a
  81. prefixed row, simply type the row key followed by a star *. The prefix
  82. should be highlighted like any other searchbar keyword. A prefix scan is
  83. performed exactly like a regular scan, but with a prefixed row.</p>
  84. <pre><code>domain.10* +10
  85. </code></pre>
  86. <p>Finally, as a new feature, you can also take full advantage of the
  87. <a href="denied:about:blank">HBase filtering</a>language, by typing your filter
  88. string between curly braces. HBase Browser autocompletes your filters
  89. for you so you don't have to look them up every time. You can apply
  90. filters to rows or scans.</p>
  91. <pre><code>domain.1000 {ColumnPrefixFilter('100-') AND ColumnCountGetFilter(3)}
  92. </code></pre>
  93. <p>This doc only covers a few basic features of the Smart Search. You can
  94. take advantage of the full querying language by referring to the help
  95. menu when using the app. These include column prefix, bare columns,
  96. column range, etc. Remember that if you ever need help with the
  97. searchbar, you can use the help menu that pops up while typing, which
  98. will suggest next steps to complete your query.</p>
  99. </html>