Skip to main content
roshanbi
roshanbi
Gold ⭐️
June 12, 2021
Solved

schedule sql

Hello Team,

 

is there a way we can schedule a sql statement in Impala (hue)?

 

For example I wish to schedule delete of a table.

 

delete cdr.tab1;

 

Thanks,

 

Roshan

ChethanYM
ChethanYMAnswer
Gold ⭐️
July 5, 2021

Hi @roshanbi It looks like you do not have permissions to create an workflow, Please try it from any other user or ask your admin team to grant a privileges to you.

I found below Blog where it shows step by step procedure to create an workflow and schedule it in Hue. Please check and follow.

https://www.programmersought.com/article/44483680705/

 

View in thread

8 replies

ask_bill_brooks
Platinum ⭐️
ask_bill_brooks
Platinum ⭐️
June 13, 2021

It would be helpful to community members inclined to answer your question if you included which version of Hue you're using, and from which distribution (i.e., HDP, CDH or CDP) you installed it from.

 

 

Translate
Bill Brooks, Community Moderator Was your question answered? Make sure to mark the answer as the accepted solution. If you find a reply useful, say thanks by clicking on the thumbs up button.
    roshanbi
    roshanbiAuthor
    Gold ⭐️
    June 14, 2021

    Hi,

     

    thanks for the update.

     

    Please find below details:

    impalad version 3.4.0-SNAPSHOT RELEASE (build 134517e42b7b6085e758195465f956f431e0e575) Built on Sat Dec 12 11:15:02 UTC 2020
    Version: Cloudera Enterprise 7.1.3 (#4999720 built by jenkins on 20200805-1701 git: fa596184790377f07ba80e9cd4da8b875237939c)

    Java VM Name: OpenJDK 64-Bit Server VM

    Java Version: 11.0.10

     

    Thanks,

     

    Roshan

    Translate
    roshanbi
    roshanbiAuthor
    Gold ⭐️
    June 14, 2021

    How do I find from which distribution I installed it?

    Translate
    Terms & ConditionsAccessibility statement