[
https://issues.apache.org/jira/browse/SQOOP-816?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13563851#comment-13563851
]
Vidhya Parvathy R commented on SQOOP-816:
------------------------------------------
Wouldn't it be much easier to sqoop directly to HDFS and execute "create
external table" query in hive.
Changing the managed tables to external would take up a lot of processing in
the background since the contend needs to be transferred to HDFS to make the
table external.
> 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
> Priority: Minor
> Labels: External, Hive,, Scoop,, Tables
>
> 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 is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
