Support Questions
Find answers, ask questions, and share your expertise

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

Rising Star

Just curious to find.....

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

1 ACCEPTED SOLUTION

Accepted Solutions

Mentor

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

View solution in original post

1 REPLY 1

Mentor

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

View solution in original post