12345678910111213141516171819202122 |
- /* syntax version 1 */
- /* postgres can not */
- /* dq file can not */
- $udfScript = @@
- def MyFunc(stream):
- return stream
- @@;
- $record = (SELECT TableRow() FROM plato.Input);
- $recordType = TypeOf(Unwrap($record));
- $streamType = StreamType(VariantType(TupleType($recordType, $recordType, $recordType)));
- $udf = Python3::MyFunc(CallableType(0, $streamType, $streamType), $udfScript);
- $src = (select * from plato.Input where key > "200");
- $i, $j, $k = (PROCESS plato.Input, (select * from plato.Input where key > "100"), $src USING $udf(TableRows()));
- select * from $i;
- select * from $j;
- select * from $k;
|