New Contributor
Posts: 1
Registered: ‎06-20-2018

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







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?