Sqoop2 create table schema option?

[Syed Akram <ak...@zohocorp.com>]

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