[ https://issues.apache.org/jira/browse/SQOOP-816?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15494656#comment-15494656 ]
Chris Teoh edited comment on SQOOP-816 at 9/16/16 10:54 AM: ------------------------------------------------------------ Added --as-external-table option when using --hive-import option, --target-dir option and --table-location option. --as-external-table - makes the destination table external table --table-location - external table HDFS location was (Author: chris.t...@gmail.com): Added --as-external-table option when using --hive-import option and --target-dir option > Scoop and support for external Hive tables > ------------------------------------------ > > Key: SQOOP-816 > URL: https://issues.apache.org/jira/browse/SQOOP-816 > Project: Sqoop > Issue Type: Improvement > Components: hive-integration > Reporter: Santosh Achhra > Assignee: Chris Teoh > Priority: Minor > Labels: External, Hive,, Scoop,, Tables, newbie > > Sqoop is not supporting HIVE external tables at the moment. Any imports using > scoop creates a managed table, in real world scenario it is very important to > have EXTERNAL tables. As of now we have to execute ALTER statement to change > table properties to make the the table as external table which is not a big > deal but it would nice have an option in scoop to specify type of table which > is required -- This message was sent by Atlassian JIRA (v6.3.4#6332)