Write saveAsTable | teradatamlspk | pyspark2teradataml - Write saveAsTable - Teradata Vantage

Teradata® VantageCloud Lake

Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

saveAsTable provides capability of changing the type of column while saving the table.

Example

>>> df
DataFrame[id: int, masters: str, gpa: float, stats: str, programming: str, admitted: int]
>>> from teradatasqlalchemy import VARCHAR
>>> from teradatasqlalchemy import INTEGER
>>> df.write.options(types = {'admitted': VARCHAR, 'gpa':INTEGER}).saveAsTable("new_table", mode = "overwrite")
>>> df1 = teraspark_session.createDataFrame("new_table")
>>> df1
DataFrame[id: int, masters: str, gpa: int, stats: str, programming: str, admitted: str]