Hadoop was never meant to be user friendly. Which is why you have commercial versions of it like Cloudera & AWS EMR, meant to fill that void in the industry.
FWIW, I feel your pain on a daily basis, but I do like Hadoop as a low cost massively distributed db.