About vivek_b3ds

moahmedhassaan · ‎03-10-2023

any way to use query for filter only last minutes transactions

CodingAway · ‎02-05-2020

Instead of using the function: prepend (this just shifts your data), how do you do an outright replace for the header row? I tried using Literal search, but I end up having strange characters when the replace occurs

JonathanSneep · ‎10-01-2018

@Vivek Singh Unfortunately that information isn't in zookeeper, so we can't get it from there unless you write the information to zookeeper yourself (the solution might get overly complicated now). If you really must avoid REST you could try to query the ambari database to list the installed services for example like so; psql ambari -U ambari -W -p 5432 -c "select * from clusterservices"

joseph_cheung2 · ‎09-10-2018

more a question, so any update for manipulating variables? I have the same issue. Which API to call?

Shu_ashu · ‎06-04-2018

@Vivek Singh PutHiveQL processor is used to execute HiveDDL/DML commands and the processor expects incoming flowfile content would be HiveQL command. You can keep your create table statement by using GenerateFlowfile processor (or) replacetext processor ..etc and feed the success relation to PutHiveQL processor then the processor executes the content of flowfile and creates the table. Flow: GenerateFlowfile configs: PuthiveQL configs: Configure/enable HiveConnection pool and if you are having more than one HiveDDL/DML command in the flowfile content then use ; as delimiter then the processor will execute those commands with the specified delimiter. In NiFi convertAvroTo ORC processor adds hive.ddl attribute based on the flowfile content we can make use of that attribute and then use ReplaceText processor to create new flowfile content and execute the hive ddl statement using PutHiveQL processor. Please refer to this link for more details regarding generating/executing hive.ddl statements using NiFi.

ottobackwards · ‎04-06-2018

try $.[*] or $[*] http://jsonpath.herokuapp.com/ is a good place to practice https://github.com/json-path/JsonPath for documentation

mburgess · ‎04-05-2018

You might be able to use jvm-npm as a bridge to load that module, but see the documentation on the jvm-npm site for restrictions (such as needing to be a "pure" NPM module that does not depend on the Node.js API)

vivek_b3ds · ‎03-29-2018

Thanks setting max bin age property works.

Shu_ashu · ‎04-02-2018

@Vivek Singh Does the answer helped, then please Click on Accept button below to accept the answer, That would be great help to Community users to find solution quickly for these kind of issues.

Online	Offline
Last Visited	‎04-01-2019 07:04 AM

Member Since	‎01-16-2018 11:24 AM
Last Visited	‎04-01-2019 07:04 AM
Posts	25
Kudos received	2

Cloudera Community

Re: How to write mongoDb query in Apache Nifi GetM...

Re: How to change csv attribute/header name in apa...

Re: How to check if specific set of component is i...

Re: How to access NIFI Process Group variable in E...

Re: How to execute Hive DDL Command from Apache NI...

Re: Apache NIFI SplitJson correct Json path expres...

Re: How to use npm package in Apache NIFI's Execut...

Re: How to merge multiple csv coming through flowf...

Re: How to generate UUID in apache NIFI ?