Policy is synced to all the nodes. You can check that in Ranger->Audit->Plugins. If not, then you should check if you have access policy for node identities,  ... View more

You can use the flow you have in mind. But, i would suggest some optimization for your flow here:  PutHDFS & PutHiveQL -> I suggest you create an external table on HDFS so you can skip the puthiveql Rest of your flow is to make SQL statements -> As i suggested before, you can look at PutDatabaseRecord since it has a recordreader(in your case AvroReader) and you can mention what type of sql query needs to be generated. This will help you with all the conversions and make the flow much much faster. The process to retrieve selection columns you can still use the same flow, just change the query you retrieve from getfile.   Hope this helps. ... View more

Hi....yes you can use selecthiveql to run multiple hiveql statements. I would suggest putting the sql statements in a file / files and use list file and putfile processors before selecthiveql....Data is stored in flowfile content so you do not need to have a variable or anything. Finally you can use PutDatabaseRecord to write it to sql db.    Ideal flow with no transformations :  ListFile->FetchFIle->SelectHiveql->putdatabaserecord   Hope this helps. ... View more

Turns out it was either the antivirus or group policies that was blocking the connection. I am trying to get more info and update the post but if someone stumbles onto this, they should check this first. ... View more

You can try to use this command : http://<ambari-server>:8080/api/v1/stacks/{stackName}/versions/{stackVersion}/services   To get help on API calls use this : http://<ambari-server>:8080/api-docs. You can try out api calls to understand what api returns. ... View more