Home Forums Oozie Beginner question regarding Oozie & Hive

Tagged: ,

This topic contains 7 replies, has 5 voices, and was last updated by  Seth Lyubich 1 year, 6 months ago.

  • Creator
    Topic
  • #22089

    Lars Schulte
    Member

    Hey guys,

    i am running the sandbox and i want to run some hive-scripts (first tiny question: can i just take working scripts from the Beeswax panel and upload them as .sql files?) with oozie.
    I just created a new workflow, added my hive-jobs and added all the files to the working directory.
    after submitting it only shows me
    “Error submitting workflow test – sandbox

    E0701: XML schema error, cvc-elt.1.a: Cannot find the declaration of element ‘workflow-app’.”
    which seems to me like i made a config error somewhere?

    workflow xml:

    http://pastebin.com/cxaiyC7M

    i would appreciate your help,

    Lars

Viewing 7 replies - 1 through 7 (of 7 total)

You must be logged in to reply to this topic.

  • Author
    Replies
  • #24996

    Seth Lyubich
    Keymaster

    Hi Tanzir,

    Thanks for letting us know that you were able to resolve the issue.

    Lars, are you still having issue submitting the job?

    Thanks,
    Seth

    Collapse
    #24883

    Tanzir
    Participant

    Hi Larry,
    I have fixed the problem. Those tables were not present from oozie side that’s why it was throwing those errors. When it was running through oozie it was pointed to a wrong mysql database. After putting (in app path) the expected hive-site.xml and hive-default.xml fixed that problem. Thanks for your time.

    Collapse
    #24195

    Larry Liu
    Moderator

    Hi, Tanzir

    Can you privide the log for the job?

    Larry

    Collapse
    #24086

    Tanzir
    Participant

    Hello Everyone,
    I’m also new in Hive. I’m facing some issues while running hive script through oozie.

    When I run the following script (script.q), on oozie console I can see its ‘SUCCEEDED’.


    show tables;

    But when I ran the following query in the script, oozie console shows its “KILLED”


    select count(*) from session_steps;

    I’m able to run it separately, like:

    [ambari_qa@ip-10-0-0-91 hive-oozie]$ hive -f script.q

    Any idea what’s going on here? I have checked the log from the oozie console but haven’t seen any useful information there. Any information will be highly appreciate.

    Collapse
    #22870

    tedr
    Moderator

    Hi Lars,

    It looks like you may have to run it manually to get past the error. In the mean time I’ll look into why the line is left out when oozie generates the workflow.

    Thanks,
    Ted.

    Collapse
    #22660

    Lars Schulte
    Member

    Yes, it is missing.
    I inserted it and ran it again, but it says it is missing due to the fact, that oozies generates it newly every time i run it.
    Is there a way to disable this behavior? Or do i have to run it manually?

    Collapse
    #22472

    Seth Lyubich
    Keymaster

    Hi Lars,

    It is possible that line below is missing in workflow.xml file.

    <?xml version=”1.0″ encoding=”UTF-8″?>

    Can you please try to add this line and try again? You can try to run xmllint utility to verify formatting of your xml files.

    Hope this helps.

    Thanks,
    Seth

    Collapse
Viewing 7 replies - 1 through 7 (of 7 total)