Updated sandbox. everything is working now, thanks ... View more

Thank you so much @Constantin Stanca, I followed the other link and installed R, rhdfs, rmr2 and rhive. It was a great help. ... View more

@Mushtaq Rizvi I hope what ever you're doing above is just replacing with "None" which is a string which consumes memory. Let's I've a scenario. I wanted to replace the blank spaces like below with null values. Can you suggest something on how to do this. Because the whitespaces consume memory where as null values doesn't. |Extension| |gif | | | |gif | | | |html | I wanted it like this. |Extension| |gif | |null| |gif | |null| |html | ... View more

@Luis Figueroa: Thank you for your suggestion however it doesn't work for me: I am using HDP 2.5, and I need to transfer a file from my local windows host to sandbox, here is my command: scp -P 2122 /RXIE/..../test.csv root@localhost:root I received the following error message: ssh: connection to host localhost port 2122: Connection refused Thank you. ... View more

Thanks a lot @Bernhard Walter , that works like a charm ... View more

Thank you so much @Andy LoPresto, it worked. It was capturing nothing earlier, perhaps because of other 3 digit numbers. The log format is consistent throughout the file, so yeah, the workflow flowed like a water 🙂 ... View more

@Greg, i am trying to execute mysql queries, got error prefix not found. when i verified in mysql note there i observer mysql is there instead of %mysql. But unable to add % before mysql, its not editable. can u please help me how can i edit. ... View more

Thanks alot @Andrew Ryan, I moved all the files from the topologies folder, and then restarted Knox, it created default, admin and knoxsso xml files. Tested default and it worked fine. Then I moved back the old knox_sample.xml to the folder and restarted Knox, it worked. Still wondering what could be the issue ... View more

It worked, thanks a lot @jhorsch. I was missing some mandatory fields in json payload, that should be the reason for the error. ... View more