Reply
Highlighted
Contributor
Posts: 48
Registered: ‎05-30-2015

sqoop2 splits mssql tables to few text files

Hi there,

 

I have 2 question for sqoop2:

 

1. I managed to import MS SQL version 8 to hdfs using sqoop2, but the table I imported is splitted to a few text files with long and meaningless filename. Is there anyway to make it to meaningful file name like file1.txt. file2.txt?

 

2. One of the content of the column was replace by 'net.sourceforge.jtds.jdbc.ClobImpl@6073d7f6' instead of the original content, I am not sure why, not sure if anyone here has the same issue.

 

Thanks!

Spoiler
 
Contributor
Posts: 48
Registered: ‎05-30-2015

Re: sqoop2 splits mssql tables to few text files

I managed to solve the second issue by using "useLOBs=false" in the connection string

 

jdbc:jtds:sqlserver://ServerName;useLOBs=false