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',path='src/main/resources/people.txt')""")
Best Regards
霍战锋 于2019年8月13日周
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
> below, I can't query any
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
