Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

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

Re: Impala-shell timeout via oozie workflow

Rising Star

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

1 REPLY 1

Re: Impala-shell timeout via oozie workflow

Rising Star

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

Don't have an account?
Coming from Hortonworks? Activate your account here