Hubert-Dudek
Databricks MVP
In response to thushar

‎01-23-2023 05:43 AM

Maybe try something like 

df.createOrReplaceTempView("my_table")
 
spark.sql("CREATE TABLE rectangles(
  a INT,
  b INT,
  area INT GENERATED ALWAYS AS (a * b)
);
INSERT INTO rectangles (a, b)
select
  a,
  b
FROM
  my_table)


My blog: https://databrickster.medium.com/
0 Kudos