HBase Scan - RowKey Filters

So let's see if I can briefly explain my problem.

Imagine that we have a HBase table in which there is information about each visit to discos: Each discotheque registers its name, the name of the visitor and the day of his visit. ( yes, this is a dumb example, I know .. ).

So, for example, these will be some table values:

..
ministryOfSoundJamesOliver01022017
ministryOfSoundJamesOliver02022017
ministryOfSoundJamesOliver03022017
ministryOfSoundOliviaNewton04042017
ministryOfSoundOliviaNewton06042017
...
pachaibizaJohnMcKiness06042017
pachaibizaJohnMcKiness04042017
pachaibizaWilliamForrester04042017
..

RowKey has the following structure:

discoName

PERSONNAME

dayOfTheYear

(there are several other columns / classifiers in the table, but I do not mind them for this problem).


Question: Imagine a boy who just loves going to Ministry Of Sound. He just loves it, he spends all his money on a disco and drugs (but that's not the point).

- , Ministry of Sound. , , . F.E:

..
ministryOfSoundJohnnyYonkie01022017
ministryOfSoundJohnnyYonkie02022017
ministryOfSoundJohnnyYonkie03022017
ministryOfSoundJohnnyYonkie04022017
ministryOfSoundJohnnyYonkie05022017
ministryOfSoundAnotherDude02022017
...

AnotherDude, 4 Johnny.

, :


HBase, (x) (x + y) [ x discoName y personName] ?


!

+4
1

: , : (

, , : , .

, , , . API- , .

, MinistryOfSound . ( , HBase - , - )

, ad-hoc-, , , API- mapreduce - , Apache Spark-interconnect "" .

, .

"", CoProcessor. , PrefixFilter'd . CoProcessors, : HBase: . , RegionServer.

, , , , , - .

: Apache Phoenix , rowkey , . , , , , , , .

+1

Source: https://habr.com/ru/post/1671809/


All Articles