Return-Path: X-Original-To: apmail-hadoop-mapreduce-user-archive@minotaur.apache.org Delivered-To: apmail-hadoop-mapreduce-user-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id EEE9717E70 for ; Mon, 23 Feb 2015 11:09:54 +0000 (UTC) Received: (qmail 59389 invoked by uid 500); 23 Feb 2015 11:09:28 -0000 Delivered-To: apmail-hadoop-mapreduce-user-archive@hadoop.apache.org Received: (qmail 59267 invoked by uid 500); 23 Feb 2015 11:09:28 -0000 Mailing-List: contact user-help@hadoop.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hadoop.apache.org Delivered-To: mailing list user@hadoop.apache.org Received: (qmail 59257 invoked by uid 99); 23 Feb 2015 11:09:27 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 23 Feb 2015 11:09:27 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of wget.null@gmail.com designates 74.125.82.54 as permitted sender) Received: from [74.125.82.54] (HELO mail-wg0-f54.google.com) (74.125.82.54) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 23 Feb 2015 11:09:22 +0000 Received: by mail-wg0-f54.google.com with SMTP id y19so24762141wgg.13 for ; Mon, 23 Feb 2015 03:07:31 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=from:content-type:message-id:mime-version:subject:date:references :to:in-reply-to; bh=lFl/7xZLJqVBWY/U46pzrGn4jb996yns8wd7u0WFUSQ=; b=Epcn/XjIPrl5poWlQLaWSTrbDDHKOtGStRv3MauNgt5mmgAMGQGRHipz6/TaLDdqGN 9Eb1l1+Qo/QpVRUqjkJvqySElqKJ3uvFOndTbgbXsNt2GvW0PQv+vq1my0vLgD872bXG YVyT25OfRvgw14viN0JTdHpVNzjgyyRVZRqyQqvrEs6ZrNt4BP8kIgAZcVGofpJRC+3S wfnHwn+4eJkO1VO3gdKBnOjNo+9lAe5s+JKBnSLe4vSyleMRBus0wy3rQOIpQNVG2BHx sjmXYyHAMo191rwyA/ljwE3NbBmm96q7XlVqqWJvakHPOVS2RZk3tpUfrbUShS5XKIB2 lvlQ== X-Received: by 10.194.118.198 with SMTP id ko6mr20365719wjb.47.1424689651867; Mon, 23 Feb 2015 03:07:31 -0800 (PST) Received: from [192.168.178.39] (HSI-KBW-091-089-101-042.hsi2.kabelbw.de. [91.89.101.42]) by mx.google.com with ESMTPSA id fo17sm55073900wjc.19.2015.02.23.03.07.30 for (version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128); Mon, 23 Feb 2015 03:07:30 -0800 (PST) From: Alexander Alten-Lorenz Content-Type: multipart/alternative; boundary="Apple-Mail=_86EB966C-AE07-45BB-8A69-CAC9314D63F4" Message-Id: <38561E92-E036-415B-9DC1-191CBDBDCE46@gmail.com> Mime-Version: 1.0 (Mac OS X Mail 8.2 \(2070.6\)) Subject: Re: mssql bulk copy dat files Date: Mon, 23 Feb 2015 12:07:29 +0100 References: To: user@hadoop.apache.org In-Reply-To: X-Mailer: Apple Mail (2.2070.6) X-Virus-Checked: Checked by ClamAV on apache.org --Apple-Mail=_86EB966C-AE07-45BB-8A69-CAC9314D63F4 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii Not per default. But you can use sqoop to offload the DBs into = something-delimited text. http://mapredit.blogspot.de/2011/10/sqoop-and-microsoft-sql-server.html = http://www.microsoft.com/en-us/download/details.aspx?id=3D27584 = > On 23 Feb 2015, at 12:01, Jonathan Aquilina = wrote: >=20 > Can hadoop process dat files that are generated by MS SQL bulk copy? >=20 > =20 > --=20 > Regards, > Jonathan Aquilina > Founder Eagle Eye T --Apple-Mail=_86EB966C-AE07-45BB-8A69-CAC9314D63F4 Content-Transfer-Encoding: 7bit Content-Type: text/html; charset=us-ascii
Not per default. But you can use sqoop to offload the DBs into something-delimited text.



On 23 Feb 2015, at 12:01, Jonathan Aquilina <jaquilina@eagleeyet.net> wrote:

Can hadoop process dat files that are generated by MS SQL bulk copy?

 
-- 
Regards, Jonathan Aquilina Founder Eagle Eye T

--Apple-Mail=_86EB966C-AE07-45BB-8A69-CAC9314D63F4--