Not working either : SELECT stack(2,AppWeb, ByteWeb, PacketWeb, AppP2P, ByteP2P, PacketP2P) AS App,Byte,Packet FROM testApp2; > FAILED: SemanticException 1:76 Only a single expression in the SELECT clause is supported with UDTF's. Error encountered near token 'Byte'
I tried to quote the aliases or to use array-style with no luck. Is there any description of hive grammar somewhere ? I only found this doc : https://cwiki.apache.org/Hive/languagemanual-select.html, but "select_expr" is not described .... 2013/1/10 Nitin Pawar <nitinpawar...@gmail.com> > 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 >
