擅长:python、mysql、java
<p>您还可以使用三重引号编写多行字符串sql查询,如下所示:</p>
<pre><code>spark.sql("""
Select acts.accountname, acts.county_state,loc.Town, acts.country
from assure_crm_accounts acts
inner join assure_crm_accountlocation loc
on acts.GPAddressCode = loc.GPAddressCode
"""
)
</code></pre>