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