[SQOOP-3358] sqoop2 1.99.7 Schema name of Job not work for MariaDB

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.99.7
• Component/s: connectors/generic
• Labels: Schema_Name

Environment

Mac  10.13.5

Sqoop 1.99.7

• Assignee: Unassigned
• Reporter: Wang
• Created: 08/Aug/18 02:00
• Updated: 08/Aug/18 02:00

Description

Hi guys,

     I find a problem when use sqoop2 1.99.7, that is:

     I want to export MariaDB(mysql) to hdfs using the connector org.apache.sqoop.connector.jdbc.GenericJdbcConnector。First, I create a Link using "dbc:mysql://server_host:server_port/db_name"。Then, I create a Job from mysql_link to hdfs_link。And The "Schema Name" is the db_name。Finally, I start the Job, but it responses that other_db_name.Table_name not exist.  The other_db_name is also in the mysql server, but not the one I set in "Schema Name". Why?  Is't that sqoop2 not support MariaDB.

    Other problem  is that  when I set "SQL statement" as "select * from table ${CONDITIONS}" and "Table name" empty. It will warns that "revise your input". Why ? Is't that it not support "SQL statement"