[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 4/14/17 2:52 PM:
-----------------------------------------------------------

Added --external-table-dir option, its presence will cause external table to be created.
--external-table-dir - external table HDFS location

Patch updated for latest trunk codebase.

Review at https://reviews.apache.org/r/51912/



was (Author: chris.teoh@gmail.com):
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

> 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.15#6346)