Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Nifi PutHiveQL from SelectHiveQL

avatar

Hello

I have the Hive Rawdata External Table and need populate swap data from select * from rawdata.

The process is execute by crontab daily, and i want migrate the process to Nifi.

Whats best pratice for this question?

Thanks.

1 ACCEPTED SOLUTION

avatar
Master Guru
hide-solution

This problem has been solved!

Want to get a detailed solution you have to login/registered on the community

Register/Login
4 REPLIES 4

avatar
Master Guru
hide-solution

This problem has been solved!

Want to get a detailed solution you have to login/registered on the community

Register/Login

avatar
@Shu

This is working.

Thanks for your time.

Att.

avatar

@Shu

I can cascade the executions?

After finish table A, start table B?

Thanks

avatar
Master Guru
@Danilo Sousa

if you want to execute sequentially then you can use Success of PutHiveQL processor to trigger another job(i.e. start table B).

Flow:

1.GenerateFlowfile //start with tableA
2.PutHiveQL
3.ReplaceText //to prepare tableB statement 4.PutHiveQL