You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@sqoop.apache.org by Syed Akram <ak...@zohocorp.com> on 2015/02/09 08:02:33 UTC

Sqoop1 create-hive-table Exception

Hi,

Basically. iam loading data from mysql to hive into 3 steps.


1.import mysql data to hdfs using sqoop2.
2.create table schema using sqoop1 import -create-hive-table option
3. load data inpath 'hdfs path' into table 'hive table'


but, iam getting below exception when creating hive table schema using sqoop1


java.lang.SecurityException: Cannot replace security manager
 at org.apache.sqoop.util.SubprocessSecurityManager.checkPermission(SubprocessSecurityManager.java:100)
 at java.lang.System.setSecurityManager0(System.java:297)
 at java.lang.System.setSecurityManager(System.java:288)
 at org.apache.sqoop.util.SubprocessSecurityManager.install(SubprocessSecurityManager.java:61)
 at org.apache.sqoop.hive.HiveImport.executeScript(HiveImport.java:320)
 at org.apache.sqoop.hive.HiveImport.importTable(HiveImport.java:239)
 at org.apache.sqoop.tool.CreateHiveTableTool.run(CreateHiveTableTool.java:58)
 at org.apache.sqoop.Sqoop.run(Sqoop.java:143)
 at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70)
 at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:179)
 at org.apache.sqoop.Sqoop.runTool(Sqoop.java:218)
 at org.apache.sqoop.Sqoop.runTool(Sqoop.java:227)





Please suggest me, if any other solution.


Thanks in advance

Re: Sqoop1 create-hive-table Exception

Posted by Abraham Elmahrek <ab...@cloudera.com>.
It seems like you are running Sqoop from a Java program and not the CLI. I
wouldn't do this more than once. Sqoop does a few Security Manager
operations that may cause problems in the future.

-Abe

On Sun, Feb 8, 2015 at 11:02 PM, Syed Akram <ak...@zohocorp.com>
wrote:

>
> Hi,
>
> Basically. iam loading data from mysql to hive into 3 steps.
>
> 1.import mysql data to hdfs using sqoop2.
> 2.create table schema using sqoop1 import -create-hive-table option
> 3. load data inpath 'hdfs path' into table 'hive table'
>
> but, iam getting below exception when creating hive table schema using
> sqoop1
>
> java.lang.SecurityException: Cannot replace security manager
> at
> org.apache.sqoop.util.SubprocessSecurityManager.checkPermission(SubprocessSecurityManager.java:100)
> at java.lang.System.setSecurityManager0(System.java:297)
> at java.lang.System.setSecurityManager(System.java:288)
> at
> org.apache.sqoop.util.SubprocessSecurityManager.install(SubprocessSecurityManager.java:61)
> at org.apache.sqoop.hive.HiveImport.executeScript(HiveImport.java:320)
> at org.apache.sqoop.hive.HiveImport.importTable(HiveImport.java:239)
> at
> org.apache.sqoop.tool.CreateHiveTableTool.run(CreateHiveTableTool.java:58)
> at org.apache.sqoop.Sqoop.run(Sqoop.java:143)
> at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70)
> at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:179)
> at org.apache.sqoop.Sqoop.runTool(Sqoop.java:218)
> at org.apache.sqoop.Sqoop.runTool(Sqoop.java:227)
>
>
> Please suggest me, if any other solution.
>
> Thanks in advance
>