Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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:
 
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB