Hi, Can anyone please let us know how to write the output of the Spark SQL in Local and HDFS path using Scala code.
*Code :-* scala> val result = sqlContext.sql("select empno , name from emp"); scala > result.show(); If I give the command result.show() then It will print the output in the console. I need to redirect the output in local file as well as HDFS file. with the delimiter as "|". We tried with the below code result.saveAsTextFile ("home/Prasad/result.txt") It is not working as expected. -- ---------------------------------------------- Prasad. T