Dear Wiki user, You have subscribed to a wiki page or wiki category on "Lucene-hadoop Wiki" for change notification.
The following page has been changed by udanax: http://wiki.apache.org/lucene-hadoop/Hbase/HbaseShell ------------------------------------------------------------------------------ {{{ Hbase > A = table('movieLog_table'); - Hbase > B = A.Group('RunningTime', SUM('vote')); + Hbase > B = A.Group('length', 'vote'); Hbase > Store B to table('m_table'); }}} @@ -187, +187 @@ {{{ Hbase > CREATE TABLE m_table ('vote'); Hbase > INSERT INTO m_table ('vote') - --> SELECT * FROM + --> SELECT * FROM --> (SELECT + --> length, vote - --> RunningTime, - --> sum('vote:user1') vote:user1, - --> sum('vote:user2') vote:user2, - --> sum('vote:user3') vote:user3, - --> sum('vote:user4') vote:user4 - ... - .. --> FROM movieLog_table - --> GROUP BY RunningTime) + --> GROUP BY length) - --> ORDER BY 1; + --> ORDER BY 1; }}} - In either case, return the same results. + In either case, return the same results. (It's a simple example.) '''m_table : ''' {{{ Row Columnfamilies ------------ ---------------------------------- - RunningTime vote ... + length vote ... ------------ ------------------- ---------- - 112 vote:user2 1100 ... + 0112 vote:user2 1 ... - vote:user4 1500 + vote:user4 5 - 124 vote:user3 1600 + 0124 vote:user3 3 - 125 vote:user3 2850 + 0125 vote:user3 1 - 131 vote:user1 2450 + 0131 vote:user1 2 - vote:user4 3050 + vote:user4 4 ... }}} - The expected matrix A of (Movie Running Time by User) would be as sampled below : + The expected matrix A of (length by User) would be as sampled below : [[BR]]Note : Cell data is an aggregate value of voting. {{{ Vote:user1 vote:user2 vote:user3 vote:user4 ---------- ---------- ---------- ---------- ---------- - 112 1100 1500 + 0112 1 5 - 124 1600 + 0124 3 - 125 2850 + 0125 1 - 131 2450 3050 + 0131 2 4 }}} - Now, you want the analysis to find a unknown relationship between User and Movie Running Time? + Now, you want the analysis to find an unknown pattern between length and user? {{{ - Hbase > ok, you can find a unknown relationship using the algebraic operations. + Hbase > we can just use the matrix operations. }}} '''So, Here's my questions.'''
