can someone give me install instructions for NIFI on HDP and not SANDBOX ? I see this link but Its confusing as it talks about SANDBOX and also HDP . https://community.hortonworks.com/questions/44042/adding-nifi-server-to-hdp-25-sandbox.html ... View more

I have a file with data like below , I want to grab the info between each START - START-END lines and save it using a KEY value on first line. how can I do that ? please note that the number of lines between the START and START-END is varying. I would like to put this in HIVE database also. START - KEY-VALUE and bunch of info on this line bunch of info on this line bunch of info on this line bunch of info on this line START-END bunch of info on this line START - KEY-VALUE and bunch of info on this line bunch of info on this line START-END bunch of info on this line regards ... View more

I am unable to import a table into HIVE , I am getting error "database doesn't exist" , googling Iam seeing people reporting that for Cloudera hive metastore needs to be set in "remote" mode. is there something I have to do in Horton works also? can I use the "default" database that comes with the postgres Hive database or do I have to create a new one if I want to use HIVE? below is the command I am giving and the error generated , I am not sure why is the command looking for a database called "PATRON" ? sqoop import --connect "jdbc:oracle:thin:@(description=(address=(protocol=tcp)(host=patronQA)(port=1526))(connect_data=(service_name=patron)))" --username PATRON --password xxxx --table PATRON.TAB1 --split-by TAB1.ACCT_NUM --hive-import --create-hive-table FAILED: SemanticException [Error 10072]: Database does not exist: PATRON ... View more

I am keep getting these errors , and most of the time the application succeeds still. what is this error and how I can resolve this ? I have ssh setup between all hosts 16/08/26 14:59:54 INFO mapreduce.Job: Job job_1472231356029_0008 failed with state FAILED due to: Application application_1472231356029_0008 failed 2 times due to Error launching appattempt_1472231356029_0008_000002. Got exception: java.net.NoRouteToHostException: No Route to Host from hadoop2.tolls.dot.state.fl.us/10.100.44.16 to hadoop3.tolls.dot.state.fl.us:45454 failed on socket timeout exception: java.net.NoRouteToHostException: No route to host; For more details see: http://wiki.apache.org/hadoop/NoRouteToHost ... View more