[
https://issues.apache.org/jira/browse/SQOOP-1804?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14307528#comment-14307528
]
Hudson commented on SQOOP-1804:
-------------------------------
SUCCESS: Integrated in Sqoop2-hadoop200 #726 (See
[https://builds.apache.org/job/Sqoop2-hadoop200/726/])
SQOOP-1804: Add editable and override attribute to inputs (jarcec:
https://git-wip-us.apache.org/repos/asf?p=sqoop.git&a=commit&h=6fc50b08b0b4bc18305c829c4abc9bbcdbbd34b6)
*
repository/repository-derby/src/test/java/org/apache/sqoop/repository/derby/TestConnectorHandling.java
* common/src/main/java/org/apache/sqoop/model/MInput.java
* common/src/test/java/org/apache/sqoop/json/util/ConfigTestUtil.java
* common/src/main/java/org/apache/sqoop/model/MEnumInput.java
* common/src/test/java/org/apache/sqoop/model/TestMValidatedElement.java
*
repository/repository-common/src/main/java/org/apache/sqoop/repository/common/CommonRepositorySchemaConstants.java
* common/src/main/java/org/apache/sqoop/model/MBooleanInput.java
* common/src/test/java/org/apache/sqoop/json/util/TestConfigSerialization.java
*
repository/repository-derby/src/test/java/org/apache/sqoop/repository/derby/TestDriverHandling.java
* common/src/main/java/org/apache/sqoop/json/util/ConfigInputConstants.java
* common/src/main/java/org/apache/sqoop/model/MStringInput.java
* shell/src/main/java/org/apache/sqoop/shell/utils/ConfigDisplayer.java
* common/src/test/java/org/apache/sqoop/model/TestMNamedElement.java
* common/src/test/java/org/apache/sqoop/model/TestMConnector.java
*
repository/repository-derby/src/test/java/org/apache/sqoop/repository/derby/TestInputTypes.java
* common/src/test/java/org/apache/sqoop/model/TestMConfigList.java
* common/src/main/java/org/apache/sqoop/model/MIntegerInput.java
* shell/src/main/java/org/apache/sqoop/shell/utils/ConfigFiller.java
*
repository/repository-derby/src/main/java/org/apache/sqoop/repository/derby/DerbySchemaUpgradeQuery.java
* common/src/main/java/org/apache/sqoop/model/ModelError.java
*
repository/repository-postgresql/src/test/java/org/apache/sqoop/integration/repository/postgresql/PostgresqlTestCase.java
*
repository/repository-derby/src/main/java/org/apache/sqoop/repository/derby/DerbyRepositoryHandler.java
* common/src/test/java/org/apache/sqoop/model/TestMBooleanInput.java
* common/src/main/java/org/apache/sqoop/json/util/ConfigInputSerialization.java
* shell/src/main/java/org/apache/sqoop/shell/core/Constants.java
*
repository/repository-derby/src/test/java/org/apache/sqoop/repository/derby/DerbyTestCase.java
* core/src/test/java/org/apache/sqoop/driver/TestDriverConfigUpgrader.java
*
repository/repository-derby/src/main/java/org/apache/sqoop/repository/derby/DerbySchemaCreateQuery.java
* common/src/main/java/org/apache/sqoop/model/MConfig.java
*
connector/connector-generic-jdbc/src/test/java/org/apache/sqoop/connector/jdbc/TestGenericJdbcConnectorUpgrader.java
* common/src/main/java/org/apache/sqoop/model/ConfigUtils.java
* common/src/test/java/org/apache/sqoop/model/TestConfigUtils.java
* common/src/test/java/org/apache/sqoop/model/TestMAccountableEntity.java
*
repository/repository-common/src/main/java/org/apache/sqoop/repository/common/CommonRepositoryHandler.java
* common/src/main/java/org/apache/sqoop/model/MMapInput.java
* common/src/test/java/org/apache/sqoop/model/TestMEnumInput.java
* common/src/test/java/org/apache/sqoop/model/TestMIntegerInput.java
*
repository/repository-common/src/main/java/org/apache/sqoop/repository/common/CommonRepositoryInsertUpdateDeleteSelectQuery.java
* common/src/main/java/org/apache/sqoop/error/code/CommonRepositoryError.java
*
repository/repository-derby/src/main/java/org/apache/sqoop/repository/derby/DerbySchemaConstants.java
* shell/src/main/resources/shell-resource.properties
* common/src/test/java/org/apache/sqoop/model/TestMMapInput.java
* common/src/main/java/org/apache/sqoop/model/Input.java
* common/src/test/java/org/apache/sqoop/model/TestMJob.java
* common/src/test/java/org/apache/sqoop/model/TestMLink.java
* common/src/main/java/org/apache/sqoop/model/InputEditable.java
* common/src/test/java/org/apache/sqoop/model/TestMStringInput.java
* common/src/test/java/org/apache/sqoop/model/TestMConfig.java
> Add editable and override attribute to inputs
> ---------------------------------------------
>
> Key: SQOOP-1804
> URL: https://issues.apache.org/jira/browse/SQOOP-1804
> Project: Sqoop
> Issue Type: Sub-task
> Reporter: Veena Basavaraj
> Assignee: Veena Basavaraj
> Fix For: 1.99.5
>
> Attachments: SQOOP-1804-v1.patch, SQOOP-1804-v4.patch,
> SQOOP-1804-v5-1.patch, SQOOP-1804-v5.patch, SQOOP-1804-v6.patch,
> SQOOP-1804-v7.patch, SQOOP-1804.patch
>
>
> Details of this proposal are in the wiki.
> https://cwiki.apache.org/confluence/display/SQOOP/Delta+Fetch+And+Merge+Design#DeltaFetchAndMergeDesign-Wheretostoretheoutputinsqoop?
> Update: The above highlights the pros and cons of each approach.
> #4 is chosen, since it is less intrusive, more clean and allows U/Edit per
> value in the output easily.
> Will use this ticket for more detailed discussion on storage options for the
> output from connectors
> 1.
> {code}
> // will have FK to submission
> public static final String QUERY_CREATE_TABLE_SQ_JOB_OUTPUT_SUBMISSION =
> "CREATE TABLE " + TABLE_SQ_JOB_OUTPUT + " ("
> + COLUMN_SQ_JOB_OUT_ID + " BIGINT GENERATED ALWAYS AS IDENTITY (START
> WITH 1, INCREMENT BY 1), "
> + COLUMN_SQ_JOB_OUT_KEY + " VARCHAR(32), "
> + COLUMN_SQ_JOB_OUT_VALUE + " LONG VARCHAR,"
> + COLUMN_SQ_JOB_OUT_TYPE + " VARCHAR(32),"
> + COLUMN_SQD_ID + " VARCHAR(32)," // FK to the direction table, since
> this allows to distinguish output from FROM/ TO part of the job
> + COLUMN_SQRS_SUBMISSION + " BIGINT, "
> + "CONSTRAINT " + CONSTRAINT_SQRS_SQS + " "
> + "FOREIGN KEY (" + COLUMN_SQRS_SUBMISSION + ") "
> + "REFERENCES " + TABLE_SQ_SUBMISSION + "(" + COLUMN_SQS_ID + ") ON
> DELETE CASCADE "
> {code}
> 2.
> At the code level, we will define MOutputType, one of the types can be BLOB
> as well, if a connector decides to store the value as a BLOB
> {code}
> class JobOutput {
> String key;
> Object value;
> MOutputType type;
> }
> {code}
> 3.
> At the repository API, add a new API to get job output for a particular
> submission Id and allow updates on values.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
