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 >> Sqoop2 : The type is not supported - BigDecimal


Copy link to this message
-
Re: Sqoop2 : The type is not supported - BigDecimal
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
>
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