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

Switch to Plain View
Sqoop, mail # user - Sqoop2 : The type is not supported - BigDecimal


+
Amit 2013-05-06, 10:01
+
Jarek Jarcec Cecho 2013-05-13, 17:11
Copy link to this message
-
Re: Sqoop2 : The type is not supported - BigDecimal
Amit 2013-05-14, 07:31
None, I am using default extractors and loaders.

--
Thanks,
Amit
On Mon, May 13, 2013 at 10:41 PM, Jarek Jarcec Cecho <[EMAIL PROTECTED]>wrote:

> Hi Amit,
> how many extractors and loaders do you have configured in this job?
>
> Jarcec
>
> On Mon, May 06, 2013 at 03:31:43PM +0530, Amit wrote:
> > Hi,
> >
> > I am not able to import MySQL tables containing decimal datatype. Am I
> > doing anything wrong? Here is the sqoop log file -
> >
> > java.lang.Exception: org.apache.sqoop.common.SqoopException:
> > MAPRED_EXEC_0017:Error occurs during extractor run
> > at
> org.apache.hadoop.mapred.LocalJobRunner$Job.run(LocalJobRunner.java:400)
> > Caused by: org.apache.sqoop.common.SqoopException: MAPRED_EXEC_0017:Error
> > occurs during extractor run
> > at org.apache.sqoop.job.mr.SqoopMapper.run(SqoopMapper.java:94)
> >  at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:725)
> > at org.apache.hadoop.mapred.MapTask.run(MapTask.java:332)
> >  at
> >
> org.apache.hadoop.mapred.LocalJobRunner$Job$MapTaskRunnable.run(LocalJobRunner.java:232)
> >  at
> java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
> > at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
> >  at java.util.concurrent.FutureTask.run(FutureTask.java:166)
> > at
> >
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
> >  at
> >
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
> >  at java.lang.Thread.run(Thread.java:722)
> > Caused by: org.apache.sqoop.common.SqoopException:
> MAPRED_EXEC_0013:Cannot
> > write to the data writer
> >  at
> >
> org.apache.sqoop.job.mr.SqoopMapper$MapDataWriter.writeContent(SqoopMapper.java:142)
> >  at
> >
> org.apache.sqoop.job.mr.SqoopMapper$MapDataWriter.writeArrayRecord(SqoopMapper.java:124)
> > at
> >
> org.apache.sqoop.connector.jdbc.GenericJdbcImportExtractor.extract(GenericJdbcImportExtractor.java:60)
> >  at
> >
> org.apache.sqoop.connector.jdbc.GenericJdbcImportExtractor.extract(GenericJdbcImportExtractor.java:31)
> >  at org.apache.sqoop.job.mr.SqoopMapper.run(SqoopMapper.java:89)
> > ... 9 more
> > Caused by: java.io.IOException: org.apache.sqoop.common.SqoopException:
> > MAPRED_EXEC_0012:The type is not supported - java.math.BigDecimal
> >  at org.apache.sqoop.job.io.Data.writeArray(Data.java:309)
> > at org.apache.sqoop.job.io.Data.write(Data.java:171)
> >  at
> >
> org.apache.hadoop.io.serializer.WritableSerialization$WritableSerializer.serialize(WritableSerialization.java:100)
> >  at
> >
> org.apache.hadoop.io.serializer.WritableSerialization$WritableSerializer.serialize(WritableSerialization.java:84)
> >  at
> >
> org.apache.hadoop.mapred.MapTask$MapOutputBuffer.collect(MapTask.java:1075)
> >  at
> >
> org.apache.hadoop.mapred.MapTask$NewOutputCollector.write(MapTask.java:655)
> > at
> >
> org.apache.hadoop.mapreduce.task.TaskInputOutputContextImpl.write(TaskInputOutputContextImpl.java:89)
> >  at
> >
> org.apache.hadoop.mapreduce.lib.map.WrappedMapper$Context.write(WrappedMapper.java:112)
> >  at
> >
> org.apache.sqoop.job.mr.SqoopMapper$MapDataWriter.writeContent(SqoopMapper.java:140)
> > ... 13 more
> > Caused by: org.apache.sqoop.common.SqoopException: MAPRED_EXEC_0012:The
> > type is not supported - java.math.BigDecimal
> > ... 22 more
> >
> > --
> > Thanks,
> > Am
> > it
>
+
Jarek Jarcec Cecho 2013-05-21, 09:47
+
Amit 2013-05-21, 11:24
+
Jarek Jarcec Cecho 2013-05-21, 11:35
+
Amit 2013-05-21, 11:57
+
Jarek Jarcec Cecho 2013-05-21, 12:03
+
Amit 2013-05-21, 12:59