you need to set output directory in your job FileInputFormat.addInputPath(job, new Path(otherArgs.get(0))); FileOutputFormat.setOutputPath(job, new Path(otherArgs.get(1))); ... View more

I should've clarified which jira, I was suggesting to file a jira with Apache @Bidyut B. ... View more

here's a scenario that works on Sandbox # Create Hive table drop table if exists export_table; create table export_table ( key int, value string ) row format delimited fields terminated by ","; # populate Hive with dummy data insert into export_table values("1", "ExportedValue"); # confirm Hive table has data select * from export_table; # display the values in hive as hdfs files hdfs dfs -cat /apps/hive/warehouse/export_table/000000_0 # export table to MySQL # MySQL table must exist su mysql mysql -u root create database export; use export; create table exported (rowkey int, value varchar(20)); exit; # on HDP 2.3.2 Sandbox, SQOOP-1400 bug, use --driver com.mysql.jdbc.Driver to overcome the problem # sqoop export from a Hive table into MySQL sqoop export --connect jdbc:mysql://127.0.0.1/export --username hive --password hive --table exported --direct --export-dir /apps/hive/warehouse/export_table --driver com.mysql.jdbc.Driver # login to Mysql and check the table su mysql mysql -u root use export; select * from exported; exit; ... View more

you typically wouldn't use sqoop to query Hive table. Login to mysql and list databases there. Once you know which db you'd like to import then you can use the command you'd used before. For exporting hive data, you'd use hive commands, pig scripts, hdfs commands, etc. ... View more

@Peter Coates I think it depends on staleness property of your hdfs-site configuration. If it takes a long time to reboot a server, namenode will mark the DN as stale. Take a look at this property, dfs.namenode.stale.datanode.interval. ... View more

@Mihai Morareanu glad it worked for you, please accept one of the valid answers to close out the thread. ... View more

@Revlin Abbi you're confusing your local filesystem with Sandbox filesystem. You can create a mysql database in Sandbox as it already comes with mysql server, you can create a db in postgres as well, Ambari db is one such database. Unless you specify host-guest networking so that guest can access the host's services, you won't be able to achieve what you're doing. It's a lot simpler to work with mysql that is inside Sandbox guest machine. ... View more

@Kuldeep Kulkarni you can also poke around in the ambari database for status installed but that's essentially the same as using API only much more intrusive. ... View more