Re: SELECT from table saved under path

johnb1 · ‎01-27-2023

Hi!

I saved a dataframe as a delta table with the following syntax:

(test_df
  .write
  .format("delta")
  .mode("overwrite")
  .save(output_path)
)

How can I issue a SELECT statement on the table?

What do I need to insert into [table_name] below?

SELECT * FROM [table_name]

Ajay-Pandey · ‎01-27-2023

Hi @John B there is two way to access your delta table-

SELECT * FROM delta.`your_delta_table_path`

df.write.format("delta").mode("overwrite").option("path", "your_path").saveAsTable("table_name")

Now you can use your select query-

SELECT * FROM [table_name]

Ajay Kumar Pandey

johnb1 · ‎01-27-2023

Hi @Ajay Pandey

When trying the first option I get:

Ajay-Pandey · ‎01-27-2023

Hi @John B in the above code instead of your path variable put your absolute path. Please refer to snapshot-

Ajay Kumar Pandey

Ajay-Pandey · ‎01-27-2023

Ajay Kumar Pandey