---

layout: global type: “page singular” title: Spark SQL & DataFrames description: Spark SQL is Spark's module for working with structured data, either within Spark programs or through standard JDBC and ODBC connectors. subproject: SQL

<div style="margin-top: 15px; text-align: left; display: inline-block;">
  <div class="code">
	results = spark.<span class="sparkop">sql</span>(<br/>&nbsp;&nbsp;<span class="closure">"SELECT * FROM people"</span>)<br/>
	names = results.<span class="sparkop">map</span>(<span class="closure">lambda p: p.name</span>)<br/>
  </div>
  <div class="caption">Apply functions to results of SQL queries.</div>
</div>