Return-Path: Delivered-To: apmail-hadoop-hive-user-archive@minotaur.apache.org Received: (qmail 53468 invoked from network); 18 Mar 2009 08:47:06 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 18 Mar 2009 08:47:06 -0000 Received: (qmail 57301 invoked by uid 500); 18 Mar 2009 08:47:06 -0000 Delivered-To: apmail-hadoop-hive-user-archive@hadoop.apache.org Received: (qmail 57204 invoked by uid 500); 18 Mar 2009 08:47:05 -0000 Mailing-List: contact hive-user-help@hadoop.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: hive-user@hadoop.apache.org Delivered-To: mailing list hive-user@hadoop.apache.org Received: (qmail 57195 invoked by uid 99); 18 Mar 2009 08:47:05 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 18 Mar 2009 01:47:05 -0700 X-ASF-Spam-Status: No, hits=2.2 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of zshao9@gmail.com designates 74.125.44.29 as permitted sender) Received: from [74.125.44.29] (HELO yx-out-2324.google.com) (74.125.44.29) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 18 Mar 2009 08:47:00 +0000 Received: by yx-out-2324.google.com with SMTP id 3so275801yxj.29 for ; Wed, 18 Mar 2009 01:46:39 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:content-type; bh=sjI6kyu331mMSEAtHAnNwSNDdWrCf0ZFxEoHaWU1IKM=; b=dhIe4HG4gp//VcoDbC8oce8Amy1GH5IBRMNIXLe1gLlfqEFBnhqT/OTwMq6R1IBAlF OlWE/esKEMAXMIih3WpxMKE9Ha7CwjFFJgpSUbuVGAWF31qpecgCxWEsCMF91yp8t/Lq jy0xKXOkOsX85tchZ6ri2QXf2oKT19iS9Bd70= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; b=d94VtWOPDXTCwfnOA+16pJVb0vWmTWwJr9IiytCSDFLFUSbRat/I4v2q1eakbrtzc4 AL4LFp6PJ8eQwnkxe8DZfC7oPhfswbHpnQWLnAxdAthiLjNyOtt1I/MNaUuzlaTwtPR1 fJ5ETRfSxwUnk8vGsczvgpeLGnPMuQldwHHT8= MIME-Version: 1.0 Received: by 10.100.138.17 with SMTP id l17mr1215977and.76.1237365998869; Wed, 18 Mar 2009 01:46:38 -0700 (PDT) In-Reply-To: References: <34fd060d0903171056k5e49e35ava4319cc01ddfbbac@mail.gmail.com> Date: Wed, 18 Mar 2009 01:46:38 -0700 Message-ID: <34fd060d0903180146j7e1e8104pce4b8dac7969fdf9@mail.gmail.com> Subject: Re: NullPointerException when using join on table with map column From: Zheng Shao To: hive-user@hadoop.apache.org Content-Type: multipart/alternative; boundary=001485f54734d1e041046560b81e X-Virus-Checked: Checked by ClamAV on apache.org --001485f54734d1e041046560b81e Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Hi Stephen, Maps are not expected to have a null value in Hive, because we use java HashMap internally to store the Maps. Zheng On Tue, Mar 17, 2009 at 11:09 AM, Stephen Corona wrote: > Are map's allowed to have a key with a null value? Or does it expect every > key to have a non-null value? > > Steve > ________________________________________ > From: Zheng Shao [zshao9@gmail.com] > Sent: Tuesday, March 17, 2009 1:56 PM > To: hive-user@hadoop.apache.org > Subject: Re: NullPointerException when using join on table with map column > > Hi, > > It seems DynamicSerde has problems with the null values somewhere. We > are working on replacing it with LazySimpleSerDe. > > In the meanwhile, please use subquery and the problem should disappear. > > Select count(1), mykey from (Select id, mymap['mykey'] as mykey from > tablea) tablea join tableb on tablea.id = tableb.id group by mykey; > > Zheng > > > On 3/17/09, Stephen Corona wrote: > > Hey guys. I am trying to run a query like: > > > > select count(1), request.attributes['category_selection_method'] from > > request left outer join test on request.recipient_id = test.recipient_id > > group by request.attributes['category_selection_method']; > > > > I can run the query WITHOUT the join and it works fine. I can also run > the > > query with the join if I don't reference the attributes column (i.e, the > > map). Is there a problem with doing joins when a table has a map column? > > > > However, when I run this query I get the following error: > > > > java.lang.RuntimeException: org.apache.hadoop.hive.serde2.SerDeException: > > java.lang.NullPointerException > > at > org.apache.hadoop.hive.ql.exec.ExecMapper.map(ExecMapper.java:75) > > at org.apache.hadoop.mapred.MapRunner.run(MapRunner.java:50) > > at org.apache.hadoop.mapred.MapTask.run(MapTask.java:332) > > at org.apache.hadoop.mapred.Child.main(Child.java:155) > > Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: > > org.apache.hadoop.hive.serde2.SerDeException: > java.lang.NullPointerException > > at > > > org.apache.hadoop.hive.ql.exec.ReduceSinkOperator.process(ReduceSinkOperator.java:191) > > at > org.apache.hadoop.hive.ql.exec.Operator.forward(Operator.java:315) > > at > > > org.apache.hadoop.hive.ql.exec.SelectOperator.process(SelectOperator.java:89) > > at > org.apache.hadoop.hive.ql.exec.Operator.forward(Operator.java:315) > > at > > > org.apache.hadoop.hive.ql.exec.TableScanOperator.process(TableScanOperator.java:49) > > at > org.apache.hadoop.hive.ql.exec.Operator.forward(Operator.java:315) > > at > org.apache.hadoop.hive.ql.exec.MapOperator.process(MapOperator.java:178) > > at > org.apache.hadoop.hive.ql.exec.ExecMapper.map(ExecMapper.java:71) > > ... 3 more > > Caused by: org.apache.hadoop.hive.serde2.SerDeException: > > java.lang.NullPointerException > > at > > > org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe.serialize(DynamicSerDe.java:178) > > at > > > org.apache.hadoop.hive.ql.exec.ReduceSinkOperator.process(ReduceSinkOperator.java:189) > > ... 10 more > > Caused by: java.lang.NullPointerException > > at > > > org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDeTypeMap.serialize(DynamicSerDeTypeMap.java:136) > > at > > > org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDeFieldList.serialize(DynamicSerDeFieldList.java:249) > > at > > > org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDeStructBase.serialize(DynamicSerDeStructBase.java:81) > > at > > > org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe.serialize(DynamicSerDe.java:174) > > ... 11 more > > > > > > describe request- > > > > request_id string > > attributes map > > day string > > > > create table for request: > > > > create table request ( > > request_id > > attributes map > > ) > > row format delimited fields terminated by '\001' collection items > terminated > > by '\003' map keys terminated by '\002'; > > > > describe test- > > recipient_id string > > > > explain query > > > > ABSTRACT SYNTAX TREE: > > (TOK_QUERY (TOK_FROM (TOK_LEFTOUTERJOIN (TOK_TABREF request) > (TOK_TABREF > > test) (= (TOK_COLREF request recipient_id) (TOK_COLREF test > recipient_id)))) > > (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT > > (TOK_SELEXPR (TOK_FUNCTION count 1)) (TOK_SELEXPR ([ (TOK_COLREF request > > attributes) 'category_selection_method'))) (TOK_GROUPBY ([ (TOK_COLREF > > request attributes) 'category_selection_method')))) > > > > STAGE DEPENDENCIES: > > Stage-1 is a root stage > > Stage-2 depends on stages: Stage-1 > > Stage-0 is a root stage > > > > STAGE PLANS: > > Stage: Stage-1 > > Map Reduce > > Alias -> Map Operator Tree: > > test > > Reduce Output Operator > > key expressions: > > expr: recipient_id > > type: string > > sort order: + > > Map-reduce partition columns: > > expr: recipient_id > > type: string > > tag: 1 > > value expressions: > > expr: recipient_id > > type: string > > request > > Select Operator > > expressions: > > expr: recipient_id > > type: string > > expr: attributes > > type: map > > Reduce Output Operator > > key expressions: > > expr: 0 > > type: string > > sort order: + > > Map-reduce partition columns: > > expr: 0 > > type: string > > tag: 0 > > value expressions: > > expr: 0 > > type: string > > expr: 1 > > type: map > > Reduce Operator Tree: > > Join Operator > > condition map: > > Left Outer Join0 to 1 > > condition expressions: > > 0 {VALUE.0} {VALUE.1} > > 1 {VALUE.0} > > Group By Operator > > aggregations: > > expr: count(1) > > keys: > > expr: 1['category_selection_method'] > > type: string > > mode: hash > > File Output Operator > > compressed: false > > GlobalTableId: 0 > > table: > > input format: > > org.apache.hadoop.mapred.SequenceFileInputFormat > > output format: > > org.apache.hadoop.mapred.SequenceFileOutputFormat > > name: binary_table > > > > Stage: Stage-2 > > Map Reduce > > Alias -> Map Operator Tree: > > /tmp/hive-root/532094399/571818099.10002 > > Reduce Output Operator > > key expressions: > > expr: 0 > > type: string > > sort order: + > > Map-reduce partition columns: > > expr: 0 > > type: string > > tag: -1 > > value expressions: > > expr: 1 > > type: bigint > > Reduce Operator Tree: > > Group By Operator > > aggregations: > > expr: count(VALUE.0) > > keys: > > expr: KEY.0 > > type: string > > mode: mergepartial > > Select Operator > > expressions: > > expr: 1 > > type: bigint > > expr: 0 > > type: string > > File Output Operator > > compressed: false > > GlobalTableId: 0 > > table: > > input format: org.apache.hadoop.mapred.TextInputFormat > > output format: > > org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat > > > > Stage: Stage-0 > > Fetch Operator > > limit: -1 > > > > > > > > -- > Sent from Gmail for mobile | mobile.google.com > > Yours, > Zheng > -- Yours, Zheng --001485f54734d1e041046560b81e Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Hi Stephen,

