hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Clay McDonald <stuart.mcdon...@bateswhite.com>
Subject ???? FAILED: SemanticException [Error 10084]: Stateful UDF's can only be invoked in the SELECT list
Date Thu, 10 Jul 2014 17:08:20 GMT
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

Mime
View raw message