Description

outputColNames CAN NOT have the same colName with reservedColName except the selectedColName.

Parameters

Name Description Type Required？ Default Value
selectedCols Names of the columns used for processing String[] ✓
outputCols Names of the output columns String[] ✓
reservedCols Names of the columns to be retained in the output table String[] null

Script Example

Code

  1. class SplitOp(object):
  2.     def eval(self, *args):
  3.         for index, x in enumerate(args):
  4.             yield index, x
  5.     pass
  7. source = CsvSourceBatchOp()\
  8.     .setSchemaStr("sepal_length double, sepal_width double, petal_length double, petal_width double, category string")\
  9.     .setFilePath("https://alink-release.oss-cn-beijing.aliyuncs.com/data-files/iris.csv")
  10. udtfOp = UDTFBatchOp() \
  11.     .setFunc(SplitOp()) \
  12.     .setResultTypes(["LONG", "DOUBLE"]) \
  13.     .setSelectedCols(['sepal_length', 'sepal_width']) \
  14.     .setOutputCols(['index', 'x'])
  15. udtf_res = udtfOp.linkFrom(source)
  17. udtf_res.firstN(10).print()

Results

  1.    index    x
  2. 0      0  5.1
  3. 1      1  3.5
  4. 2      0  5.0
  5. 3      1  2.0
  6. 4      0  5.0
  7. 5      1  3.2
  8. 6      0  6.6
  9. 7      0  5.1
  10. 8      1  3.7
  11. 9      0  6.4