question Re: schedule sql in Support Questions

schedule sql

roshanbi — Sat, 12 Jun 2021 14:42:12 GMT

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

Re: schedule sql

ask_bill_brooks — Sun, 13 Jun 2021 15:48:03 GMT

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.

Re: schedule sql

roshanbi — Mon, 14 Jun 2021 02:17:23 GMT

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

Re: schedule sql

roshanbi — Mon, 14 Jun 2021 02:18:28 GMT

How do I find from which distribution I installed it?

Re: schedule sql

ask_bill_brooks — Fri, 18 Jun 2021 20:38:42 GMT

Hi @roshanbi

Just perusing the Hue user documentation, I read this:

Scheduler: The application lets you build workflows and then schedule them to run regularly automatically. A monitoring interface shows the progress, logs and allow actions like pausing or stopping jobs.

Re: schedule sql

roshanbi — Tue, 22 Jun 2021 09:54:26 GMT

Hi,

can you please advise on the steps to build the workflows on Hue?

Thanks,

Roshan

Re: schedule sql

roshanbi — Tue, 22 Jun 2021 10:45:00 GMT

I am getting error below

Re: schedule sql

ChethanYM — Mon, 05 Jul 2021 06:19:28 GMT

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/

Re: schedule sql

VidyaSargur — Wed, 07 Jul 2021 06:54:23 GMT

Hi. @roshanbi, Has any of the replies helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future. If you are still experiencing the issue, kindly provide more information that can help the experts help you.