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

Switch to Threaded View
Sqoop >> mail # user >> Error while sqoop-export


Copy link to this message
-
Re: Error while sqoop-export
Hi Bhavesh
       In your sqoop export can you specify the field delimiter  as well
and try out
--input-fields-terminated-by ','
On Thu, Mar 29, 2012 at 5:07 PM, Bhavesh Shah <[EMAIL PROTECTED]>wrote:

> Hello,
>
> I have the table in Hive which has field delimiter as "," and I want to
> export it in SQL Server. I have also created the same table in SQL Server.
> But I am getting error.
> What is happening wrong with me.
> Pls help me.
> Error is as below:
>
> hadoop@ubuntu:~/sqoop-1.3.0-cdh3u1/bin$ ./sqoop-export --connect
> 'jdbc:sqlserver://192.168.1.1 <http://192.168.105.60>;username=abcd;password=12345;database=HadoopTest'
> --table tmptempmeasurereport --export-dir
> /user/hive/warehouse/tmptempmeasurereport
>
> 12/03/29 16:20:21 INFO SqlServer.MSSQLServerManagerFactory: Using
> Microsoft's SQL Server - Hadoop Connector
> 12/03/29 16:20:21 INFO manager.SqlManager: Using default fetchSize of 1000
> 12/03/29 16:20:21 INFO tool.CodeGenTool: Beginning code generation
> 12/03/29 16:20:21 INFO manager.SqlManager: Executing SQL statement: SELECT
> TOP 1 * FROM [tmptempmeasurereport]
> 12/03/29 16:20:21 INFO manager.SqlManager: Executing SQL statement: SELECT
> TOP 1 * FROM [tmptempmeasurereport]
> 12/03/29 16:20:21 INFO orm.CompilationManager: HADOOP_HOME is
> /home/hadoop/hadoop-0.20.2-cdh3u2
> 12/03/29 16:20:22 INFO orm.CompilationManager: Writing jar file:
> /tmp/sqoop-hadoop/compile/1c5aae88cd7daca66aa665d4bab5b470/tmptempmeasurereport.jar
> 12/03/29 16:20:22 INFO mapreduce.ExportJobBase: Beginning export of
> tmptempmeasurereport
> 12/03/29 16:20:22 INFO manager.SqlManager: Executing SQL statement: SELECT
> TOP 1 * FROM [tmptempmeasurereport]
> 12/03/29 16:20:22 WARN mapreduce.ExportJobBase: IOException checking
> SequenceFile header: java.io.EOFException
> 12/03/29 16:20:23 INFO input.FileInputFormat: Total input paths to process
> : 2
> 12/03/29 16:20:23 INFO input.FileInputFormat: Total input paths to process
> : 2
> 12/03/29 16:20:23 INFO mapred.JobClient: Running job: job_201203291108_0645
> 12/03/29 16:20:24 INFO mapred.JobClient:  map 0% reduce 0%
> 12/03/29 16:20:29 INFO mapred.JobClient: Task Id :
> attempt_201203291108_0645_m_000000_0, Status : FAILED
> java.util.NoSuchElementException
>     at java.util.AbstractList$Itr.next(AbstractList.java:350)
>     at tmptempmeasurereport.__loadFromFields(tmptempmeasurereport.java:383)
>     at tmptempmeasurereport.parse(tmptempmeasurereport.java:332)
>     at
> com.cloudera.sqoop.mapreduce.TextExportMapper.map(TextExportMapper.java:79)
>     at
> com.cloudera.sqoop.mapreduce.TextExportMapper.map(TextExportMapper.java:38)
>     at org.apache.hadoop.mapreduce.Mapper.run(Mapper.java:144)
>     at
> com.cloudera.sqoop.mapreduce.AutoProgressMapper.run(AutoProgressMapper.java:187)
>     at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:647)
>     at org.apache.hadoop.mapred.MapTask.run(MapTask.java:323)
>     at org.apache.hadoop.mapred.Child$4.run(Child.java:270)
>     at java.security.AccessController.doPrivileged(Native Method)
>     at javax.security.auth.Subject.doAs(Subject.java:396)
>     at
> org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1127)
>     at org.apache.hadoop.mapred.Child.main(Child.java:264)
>
> 12/03/29 16:20:34 INFO mapred.JobClient: Task Id :
> attempt_201203291108_0645_m_000000_1, Status : FAILED
> java.util.NoSuchElementException
>     at java.util.AbstractList$Itr.next(AbstractList.java:350)
>     at tmptempmeasurereport.__loadFromFields(tmptempmeasurereport.java:383)
>     at tmptempmeasurereport.parse(tmptempmeasurereport.java:332)
>     at
> com.cloudera.sqoop.mapreduce.TextExportMapper.map(TextExportMapper.java:79)
>     at
> com.cloudera.sqoop.mapreduce.TextExportMapper.map(TextExportMapper.java:38)
>     at org.apache.hadoop.mapreduce.Mapper.run(Mapper.java:144)
>     at
> com.cloudera.sqoop.mapreduce.AutoProgressMapper.run(AutoProgressMapper.java:187)
>     at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:647)
Regards
       Bejoy