public class SQLTransformer extends Transformer implements DefaultParamsWritable
SQLTransformer supports statements like:
SELECT a, a + b AS a_b FROM __THIS__
SELECT a, SQRT(b) AS b_sqrt FROM __THIS__ where a > 5
SELECT a, b, SUM(c) AS c_sum FROM __THIS__ GROUP BY a, b
| Constructor and Description |
|---|
SQLTransformer() |
SQLTransformer(String uid) |
| Modifier and Type | Method and Description |
|---|---|
SQLTransformer |
copy(ParamMap extra)
Creates a copy of this instance with the same UID and some extra params.
|
String |
getStatement() |
static SQLTransformer |
load(String path) |
static MLReader<T> |
read() |
SQLTransformer |
setStatement(String value) |
Param<String> |
statement()
SQL statement parameter.
|
Dataset<Row> |
transform(Dataset<?> dataset)
Transforms the input dataset.
|
StructType |
transformSchema(StructType schema)
:: DeveloperApi ::
|
String |
uid()
An immutable unique ID for the object and its derivatives.
|
transform, transform, transformequals, getClass, hashCode, notify, notifyAll, toString, wait, wait, waitwritesaveclear, copyValues, defaultCopy, defaultParamMap, explainParam, explainParams, extractParamMap, extractParamMap, get, getDefault, getOrDefault, getParam, hasDefault, hasParam, isDefined, isSet, paramMap, params, set, set, set, setDefault, setDefault, shouldOwntoStringinitializeLogging, initializeLogIfNecessary, initializeLogIfNecessary, isTraceEnabled, log_, log, logDebug, logDebug, logError, logError, logInfo, logInfo, logName, logTrace, logTrace, logWarning, logWarningpublic SQLTransformer(String uid)
public SQLTransformer()
public static SQLTransformer load(String path)
public static MLReader<T> read()
public String uid()
Identifiableuid in interface Identifiablepublic final Param<String> statement()
public SQLTransformer setStatement(String value)
public String getStatement()
public Dataset<Row> transform(Dataset<?> dataset)
Transformertransform in class Transformerdataset - (undocumented)public StructType transformSchema(StructType schema)
PipelineStageCheck transform validity and derive the output schema from the input schema.
We check validity for interactions between parameters during transformSchema and
raise an exception if any parameter value is invalid. Parameter value checks which
do not depend on other parameters are handled by Param.validate().
Typical implementation should first conduct verification on schema change and parameter validity, including complex parameter interaction checks.
transformSchema in class PipelineStageschema - (undocumented)public SQLTransformer copy(ParamMap extra)
ParamsdefaultCopy().copy in interface Paramscopy in class Transformerextra - (undocumented)