Database Reference
In-Depth Information
And now that you have some data, you will create an index that will allow you to execute a
simple SQL query to retrieve
Dune
reviews:
CREATE
CREATE INDEX
INDEX OON
reviews
(
title
);
SELECT
SELECT
*
FROM
FROM
reviews
WHERE
WHERE
title
=
'Dune'
;
reviewer
|
title
|
rating
----------+------------+-------
Kevin
|
Dune
|
10
Marshall
|
Dune
|
1
Kevin
|
Casablanca
|
5
HBase
License
Apache License, Version 2.0
Activity
High
Purpose
NoSQL database with random access
Official Page
Hadoop Integration Fully Integrated
There are many situations in which you might have sparse data. That is, there are many at-
tributes of the data, but each observation only has a few of them. For example, you might
want a table of various tickets in a help-desk application. Tickets for email might have differ-
ent information (and attributes or columns) than tickets for network problems or lost pass-
words, or issues with backup system. There are other situations in which you have data that
has a large number of common values in a column or attribute, say “country” or “state.”
Each of these example might lead you to consider HBase.