Which tool to schedule Hive queries?

[#1]

Hi,

I would like to create/update Hive tables let's say once per hour.

Which tool should i use to schedule the execution of my hql script?

Thank you in advance

[#2]

why can't you use oozie time based workflow.

[#3]

Well, most of the tutorials i found on Oozie were written 2 or 3 years ago so i was wondering if it was still the recommended tech for this kind of things.

[#4]

You can also use falocn with hive action.

[#5]

you also invested time in learning nifi, nifi has a cron based scheduler, would be interesting to see it leveraged for this use case. Look under scheduling tab https://nifi.apache.org/docs/nifi-docs/html/user-guide.html#Configuring_a_Processor

[#6]

Yes i use it to request the API i'm interested in once a week (except for the twitter streaming api of course).