Maps are not expected to have a null value in Hive, beca= use we use java HashMap internally to store the Maps.

Zheng

<= div class=3D"gmail_quote">On Tue, Mar 17, 2009 at 11:09 AM, Stephen Corona = <scorona@ad= knowledge.com> wrote:
Are map's all= owed to have a key with a null value? Or does it expect every key to have a= non-null value?

Steve
________________________________________
From: Zheng Shao [zshao9@gmail.com]=
Sent: Tuesday, March 17, 2009 1:56 PM
To: hive-user@hadoop.apache.= org
Subject: Re: NullPointerException when using join on table with map column<= br>

Hi,

It seems DynamicSerde has problems with the null values somewhere. We
are working on replacing it with LazySimpleSerDe.

In the meanwhile, please use subquery and the problem should disappear.

Select count(1), mykey from (Select id, mymap['mykey'] as mykey fro= m
tablea) tablea join tableb on tablea.id =3D tableb.i= d group by mykey;

Zheng


On 3/17/09, Stephen Corona <s= corona@adknowledge.com> wrote:
> Hey guys. I am trying to run a query like:
>
> select count(1), request.attributes['category_selection_method'= ;] from
> request left outer join test on request.recipient_id =3D test.recipien= t_id
> group by request.attributes['category_selection_method'];
>
> I can run the query WITHOUT the join and it works fine. I can also run= the
> query with the join if I don't reference the attributes column (i.= e, the
> map). Is there a problem with doing joins when a table has a map colum= n?
>
> However, when I run this query I get the following error:
>
> java.lang.RuntimeException: org.apache.hadoop.hive.serde2.SerDeExcepti= on:
> java.lang.NullPointerException
> =A0 =A0 =A0 at org.apache.hadoop.hive.ql.exec.ExecMapper.map(ExecMappe= r.java:75)
> =A0 =A0 =A0 at org.apache.hadoop.mapred.MapRunner.run(MapRunner.java:5= 0)
> =A0 =A0 =A0 at org.apache.hadoop.mapred.MapTask.run(MapTask.java:332)<= br> > =A0 =A0 =A0 at org.apache.hadoop.mapred.Child.main(Child.java:155)
> Caused by: org.apache.hadoop.hive.ql.metadata.HiveException:
> org.apache.hadoop.hive.serde2.SerDeException: java.lang.NullPointerExc= eption
> =A0 =A0 =A0 at
> org.apache.hadoop.hive.ql.exec.ReduceSinkOperator.process(ReduceSinkOp= erator.java:191)
> =A0 =A0 =A0 at org.apache.hadoop.hive.ql.exec.Operator.forward(Operato= r.java:315)
> =A0 =A0 =A0 at
> org.apache.hadoop.hive.ql.exec.SelectOperator.process(SelectOperator.j= ava:89)
> =A0 =A0 =A0 at org.apache.hadoop.hive.ql.exec.Operator.forward(Operato= r.java:315)
> =A0 =A0 =A0 at
> org.apache.hadoop.hive.ql.exec.TableScanOperator.process(TableScanOper= ator.java:49)
> =A0 =A0 =A0 at org.apache.hadoop.hive.ql.exec.Operator.forward(Operato= r.java:315)
> =A0 =A0 =A0 at org.apache.hadoop.hive.ql.exec.MapOperator.process(MapO= perator.java:178)
> =A0 =A0 =A0 at org.apache.hadoop.hive.ql.exec.ExecMapper.map(ExecMappe= r.java:71)
> =A0 =A0 =A0 ... 3 more
> Caused by: org.apache.hadoop.hive.serde2.SerDeException:
> java.lang.NullPointerException
> =A0 =A0 =A0 at
> org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe.serialize(Dyna= micSerDe.java:178)
> =A0 =A0 =A0 at
> org.apache.hadoop.hive.ql.exec.ReduceSinkOperator.process(ReduceSinkOp= erator.java:189)
> =A0 =A0 =A0 ... 10 more
> Caused by: java.lang.NullPointerException
> =A0 =A0 =A0 at
> org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDeTypeMap.seriali= ze(DynamicSerDeTypeMap.java:136)
> =A0 =A0 =A0 at
> org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDeFieldList.seria= lize(DynamicSerDeFieldList.java:249)
> =A0 =A0 =A0 at
> org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDeStructBase.seri= alize(DynamicSerDeStructBase.java:81)
> =A0 =A0 =A0 at
> org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe.serialize(Dyna= micSerDe.java:174)
> =A0 =A0 =A0 ... 11 more
>
>
> describe request-
>
> request_id =A0 =A0 =A0string
> attributes =A0 =A0map<string,string>
> day =A0 string
>
> create table for request:
>
> create table request (
> request_id
> attributes map <string, string>
> )
> row format delimited fields terminated by '\001' collection it= ems terminated
> by '\003' map keys terminated by '\002';
>
> describe test-
> recipient_id string
>
> explain query
>
> ABSTRACT SYNTAX TREE:
> =A0 (TOK_QUERY (TOK_FROM (TOK_LEFTOUTERJOIN (TOK_TABREF request) (TOK_= TABREF
> test) (=3D (TOK_COLREF request recipient_id) (TOK_COLREF test recipien= t_id))))
> (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT
> (TOK_SELEXPR (TOK_FUNCTION count 1)) (TOK_SELEXPR ([ (TOK_COLREF reque= st
> attributes) 'category_selection_method'))) (TOK_GROUPBY ([ (TO= K_COLREF
> request attributes) 'category_selection_method'))))
>
> STAGE DEPENDENCIES:
> =A0 Stage-1 is a root stage
> =A0 Stage-2 depends on stages: Stage-1
> =A0 Stage-0 is a root stage
>
> STAGE PLANS:
> =A0 Stage: Stage-1
> =A0 =A0 Map Reduce
> =A0 =A0 =A0 Alias -> Map Operator Tree:
> =A0 =A0 =A0 =A0 test
> =A0 =A0 =A0 =A0 =A0 =A0 Reduce Output Operator
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 key expressions:
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 expr: recipient_id
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 type: string
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 sort order: +
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 Map-reduce partition columns:
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 expr: recipient_id
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 type: string
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 tag: 1
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 value expressions:
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 expr: recipient_id
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 type: string
> =A0 =A0 =A0 =A0 request
> =A0 =A0 =A0 =A0 =A0 =A0 Select Operator
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 expressions:
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 expr: recipient_id
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 type: string
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 expr: attributes
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 type: map<string,string>=
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 Reduce Output Operator
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 key expressions:
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 expr: 0
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 type: string
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 sort order: +
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 Map-reduce partition columns:
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 expr: 0
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 type: string
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 tag: 0
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 value expressions:
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 expr: 0
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 type: string
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 expr: 1
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 type: map<string,string= >
> =A0 =A0 =A0 Reduce Operator Tree:
> =A0 =A0 =A0 =A0 Join Operator
> =A0 =A0 =A0 =A0 =A0 condition map:
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0Left Outer Join0 to 1
> =A0 =A0 =A0 =A0 =A0 condition expressions:
> =A0 =A0 =A0 =A0 =A0 =A0 0 {VALUE.0} {VALUE.1}
> =A0 =A0 =A0 =A0 =A0 =A0 1 {VALUE.0}
> =A0 =A0 =A0 =A0 =A0 Group By Operator
> =A0 =A0 =A0 =A0 =A0 =A0 aggregations:
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 expr: count(1)
> =A0 =A0 =A0 =A0 =A0 =A0 keys:
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 expr: 1['category_selection_me= thod']
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 type: string
> =A0 =A0 =A0 =A0 =A0 =A0 mode: hash
> =A0 =A0 =A0 =A0 =A0 =A0 File Output Operator
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 compressed: false
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 GlobalTableId: 0
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 table:
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 input format:
> org.apache.hadoop.mapred.SequenceFileInputFormat
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 output format:
> org.apache.hadoop.mapred.SequenceFileOutputFormat
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 name: binary_table
>
> =A0 Stage: Stage-2
> =A0 =A0 Map Reduce
> =A0 =A0 =A0 Alias -> Map Operator Tree:
> =A0 =A0 =A0 =A0 /tmp/hive-root/532094399/571818099.10002
> =A0 =A0 =A0 =A0 =A0 Reduce Output Operator
> =A0 =A0 =A0 =A0 =A0 =A0 key expressions:
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 expr: 0
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 type: string
> =A0 =A0 =A0 =A0 =A0 =A0 sort order: +
> =A0 =A0 =A0 =A0 =A0 =A0 Map-reduce partition columns:
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 expr: 0
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 type: string
> =A0 =A0 =A0 =A0 =A0 =A0 tag: -1
> =A0 =A0 =A0 =A0 =A0 =A0 value expressions:
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 expr: 1
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 type: bigint
> =A0 =A0 =A0 Reduce Operator Tree:
> =A0 =A0 =A0 =A0 Group By Operator
> =A0 =A0 =A0 =A0 =A0 aggregations:
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 expr: count(VALUE.0)
> =A0 =A0 =A0 =A0 =A0 keys:
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 expr: KEY.0
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 type: string
> =A0 =A0 =A0 =A0 =A0 mode: mergepartial
> =A0 =A0 =A0 =A0 =A0 Select Operator
> =A0 =A0 =A0 =A0 =A0 =A0 expressions:
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 expr: 1
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 type: bigint
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 expr: 0
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 type: string
> =A0 =A0 =A0 =A0 =A0 =A0 File Output Operator
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 compressed: false
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 GlobalTableId: 0
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 table:
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 input format: org.apache.hadoop.ma= pred.TextInputFormat
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 output format:
> org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
>
> =A0 Stage: Stage-0
> =A0 =A0 Fetch Operator
> =A0 =A0 =A0 limit: -1
>
>
>

--
Sent from Gmail for mobile | mobile.google.com

Yours,
Zheng



--
Yours,
Z= heng
--001485f54734d1e041046560b81e--