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


Copy link to this message
-
Re: hive error
Hi Soham,

Can you try doing a sqoop import while specifying your table as
database.table (i.e. with dot notation)?

Regards, Kathleen

On Wed, Jun 6, 2012 at 11:47 PM, soham sardar <[EMAIL PROTECTED]>wrote:

> *when i try to sqoop import into my hive the following error :
>
> sqoop import --connect jdbc:mysql://localhost:3306/hue  --table inters
> --direct-split-size 8  --hive-import --create-hive-table --username hues -P
>
> *
>
> ERROR tool.ImportTool: Encountered IOException running import job:
> java.io.IOException: Hive exited with status 9
>        at
> com.cloudera.sqoop.hive.HiveImport.executeExternalHiveScript(HiveImport.java:349)
>        at
> com.cloudera.sqoop.hive.HiveImport.executeScript(HiveImport.java:299)
>        at
> com.cloudera.sqoop.hive.HiveImport.importTable(HiveImport.java:241)
>        at
> com.cloudera.sqoop.tool.ImportTool.importTable(ImportTool.java:395)
>        at com.cloudera.sqoop.tool.ImportTool.run(ImportTool.java:456)
>        at com.cloudera.sqoop.Sqoop.run(Sqoop.java:146)
>        at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
>        at com.cloudera.sqoop.Sqoop.runSqoop(Sqoop.java:182)
>        at com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:221)
>        at com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:230)
>        at com.cloudera.sqoop.Sqoop.main(Sqoop.java:239) this is the error
> in import when i use --import-hive
>
>
>
> *and also when i try to import the same table twice it says directory
> already contains the name specified so how to tackle this
> situation??????????*
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