Return-Path: 
 <core-dev-return-72147-apmail-hadoop-core-dev-archive=hadoop.apache.org@hadoop.apache.org>
Delivered-To: apmail-hadoop-core-dev-archive@www.apache.org
Received: (qmail 18006 invoked from network); 29 Jun 2009 06:53:01 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3)
  by minotaur.apache.org with SMTP; 29 Jun 2009 06:53:01 -0000
Received: (qmail 57211 invoked by uid 500); 29 Jun 2009 06:53:11 -0000
Delivered-To: apmail-hadoop-core-dev-archive@hadoop.apache.org
Received: (qmail 57150 invoked by uid 500); 29 Jun 2009 06:53:11 -0000
Mailing-List: contact core-dev-help@hadoop.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:core-dev-help@hadoop.apache.org>
List-Unsubscribe: <mailto:core-dev-unsubscribe@hadoop.apache.org>
List-Post: <mailto:core-dev@hadoop.apache.org>
List-Id: <core-dev.hadoop.apache.org>
Reply-To: core-dev@hadoop.apache.org
Delivered-To: mailing list core-dev@hadoop.apache.org
Received: (qmail 57140 invoked by uid 99); 29 Jun 2009 06:53:11 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 29 Jun 2009 06:53:11 +0000
X-ASF-Spam-Status: No, hits=-2000.0 required=10.0
	tests=ALL_TRUSTED
X-Spam-Check-By: apache.org
Received: from [140.211.11.140] (HELO brutus.apache.org) (140.211.11.140)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 29 Jun 2009 06:53:08 +0000
Received: from brutus (localhost [127.0.0.1])
	by brutus.apache.org (Postfix) with ESMTP id A685A234C053
	for <core-dev@hadoop.apache.org>; Sun, 28 Jun 2009 23:52:47 -0700 (PDT)
Message-ID: <34680285.1246258367681.JavaMail.jira@brutus>
Date: Sun, 28 Jun 2009 23:52:47 -0700 (PDT)
From: "Kevin Weil (JIRA)" <jira@apache.org>
To: core-dev@hadoop.apache.org
Subject: [jira] Updated: (HADOOP-6115) Sqoop should allow a "where" clause
 to avoid having to export entire tables
In-Reply-To: <247895648.1246144967626.JavaMail.jira@brutus>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394
X-Virus-Checked: Checked by ClamAV on apache.org


     [ https://issues.apache.org/jira/browse/HADOOP-6115?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kevin Weil updated HADOOP-6115:
-------------------------------

    Attachment: HADOOP-6115.patch

This patch adds the ability to specify a "where" clause to sqoop, in the form

<normal sqoop command> --where "my_row > 0 and my_text like '%sqoop%'"

It also works with sqoop's mysql-specific --local flag, using mysqldump's -w flag.  

> Sqoop should allow a "where" clause to avoid having to export entire tables
> ---------------------------------------------------------------------------
>
>                 Key: HADOOP-6115
>                 URL: https://issues.apache.org/jira/browse/HADOOP-6115
>             Project: Hadoop Common
>          Issue Type: Improvement
>          Components: contrib/sqoop
>    Affects Versions: 0.21.0
>            Reporter: Kevin Weil
>            Priority: Minor
>         Attachments: HADOOP-6115.patch
>
>
> Sqoop currently only exports at the granularity of a table.  This doesn't work well on systems with large tables, where the overhead of performing a full dump each time is significant.  Allowing the user to specify a where clause is a relatively simple task which will give Sqoop a lot more flexibility.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.