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 >> import from Oracle to Hive : 2 errors


Copy link to this message
-
Re: import from Oracle to Hive : 2 errors
Hi Jerome,
there are many ways how to achieve that. Considering that you are doing table based import, you can take advantage of --where parameter to specify any arbitrary condition to choose the proper 1000 rows. Another option would be use query based import instead of table, where you can specify entire query that should be imported.

Jarcec

On Mon, Jun 17, 2013 at 05:59:45PM +0200, Jérôme Verdier wrote:
> I have the solution to my problem.
>
> I resolved it by using the option --hive-table default.VENTES_EAN in my
> sqoop script.
>
> But, i have another question :
>
> i want to import from oracle to hive only 1000 rows from my table, how we
> can do this using sqoop ?
>
> Thanks.
>
> --
> Jérôme
>
>
> 2013/6/17 Jérôme Verdier <[EMAIL PROTECTED]>
>
> > Hi Jarcec,
> >
> > Thanks for your answer, you're always very helpful =)
> >
> > i think that my Hive installation is OK, i can connect to hive server
> > through my laptop using JDBC and Squirrel SQL.
> >
> > Here are the hive logs :
> >
> > 2013-06-17 17:16:40,452 WARN  conf.HiveConf (HiveConf.java:<clinit>(75)) -
> > hive-site.xml not found on CLASSPATH
> > 2013-06-17 17:20:51,228 WARN  conf.HiveConf (HiveConf.java:<clinit>(75)) -
> > hive-site.xml not found on CLASSPATH
> > 2013-06-17 17:20:53,296 ERROR DataNucleus.Plugin
> > (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
> > "org.eclipse.core.resources" but it cannot be resolved.
> > 2013-06-17 17:20:53,296 ERROR DataNucleus.Plugin
> > (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
> > "org.eclipse.core.resources" but it cannot be resolved.
> > 2013-06-17 17:20:53,297 ERROR DataNucleus.Plugin
> > (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
> > "org.eclipse.core.runtime" but it cannot be resolved.
> > 2013-06-17 17:20:53,297 ERROR DataNucleus.Plugin
> > (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
> > "org.eclipse.core.runtime" but it cannot be resolved.
> > 2013-06-17 17:20:53,297 ERROR DataNucleus.Plugin
> > (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
> > "org.eclipse.text" but it cannot be resolved.
> > 2013-06-17 17:20:53,297 ERROR DataNucleus.Plugin
> > (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
> > "org.eclipse.text" but it cannot be resolved.
> > 2013-06-17 17:20:58,645 ERROR exec.Task
> > (SessionState.java:printError(401)) - FAILED: Error in metadata:
> > InvalidObjectException(message:There is no database named themis)
> > org.apache.hadoop.hive.ql.metadata.HiveException:
> > InvalidObjectException(message:There is no database named themis)
> >     at org.apache.hadoop.hive.ql.metadata.Hive.createTable(Hive.java:576)
> >     at
> > org.apache.hadoop.hive.ql.exec.DDLTask.createTable(DDLTask.java:3698)
> >     at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:253)
> >     at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:138)
> >     at
> > org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:57)
> >     at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1336)
> >     at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1122)
> >     at org.apache.hadoop.hive.ql.Driver.run(Driver.java:935)
> >     at
> > org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:259)
> >     at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:216)
> >     at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:412)
> >     at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:347)
> >     at
> > org.apache.hadoop.hive.cli.CliDriver.processReader(CliDriver.java:445)
> >     at org.apache.hadoop.hive.cli.CliDriver.processFile(CliDriver.java:455)
> >     at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:711)
> >     at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:613)
> >     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> >     at
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