I dont think you can do this directly in a query. (I can be wrong) I just asked took suggestion from a hive guru and he suggested to try lateral view
https://cwiki.apache.org/Hive/languagemanual-lateralview.html On Thu, Jan 10, 2013 at 1:42 AM, Mathieu Despriee <mdespr...@octo.com>wrote: > 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 >> > > -- Nitin Pawar
