Just curious to find.....
Why Sqoop will not allow us to create an external table while sqooping the data from RDBMS ?
it is possible, I see people sqoop into manged table then alter table to be external, sqoop continues to work
Another option is to manually create table in hive as external and sqoop reference to that table, see section on incremental_table http://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.3.0/bk_dataintegration/content/incrementally-upd...
For sqoop to create an external table outright, you might want to open an enhancement jira
View solution in original post