You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@sqoop.apache.org by soham sardar <so...@gmail.com> on 2012/06/08 10:02:15 UTC
sqoop import problem with hive
*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??????????*
Re: sqoop import problem with hive
Posted by Bejoy KS <be...@gmail.com>.
You gotta fix hive issue first. What is the error you get when trying to create tables and load data on to them?
Regards
Bejoy KS
Sent from handheld, please excuse typos.
-----Original Message-----
From: soham sardar <so...@gmail.com>
Date: Fri, 8 Jun 2012 14:00:05
To: <us...@sqoop.apache.org>; <be...@gmail.com>
Subject: Re: sqoop import problem with hive
yes bejoy i am deleting the output dir everytime i m importing the same
table and yea my hive has some issue but i dint know what i would be
greatful if someone could get me out of this .. and m not able to create
any sample table in hive ...
On Fri, Jun 8, 2012 at 1:44 PM, Bejoy KS <be...@gmail.com> wrote:
> **
> Soham
>
> Can you send the log with --verbose enabled.
>
> It looks like your hive is having some issue. Are you able to create
> sample tables and load data into from hive CLI?
>
> Once the import is done the output dir will be created. So when you try
> the second time you need to delete that dir in hdfs.
>
>
> Regards
> Bejoy KS
>
> Sent from handheld, please excuse typos.
> ------------------------------
> *From: * soham sardar <so...@gmail.com>
> *Date: *Fri, 8 Jun 2012 13:32:15 +0530
> *To: *user<us...@sqoop.apache.org>
> *ReplyTo: * user@sqoop.apache.org
> *Subject: *sqoop import problem with hive
>
> *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??????????*
>
Re: sqoop import problem with hive
Posted by soham sardar <so...@gmail.com>.
yes bejoy i am deleting the output dir everytime i m importing the same
table and yea my hive has some issue but i dint know what i would be
greatful if someone could get me out of this .. and m not able to create
any sample table in hive ...
On Fri, Jun 8, 2012 at 1:44 PM, Bejoy KS <be...@gmail.com> wrote:
> **
> Soham
>
> Can you send the log with --verbose enabled.
>
> It looks like your hive is having some issue. Are you able to create
> sample tables and load data into from hive CLI?
>
> Once the import is done the output dir will be created. So when you try
> the second time you need to delete that dir in hdfs.
>
>
> Regards
> Bejoy KS
>
> Sent from handheld, please excuse typos.
> ------------------------------
> *From: * soham sardar <so...@gmail.com>
> *Date: *Fri, 8 Jun 2012 13:32:15 +0530
> *To: *user<us...@sqoop.apache.org>
> *ReplyTo: * user@sqoop.apache.org
> *Subject: *sqoop import problem with hive
>
> *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??????????*
>
Re: sqoop import problem with hive
Posted by Bejoy KS <be...@gmail.com>.
Soham
Can you send the log with --verbose enabled.
It looks like your hive is having some issue. Are you able to create sample tables and load data into from hive CLI?
Once the import is done the output dir will be created. So when you try the second time you need to delete that dir in hdfs.
Regards
Bejoy KS
Sent from handheld, please excuse typos.
-----Original Message-----
From: soham sardar <so...@gmail.com>
Date: Fri, 8 Jun 2012 13:32:15
To: user<us...@sqoop.apache.org>
Reply-To: user@sqoop.apache.org
Subject: sqoop import problem with hive
*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??????????*