Support Questions
Find answers, ask questions, and share your expertise

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".