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?