Re: Sreate temp table or view by using location

It works by using "create temp view" and "options(path='something')" together, thanks. spark.sql("""create temp view people (name string, age int) using csv options(sep=',',inferSchema='true',ignoreLeadingWhiteSpace='true'

Re: Sreate temp table or view by using location

Sorry for the typo. The title is 'Create temp table or view by using location'. Best Regards 霍战锋 于2019年8月13日周二 下午8:00写道： > Hi, > > I'm trying to use spark SQL to define a temp table which can be > destroyed automatically with the session. But when I using the SQL as

Sreate temp table or view by using location

Hi, I'm trying to use spark SQL to define a temp table which can be destroyed automatically with the session. But when I using the SQL as below, I can't query any valid row, meanwhile, it works when I delete the word 'temp'. Is there anyone can tell me how to write the right SQL? It doesn't wor