You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@sqoop.apache.org by "Veena Basavaraj (JIRA)" <ji...@apache.org> on 2014/11/24 22:05:15 UTC
[jira] [Assigned] (SQOOP-1796) Support Incremental Semantics in
command line tool for Job
[ https://issues.apache.org/jira/browse/SQOOP-1796?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Veena Basavaraj reassigned SQOOP-1796:
--------------------------------------
Assignee: Veena Basavaraj
> Support Incremental Semantics in command line tool for Job
> ----------------------------------------------------------
>
> Key: SQOOP-1796
> URL: https://issues.apache.org/jira/browse/SQOOP-1796
> Project: Sqoop
> Issue Type: Sub-task
> Reporter: Veena Basavaraj
> Assignee: Veena Basavaraj
> Fix For: 1.99.5
>
>
> WIP ( so do not consider this as a final design)
> This task will support the Incremental semantics to provide in the command line tool. In sqoop 1 here is the semantics, using the --incremental and the corresponding fields that specify the column and value. The > is somehow not configurable. This can be easily made configurable using predicates that specify the column/ value and the operator in one shot.
> {code}
> sqoop import \
> --connect jdbc:mysql://mysql.example.com/sqoop \
> --username sqoop \
> --password sqoop \
> --table visits \
> --incremental append \
> --check-column id \
> --last-value 1
> {code}
> In Sqoop 2: When we create a job, we are asked for ( wrt to the connectors)
> FromJobConfigValues
> ToJobConfigValues
> Should the incremental be more generically a delta import, so this predicate can me more more generic, such as values in between 'A' and 'B' or values < 20. Its just going to provide flexibility and avoid having 2 fields, incremental, check-column and value. It can all be encapsulated in one field predicate.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)