I never ran into this kind of problem but can you try select as A,B,C
On Thu, Jan 10, 2013 at 12:58 AM, Mathieu Despriee <mdespr...@octo.com>wrote: > SELECT stack(2,AppWeb, ByteWeb, PacketWeb, AppP2P, ByteP2P, PacketP2P) AS > A FROM testApp2; > > > 2013/1/10 Nitin Pawar <nitinpawar...@gmail.com> > >> can you provide your query ? >> >> >> On Thu, Jan 10, 2013 at 12:39 AM, Mathieu Despriee <mdespr...@octo.com>wrote: >> >>> 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 >> > > -- Nitin Pawar
