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 <[email protected]> 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 >
