Home Forums Oozie Oozie via Hue: Sqoop Eval Failing

This topic contains 1 reply, has 1 voice, and was last updated by  Nick Martin 1 year ago.

  • Creator
    Topic
  • #43366

    Nick Martin
    Participant

    I can successfully run Sqoop imports and exports via a workflow in Oozie, but I’m having trouble with the Sqoop -eval statement in Hue(Oozie). When I attempt to run a Sqoop -eval task I get “error parsing arguments for eval”. I’ve tried running both the command text version and inputting individual params and get errors with both. I should note that when I execute the same Sqoop -eval task I’m attempting in Hue in shell it runs perfectly fine.

    Error:

    Sqoop command arguments :
    eval
    –connect jdbc:oracle:thin:@xxx-xxx.xxx.xxx.xxx:0000/SCHEMA
    –username xxx
    –password xxx
    -e ‘TRUNCATE TABLE SCHEMA.TABLE_INFO’
    =================================================================

    >>> Invoking Sqoop command line now >>>

    575 [main] WARN org.apache.sqoop.tool.SqoopTool – $SQOOP_CONF_DIR has not been set in the environment. Cannot check for additional configuration.
    608 [main] ERROR org.apache.sqoop.tool.BaseSqoopTool – Error parsing arguments for eval:
    608 [main] ERROR org.apache.sqoop.tool.BaseSqoopTool – Unrecognized argument: –connect jdbc:oracle:thin:@xxx-xxx.xxx.xxx.xxx:0000/SCHEMA
    608 [main] ERROR org.apache.sqoop.tool.BaseSqoopTool – Unrecognized argument: –username xxx
    608 [main] ERROR org.apache.sqoop.tool.BaseSqoopTool – Unrecognized argument: –password xxx
    608 [main] ERROR org.apache.sqoop.tool.BaseSqoopTool – Unrecognized argument: -e ‘TRUNCATE TABLE SCHEMA.TABLE_INFO’
    usage: sqoop eval [GENERIC-ARGS] [TOOL-ARGS]

    Common arguments:
    –connect Specify JDBC connect
    string
    –connection-manager Specify connection manager
    class name
    –connection-param-file Specify connection
    parameters file
    –driver Manually specify JDBC
    driver class to use
    –hadoop-home Override
    $HADOOP_MAPRED_HOME_ARG
    –hadoop-mapred-home Override
    $HADOOP_MAPRED_HOME_ARG
    –help Print usage instructions
    -P Read password from console
    –password Set authentication
    password
    –password-file Set authentication
    password file path
    –username Set authentication
    username
    –verbose Print more information
    while working

    SQL evaluation arguments:
    -e,–query Execute ‘statement’ in SQL and exit

    Generic Hadoop command-line arguments:
    (must preceed any tool-specific arguments)
    Generic options supported are
    -conf specify an application configuration file
    -D use value for given property
    -fs specify a namenode
    -jt specify a job tracker
    -files specify comma separated files to be copied to the map reduce cluste

Viewing 1 replies (of 1 total)

You must be logged in to reply to this topic.

Viewing 1 replies (of 1 total)