Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

ERROR parsing argument to eval when running sqoop from oozie

Highlighted

ERROR parsing argument to eval when running sqoop from oozie

Expert Contributor

I have following sqoop command in oozie workflow:

eval --connect "jdbc:mysql://hostname/dbname" --username=root --password 'pass' --query "TRUNCATE TABLE tablename;"

It runs fine from command line but when I run it through oozie, I get

2018-02-22 23:37:45,932 [main] ERROR org.apache.sqoop.tool.BaseSqoopTool  - Error parsing arguments for eval:
2018-02-22 23:37:45,932 [main] ERROR org.apache.sqoop.tool.BaseSqoopTool  - Unrecognized argument: TABLE
2018-02-22 23:37:45,932 [main] ERROR org.apache.sqoop.tool.BaseSqoopTool  - Unrecognized argument: tablename;"

How do I fix this?

1 REPLY 1

Re: ERROR parsing argument to eval when running sqoop from oozie

Guru

@Simran Kaur Just remove the keyword "TABLE".