Why Sqoop will not allow us to create an external table while sqooping the data from RDBMS ?

[#1]

Just curious to find.....

Why Sqoop will not allow us to create an external table while sqooping the data from RDBMS ?

[#2 · Accepted solution]

it is possible, I see people sqoop into manged table then alter table to be external, sqoop continues to work

http://stackoverflow.com/questions/27991258/how-to-create-external-table-in-hive-using-sqoop-need-su...

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