Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

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

avatar
Expert Contributor

Just curious to find.....

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

1 ACCEPTED SOLUTION

avatar
Master 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

avatar
Master 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