spark-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From 霍战锋 <huozhanf...@gmail.com>
Subject Re: Sreate temp table or view by using location
Date Tue, 13 Aug 2019 12:03:22 GMT
Sorry for the typo. The title is 'Create temp table or view by using
location'.
Best Regards


霍战锋 <huozhanfeng@gmail.com> 于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 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 work like this one.
> spark.sql("create temp view people (name string, age int) using csv options(sep=',',inferSchema='true',ignoreLeadingWhiteSpace='true')
location 'src/main/resources/people.txt'")
>
> It works like this one, but it's not a temp table.
> spark.sql("create view people (name string, age int) using csv options(sep=',',inferSchema='true',ignoreLeadingWhiteSpace='true')
location 'src/main/resources/people.txt'")
>
> As a repetition, I would like to use SQL to get the same result as
> 'dataset.createOrReplaceTempView(table name)'.
>
> Thank you.
>
> Best Regards
>

Mime
View raw message