You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@hive.apache.org by Clay McDonald <st...@bateswhite.com> on 2014/07/10 19:08:20 UTC

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

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