Cron Job that runs HiveQL

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Cron Job that runs HiveQL

Daniel Müller
Is there a possibility to run a HiveQL processor, that runs just a
"alter table abc concatenate" command like in a cron job, without having
a pre- nor post-processor?

I want to call the command above just in a regular time interval,
without depending on other processes on my NiFi instance.

Thank you!

Reply | Threaded
Open this post in threaded view
|

Re: Cron Job that runs HiveQL

Pierre Villard
Hi Daniel,

You can add a GenerateFlowFile processor with the query you want to execute
for the content of generated flow files, set the expected scheduling (cron
scheduling), and connect it to a PutHiveQL that will execute the query from
the content of the flow file.

Does it make sense?

Pierre

2017-10-23 13:52 GMT+02:00 Daniel Müller <[hidden email]>:

> Is there a possibility to run a HiveQL processor, that runs just a "alter
> table abc concatenate" command like in a cron job, without having a pre-
> nor post-processor?
>
> I want to call the command above just in a regular time interval, without
> depending on other processes on my NiFi instance.
>
> Thank you!
>
>