You are viewing a plain text version of this content. The canonical link for it is here.
Posted to hdfs-user@hadoop.apache.org by Jonathan Aquilina <ja...@eagleeyet.net> on 2015/02/23 12:01:52 UTC
mssql bulk copy dat files
Can hadoop process dat files that are generated by MS SQL bulk copy?
--
Regards,
Jonathan Aquilina
Founder Eagle Eye T
Re: mssql bulk copy dat files
Posted by Jonathan Aquilina <ja...@eagleeyet.net>.
We are using sqlcmd at the moment I was just curious though as Bulk copy
can copy to files rows really quickly into and out of a db.
---
Regards,
Jonathan Aquilina
Founder Eagle Eye T
On 2015-02-23 12:07, Alexander Alten-Lorenz wrote:
> 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 [1]
> http://www.microsoft.com/en-us/download/details.aspx?id=27584 [2]
>
>> On 23 Feb 2015, at 12:01, Jonathan Aquilina <ja...@eagleeyet.net> wrote:
>>
>> Can hadoop process dat files that are generated by MS SQL bulk copy?
>>
>> --
>> Regards,
>> Jonathan Aquilina
>> Founder Eagle Eye T
Links:
------
[1]
http://mapredit.blogspot.de/2011/10/sqoop-and-microsoft-sql-server.html
[2] http://www.microsoft.com/en-us/download/details.aspx?id=27584
Re: mssql bulk copy dat files
Posted by Jonathan Aquilina <ja...@eagleeyet.net>.
We are using sqlcmd at the moment I was just curious though as Bulk copy
can copy to files rows really quickly into and out of a db.
---
Regards,
Jonathan Aquilina
Founder Eagle Eye T
On 2015-02-23 12:07, Alexander Alten-Lorenz wrote:
> 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 [1]
> http://www.microsoft.com/en-us/download/details.aspx?id=27584 [2]
>
>> On 23 Feb 2015, at 12:01, Jonathan Aquilina <ja...@eagleeyet.net> wrote:
>>
>> Can hadoop process dat files that are generated by MS SQL bulk copy?
>>
>> --
>> Regards,
>> Jonathan Aquilina
>> Founder Eagle Eye T
Links:
------
[1]
http://mapredit.blogspot.de/2011/10/sqoop-and-microsoft-sql-server.html
[2] http://www.microsoft.com/en-us/download/details.aspx?id=27584
Re: mssql bulk copy dat files
Posted by Jonathan Aquilina <ja...@eagleeyet.net>.
We are using sqlcmd at the moment I was just curious though as Bulk copy
can copy to files rows really quickly into and out of a db.
---
Regards,
Jonathan Aquilina
Founder Eagle Eye T
On 2015-02-23 12:07, Alexander Alten-Lorenz wrote:
> 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 [1]
> http://www.microsoft.com/en-us/download/details.aspx?id=27584 [2]
>
>> On 23 Feb 2015, at 12:01, Jonathan Aquilina <ja...@eagleeyet.net> wrote:
>>
>> Can hadoop process dat files that are generated by MS SQL bulk copy?
>>
>> --
>> Regards,
>> Jonathan Aquilina
>> Founder Eagle Eye T
Links:
------
[1]
http://mapredit.blogspot.de/2011/10/sqoop-and-microsoft-sql-server.html
[2] http://www.microsoft.com/en-us/download/details.aspx?id=27584
Re: mssql bulk copy dat files
Posted by Jonathan Aquilina <ja...@eagleeyet.net>.
We are using sqlcmd at the moment I was just curious though as Bulk copy
can copy to files rows really quickly into and out of a db.
---
Regards,
Jonathan Aquilina
Founder Eagle Eye T
On 2015-02-23 12:07, Alexander Alten-Lorenz wrote:
> 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 [1]
> http://www.microsoft.com/en-us/download/details.aspx?id=27584 [2]
>
>> On 23 Feb 2015, at 12:01, Jonathan Aquilina <ja...@eagleeyet.net> wrote:
>>
>> Can hadoop process dat files that are generated by MS SQL bulk copy?
>>
>> --
>> Regards,
>> Jonathan Aquilina
>> Founder Eagle Eye T
Links:
------
[1]
http://mapredit.blogspot.de/2011/10/sqoop-and-microsoft-sql-server.html
[2] http://www.microsoft.com/en-us/download/details.aspx?id=27584
Re: mssql bulk copy dat files
Posted by Alexander Alten-Lorenz <wg...@gmail.com>.
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://mapredit.blogspot.de/2011/10/sqoop-and-microsoft-sql-server.html>
http://www.microsoft.com/en-us/download/details.aspx?id=27584 <http://www.microsoft.com/en-us/download/details.aspx?id=27584>
> On 23 Feb 2015, at 12:01, Jonathan Aquilina <ja...@eagleeyet.net> wrote:
>
> Can hadoop process dat files that are generated by MS SQL bulk copy?
>
>
> --
> Regards,
> Jonathan Aquilina
> Founder Eagle Eye T
Re: mssql bulk copy dat files
Posted by Alexander Alten-Lorenz <wg...@gmail.com>.
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://mapredit.blogspot.de/2011/10/sqoop-and-microsoft-sql-server.html>
http://www.microsoft.com/en-us/download/details.aspx?id=27584 <http://www.microsoft.com/en-us/download/details.aspx?id=27584>
> On 23 Feb 2015, at 12:01, Jonathan Aquilina <ja...@eagleeyet.net> wrote:
>
> Can hadoop process dat files that are generated by MS SQL bulk copy?
>
>
> --
> Regards,
> Jonathan Aquilina
> Founder Eagle Eye T
Re: mssql bulk copy dat files
Posted by Alexander Alten-Lorenz <wg...@gmail.com>.
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://mapredit.blogspot.de/2011/10/sqoop-and-microsoft-sql-server.html>
http://www.microsoft.com/en-us/download/details.aspx?id=27584 <http://www.microsoft.com/en-us/download/details.aspx?id=27584>
> On 23 Feb 2015, at 12:01, Jonathan Aquilina <ja...@eagleeyet.net> wrote:
>
> Can hadoop process dat files that are generated by MS SQL bulk copy?
>
>
> --
> Regards,
> Jonathan Aquilina
> Founder Eagle Eye T
Re: mssql bulk copy dat files
Posted by Alexander Alten-Lorenz <wg...@gmail.com>.
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://mapredit.blogspot.de/2011/10/sqoop-and-microsoft-sql-server.html>
http://www.microsoft.com/en-us/download/details.aspx?id=27584 <http://www.microsoft.com/en-us/download/details.aspx?id=27584>
> On 23 Feb 2015, at 12:01, Jonathan Aquilina <ja...@eagleeyet.net> wrote:
>
> Can hadoop process dat files that are generated by MS SQL bulk copy?
>
>
> --
> Regards,
> Jonathan Aquilina
> Founder Eagle Eye T