Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
Hive, mail # user - Stack function in Hive : how to specify multiple aliases?


Copy link to this message
-
Stack function in Hive : how to specify multiple aliases?
Mathieu Despriee 2013-01-10, 08:39
Hi folks,

I want to use the stack function, described here :
https://cwiki.apache.org/Hive/languagemanual-udf.html#LanguageManualUDF-BuiltinTableGeneratingFunctions%2528UDTF%2529

Hive asks me to provide the multiple aliases for the resulting columns
("The number of aliases in the AS clause does not match the number of
colums output by the UDTF, expected 3 aliases but got 1").

What's the syntax to provide multiple aliases ?

Thanks,
Mathieu
+
Nitin Pawar 2013-01-10, 08:43
+
Mathieu Despriee 2013-01-10, 08:58
+
Nitin Pawar 2013-01-10, 09:08
+
Mathieu Despriee 2013-01-10, 09:42
+
Dean Wampler 2013-01-10, 14:13
+
Mathieu Despriee 2013-01-11, 15:00
+
Nitin Pawar 2013-01-10, 10:14