@Jay Kumar SenSharma So we moved ahead and used another IP: XX.XX.XX.51 (which has internet access) to install HDP and then reverted HDP back to its original IP: XX.XX.XX.160 (which does't have internet access) and did the same to install HDF using IP: XX.XX.XX.51 (which has internet access) and then reverted HDF back to its original IP: XX.XX.XX.161 (which doesn't has internet access). When HDP and HDF were on IP: XX.XX.XX.51, all the services were up and running and restart-able but the moment those were reverted back i.e. HDP and HDF to those original IPs, everything got hung. Now services are in start mode as were when were on IP: XX.XX.XX.51 and we can't stop & restart and other things like hive is not accessible, NiFi UI does't appear etc. Please advice. ... View more

@Mustafa Ali Qizilbash I tried with your UpdateRecord configs, not able to get your csv data(I used some sample data from your question screenshot) and the flow worked as expected. InputData: hw_3g_result_time,hw_3g_granularity_period,hw_3g_bsc_name,hw_3g_bsc_type,hw_3g_cell_name,hw_3g_cell_id,hw_3g_cell_index,hw_3g_reliability,VSRABAttEstabAMR,VSRABSuccEstabCSAMR 2018-04-26 0000,60,ULHR,BSC,UQRUR,48063,216,Reliable,33333,33 2018-04-26 0000,60,ULHR,BSC,UQRUR,48063,216,Reliable,77777,7 OutputData: hw_3g_result_time,hw_3g_granularity_period,hw_3g_bsc_name,hw_3g_bsc_type,hw_3g_cell_name,hw_3g_cell_id,hw_3g_cell_index,hw_3g_reliability,vsrabattestabamr,vsrabsuccestabcsamr 2018-04-26 0000,60,ULHR,BSC,UQRUR,48063,216,Reliable,33333,33 2018-04-26 0000,60,ULHR,BSC,UQRUR,48063,216,Reliable,77777,7 I attached the sample flow template that I have tried update-record-222899.xml .Use the attached flow xml as a reference and change per your case. ... View more

Many thanks, it worked. ... View more

Issue Resolved for me. In HDP 3.0, please use PutHive3Streaming, PutHive3QL and SelectHiveQL. Cheers. ... View more

Found the missing pieces. Go to Configuration (not configure) and added all Controller Services related to Avro and CSV (if you are loading from source). Issue resolved. ... View more

Upgraded the Firefox to latest version using following command: yum update firefox ------------------ Another error came in the process i.e. Failed to start Flow Service due to: java.net.BindException: Address already in use (Bind failed) Fixed it by changing NiFi protocol port from 9988 to 9989 Issue closed. ... View more

@Veerendra Nath Jasthi The DN there is coming from the keystore being used by your NiFi nodes. I have no idea why the certs created for your servers all have nifiadmin in them.... ... But just like your user DN, the node identities must match exactly with what is in those server certs in the keystore.. - <property name="Node Identity 1">CN=nifiadmin, OU=NIFIrsdevhdf1.medassurant.local, OU=NIFI</property> <property name="Node Identity 2">CN=nifiadmin, OU=NIFIrsdevhdf2.medassurant.local, OU=NIFI/</property> <property name="Node Identity 3">CN=nifiadmin, OU=NIFIrsdevhdf3.medassurant.local, OU=NIFI</property> - so you will need to edit your node identities so they match the above and once again stop NiFi, remove your users.xml and authorizations.xml files, and then start NiFi again via Ambari. - Thank you, Matt ... View more

I am facing the same problem. Following all the above steps but still unable to get delete command running. Note: I have table with no sorting. ... View more

I am getting same error in HDP 3. ... View more