Re: sqoop1 create-hive-table for multiple tables Not working

[Syed Akram]

edit:            
String db = "dbname"; 
for (int i=0;i<tables.size();i++){
      String tableName = tables.get(i);
      String[] str = {"create-hive-table", "--connect", jdbc:mysql://myip:port, 
"--table", tableName,
                    "--hive-table", db+"."+tableName, "--fields-terminated-by", 
",",
                    "--username", "username", "--password", "password"};
      Sqoop.runTool(str);

} 




---- On Mon, 09 Feb 2015 18:26:21 +0530 Syed 
Akram<akram.ba...@zohocorp.com> wrote ---- 

Hi,


Iam trying to do sqoop create-hive-table for one db which have 600 tables, 
sequentially.
But only first table of that db, schema is created in hive, other tables 
schemas are not being created in hive. and no error message showing where iam 
going wrong.


below java code i'm using to do that




 
for (int i=0;i<tables.size();i++){
      String[] str = {"create-hive-table", "--connect", jdbc:mysql://myip:port, 
"--table", tableName,
                    "--hive-table", db+"."+tableName, "--fields-terminated-by", 
",",
                    "--username", "username", "--password", "password"};
      Sqoop.runTool(str);

}
Please tell me where iam going wrong




Thanks