Sqoop does not work with parameters

I am trying to run a sqoop job. I am using the sqoop version of Sqoop 1.4.6-cdh5.8.0 and does not work for this version

It works fine with Sqoop 1.4.5-cdh5.4.0.

 sqoop job --create E8 -- import  --connect jdbc:mysql://localhost/test -- username root --password cloudera --table NAME --hive-import -m1

 sqoop job --exec E8 -- --table dummy1

Is there a problem with the syntax. If anyone can help with this.

       Warning: /usr/lib/sqoop/../accumulo does not exist! Accumulo 
       imports  will fail.
       Please set $ACCUMULO_HOME to the root of your Accumulo installation.
       16/12/23 04:48:10 INFO sqoop.Sqoop: Running Sqoop version: 1.4.6-
       cdh5.8.0
       Enter password: 
       16/12/23 04:48:19 INFO manager.MySQLManager: Preparing to use a 
       MySQL  streaming resultset.
       16/12/23 04:48:19 INFO tool.CodeGenTool: Beginning code generation
       16/12/23 04:48:20 INFO manager.SqlManager:
       Executing SQL statement: SELECT t.* FROM `NAME` AS t LIMIT 1
       16/12/23 04:48:20 ERROR manager.SqlManager: Error executing 
       statement: 
       com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table    
      'test.NAME' doesn't exist
+4
source share
2 answers

Assuming that you have already completed the basic checks (for example, manually placing the parameter in the task and completing it), I would say that the syntax looks correct.

When viewed in a document, it is mentioned that you can override properties. Unfortunately, they only show an example that adds a property and does not display an override.

, , , .


, , , :

  • ( / , , , ...)
+3

, sqoop-1.4.6-cdh5.8.0 sqoop-1.4.6-cdh5.9.0

, , , 1.4.5.

:

1) 'sqoop-1.4.5-cdh5.4.0.jar' http://repo.spring.io/libs-release/org/apache/sqoop/sqoop/1.4.5-cdh5.4.0/

2) "sqoop-1.4.6-cdh5.8.0.jar" "sqoop-1.4.5-cdh5.4.0.jar" "sqoop.jar", "sqoop-1.4 0,5-cdh5.4.0.jar

3) , .

+2

Source: https://habr.com/ru/post/1664685/


All Articles