[SQOOP-1061] Sqoop2: Introduce conditions on forms or inputs

• Type: New Feature
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.99.2
• Fix Version/s: 2.0.0
• Assignee: Abraham Elmahrek
• Reporter: Jarek Jarcec Cecho
• Created: 28/May/13 06:20
• Updated: 17/Dec/14 17:46

Description

Currently we have static set of forms for Connection and Job objects with all possible inputs (~ questions) that we might possibly need to know. This seems to be very confusing for the end user as he is asked questions that might not make sense for his case.

For example consider the Generic JDBC Connector that is asking following questions when creating the Job object:

Schema name:  (Make sense only for Table)
Table name: (Make sense only for Table)
Table SQL statement: (Make sense only for Query)
Table column names:  (Make sense only for Table)

The possibilities Table name and Table SQL statement are mutually exclusive, so can't be filled at the same time. We do have support for validations that will filter such incorrect entries, however the user is still asked the questions, which is kind of confusing.

I was thinking how to address this issue and I think that very nice and extensible solution would be allow some sort of conditions on either forms or inputs (or maybe both). For example we could create a new Enum input "Import type" with values TABLE or QUERY and then create conditions on the individual inputs to show them up only in case that this new input have certain value. For example (this is mock) for table:

Import Type:  TABLE
Schema name: 
Table name: 
Table column names: 

Or for query:

Import Type:  QUERY
Table SQL statement: 

I do not currently have more deeper proposal on my mind, however I'm looking forward for community feedback to see if it would make sense to go with this proposal further.

Issue Links

• relates to: SQOOP-1644 Sqoop2: Enhance the connector/ driver config input options for better usability

Sub-Tasks

• Sqoop2: Add conditions to shell client: Open
• Sqoop2: Models and serialization for conditions: Open