please don't use "order by" clause in your query.. you can order the data separately when you try to select the data from the HDFS location.. ... View more

it is a clear permission issue only.. ... View more