Hi
What you are trying to do does not make sense. I suggest you to understand
how Views work in SQL. IMHO you are better off creating a table.
Ayan
On Fri, 6 Jan 2023 at 12:20 am, Stelios Philippou
wrote:
> Vajiha,
>
> I dont see your query working as you hope it will.
>
> spark.sql will execu
Vajiha,
I dont see your query working as you hope it will.
spark.sql will execute a query on a database level
to retrieve the temp view you need to go from the sessions.
i.e
session.sql("SELECT * FROM TEP_VIEW")
You might need to retrieve the data in a collection and iterate over them
to do ba
Vajiha,
I believe that you might be confusing stuff ?
Permanent View in PSQL is a standard view.
Temp view or Global View is the Spark View that is internal for Spark.
Can we get a snippet of the code please.
On Wed, 4 Jan 2023 at 15:10, Vajiha Begum S A
wrote:
>
> I have tried to Create a p
