@Javert Kirilov When a table is dropped, the data in case of managed tables gets cleaned up. However for an external table only the metadata of the table is cleared and the data still persists as it is in its place. Could you please confirm if you are using managed or external table? ... View more

@PJ All the hive queries are executed using the queue specified by "tez.queue.name" property. You should try using -Dtez.queue.name=A argument in sqoop import job. ... View more

@Mohammed Syam You can check the host on which hiveserver2 is running by going to Ambari UI and clicking on HiverServer2 under Hive service section. Login to the host and run the script. You can confirm if hive is running by using the command 'which hive' as mentioned above before running the script. ... View more

@Chaitanya D Can you try adding the option --bindir to your sqoop command. --bindir <path to sqoop home>/lib e.g. /usr/lib/sqoop/sqoop-1.4.6/lib/ ... View more

@Andrew Duncan Can you try running the sqoop job by placing all options related to incremental append before --connect option. Something like this - sqoop job --create myjob -- import --append ---check-column <column> --incremental append --last-value -9999999 --connect "jdbc:sqlserver://<server>;database=<database>" -username <databaseUser> --password <databasePassword> --table <table> --target-dir "<someDataDirectory>" --hive-import --hive-database <hiveDatabase>--autoreset-to-one-mapper --hive-delims-replacement " " --outdir <outputdir> --bindir <bindir> -- -- --schema <databaseSchema> Do let me know if it works. ... View more