Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Sqoop >> mail # user >> sqoop2 export to microsoft SQL server - supported jdbc connectors


Copy link to this message
-
Re: sqoop2 export to microsoft SQL server - supported jdbc connectors
Thanks Abe.

The export query that fails is
INSERT INTO TestTable ( SELECT * FROM StageTable )

MSSQL server does not support the paranthesis around the select.

This works -
INSERT INTO TestTable SELECT * FROM StageTable
Cheers,
Suhas.
On Wed, Jul 16, 2014 at 11:25 AM, Abraham Elmahrek <[EMAIL PROTECTED]> wrote: