Hey Gopal, I am using Apache Hive v2.3.2. Here is the explain:
+----------------------------------------------------+ | Explain | +----------------------------------------------------+ | STAGE DEPENDENCIES: | | Stage-1 is a root stage | | Stage-0 depends on stages: Stage-1 | | | | STAGE PLANS: | | Stage: Stage-1 | | Map Reduce | | Map Operator Tree: | | TableScan | | alias: u | | Statistics: Num rows: 1 Data size: 762813939712 Basic stats: PARTIAL Column stats: NONE | | Select Operator | | expressions: xxxx (type: string) | | outputColumnNames: _col0 | | Statistics: Num rows: 1 Data size: 762813939712 Basic stats: PARTIAL Column stats: NONE | | Reduce Output Operator | | key expressions: _col0 (type: string) | | sort order: + | | Statistics: Num rows: 1 Data size: 762813939712 Basic stats: PARTIAL Column stats: NONE | | Reduce Operator Tree: | | Select Operator | | expressions: KEY.reducesinkkey0 (type: string) | | outputColumnNames: _col0 | | Statistics: Num rows: 1 Data size: 762813939712 Basic stats: PARTIAL Column stats: NONE | | Limit | | Number of rows: 20 | | Statistics: Num rows: 1 Data size: 762813939712 Basic stats: PARTIAL Column stats: NONE | | File Output Operator | | compressed: false | | Statistics: Num rows: 1 Data size: 762813939712 Basic stats: COMPLETE Column stats: NONE | | table: | | input format: org.apache.hadoop.mapred.TextInputFormat | | output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat | | serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe | | | | Stage: Stage-0 | | Fetch Operator | | limit: 20 | | Processor Tree: | | ListSink | | | +——————————————————————————+ Mainak > On Feb 6, 2019, at 4:30 PM, Gopal Vijayaraghavan <gop...@apache.org> wrote: > > >> I am running an older version of Hive on MR. Does it have it too? > > Hard to tell without an explain. > > AFAIK, this was fixed in Aug 2013 - how old is your build? > > Cheers, > Gopal > > > >