Return-Path: X-Original-To: apmail-hadoop-common-user-archive@www.apache.org Delivered-To: apmail-hadoop-common-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 13B0BC40A for ; Thu, 10 May 2012 11:32:15 +0000 (UTC) Received: (qmail 43125 invoked by uid 500); 10 May 2012 11:32:11 -0000 Delivered-To: apmail-hadoop-common-user-archive@hadoop.apache.org Received: (qmail 43073 invoked by uid 500); 10 May 2012 11:32:11 -0000 Mailing-List: contact common-user-help@hadoop.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: common-user@hadoop.apache.org Delivered-To: mailing list common-user@hadoop.apache.org Received: (qmail 43057 invoked by uid 99); 10 May 2012 11:32:11 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 10 May 2012 11:32:11 +0000 X-ASF-Spam-Status: No, hits=-2.3 required=5.0 tests=RCVD_IN_DNSWL_MED,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: local policy) Received: from [128.135.12.76] (HELO smtp00.uchicago.edu) (128.135.12.76) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 10 May 2012 11:32:01 +0000 Received: from m4500-03.uchicago.edu (md00.uchicago.edu [128.135.249.212]) by smtp00.uchicago.edu (8.13.8/8.13.8) with ESMTP id q4ABVeHB014770 for ; Thu, 10 May 2012 06:31:40 -0500 Received: (from mstore03.uchicago.edu [128.135.249.212]) by mstore03.uchicago.edu (MOS 4.1.9-GA) with HTTP/1.1 id BJN92365 (AUTH shiyu@uchicago.edu); Thu, 10 May 2012 06:31:39 -0500 (CDT) From: Shi Yu Subject: Re: SQL analysis To: common-user@hadoop.apache.org X-Mailer: Mirapoint Webmail Direct 4.1.9-GA MIME-Version: 1.0 In-Reply-To: <11D038C752939E4DA1D91A6803104824049D6A9D32@MUKPBCC1XMB714C.collab.barclayscorp.com> References: <11D038C752939E4DA1D91A6803104824049D6A9D32@MUKPBCC1XMB714C.collab.barclayscorp.com> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Message-Id: <20120510063139.BJN92365@mstore03.uchicago.edu> Date: Thu, 10 May 2012 06:31:39 -0500 (CDT) It depends on your use case, for example, query only or you have requirement of real time insert and update. The solutions can be different. You might need consider HBase, Cassandra or tools like Flume.