Tuesday 25 November 2014

Sqoop Action Loads Oracle in Oozie

Some places are different from command line.

1. <file> tag must after <arg>
2. Sql query must be placed in one line, not multiple lines.
3. ojdbc6.jar must be in lib folder, although it is in /var/lib/sqoop
4. for Oracle query in Oozie, use "WHERE $CONDITIONS"
Otherwise,
ERROR manager.SqlManager: Error executing statement: java.sql.SQLSyntaxErrorException: ORA-00911: invalid character
5. make sure the group permission is correct for /tmp/hive-yarn
6. Sqoop maps numeric and decimal to double in Hive


Reference:
https://groups.google.com/a/cloudera.org/forum/#!topic/cdh-user/OIKDwyeSsiU
https://sqoop.apache.org/docs/1.4.1-incubating/SqoopUserGuide.html

No comments:

Post a Comment