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

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

 

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?   

 

 

 

 

 

 

 

 

Announcements