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.

HUE Impala Pauses After "Create Table as Select..." statements - WorkAround?

Highlighted

HUE Impala Pauses After "Create Table as Select..." statements - WorkAround?

New Contributor

 

Hello!

 

Impala_Problem_20180620.jpg

 

 

I am having a problem running a script in HUE Impala that I want to create multiple output tables.   All of my intermediate steps run just fine, but after each Create Table step is encountered that uses a Select statement within it, the script I'm running pauses after creating the table - requiring me to click the blue run button to continue.  I'd like to run the job on a schedule, rather than having to be present to hit the click button to continue several times.   

 

Is there a workaround short of splitting the script into multiple scripts that then will run independently on a schedule?   ** I am using views in the joins that create the tables.  But the tables are what I hope to have refreshed each day when the script runs.**  Suggestions to prevent these pauses in the script?