From mapreduce-issues-return-1552-apmail-hadoop-mapreduce-issues-archive=hadoop.apache.org@hadoop.apache.org Tue Aug 04 20:54:34 2009 Return-Path: Delivered-To: apmail-hadoop-mapreduce-issues-archive@minotaur.apache.org Received: (qmail 56728 invoked from network); 4 Aug 2009 20:54:34 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 4 Aug 2009 20:54:34 -0000 Received: (qmail 732 invoked by uid 500); 4 Aug 2009 20:54:39 -0000 Delivered-To: apmail-hadoop-mapreduce-issues-archive@hadoop.apache.org Received: (qmail 701 invoked by uid 500); 4 Aug 2009 20:54:39 -0000 Mailing-List: contact mapreduce-issues-help@hadoop.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: mapreduce-issues@hadoop.apache.org Delivered-To: mailing list mapreduce-issues@hadoop.apache.org Received: (qmail 691 invoked by uid 99); 4 Aug 2009 20:54:39 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 04 Aug 2009 20:54:38 +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; Tue, 04 Aug 2009 20:54:35 +0000 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id E4F8729A0017 for ; Tue, 4 Aug 2009 13:54:14 -0700 (PDT) Message-ID: <1370067725.1249419254937.JavaMail.jira@brutus> Date: Tue, 4 Aug 2009 13:54:14 -0700 (PDT) From: "Omer Trajman (JIRA)" To: mapreduce-issues@hadoop.apache.org Subject: [jira] Updated: (MAPREDUCE-775) Add input/output formatters for Vertica clustered ADBMS. In-Reply-To: <937583026.1248132914890.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/MAPREDUCE-775?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Omer Trajman updated MAPREDUCE-775: ----------------------------------- Attachment: (was: MAPREDUCE-775.patch) > Add input/output formatters for Vertica clustered ADBMS. > -------------------------------------------------------- > > Key: MAPREDUCE-775 > URL: https://issues.apache.org/jira/browse/MAPREDUCE-775 > Project: Hadoop Map/Reduce > Issue Type: New Feature > Reporter: Omer Trajman > Fix For: 0.21.0 > > Attachments: MAPREDUCE-775.patch > > > Add native support for Vertica as an input or output format taking advantage of parallel read and write properties of the DBMS. > > On the input side allow for parametrized queries (a la prepared statements) and create a split for each combination of parameters. Also support the parameter list to be generated from a sql statement. For example - return metrics for all dimensions that meet criteria X with one input split for each dimension. Divide the read among any number of hosts in the Vertica cluster. > > On the output side, support Vertica streaming load to any number of hosts in the Vertica cluster. Output may be to a different cluster than input. > > Also includes Input and Output formatters that support streaming interface. > Code has been tested and run on live systems under 19 and 20. Patch for 21 with new API will be ready end of this week. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.