Write insertInto | teradatamlspk | pyspark2teradataml - Write insertInto - 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

insertInto 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}).insertInto("new_table", overwrite = True)
>>> df1 = teraspark_session.createDataFrame("new_table")
>>> df1
DataFrame[id: int, masters: str, gpa: int, stats: str, programming: str, admitted: str]