Support Questions
Find answers, ask questions, and share your expertise
Announcements
Check out our newest addition to the community, the Cloudera Innovation Accelerator group hub.

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

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