invalid_row_sequence.q

/tags/release-0.2.0-rc0/hive/external/contrib/src/test/queries/clientnegative/invalid_row_sequence.q

#
text | 13 lines | 9 code | 4 blank | 0 comment | 0 complexity | f93442f1923f01ca905ecde62b07bdd1 MD5 | raw file

 1-- Verify that a stateful UDF cannot be used outside of the SELECT list
 2
 3drop temporary function row_sequence;
 4
 5add jar ${system:build.dir}/hive-contrib-${system:hive.version}.jar;
 6
 7create temporary function row_sequence as 
 8'org.apache.hadoop.hive.contrib.udf.UDFRowSequence';
 9
10select key
11from (select key from src order by key) x
12where row_sequence() < 5
13order by key;