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

Impala-shell timeout via oozie workflow

Solved Go to solution
Highlighted

Impala-shell timeout via oozie workflow

Rising Star

Hi,

I have a simple oozie workflow which runs an impala-shell and exeutes a impala query file.  The query is a big one so I expect to see if take a few hours, however worlflow keeps getting killed after 1 hour.  When looking through the logs I see on the impala-shell logs the following "timeout 1hr"

>>> Invoking Shell command line now >>

Stdoutput Generating kerberos ticket, attempt 0, fromxxx.keytab for xxx@xxx.xom
Stdoutput Sucessfully obtained Kerberos ticket for xxx@xxx.com
Stdoutput Generating random string
Stdoutput Query parameters:
Stdoutput   tempTable=temp._attxxx_60742242
Stdoutput 0: Running query query.sql with timeout 1h, attempt 0, parameters:


The impala admission queue the query executes under has no timeout setting set, so i'm at a loss as to were this value is been picked up from?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: Impala-shell timeout via oozie workflow

Rising Star

Turns out this was a enviroement variable set within the impala-shell.sh

View solution in original post

3 REPLIES 3
Highlighted

Re: Impala-shell timeout via oozie workflow

Rising Star

Turns out this was a enviroement variable set within the impala-shell.sh

View solution in original post

Highlighted

Re: Impala-shell timeout via oozie workflow

New Contributor

Hi Chris,

 

I am facing some challenges while executing the impala shell command through oozie. If possible can you please share the sample of script file in order to execute the query using Oozie workflow

Re: Impala-shell timeout via oozie workflow

Moderator

Hi @rohit19,

 

As this is an older post you would have a better chance of receiving a resolution by starting a new thread. This will also provide the opportunity to provide details specific to your environment that could aid others in providing a more accurate answer to your question.


Madhuri Adipudi, Technical Solutions Manager

Was your question answered? Make sure to mark the answer as the accepted solution.
If you find a reply useful, say thanks by clicking on the thumbs up button.

Learn more about the Cloudera Community: