/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. 

  2. 

  3. drop temporary function row_sequence;
    4. 

  4. 

  5. add jar ${system:build.dir}/hive-contrib-${system:hive.version}.jar;
    6. 

  6. 

  7. create temporary function row_sequence as 
    8. 

  8. 'org.apache.hadoop.hive.contrib.udf.UDFRowSequence';
    9. 

  9. 

  10. select key
    11. 

  11. from (select key from src order by key) x
    12. 

  12. where row_sequence() < 5
    13. 

  13. order by key;
    14.