| jarodwen | cbbab14 | 2013-02-01 07:56:46 +0000 | [diff] [blame] | 1 | /* |
| 2 | * Description : Create UDF and invoke it in limit clause | ||||
| 3 | * Expected Res : Success | ||||
| 4 | * Date : Sep 5th 2012 | ||||
| 5 | */ | ||||
| 6 | |||||
| 7 | drop dataverse test if exists; | ||||
| 8 | create dataverse test; | ||||
| 9 | |||||
| 10 | write output to nc1:"rttest/user-defined-functions_udf23.adm"; | ||||
| 11 | |||||
| 12 | create function test.numRows(){ | ||||
| 13 | 6 | ||||
| 14 | } | ||||
| 15 | |||||
| 16 | for $l in dataset('Metadata.Dataset') | ||||
| 17 | limit test.numRows() | ||||
| 18 | return $l | ||||