title: Query hdfs with Spark Sql
body: <p>I have a csv file in hdfs, how can I query this file with spark SQL? For example I would like to make a select request on special columns and get the result to be stored again to the Hadoop distributed file system </p>
  
  <p>Thanks</p>