Home | About | Sematext search-lucene.com search-hadoop.com
 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
Amit 2013-05-21, 12:59
Thanks a lot for your support.
On Tue, May 21, 2013 at 5:33 PM, Jarek Jarcec Cecho <[EMAIL PROTECTED]>wrote:

> You seems to be using local job runner (based on the external id
> "job_local") that do not supports retrieving status of submitted jobs. I
> would advise switching to real Hadoop cluster.
>
> Jarcec
>
> On Tue, May 21, 2013 at 05:27:18PM +0530, Amit wrote:
> > Thank You, now its worked. But I am getting job Status: UNKNOWN. Can you
> > please tell me whats wrong?
> >
> >
> > sqoop:000> submission status --jid 8
> > Submission details
> > Job id: 8
> > Status: UNKNOWN
> > Creation date: 2013-05-21 17:20:24 IST
> > Last update date: 2013-05-21 17:20:59 IST
> > External Id: job_local_0005
> >         http://localhost:8080/
> >
> >
> >
> > On Tue, May 21, 2013 at 5:05 PM, Jarek Jarcec Cecho <[EMAIL PROTECTED]
> >wrote:
> >
> > > Hi Amit,
> > > it seems that you've set extractors and loaders to 1, would you mind
> > > removing any values in both fields?
> > >
> > > Jarcec
> > >
> > > On Tue, May 21, 2013 at 04:54:16PM +0530, Amit wrote:
> > > > sqoop:000> show job --jid 8
> > > > 1 job(s) to show:
> > > > Job with id 8 and name First job (Created 5/6/13 3:10 PM, Updated
> 5/6/13
> > > > 8:21 PM)
> > > > Using Connection id 5 and Connector id 1
> > > >   Database configuration
> > > >     Schema name:
> > > >     Table name: business_entities
> > > >     Table SQL statement:
> > > >     Table column names: Company
> > > >     Partition column name: ID
> > > >     Boundary query:
> > > >   Output configuration
> > > >     Storage type: HDFS
> > > >     Output format: TEXT_FILE
> > > >     Output directory: /landscape/MySQL
> > > >   Throttling resources
> > > >     Extractors: 1
> > > >     Loaders: 1
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > On Tue, May 21, 2013 at 3:17 PM, Jarek Jarcec Cecho <
> [EMAIL PROTECTED]
> > > >wrote:
> > > >
> > > > > Hi sir,
> > > > > would you mind sharing output of the "show job" command and the
> > > mapreduce
> > > > > job configuration XML file?
> > > > >
> > > > > Jarcec
> > > > >
> > > > > On Tue, May 14, 2013 at 01:01:52PM +0530, Amit wrote:
> > > > > > 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
> > > > > > > >
> > > > > > >
> > > > >
> > >