What happens when you try the url in your browser? Which browser are you using? Did you try another browser? What happens when you use the ambari login url http://http://localhost:8080/#/login? Which version of HDP sandbox? ... View more

Followed instructions and it worked. Thanks @Sriharsha Chintalapani ... View more

@Bala Vignesh N V You will need to do a little data engineering to prep your data for the hive table ... basically, replacing the pipe | with a comma. You can do this easily in pig by running this script: a = LOAD '/sourcefilepath' as (fullrecord:chararray); b = FOREACH x generate REPLACE(fullrecord, '\\|', ','); STORE b INTO '/targetfilepath ' USING PigStorage (','); You could also do this pipe replace in sed before loading to hdfs. Pig is advantageous however because it will run in map-reduce or tez and be much faster (parallel processing) especially for large files. The fact that you have some values that include the delimiter is a problem ... unless there is a clear pattern you will have to write a program that finds each record with too many delimiters and then write a script to replace these one by one (e.g replace 'new york, usa' with 'new york usa' . If you used pig, b = would have to be repeated for each such value with delim. If you are unfamiliar with pig, this is a good tutorial to show how to implement the above https://hortonworks.com/tutorial/how-to-process-data-with-apache-pig/ ... View more

I think this link will show you how to change INFO to WARN or ERROR, as well as adjust rotating log sizes https://community.hortonworks.com/content/supportkb/49455/atlas-default-logging-is-filling-up-file-system-ho.html ... View more

Streaming the data to hadoop does consume a lot of CPU even though the data is only passing through. Putting the client on the edge node isolates this and thus prevents CPU contention on the cluster doing jobs. The edge node typically is used for client implementation a) to isolate users from logging into master or worker nodes, and b) for isolating resource usage as with CPU with Sqoop. ... View more