Hi,   I'm referring  this below article; https://community.cloudera.com/t5/Community-Articles/Create-Dynamic-Partitions-based-on-FlowFile-Content-Convert/ta-p/248367 I'm trying to create pipeline in nifi while data coming realtime streaming based say some example kafka, while data put in hdfs in partitioned location, it may ended be with many small files at the same while querying im facing performance lag issue; can you please give some apporaches to resolve small files issue in nifi itself with orc file format;   ... View more

Hi,   Im currently merge content processor with avro files, data will be coming streaming manner, we want to merge with existing file with new file. While i set minimum no of entries as 2  Is there any possiblities to set minimum no of entires as dynamic manner (dynamic no of input flow files).. Can you please help me out.  ... View more

I want to split and transfer the json data in NiFi, Here is my json structure look like this; I want to split json by id1,id2 array of json transfer to respective processor group say example processor_group a,b. I tried with evaluate json path $.id1,$.id2 but i didn't get exact solution. Can you please help me out from this issue; { "id1": [{ "u_name": "aa" }, { "addr": "bb" }], "id2": [{ "u_name": "aa" }, { "addr": "bb" }] }   ... View more

Hi,   I'm currently working consumekafka poll messsage every interval 500 to 10000 records, while nifi iteration happen every 30 seconds once. i want to consumekafka once all jobs completed poll the next iteration. But consumekafka processor doesn't support upstream connection. can you help me out from this issue or could please suggest me how i can resolve? once puthdfs success i need to consume next iteration here i mentioned nifi workflow. Workflow: consumekafka -> mergecontent->convertRecord->updateattribute->puthdfs     ... View more

Hi,   I try to put/List hdfs from NiFi in aws ec2 instance, But i cant be able to put/List hadoop file system and here is my log in nifi. Please have a look; I have enabled 8020,50010 in emr security group also. Kindly help me out from this issue.    2020-03-30 12:09:30,082 ERROR [Timer-Driven Process Thread-8] o.apache.nifi.processors.hadoop.PutHDFS PutHDFS[id=18f688e9-084d-373b-9f6a-58cb9cdc355a] Failed to properly initialize Processor. If still scheduled to run, NiFi will attempt to initialize and run the Processor again after the 'Administrative Yield Duration' has elapsed. Failure is due to java.nio.channels.UnresolvedAddressException: java.nio.channels.UnresolvedAddressException java.nio.channels.UnresolvedAddressException: null at sun.nio.ch.Net.checkAddress(Net.java:101) at sun.nio.ch.SocketChannelImpl.connect(SocketChannelImpl.java:619) at org.apache.hadoop.net.SocketIOWithTimeout.connect(SocketIOWithTimeout.java:192) at org.apache.hadoop.net.NetUtils.connect(NetUtils.java:531) at org.apache.hadoop.net.NetUtils.connect(NetUtils.java:495) at org.apache.nifi.processors.hadoop.AbstractHadoopProcessor.checkHdfsUriForTimeout(AbstractHadoopProcessor.java:457) at org.apache.nifi.processors.hadoop.AbstractHadoopProcessor.resetHDFSResources(AbstractHadoopProcessor.java:363) at org.apache.nifi.processors.hadoop.AbstractHadoopProcessor.abstractOnScheduled(AbstractHadoopProcessor.java:251) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.nifi.util.ReflectionUtils.invokeMethodsWithAnnotations(ReflectionUtils.java:142) at org.apache.nifi.util.ReflectionUtils.invokeMethodsWithAnnotations(ReflectionUtils.java:130) at org.apache.nifi.util.ReflectionUtils.invokeMethodsWithAnnotations(ReflectionUtils.java:75) at org.apache.nifi.util.ReflectionUtils.invokeMethodsWithAnnotation(ReflectionUtils.java:52) at org.apache.nifi.controller.StandardProcessorNode.lambda$initiateStart$4(StandardProcessorNode.java:1515) at org.apache.nifi.engine.FlowEngine$3.call(FlowEngine.java:123) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748)  ... View more

Hi,   I need a suggestion, while select only rows when certain range met. For example, here is below dataset;   id|count|name|status _________________ 1| 10 | xxx | 0 2| 20 | yyy | 0 3| 30 | zzz | 1 4| 40 | qqq | 0 5| 50 | ppp | 0   I want select only between 0 and 1 expected result;   id|count|name|status _________________ 1| 10 | xxx | 0 2| 20 | yyy | 0 3| 30 | zzz | 1   sql : select * from tbl where status between 0 and 1  But I got entire values from that table. Please give me any suggestion, im stuck on this.    ... View more

Hi,   I created dataflow in NiFi, From two difference sources one from HDFS and another from kafka consumer processor merge those data push it finally put it in HDFS location. Here i need to consume data from two different topic but jobs needs to same,  For example; Topic A - if topic A started publishing and i wait for til end publish complete, I started consume data Topic B - If topic B started publishing and i want to wait till the end publish completed, after that start consume data. kafka_consumer(A,B topic) -> update attribute      GetHDFS -> update attribute                             -> merge -> puthdfs   Can you please suggest me how can i do that consume from two kafka topic sequentially.        ... View more

Hi,   Currently i try to update records in hdfs file system, while hdfs partitioned table mapped with hive schema. Data has been dynamically updated in hdfs respective location. We want update our records in hdfs file system, while i try to set hive as transaction table presto doesn't support query that table. is there any alternative to do for incremental updates and external location is hdfs ... View more

