Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

sqoop2 splits mssql tables to few text files

sqoop2 splits mssql tables to few text files

Rising Star

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
 
1 REPLY 1

Re: sqoop2 splits mssql tables to few text files

Rising Star

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

 

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