Return-Path: Delivered-To: apmail-lucene-hadoop-commits-archive@locus.apache.org Received: (qmail 69440 invoked from network); 18 Sep 2007 14:29:37 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 18 Sep 2007 14:29:37 -0000 Received: (qmail 70637 invoked by uid 500); 18 Sep 2007 14:29:29 -0000 Delivered-To: apmail-lucene-hadoop-commits-archive@lucene.apache.org Received: (qmail 70534 invoked by uid 500); 18 Sep 2007 14:29:29 -0000 Mailing-List: contact hadoop-commits-help@lucene.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: hadoop-dev@lucene.apache.org Delivered-To: mailing list hadoop-commits@lucene.apache.org Received: (qmail 70525 invoked by uid 99); 18 Sep 2007 14:29:29 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 18 Sep 2007 07:29:29 -0700 X-ASF-Spam-Status: No, hits=-100.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.130] (HELO eos.apache.org) (140.211.11.130) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 18 Sep 2007 14:31:30 +0000 Received: from eos.apache.org (localhost [127.0.0.1]) by eos.apache.org (Postfix) with ESMTP id 4F1B159A07 for ; Tue, 18 Sep 2007 14:29:14 +0000 (GMT) Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit From: Apache Wiki To: hadoop-commits@lucene.apache.org Date: Tue, 18 Sep 2007 14:29:14 -0000 Message-ID: <20070918142914.22508.86672@eos.apache.org> Subject: [Lucene-hadoop Wiki] Trivial Update of "Hbase/HbaseShell" by udanax X-Virus-Checked: Checked by ClamAV on apache.org 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.'''