https://community.cloudera.com/t5/Archives-of-Support-Questions/Why-Sqoop-will-not-allow-us-to-create-an-external-table/m-p/165240#M53744 <P>Just curious to find.....</P><P>Why Sqoop will not allow us to create an external table while sqooping the data from RDBMS ?</P> Wed, 08 Feb 2017 14:04:58 GMT PentaReddy 2017-02-08T14:04:58Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Why-Sqoop-will-not-allow-us-to-create-an-external-table/m-p/165240#M53744 <P>Just curious to find.....</P><P>Why Sqoop will not allow us to create an external table while sqooping the data from RDBMS ?</P> Wed, 08 Feb 2017 14:04:58 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Why-Sqoop-will-not-allow-us-to-create-an-external-table/m-p/165240#M53744 PentaReddy 2017-02-08T14:04:58Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Why-Sqoop-will-not-allow-us-to-create-an-external-table/m-p/165241#M53745 <P>it is possible, I see people sqoop into manged table then alter table to be external, sqoop continues to work</P><P><A href="http://stackoverflow.com/questions/27991258/how-to-create-external-table-in-hive-using-sqoop-need-suggestions#29602510" target="_blank">http://stackoverflow.com/questions/27991258/how-to-create-external-table-in-hive-using-sqoop-need-suggestions#29602510</A></P><P>Another option is to manually create table in hive as external and sqoop reference to that table, see section on incremental_table <A href="http://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.3.0/bk_dataintegration/content/incrementally-updating-hive-table-with-sqoop-and-ext-table.html" target="_blank">http://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.3.0/bk_dataintegration/content/incrementally-updating-hive-table-with-sqoop-and-ext-table.html</A></P><P>For sqoop to create an external table outright, you might want to open an enhancement jira</P> Wed, 08 Feb 2017 20:14:23 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Why-Sqoop-will-not-allow-us-to-create-an-external-table/m-p/165241#M53745 aervits 2017-02-08T20:14:23Z