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

ERROR parsing argument to eval when running sqoop from oozie

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