???? FAILED: SemanticException [Error 10084]: Stateful UDF's can only be invoked in the SELECT list

Thu, 10 Jul 2014 10:09:15 -0700 

Why is this failing? I am calling it in the SELECT list.


hive> ADD JAR /root/apache-hive-0.13.1-bin/lib/hive-contrib-0.13.1.jar;

hive> CREATE TEMPORARY FUNCTION rowSequence AS 
'org.apache.hadoop.hive.contrib.udf.UDFRowSequence';

hive> CREATE TABLE LOYALTY_CARDS AS
    > SELECT DISTINCT CARD_NBR,
    > rowSequence() AS BW_ID
    > FROM combined_card_table
    > WHERE CARD_NBR > 0
    > SORT BY CARD_NBR;
FAILED: SemanticException [Error 10084]: Stateful UDF's can only be invoked in 
the SELECT list



Thanks, Clay

Reply via email to