python/ml/sql_transformer.py

0001 #
0002 # Licensed to the Apache Software Foundation (ASF) under one or more
0003 # contributor license agreements.  See the NOTICE file distributed with
0004 # this work for additional information regarding copyright ownership.
0005 # The ASF licenses this file to You under the Apache License, Version 2.0
0006 # (the "License"); you may not use this file except in compliance with
0007 # the License.  You may obtain a copy of the License at
0008 #
0009 #    http://www.apache.org/licenses/LICENSE-2.0
0010 #
0011 # Unless required by applicable law or agreed to in writing, software
0012 # distributed under the License is distributed on an "AS IS" BASIS,
0013 # WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
0014 # See the License for the specific language governing permissions and
0015 # limitations under the License.
0016 #
0017
0018 from __future__ import print_function
0019
0020 # $example on$
0021 from pyspark.ml.feature import SQLTransformer
0022 # $example off$
0023 from pyspark.sql import SparkSession
0024
0025 if __name__ == "__main__":
0026     spark = SparkSession\
0027         .builder\
0028         .appName("SQLTransformerExample")\
0029         .getOrCreate()
0030
0031     # $example on$
0032     df = spark.createDataFrame([
0033         (0, 1.0, 3.0),
0034         (2, 2.0, 5.0)
0035     ], ["id", "v1", "v2"])
0036     sqlTrans = SQLTransformer(
0037         statement="SELECT *, (v1 + v2) AS v3, (v1 * v2) AS v4 FROM __THIS__")
0038     sqlTrans.transform(df).show()
0039     # $example off$
0040
0041     spark.stop()