[jira] [Comment Edited] (SQOOP-816) Scoop and support for external Hive tables

["Chris Teoh (JIRA)" <ji...@apache.org>]

    [ 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.teoh@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)