colRegex | teradatamlspk | pyspark2teradataml - colRegex - Teradata VantageCloud Lake

Lake - Analyze Your Data with ClearScape Analytics™

Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2026-02-20
dita:mapPath
tcl1683670667798.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
tcl1683670667798

For the colRegex function, PySpark returns result based on Scala or Java regex; teradatamlspk returns based on Python RegEx.

The following two examples show that the return are different in PySpark and teradatamlspk.

PySpark

df.select(df.colRegex("`(Col.)`")).show()
+----+----+
|Col1|Col2|
+----+----+
|   a|   1|
|   b|   2|
|   c|   3|
+----+----+

teradatamlspk

>>> df.select(df.colRegex("(Col.)")).show()
+----+----+
|Col1|Col2|
+----+----+
|   c|   3|
|   b|   2|
|   a|   1|
+----+----+