Hi,     We are currently use single node nifi server on aws ec2 instance, We are planning to move multi node cluster architecture. We are in development and testing stage. We need to setup as acvtive and passive nodes, which nifi should works fine whenever one of the server goes down another will pick. can anyone help us to move forward this scenerio or could you suggest any reference architure, ... View more

Hi,   I'm creating dynamic partitioning to push data in hdfs location with date based file structure. while i try to push data respective date folder, i had an issue after splitjson processor number of records mssing before incoming to convertjsontoavro processor. Please help me out from this issue or give me any suggestion.   split text_processor  split with $.*   Dynamic partitioning with orc, i refer this link; https://community.cloudera.com/t5/Community-Articles/Create-Dynamic-Partitions-based-on-FlowFile-Content-Convert/ta-p/248367     ... View more

Hi,   We are using aws emr with presto+hive service. while data resides in aws s3. Those tables are configured and data incrementally pusing in s3. While we are benchmarking hdfs vs s3 performance metrics. While consideration, hdfs performance better than s3. But when it comes to data persistence s3 only win. we are strict go with s3 as external location. Please give me any suggestion on increasing performance tuning for presto+s3 on aws emr.    ... View more

Hi,   I'm currently working on aws emr and we are using hive-presto service. while data has been exponentially incremente from kafka to put single table(without_partition). Now we are planning to implement partition table, say example with respective date key. when this case, how would we append and compressing orc file respective partition external storage. Please give me suggestion on this; Existing NiFI Flow; Lists3->Fetch-s3> update_attribute->  merge_content->put_s3->putHDFS. kafka_consumer->update_attribute -> ... View more

Hi,   I'm currently facing issues on apache nifi merge content from two flow files fetchs3object and kafka consume processor. My scenario is whenever new updated records are published into kafka needs to merge with s3 object file and finally pushed into s3 updated file. Here is my flow;   https://imgur.com/a/3CZfsCT Please help me to resolve from this issue.   Whenever i got updated records sometimes duplicate there or not appending properly. i don't know where is the issue.  ... View more

Hi, We were processing realtime data pushing every minute, i want to pull streaming data from elasticsearch like every second. can we give me suggestion. How could i collect streaming data from elasticsearch. After i collect the data from elasticsearch i need to apply machine intelligence with python support. Can please help me?? ... View more

Hi, I have planned to create cluster environment with hdp 2.6. we have daily data rate around 40GB. the data size get increase day by day. My question are; 1) is i plan es-hortonworks as in same cluster, it is good solution to achieve faster query response? 2) if i plan like that above, how to calculate number of master node and slave node? Please help me!!! ... View more

Hi, I have tried more a days on that particular issue, I had issue when i extract based on regexp, i got data in data providence flow file. My aim is After extract text processor -> needs to append the extracted value to filename. Normally filename propertiy added filename using update attribute. Please give me suggestion how do i append the values to puthdfs file. It would much helpful!!! Thanks. ... View more

Hi, I'm working on nifi in hdp 2.5. There is a new requirement normally user entered query/keywords in google and fetch those results either json/xml data format. I need to automate those process, But i didn't able to automate fetch google reuslt using Nifi. Is it possible to do or is there any ways to fetch results like web scrapping instead of programming with help of Nifi. Thanks. ... View more

Hi, I'm using HDP 2.5 and latest solr version 7.1.0. When i try to create collection via solr i got below error, I think the problem is there in zookeeper. Please find my log $ ./solr create -c test_solr./solr: line 2017: /opt/solr-7.1.0/solr-7.1.0/bin/solr-8983.pid: Permission denied Warning: Available entropy is low. As a result, use of the UUIDField, SSL, or any other features that require RNG might not work properly. To check for the amount of available entropy, use 'cat /proc/sys/kernel/random/entropy_avail'. Waiting up to 180 seconds to see Solr running on port 8983 [\] Started Solr server on port 8983 (pid=24630). Happy searching! $ ./solr create -c test_solr WARNING: Using _default configset. Data driven schema functionality is enabled by default, which is NOT RECOMMENDED for production use. To turn it off: curl http://localhost:8886/solr/test_solr/config -d '{"set-user-property": {"update.autoCreateFields":"false"}}' ERROR: KeeperErrorCode = ConnectionLoss for /clusterstate.json I can able to get collection in solr admin ui. But i cannot able to create collection. Please give me some solution!!. ... View more

Hi, I'm using HDP 2.5 in our server with 2 nodes. I'm running query successfully in hive. Suddenly I'm facing mapping with source table to add column to my new table, By this below query; I got vertext failled error. Please find my log hive-error.txt while running this query in hive view. Please tell me how do i resolve this issue. create table New_table As select distinct ab.id, ab.first_name, ab.middle_name, ab.last_name, b.Address, b.City_Name, b.State_Name from Temp_table ab join Source_table b on (ab.id=b.id); ... View more

Hi, I cluster 2 nodes with each node 16GB Ram and 2-CPU Cores and yarn memory has been configured 8GB as recommended. I have set those configuration in tez as below mentioned link; https://community.hortonworks.com/articles/22419/hive-on-tez-performance-tuning-determining-reducer.html I don't know how to configure as my hardware configuration. I'm over process data around 6million record. It takes much time. Please tell me how do i configure to execute as faster/increase performance. Thanks in advance! Regards, Varun ... View more