FAQ
Author: jpullokk
Date: Thu Jan 15 22:15:40 2015
New Revision: 1652286

URL: http://svn.apache.org/r1652286
Log:
HIVE-9194: Support select distinct * (Pengcheng Xiong via Laljo John Pullokkaran)

Added:
     hive/trunk/ql/src/test/queries/clientnegative/selectDistinctStarNeg_1.q
     hive/trunk/ql/src/test/queries/clientnegative/selectDistinctStarNeg_2.q
     hive/trunk/ql/src/test/queries/clientpositive/selectDistinctStar.q
     hive/trunk/ql/src/test/results/clientnegative/selectDistinctStarNeg_1.q.out
     hive/trunk/ql/src/test/results/clientnegative/selectDistinctStarNeg_2.q.out
     hive/trunk/ql/src/test/results/clientpositive/selectDistinctStar.q.out
     hive/trunk/ql/src/test/results/clientpositive/tez/selectDistinctStar.q.out
Modified:
     hive/trunk/itests/src/test/resources/testconfiguration.properties
     hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/CalcitePlanner.java
     hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java
     hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/UnparseTranslator.java

Modified: hive/trunk/itests/src/test/resources/testconfiguration.properties
URL: http://svn.apache.org/viewvc/hive/trunk/itests/src/test/resources/testconfiguration.properties?rev=1652286&r1=1652285&r2=1652286&view=diff
==============================================================================
--- hive/trunk/itests/src/test/resources/testconfiguration.properties (original)
+++ hive/trunk/itests/src/test/resources/testconfiguration.properties Thu Jan 15 22:15:40 2015
@@ -140,6 +140,7 @@ minitez.query.files.shared=alter_merge_2
    parallel.q,\
    ptf.q,\
    sample1.q,\
+ selectDistinctStar.q,\
    script_env_var1.q,\
    script_env_var2.q,\
    script_pipe.q,\

Modified: hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/CalcitePlanner.java
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/CalcitePlanner.java?rev=1652286&r1=1652285&r2=1652286&view=diff
==============================================================================
--- hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/CalcitePlanner.java (original)
+++ hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/CalcitePlanner.java Thu Jan 15 22:15:40 2015
@@ -1734,6 +1734,23 @@ public class CalcitePlanner extends Sema
        // 1. Gather GB Expressions (AST) (GB + Aggregations)
        // NOTE: Multi Insert is not supported
        String detsClauseName = qbp.getClauseNames().iterator().next();
+ // Check and transform group by *. This will only happen for select distinct *.
+ // Here the "genSelectPlan" is being leveraged.
+ // The main benefits are (1) remove virtual columns that should
+ // not be included in the group by; (2) add the fully qualified column names to unParseTranslator
+ // so that view is supported. The drawback is that an additional SEL op is added. If it is
+ // not necessary, it will be removed by NonBlockingOpDeDupProc Optimizer because it will match
+ // SEL%SEL% rule.
+ ASTNode selExprList = qb.getParseInfo().getSelForClause(detsClauseName);
+ if (selExprList.getToken().getType() == HiveParser.TOK_SELECTDI
+ && selExprList.getChildCount() == 1 && selExprList.getChild(0).getChildCount() == 1) {
+ ASTNode node = (ASTNode) selExprList.getChild(0).getChild(0);
+ if (node.getToken().getType() == HiveParser.TOK_ALLCOLREF) {
+ srcRel = genSelectLogicalPlan(qb, srcRel, srcRel);
+ RowResolver rr = this.relToHiveRR.get(srcRel);
+ qbp.setSelExprForClause(detsClauseName, SemanticAnalyzer.genSelectDIAST(rr));
+ }
+ }
        List<ASTNode> grpByAstExprs = SemanticAnalyzer.getGroupByForClause(qbp, detsClauseName);
        HashMap<String, ASTNode> aggregationTrees = qbp.getAggregationExprsForClause(detsClauseName);
        boolean hasGrpByAstExprs = (grpByAstExprs != null && !grpByAstExprs.isEmpty()) ? true : false;

Modified: hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java?rev=1652286&r1=1652285&r2=1652286&view=diff
==============================================================================
--- hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java (original)
+++ hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java Thu Jan 15 22:15:40 2015
@@ -38,6 +38,7 @@ import java.util.regex.Pattern;
  import java.util.regex.PatternSyntaxException;

  import org.antlr.runtime.ClassicToken;
+import org.antlr.runtime.CommonToken;
  import org.antlr.runtime.Token;
  import org.antlr.runtime.tree.Tree;
  import org.antlr.runtime.tree.TreeWizard;
@@ -8752,6 +8753,23 @@ public class SemanticAnalyzer extends Ba
                  // insert a select operator here used by the ColumnPruner to reduce
                  // the data to shuffle
                  curr = insertSelectAllPlanForGroupBy(curr);
+ // Check and transform group by *. This will only happen for select distinct *.
+ // Here the "genSelectPlan" is being leveraged.
+ // The main benefits are (1) remove virtual columns that should
+ // not be included in the group by; (2) add the fully qualified column names to unParseTranslator
+ // so that view is supported. The drawback is that an additional SEL op is added. If it is
+ // not necessary, it will be removed by NonBlockingOpDeDupProc Optimizer because it will match
+ // SEL%SEL% rule.
+ ASTNode selExprList = qbp.getSelForClause(dest);
+ if (selExprList.getToken().getType() == HiveParser.TOK_SELECTDI
+ && selExprList.getChildCount() == 1 && selExprList.getChild(0).getChildCount() == 1) {
+ ASTNode node = (ASTNode) selExprList.getChild(0).getChild(0);
+ if (node.getToken().getType() == HiveParser.TOK_ALLCOLREF) {
+ curr = genSelectPlan(dest, qb, curr, curr);
+ RowResolver rr = opParseCtx.get(curr).getRowResolver();
+ qbp.setSelExprForClause(dest, SemanticAnalyzer.genSelectDIAST(rr));
+ }
+ }
                  if (conf.getBoolVar(HiveConf.ConfVars.HIVEMAPSIDEAGGREGATE)) {
                    if (!conf.getBoolVar(HiveConf.ConfVars.HIVEGROUPBYSKEW)) {
                      curr = genGroupByPlanMapAggrNoSkew(dest, qb, curr);
@@ -12208,4 +12226,25 @@ public class SemanticAnalyzer extends Ba
    protected boolean deleting() {
      return false;
    }
+ public static ASTNode genSelectDIAST(RowResolver rr) {
+ HashMap<String, LinkedHashMap<String, ColumnInfo>> map = rr.getRslvMap();
+ ASTNode selectDI = new ASTNode(new CommonToken(HiveParser.TOK_SELECTDI, "TOK_SELECTDI"));
+ for (String tabAlias : map.keySet()) {
+ for (Entry<String, ColumnInfo> entry : map.get(tabAlias).entrySet()) {
+ selectDI.addChild(buildSelExprSubTree(tabAlias, entry.getKey()));
+ }
+ }
+ return selectDI;
+ }
+ private static ASTNode buildSelExprSubTree(String tableAlias, String col) {
+ ASTNode selexpr = new ASTNode(new CommonToken(HiveParser.TOK_SELEXPR, "TOK_SELEXPR"));
+ ASTNode tableOrCol = new ASTNode(new CommonToken(HiveParser.TOK_TABLE_OR_COL,
+ "TOK_TABLE_OR_COL"));
+ ASTNode dot = new ASTNode(new CommonToken(HiveParser.DOT, "."));
+ tableOrCol.addChild(new ASTNode(new CommonToken(HiveParser.Identifier, tableAlias)));
+ dot.addChild(tableOrCol);
+ dot.addChild(new ASTNode(new CommonToken(HiveParser.Identifier, col)));
+ selexpr.addChild(dot);
+ return selexpr;
+ }
  }

Modified: hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/UnparseTranslator.java
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/UnparseTranslator.java?rev=1652286&r1=1652285&r2=1652286&view=diff
==============================================================================
--- hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/UnparseTranslator.java (original)
+++ hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/UnparseTranslator.java Thu Jan 15 22:15:40 2015
@@ -97,6 +97,10 @@ class UnparseTranslator {

      int tokenStartIndex = node.getTokenStartIndex();
      int tokenStopIndex = node.getTokenStopIndex();
+ if (tokenStopIndex < 0) {
+ // this is for artificially added tokens
+ return;
+ }
      Translation translation = new Translation();
      translation.tokenStopIndex = tokenStopIndex;
      translation.replacementText = replacementText;

Added: hive/trunk/ql/src/test/queries/clientnegative/selectDistinctStarNeg_1.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientnegative/selectDistinctStarNeg_1.q?rev=1652286&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientnegative/selectDistinctStarNeg_1.q (added)
+++ hive/trunk/ql/src/test/queries/clientnegative/selectDistinctStarNeg_1.q Thu Jan 15 22:15:40 2015
@@ -0,0 +1,4 @@
+-- Duplicate column name: key
+
+drop view if exists v;
+create view v as select distinct * from src join src1 on src.key=src1.key;
\ No newline at end of file

Added: hive/trunk/ql/src/test/queries/clientnegative/selectDistinctStarNeg_2.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientnegative/selectDistinctStarNeg_2.q?rev=1652286&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientnegative/selectDistinctStarNeg_2.q (added)
+++ hive/trunk/ql/src/test/queries/clientnegative/selectDistinctStarNeg_2.q Thu Jan 15 22:15:40 2015
@@ -0,0 +1,3 @@
+-- SELECT DISTINCT and GROUP BY can not be in the same query. Error encountered near token ‘key’
+
+select distinct * from src group by key;
\ No newline at end of file

Added: hive/trunk/ql/src/test/queries/clientpositive/selectDistinctStar.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/selectDistinctStar.q?rev=1652286&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/selectDistinctStar.q (added)
+++ hive/trunk/ql/src/test/queries/clientpositive/selectDistinctStar.q Thu Jan 15 22:15:40 2015
@@ -0,0 +1,101 @@
+explain select distinct src.* from src;
+
+select distinct src.* from src;
+
+select distinct * from src;
+
+explain select distinct * from src where key < '3';
+
+select distinct * from src where key < '3';
+
+from src a select distinct a.* where a.key = '238';
+
+explain
+SELECT distinct * from (
+select * from src1
+union all
+select * from src )subq;
+
+SELECT distinct * from (
+select * from src1
+union all
+select * from src )subq;
+
+drop view if exists sdi;
+
+explain create view sdi as select distinct * from src order by key limit 2;
+
+create view sdi as select distinct * from src order by key limit 2;
+
+describe extended sdi;
+
+describe formatted sdi;
+
+select * from sdi;
+
+select distinct * from src union all select distinct * from src1;
+
+select distinct * from src join src1 on src.key=src1.key;
+
+SELECT distinct *
+FROM src1 x JOIN src y ON (x.key = y.key)
+JOIN srcpart z ON (x.value = z.value and z.ds='2008-04-08' and z.hr=11);
+
+select * from (select distinct * from src)src1
+join
+(select distinct * from src)src2
+on src1.key=src2.key;
+
+select distinct * from (select distinct * from src)src1;
+
+set hive.cbo.enable=false;
+
+explain select distinct src.* from src;
+
+select distinct src.* from src;
+
+select distinct * from src;
+
+explain select distinct * from src where key < '3';
+
+select distinct * from src where key < '3';
+
+from src a select distinct a.* where a.key = '238';
+
+explain
+SELECT distinct * from (
+select * from src1
+union all
+select * from src )subq;
+
+SELECT distinct * from (
+select * from src1
+union all
+select * from src )subq;
+
+drop view if exists sdi;
+
+explain create view sdi as select distinct * from src order by key limit 2;
+
+create view sdi as select distinct * from src order by key limit 2;
+
+describe extended sdi;
+
+describe formatted sdi;
+
+select * from sdi;
+
+select distinct * from src union all select distinct * from src1;
+
+select distinct * from src join src1 on src.key=src1.key;
+
+SELECT distinct *
+FROM src1 x JOIN src y ON (x.key = y.key)
+JOIN srcpart z ON (x.value = z.value and z.ds='2008-04-08' and z.hr=11);
+
+select * from (select distinct * from src)src1
+join
+(select distinct * from src)src2
+on src1.key=src2.key;
+
+select distinct * from (select distinct * from src)src1;

Added: hive/trunk/ql/src/test/results/clientnegative/selectDistinctStarNeg_1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientnegative/selectDistinctStarNeg_1.q.out?rev=1652286&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientnegative/selectDistinctStarNeg_1.q.out (added)
+++ hive/trunk/ql/src/test/results/clientnegative/selectDistinctStarNeg_1.q.out Thu Jan 15 22:15:40 2015
@@ -0,0 +1,9 @@
+PREHOOK: query: -- Duplicate column name: key
+
+drop view if exists v
+PREHOOK: type: DROPVIEW
+POSTHOOK: query: -- Duplicate column name: key
+
+drop view if exists v
+POSTHOOK: type: DROPVIEW
+FAILED: SemanticException [Error 10036]: Duplicate column name: key

Added: hive/trunk/ql/src/test/results/clientnegative/selectDistinctStarNeg_2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientnegative/selectDistinctStarNeg_2.q.out?rev=1652286&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientnegative/selectDistinctStarNeg_2.q.out (added)
+++ hive/trunk/ql/src/test/results/clientnegative/selectDistinctStarNeg_2.q.out Thu Jan 15 22:15:40 2015
@@ -0,0 +1 @@
+FAILED: SemanticException 3:36 SELECT DISTINCT and GROUP BY can not be in the same query. Error encountered near token 'key'

Search Discussions

  • Jpullokk at Jan 15, 2015 at 10:15 pm
    Added: hive/trunk/ql/src/test/results/clientpositive/selectDistinctStar.q.out
    URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/selectDistinctStar.q.out?rev=1652286&view=auto
    ==============================================================================
    --- hive/trunk/ql/src/test/results/clientpositive/selectDistinctStar.q.out (added)
    +++ hive/trunk/ql/src/test/results/clientpositive/selectDistinctStar.q.out Thu Jan 15 22:15:40 2015
    @@ -0,0 +1,4882 @@
    +PREHOOK: query: explain select distinct src.* from src
    +PREHOOK: type: QUERY
    +POSTHOOK: query: explain select distinct src.* from src
    +POSTHOOK: type: QUERY
    +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: src
    + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
    + Select Operator
    + expressions: key (type: string), value (type: string)
    + outputColumnNames: _col0, _col1
    + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
    + Group By Operator
    + keys: _col0 (type: string), _col1 (type: string)
    + mode: hash
    + outputColumnNames: _col0, _col1
    + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
    + Reduce Output Operator
    + key expressions: _col0 (type: string), _col1 (type: string)
    + sort order: ++
    + Map-reduce partition columns: _col0 (type: string), _col1 (type: string)
    + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
    + Reduce Operator Tree:
    + Group By Operator
    + keys: KEY._col0 (type: string), KEY._col1 (type: string)
    + mode: mergepartial
    + outputColumnNames: _col0, _col1
    + Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
    + Select Operator
    + expressions: _col0 (type: string), _col1 (type: string)
    + outputColumnNames: _col0, _col1
    + Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
    + File Output Operator
    + compressed: false
    + Statistics: Num rows: 250 Data size: 2656 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: -1
    + Processor Tree:
    + ListSink
    +
    +PREHOOK: query: select distinct src.* from src
    +PREHOOK: type: QUERY
    +PREHOOK: Input: default@src
    +#### A masked pattern was here ####
    +POSTHOOK: query: select distinct src.* from src
    +POSTHOOK: type: QUERY
    +POSTHOOK: Input: default@src
    +#### A masked pattern was here ####
    +0 val_0
    +10 val_10
    +100 val_100
    +103 val_103
    +104 val_104
    +105 val_105
    +11 val_11
    +111 val_111
    +113 val_113
    +114 val_114
    +116 val_116
    +118 val_118
    +119 val_119
    +12 val_12
    +120 val_120
    +125 val_125
    +126 val_126
    +128 val_128
    +129 val_129
    +131 val_131
    +133 val_133
    +134 val_134
    +136 val_136
    +137 val_137
    +138 val_138
    +143 val_143
    +145 val_145
    +146 val_146
    +149 val_149
    +15 val_15
    +150 val_150
    +152 val_152
    +153 val_153
    +155 val_155
    +156 val_156
    +157 val_157
    +158 val_158
    +160 val_160
    +162 val_162
    +163 val_163
    +164 val_164
    +165 val_165
    +166 val_166
    +167 val_167
    +168 val_168
    +169 val_169
    +17 val_17
    +170 val_170
    +172 val_172
    +174 val_174
    +175 val_175
    +176 val_176
    +177 val_177
    +178 val_178
    +179 val_179
    +18 val_18
    +180 val_180
    +181 val_181
    +183 val_183
    +186 val_186
    +187 val_187
    +189 val_189
    +19 val_19
    +190 val_190
    +191 val_191
    +192 val_192
    +193 val_193
    +194 val_194
    +195 val_195
    +196 val_196
    +197 val_197
    +199 val_199
    +2 val_2
    +20 val_20
    +200 val_200
    +201 val_201
    +202 val_202
    +203 val_203
    +205 val_205
    +207 val_207
    +208 val_208
    +209 val_209
    +213 val_213
    +214 val_214
    +216 val_216
    +217 val_217
    +218 val_218
    +219 val_219
    +221 val_221
    +222 val_222
    +223 val_223
    +224 val_224
    +226 val_226
    +228 val_228
    +229 val_229
    +230 val_230
    +233 val_233
    +235 val_235
    +237 val_237
    +238 val_238
    +239 val_239
    +24 val_24
    +241 val_241
    +242 val_242
    +244 val_244
    +247 val_247
    +248 val_248
    +249 val_249
    +252 val_252
    +255 val_255
    +256 val_256
    +257 val_257
    +258 val_258
    +26 val_26
    +260 val_260
    +262 val_262
    +263 val_263
    +265 val_265
    +266 val_266
    +27 val_27
    +272 val_272
    +273 val_273
    +274 val_274
    +275 val_275
    +277 val_277
    +278 val_278
    +28 val_28
    +280 val_280
    +281 val_281
    +282 val_282
    +283 val_283
    +284 val_284
    +285 val_285
    +286 val_286
    +287 val_287
    +288 val_288
    +289 val_289
    +291 val_291
    +292 val_292
    +296 val_296
    +298 val_298
    +30 val_30
    +302 val_302
    +305 val_305
    +306 val_306
    +307 val_307
    +308 val_308
    +309 val_309
    +310 val_310
    +311 val_311
    +315 val_315
    +316 val_316
    +317 val_317
    +318 val_318
    +321 val_321
    +322 val_322
    +323 val_323
    +325 val_325
    +327 val_327
    +33 val_33
    +331 val_331
    +332 val_332
    +333 val_333
    +335 val_335
    +336 val_336
    +338 val_338
    +339 val_339
    +34 val_34
    +341 val_341
    +342 val_342
    +344 val_344
    +345 val_345
    +348 val_348
    +35 val_35
    +351 val_351
    +353 val_353
    +356 val_356
    +360 val_360
    +362 val_362
    +364 val_364
    +365 val_365
    +366 val_366
    +367 val_367
    +368 val_368
    +369 val_369
    +37 val_37
    +373 val_373
    +374 val_374
    +375 val_375
    +377 val_377
    +378 val_378
    +379 val_379
    +382 val_382
    +384 val_384
    +386 val_386
    +389 val_389
    +392 val_392
    +393 val_393
    +394 val_394
    +395 val_395
    +396 val_396
    +397 val_397
    +399 val_399
    +4 val_4
    +400 val_400
    +401 val_401
    +402 val_402
    +403 val_403
    +404 val_404
    +406 val_406
    +407 val_407
    +409 val_409
    +41 val_41
    +411 val_411
    +413 val_413
    +414 val_414
    +417 val_417
    +418 val_418
    +419 val_419
    +42 val_42
    +421 val_421
    +424 val_424
    +427 val_427
    +429 val_429
    +43 val_43
    +430 val_430
    +431 val_431
    +432 val_432
    +435 val_435
    +436 val_436
    +437 val_437
    +438 val_438
    +439 val_439
    +44 val_44
    +443 val_443
    +444 val_444
    +446 val_446
    +448 val_448
    +449 val_449
    +452 val_452
    +453 val_453
    +454 val_454
    +455 val_455
    +457 val_457
    +458 val_458
    +459 val_459
    +460 val_460
    +462 val_462
    +463 val_463
    +466 val_466
    +467 val_467
    +468 val_468
    +469 val_469
    +47 val_47
    +470 val_470
    +472 val_472
    +475 val_475
    +477 val_477
    +478 val_478
    +479 val_479
    +480 val_480
    +481 val_481
    +482 val_482
    +483 val_483
    +484 val_484
    +485 val_485
    +487 val_487
    +489 val_489
    +490 val_490
    +491 val_491
    +492 val_492
    +493 val_493
    +494 val_494
    +495 val_495
    +496 val_496
    +497 val_497
    +498 val_498
    +5 val_5
    +51 val_51
    +53 val_53
    +54 val_54
    +57 val_57
    +58 val_58
    +64 val_64
    +65 val_65
    +66 val_66
    +67 val_67
    +69 val_69
    +70 val_70
    +72 val_72
    +74 val_74
    +76 val_76
    +77 val_77
    +78 val_78
    +8 val_8
    +80 val_80
    +82 val_82
    +83 val_83
    +84 val_84
    +85 val_85
    +86 val_86
    +87 val_87
    +9 val_9
    +90 val_90
    +92 val_92
    +95 val_95
    +96 val_96
    +97 val_97
    +98 val_98
    +PREHOOK: query: select distinct * from src
    +PREHOOK: type: QUERY
    +PREHOOK: Input: default@src
    +#### A masked pattern was here ####
    +POSTHOOK: query: select distinct * from src
    +POSTHOOK: type: QUERY
    +POSTHOOK: Input: default@src
    +#### A masked pattern was here ####
    +0 val_0
    +10 val_10
    +100 val_100
    +103 val_103
    +104 val_104
    +105 val_105
    +11 val_11
    +111 val_111
    +113 val_113
    +114 val_114
    +116 val_116
    +118 val_118
    +119 val_119
    +12 val_12
    +120 val_120
    +125 val_125
    +126 val_126
    +128 val_128
    +129 val_129
    +131 val_131
    +133 val_133
    +134 val_134
    +136 val_136
    +137 val_137
    +138 val_138
    +143 val_143
    +145 val_145
    +146 val_146
    +149 val_149
    +15 val_15
    +150 val_150
    +152 val_152
    +153 val_153
    +155 val_155
    +156 val_156
    +157 val_157
    +158 val_158
    +160 val_160
    +162 val_162
    +163 val_163
    +164 val_164
    +165 val_165
    +166 val_166
    +167 val_167
    +168 val_168
    +169 val_169
    +17 val_17
    +170 val_170
    +172 val_172
    +174 val_174
    +175 val_175
    +176 val_176
    +177 val_177
    +178 val_178
    +179 val_179
    +18 val_18
    +180 val_180
    +181 val_181
    +183 val_183
    +186 val_186
    +187 val_187
    +189 val_189
    +19 val_19
    +190 val_190
    +191 val_191
    +192 val_192
    +193 val_193
    +194 val_194
    +195 val_195
    +196 val_196
    +197 val_197
    +199 val_199
    +2 val_2
    +20 val_20
    +200 val_200
    +201 val_201
    +202 val_202
    +203 val_203
    +205 val_205
    +207 val_207
    +208 val_208
    +209 val_209
    +213 val_213
    +214 val_214
    +216 val_216
    +217 val_217
    +218 val_218
    +219 val_219
    +221 val_221
    +222 val_222
    +223 val_223
    +224 val_224
    +226 val_226
    +228 val_228
    +229 val_229
    +230 val_230
    +233 val_233
    +235 val_235
    +237 val_237
    +238 val_238
    +239 val_239
    +24 val_24
    +241 val_241
    +242 val_242
    +244 val_244
    +247 val_247
    +248 val_248
    +249 val_249
    +252 val_252
    +255 val_255
    +256 val_256
    +257 val_257
    +258 val_258
    +26 val_26
    +260 val_260
    +262 val_262
    +263 val_263
    +265 val_265
    +266 val_266
    +27 val_27
    +272 val_272
    +273 val_273
    +274 val_274
    +275 val_275
    +277 val_277
    +278 val_278
    +28 val_28
    +280 val_280
    +281 val_281
    +282 val_282
    +283 val_283
    +284 val_284
    +285 val_285
    +286 val_286
    +287 val_287
    +288 val_288
    +289 val_289
    +291 val_291
    +292 val_292
    +296 val_296
    +298 val_298
    +30 val_30
    +302 val_302
    +305 val_305
    +306 val_306
    +307 val_307
    +308 val_308
    +309 val_309
    +310 val_310
    +311 val_311
    +315 val_315
    +316 val_316
    +317 val_317
    +318 val_318
    +321 val_321
    +322 val_322
    +323 val_323
    +325 val_325
    +327 val_327
    +33 val_33
    +331 val_331
    +332 val_332
    +333 val_333
    +335 val_335
    +336 val_336
    +338 val_338
    +339 val_339
    +34 val_34
    +341 val_341
    +342 val_342
    +344 val_344
    +345 val_345
    +348 val_348
    +35 val_35
    +351 val_351
    +353 val_353
    +356 val_356
    +360 val_360
    +362 val_362
    +364 val_364
    +365 val_365
    +366 val_366
    +367 val_367
    +368 val_368
    +369 val_369
    +37 val_37
    +373 val_373
    +374 val_374
    +375 val_375
    +377 val_377
    +378 val_378
    +379 val_379
    +382 val_382
    +384 val_384
    +386 val_386
    +389 val_389
    +392 val_392
    +393 val_393
    +394 val_394
    +395 val_395
    +396 val_396
    +397 val_397
    +399 val_399
    +4 val_4
    +400 val_400
    +401 val_401
    +402 val_402
    +403 val_403
    +404 val_404
    +406 val_406
    +407 val_407
    +409 val_409
    +41 val_41
    +411 val_411
    +413 val_413
    +414 val_414
    +417 val_417
    +418 val_418
    +419 val_419
    +42 val_42
    +421 val_421
    +424 val_424
    +427 val_427
    +429 val_429
    +43 val_43
    +430 val_430
    +431 val_431
    +432 val_432
    +435 val_435
    +436 val_436
    +437 val_437
    +438 val_438
    +439 val_439
    +44 val_44
    +443 val_443
    +444 val_444
    +446 val_446
    +448 val_448
    +449 val_449
    +452 val_452
    +453 val_453
    +454 val_454
    +455 val_455
    +457 val_457
    +458 val_458
    +459 val_459
    +460 val_460
    +462 val_462
    +463 val_463
    +466 val_466
    +467 val_467
    +468 val_468
    +469 val_469
    +47 val_47
    +470 val_470
    +472 val_472
    +475 val_475
    +477 val_477
    +478 val_478
    +479 val_479
    +480 val_480
    +481 val_481
    +482 val_482
    +483 val_483
    +484 val_484
    +485 val_485
    +487 val_487
    +489 val_489
    +490 val_490
    +491 val_491
    +492 val_492
    +493 val_493
    +494 val_494
    +495 val_495
    +496 val_496
    +497 val_497
    +498 val_498
    +5 val_5
    +51 val_51
    +53 val_53
    +54 val_54
    +57 val_57
    +58 val_58
    +64 val_64
    +65 val_65
    +66 val_66
    +67 val_67
    +69 val_69
    +70 val_70
    +72 val_72
    +74 val_74
    +76 val_76
    +77 val_77
    +78 val_78
    +8 val_8
    +80 val_80
    +82 val_82
    +83 val_83
    +84 val_84
    +85 val_85
    +86 val_86
    +87 val_87
    +9 val_9
    +90 val_90
    +92 val_92
    +95 val_95
    +96 val_96
    +97 val_97
    +98 val_98
    +PREHOOK: query: explain select distinct * from src where key < '3'
    +PREHOOK: type: QUERY
    +POSTHOOK: query: explain select distinct * from src where key < '3'
    +POSTHOOK: type: QUERY
    +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: src
    + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
    + Filter Operator
    + predicate: (key < '3') (type: boolean)
    + Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
    + Select Operator
    + expressions: key (type: string), value (type: string)
    + outputColumnNames: _col0, _col1
    + Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
    + Group By Operator
    + keys: _col0 (type: string), _col1 (type: string)
    + mode: hash
    + outputColumnNames: _col0, _col1
    + Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
    + Reduce Output Operator
    + key expressions: _col0 (type: string), _col1 (type: string)
    + sort order: ++
    + Map-reduce partition columns: _col0 (type: string), _col1 (type: string)
    + Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
    + Reduce Operator Tree:
    + Group By Operator
    + keys: KEY._col0 (type: string), KEY._col1 (type: string)
    + mode: mergepartial
    + outputColumnNames: _col0, _col1
    + Statistics: Num rows: 83 Data size: 881 Basic stats: COMPLETE Column stats: NONE
    + Select Operator
    + expressions: _col0 (type: string), _col1 (type: string)
    + outputColumnNames: _col0, _col1
    + Statistics: Num rows: 83 Data size: 881 Basic stats: COMPLETE Column stats: NONE
    + File Output Operator
    + compressed: false
    + Statistics: Num rows: 83 Data size: 881 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: -1
    + Processor Tree:
    + ListSink
    +
    +PREHOOK: query: select distinct * from src where key < '3'
    +PREHOOK: type: QUERY
    +PREHOOK: Input: default@src
    +#### A masked pattern was here ####
    +POSTHOOK: query: select distinct * from src where key < '3'
    +POSTHOOK: type: QUERY
    +POSTHOOK: Input: default@src
    +#### A masked pattern was here ####
    +0 val_0
    +10 val_10
    +100 val_100
    +103 val_103
    +104 val_104
    +105 val_105
    +11 val_11
    +111 val_111
    +113 val_113
    +114 val_114
    +116 val_116
    +118 val_118
    +119 val_119
    +12 val_12
    +120 val_120
    +125 val_125
    +126 val_126
    +128 val_128
    +129 val_129
    +131 val_131
    +133 val_133
    +134 val_134
    +136 val_136
    +137 val_137
    +138 val_138
    +143 val_143
    +145 val_145
    +146 val_146
    +149 val_149
    +15 val_15
    +150 val_150
    +152 val_152
    +153 val_153
    +155 val_155
    +156 val_156
    +157 val_157
    +158 val_158
    +160 val_160
    +162 val_162
    +163 val_163
    +164 val_164
    +165 val_165
    +166 val_166
    +167 val_167
    +168 val_168
    +169 val_169
    +17 val_17
    +170 val_170
    +172 val_172
    +174 val_174
    +175 val_175
    +176 val_176
    +177 val_177
    +178 val_178
    +179 val_179
    +18 val_18
    +180 val_180
    +181 val_181
    +183 val_183
    +186 val_186
    +187 val_187
    +189 val_189
    +19 val_19
    +190 val_190
    +191 val_191
    +192 val_192
    +193 val_193
    +194 val_194
    +195 val_195
    +196 val_196
    +197 val_197
    +199 val_199
    +2 val_2
    +20 val_20
    +200 val_200
    +201 val_201
    +202 val_202
    +203 val_203
    +205 val_205
    +207 val_207
    +208 val_208
    +209 val_209
    +213 val_213
    +214 val_214
    +216 val_216
    +217 val_217
    +218 val_218
    +219 val_219
    +221 val_221
    +222 val_222
    +223 val_223
    +224 val_224
    +226 val_226
    +228 val_228
    +229 val_229
    +230 val_230
    +233 val_233
    +235 val_235
    +237 val_237
    +238 val_238
    +239 val_239
    +24 val_24
    +241 val_241
    +242 val_242
    +244 val_244
    +247 val_247
    +248 val_248
    +249 val_249
    +252 val_252
    +255 val_255
    +256 val_256
    +257 val_257
    +258 val_258
    +26 val_26
    +260 val_260
    +262 val_262
    +263 val_263
    +265 val_265
    +266 val_266
    +27 val_27
    +272 val_272
    +273 val_273
    +274 val_274
    +275 val_275
    +277 val_277
    +278 val_278
    +28 val_28
    +280 val_280
    +281 val_281
    +282 val_282
    +283 val_283
    +284 val_284
    +285 val_285
    +286 val_286
    +287 val_287
    +288 val_288
    +289 val_289
    +291 val_291
    +292 val_292
    +296 val_296
    +298 val_298
    +PREHOOK: query: from src a select distinct a.* where a.key = '238'
    +PREHOOK: type: QUERY
    +PREHOOK: Input: default@src
    +#### A masked pattern was here ####
    +POSTHOOK: query: from src a select distinct a.* where a.key = '238'
    +POSTHOOK: type: QUERY
    +POSTHOOK: Input: default@src
    +#### A masked pattern was here ####
    +238 val_238
    +PREHOOK: query: explain
    +SELECT distinct * from (
    +select * from src1
    +union all
    +select * from src )subq
    +PREHOOK: type: QUERY
    +POSTHOOK: query: explain
    +SELECT distinct * from (
    +select * from src1
    +union all
    +select * from src )subq
    +POSTHOOK: type: QUERY
    +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: src1
    + Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
    + Select Operator
    + expressions: key (type: string), value (type: string)
    + outputColumnNames: _col0, _col1
    + Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
    + Union
    + Statistics: Num rows: 525 Data size: 5503 Basic stats: COMPLETE Column stats: NONE
    + Group By Operator
    + keys: _col0 (type: string), _col1 (type: string)
    + mode: hash
    + outputColumnNames: _col0, _col1
    + Statistics: Num rows: 525 Data size: 5503 Basic stats: COMPLETE Column stats: NONE
    + Reduce Output Operator
    + key expressions: _col0 (type: string), _col1 (type: string)
    + sort order: ++
    + Map-reduce partition columns: _col0 (type: string), _col1 (type: string)
    + Statistics: Num rows: 525 Data size: 5503 Basic stats: COMPLETE Column stats: NONE
    + TableScan
    + alias: src
    + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
    + Select Operator
    + expressions: key (type: string), value (type: string)
    + outputColumnNames: _col0, _col1
    + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
    + Union
    + Statistics: Num rows: 525 Data size: 5503 Basic stats: COMPLETE Column stats: NONE
    + Group By Operator
    + keys: _col0 (type: string), _col1 (type: string)
    + mode: hash
    + outputColumnNames: _col0, _col1
    + Statistics: Num rows: 525 Data size: 5503 Basic stats: COMPLETE Column stats: NONE
    + Reduce Output Operator
    + key expressions: _col0 (type: string), _col1 (type: string)
    + sort order: ++
    + Map-reduce partition columns: _col0 (type: string), _col1 (type: string)
    + Statistics: Num rows: 525 Data size: 5503 Basic stats: COMPLETE Column stats: NONE
    + Reduce Operator Tree:
    + Group By Operator
    + keys: KEY._col0 (type: string), KEY._col1 (type: string)
    + mode: mergepartial
    + outputColumnNames: _col0, _col1
    + Statistics: Num rows: 262 Data size: 2746 Basic stats: COMPLETE Column stats: NONE
    + Select Operator
    + expressions: _col0 (type: string), _col1 (type: string)
    + outputColumnNames: _col0, _col1
    + Statistics: Num rows: 262 Data size: 2746 Basic stats: COMPLETE Column stats: NONE
    + File Output Operator
    + compressed: false
    + Statistics: Num rows: 262 Data size: 2746 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: -1
    + Processor Tree:
    + ListSink
    +
    +PREHOOK: query: SELECT distinct * from (
    +select * from src1
    +union all
    +select * from src )subq
    +PREHOOK: type: QUERY
    +PREHOOK: Input: default@src
    +PREHOOK: Input: default@src1
    +#### A masked pattern was here ####
    +POSTHOOK: query: SELECT distinct * from (
    +select * from src1
    +union all
    +select * from src )subq
    +POSTHOOK: type: QUERY
    +POSTHOOK: Input: default@src
    +POSTHOOK: Input: default@src1
    +#### A masked pattern was here ####
    +
    + val_165
    + val_193
    + val_265
    + val_27
    + val_409
    + val_484
    +0 val_0
    +10 val_10
    +100 val_100
    +103 val_103
    +104 val_104
    +105 val_105
    +11 val_11
    +111 val_111
    +113 val_113
    +114 val_114
    +116 val_116
    +118 val_118
    +119 val_119
    +12 val_12
    +120 val_120
    +125 val_125
    +126 val_126
    +128
    +128 val_128
    +129 val_129
    +131 val_131
    +133 val_133
    +134 val_134
    +136 val_136
    +137 val_137
    +138 val_138
    +143 val_143
    +145 val_145
    +146 val_146
    +149 val_149
    +15 val_15
    +150 val_150
    +152 val_152
    +153 val_153
    +155 val_155
    +156 val_156
    +157 val_157
    +158 val_158
    +160 val_160
    +162 val_162
    +163 val_163
    +164 val_164
    +165 val_165
    +166 val_166
    +167 val_167
    +168 val_168
    +169 val_169
    +17 val_17
    +170 val_170
    +172 val_172
    +174 val_174
    +175 val_175
    +176 val_176
    +177 val_177
    +178 val_178
    +179 val_179
    +18 val_18
    +180 val_180
    +181 val_181
    +183 val_183
    +186 val_186
    +187 val_187
    +189 val_189
    +19 val_19
    +190 val_190
    +191 val_191
    +192 val_192
    +193 val_193
    +194 val_194
    +195 val_195
    +196 val_196
    +197 val_197
    +199 val_199
    +2 val_2
    +20 val_20
    +200 val_200
    +201 val_201
    +202 val_202
    +203 val_203
    +205 val_205
    +207 val_207
    +208 val_208
    +209 val_209
    +213 val_213
    +214 val_214
    +216 val_216
    +217 val_217
    +218 val_218
    +219 val_219
    +221 val_221
    +222 val_222
    +223 val_223
    +224
    +224 val_224
    +226 val_226
    +228 val_228
    +229 val_229
    +230 val_230
    +233 val_233
    +235 val_235
    +237 val_237
    +238 val_238
    +239 val_239
    +24 val_24
    +241 val_241
    +242 val_242
    +244 val_244
    +247 val_247
    +248 val_248
    +249 val_249
    +252 val_252
    +255 val_255
    +256 val_256
    +257 val_257
    +258 val_258
    +26 val_26
    +260 val_260
    +262 val_262
    +263 val_263
    +265 val_265
    +266 val_266
    +27 val_27
    +272 val_272
    +273 val_273
    +274 val_274
    +275 val_275
    +277 val_277
    +278 val_278
    +28 val_28
    +280 val_280
    +281 val_281
    +282 val_282
    +283 val_283
    +284 val_284
    +285 val_285
    +286 val_286
    +287 val_287
    +288 val_288
    +289 val_289
    +291 val_291
    +292 val_292
    +296 val_296
    +298 val_298
    +30 val_30
    +302 val_302
    +305 val_305
    +306 val_306
    +307 val_307
    +308 val_308
    +309 val_309
    +310 val_310
    +311 val_311
    +315 val_315
    +316 val_316
    +317 val_317
    +318 val_318
    +321 val_321
    +322 val_322
    +323 val_323
    +325 val_325
    +327 val_327
    +33 val_33
    +331 val_331
    +332 val_332
    +333 val_333
    +335 val_335
    +336 val_336
    +338 val_338
    +339 val_339
    +34 val_34
    +341 val_341
    +342 val_342
    +344 val_344
    +345 val_345
    +348 val_348
    +35 val_35
    +351 val_351
    +353 val_353
    +356 val_356
    +360 val_360
    +362 val_362
    +364 val_364
    +365 val_365
    +366 val_366
    +367 val_367
    +368 val_368
    +369
    +369 val_369
    +37 val_37
    +373 val_373
    +374 val_374
    +375 val_375
    +377 val_377
    +378 val_378
    +379 val_379
    +382 val_382
    +384 val_384
    +386 val_386
    +389 val_389
    +392 val_392
    +393 val_393
    +394 val_394
    +395 val_395
    +396 val_396
    +397 val_397
    +399 val_399
    +4 val_4
    +400 val_400
    +401 val_401
    +402 val_402
    +403 val_403
    +404 val_404
    +406 val_406
    +407 val_407
    +409 val_409
    +41 val_41
    +411 val_411
    +413 val_413
    +414 val_414
    +417 val_417
    +418 val_418
    +419 val_419
    +42 val_42
    +421 val_421
    +424 val_424
    +427 val_427
    +429 val_429
    +43 val_43
    +430 val_430
    +431 val_431
    +432 val_432
    +435 val_435
    +436 val_436
    +437 val_437
    +438 val_438
    +439 val_439
    +44 val_44
    +443 val_443
    +444 val_444
    +446 val_446
    +448 val_448
    +449 val_449
    +452 val_452
    +453 val_453
    +454 val_454
    +455 val_455
    +457 val_457
    +458 val_458
    +459 val_459
    +460 val_460
    +462 val_462
    +463 val_463
    +466 val_466
    +467 val_467
    +468 val_468
    +469 val_469
    +47 val_47
    +470 val_470
    +472 val_472
    +475 val_475
    +477 val_477
    +478 val_478
    +479 val_479
    +480 val_480
    +481 val_481
    +482 val_482
    +483 val_483
    +484 val_484
    +485 val_485
    +487 val_487
    +489 val_489
    +490 val_490
    +491 val_491
    +492 val_492
    +493 val_493
    +494 val_494
    +495 val_495
    +496 val_496
    +497 val_497
    +498 val_498
    +5 val_5
    +51 val_51
    +53 val_53
    +54 val_54
    +57 val_57
    +58 val_58
    +64 val_64
    +65 val_65
    +66 val_66
    +67 val_67
    +69 val_69
    +70 val_70
    +72 val_72
    +74 val_74
    +76 val_76
    +77 val_77
    +78 val_78
    +8 val_8
    +80 val_80
    +82 val_82
    +83 val_83
    +84 val_84
    +85 val_85
    +86 val_86
    +87 val_87
    +9 val_9
    +90 val_90
    +92 val_92
    +95 val_95
    +96 val_96
    +97 val_97
    +98 val_98
    +PREHOOK: query: drop view if exists sdi
    +PREHOOK: type: DROPVIEW
    +POSTHOOK: query: drop view if exists sdi
    +POSTHOOK: type: DROPVIEW
    +PREHOOK: query: explain create view sdi as select distinct * from src order by key limit 2
    +PREHOOK: type: CREATEVIEW
    +POSTHOOK: query: explain create view sdi as select distinct * from src order by key limit 2
    +POSTHOOK: type: CREATEVIEW
    +STAGE DEPENDENCIES:
    + Stage-0 is a root stage
    +
    +STAGE PLANS:
    + Stage: Stage-0
    + Create View Operator:
    + Create View
    + or replace: false
    + columns: key string, value string
    + expanded text: select distinct `src`.`key`, `src`.`value` from `default`.`src` order by `src`.`key` limit 2
    + name: default.sdi
    + original text: select distinct * from src order by key limit 2
    +
    +PREHOOK: query: create view sdi as select distinct * from src order by key limit 2
    +PREHOOK: type: CREATEVIEW
    +PREHOOK: Input: default@src
    +PREHOOK: Output: database:default
    +PREHOOK: Output: default@sdi
    +POSTHOOK: query: create view sdi as select distinct * from src order by key limit 2
    +POSTHOOK: type: CREATEVIEW
    +POSTHOOK: Input: default@src
    +POSTHOOK: Output: database:default
    +POSTHOOK: Output: default@sdi
    +PREHOOK: query: describe extended sdi
    +PREHOOK: type: DESCTABLE
    +PREHOOK: Input: default@sdi
    +POSTHOOK: query: describe extended sdi
    +POSTHOOK: type: DESCTABLE
    +POSTHOOK: Input: default@sdi
    +key string
    +value string
    +
    +#### A masked pattern was here ####
    +PREHOOK: query: describe formatted sdi
    +PREHOOK: type: DESCTABLE
    +PREHOOK: Input: default@sdi
    +POSTHOOK: query: describe formatted sdi
    +POSTHOOK: type: DESCTABLE
    +POSTHOOK: Input: default@sdi
    +# col_name data_type comment
    +
    +key string
    +value string
    +
    +# Detailed Table Information
    +Database: default
    +#### A masked pattern was here ####
    +Protect Mode: None
    +Retention: 0
    +Table Type: VIRTUAL_VIEW
    +Table Parameters:
    +#### A masked pattern was here ####
    +
    +# Storage Information
    +SerDe Library: null
    +InputFormat: org.apache.hadoop.mapred.SequenceFileInputFormat
    +OutputFormat: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
    +Compressed: No
    +Num Buckets: -1
    +Bucket Columns: []
    +Sort Columns: []
    +
    +# View Information
    +View Original Text: select distinct * from src order by key limit 2
    +View Expanded Text: select distinct `src`.`key`, `src`.`value` from `default`.`src` order by `src`.`key` limit 2
    +PREHOOK: query: select * from sdi
    +PREHOOK: type: QUERY
    +PREHOOK: Input: default@sdi
    +PREHOOK: Input: default@src
    +#### A masked pattern was here ####
    +POSTHOOK: query: select * from sdi
    +POSTHOOK: type: QUERY
    +POSTHOOK: Input: default@sdi
    +POSTHOOK: Input: default@src
    +#### A masked pattern was here ####
    +0 val_0
    +10 val_10
    +PREHOOK: query: select distinct * from src union all select distinct * from src1
    +PREHOOK: type: QUERY
    +PREHOOK: Input: default@src
    +PREHOOK: Input: default@src1
    +#### A masked pattern was here ####
    +POSTHOOK: query: select distinct * from src union all select distinct * from src1
    +POSTHOOK: type: QUERY
    +POSTHOOK: Input: default@src
    +POSTHOOK: Input: default@src1
    +#### A masked pattern was here ####
    +0 val_0
    +10 val_10
    +100 val_100
    +103 val_103
    +104 val_104
    +105 val_105
    +11 val_11
    +111 val_111
    +113 val_113
    +114 val_114
    +116 val_116
    +118 val_118
    +119 val_119
    +12 val_12
    +120 val_120
    +125 val_125
    +126 val_126
    +128 val_128
    +129 val_129
    +131 val_131
    +133 val_133
    +134 val_134
    +136 val_136
    +137 val_137
    +138 val_138
    +143 val_143
    +145 val_145
    +146 val_146
    +149 val_149
    +15 val_15
    +150 val_150
    +152 val_152
    +153 val_153
    +155 val_155
    +156 val_156
    +157 val_157
    +158 val_158
    +160 val_160
    +162 val_162
    +163 val_163
    +164 val_164
    +165 val_165
    +166 val_166
    +167 val_167
    +168 val_168
    +169 val_169
    +17 val_17
    +170 val_170
    +172 val_172
    +174 val_174
    +175 val_175
    +176 val_176
    +177 val_177
    +178 val_178
    +179 val_179
    +18 val_18
    +180 val_180
    +181 val_181
    +183 val_183
    +186 val_186
    +187 val_187
    +189 val_189
    +19 val_19
    +190 val_190
    +191 val_191
    +192 val_192
    +193 val_193
    +194 val_194
    +195 val_195
    +196 val_196
    +197 val_197
    +199 val_199
    +2 val_2
    +20 val_20
    +200 val_200
    +201 val_201
    +202 val_202
    +203 val_203
    +205 val_205
    +207 val_207
    +208 val_208
    +209 val_209
    +213 val_213
    +214 val_214
    +216 val_216
    +217 val_217
    +218 val_218
    +219 val_219
    +221 val_221
    +222 val_222
    +223 val_223
    +224 val_224
    +226 val_226
    +228 val_228
    +229 val_229
    +230 val_230
    +233 val_233
    +235 val_235
    +237 val_237
    +238 val_238
    +239 val_239
    +24 val_24
    +241 val_241
    +242 val_242
    +244 val_244
    +247 val_247
    +248 val_248
    +249 val_249
    +252 val_252
    +255 val_255
    +256 val_256
    +257 val_257
    +258 val_258
    +26 val_26
    +260 val_260
    +262 val_262
    +263 val_263
    +265 val_265
    +266 val_266
    +27 val_27
    +272 val_272
    +273 val_273
    +274 val_274
    +275 val_275
    +277 val_277
    +278 val_278
    +28 val_28
    +280 val_280
    +281 val_281
    +282 val_282
    +283 val_283
    +284 val_284
    +285 val_285
    +286 val_286
    +287 val_287
    +288 val_288
    +289 val_289
    +291 val_291
    +292 val_292
    +296 val_296
    +298 val_298
    +30 val_30
    +302 val_302
    +305 val_305
    +306 val_306
    +307 val_307
    +308 val_308
    +309 val_309
    +310 val_310
    +311 val_311
    +315 val_315
    +316 val_316
    +317 val_317
    +318 val_318
    +321 val_321
    +322 val_322
    +323 val_323
    +325 val_325
    +327 val_327
    +33 val_33
    +331 val_331
    +332 val_332
    +333 val_333
    +335 val_335
    +336 val_336
    +338 val_338
    +339 val_339
    +34 val_34
    +341 val_341
    +342 val_342
    +344 val_344
    +345 val_345
    +348 val_348
    +35 val_35
    +351 val_351
    +353 val_353
    +356 val_356
    +360 val_360
    +362 val_362
    +364 val_364
    +365 val_365
    +366 val_366
    +367 val_367
    +368 val_368
    +369 val_369
    +37 val_37
    +373 val_373
    +374 val_374
    +375 val_375
    +377 val_377
    +378 val_378
    +379 val_379
    +382 val_382
    +384 val_384
    +386 val_386
    +389 val_389
    +392 val_392
    +393 val_393
    +394 val_394
    +395 val_395
    +396 val_396
    +397 val_397
    +399 val_399
    +4 val_4
    +400 val_400
    +401 val_401
    +402 val_402
    +403 val_403
    +404 val_404
    +406 val_406
    +407 val_407
    +409 val_409
    +41 val_41
    +411 val_411
    +413 val_413
    +414 val_414
    +417 val_417
    +418 val_418
    +419 val_419
    +42 val_42
    +421 val_421
    +424 val_424
    +427 val_427
    +429 val_429
    +43 val_43
    +430 val_430
    +431 val_431
    +432 val_432
    +435 val_435
    +436 val_436
    +437 val_437
    +438 val_438
    +439 val_439
    +44 val_44
    +443 val_443
    +444 val_444
    +446 val_446
    +448 val_448
    +449 val_449
    +452 val_452
    +453 val_453
    +454 val_454
    +455 val_455
    +457 val_457
    +458 val_458
    +459 val_459
    +460 val_460
    +462 val_462
    +463 val_463
    +466 val_466
    +467 val_467
    +468 val_468
    +469 val_469
    +47 val_47
    +470 val_470
    +472 val_472
    +475 val_475
    +477 val_477
    +478 val_478
    +479 val_479
    +480 val_480
    +481 val_481
    +482 val_482
    +483 val_483
    +484 val_484
    +485 val_485
    +487 val_487
    +489 val_489
    +490 val_490
    +491 val_491
    +492 val_492
    +493 val_493
    +494 val_494
    +495 val_495
    +496 val_496
    +497 val_497
    +498 val_498
    +5 val_5
    +51 val_51
    +53 val_53
    +54 val_54
    +57 val_57
    +58 val_58
    +64 val_64
    +65 val_65
    +66 val_66
    +67 val_67
    +69 val_69
    +70 val_70
    +72 val_72
    +74 val_74
    +76 val_76
    +77 val_77
    +78 val_78
    +8 val_8
    +80 val_80
    +82 val_82
    +83 val_83
    +84 val_84
    +85 val_85
    +86 val_86
    +87 val_87
    +9 val_9
    +90 val_90
    +92 val_92
    +95 val_95
    +96 val_96
    +97 val_97
    +98 val_98
    +
    + val_165
    + val_193
    + val_265
    + val_27
    + val_409
    + val_484
    +128
    +146 val_146
    +150 val_150
    +213 val_213
    +224
    +238 val_238
    +255 val_255
    +273 val_273
    +278 val_278
    +311 val_311
    +369
    +401 val_401
    +406 val_406
    +66 val_66
    +98 val_98
    +PREHOOK: query: select distinct * from src join src1 on src.key=src1.key
    +PREHOOK: type: QUERY
    +PREHOOK: Input: default@src
    +PREHOOK: Input: default@src1
    +#### A masked pattern was here ####
    +POSTHOOK: query: select distinct * from src join src1 on src.key=src1.key
    +POSTHOOK: type: QUERY
    +POSTHOOK: Input: default@src
    +POSTHOOK: Input: default@src1
    +#### A masked pattern was here ####
    +128 128 val_128
    +146 val_146 146 val_146
    +150 val_150 150 val_150
    +213 val_213 213 val_213
    +224 224 val_224
    +238 val_238 238 val_238
    +255 val_255 255 val_255
    +273 val_273 273 val_273
    +278 val_278 278 val_278
    +311 val_311 311 val_311
    +369 369 val_369
    +401 val_401 401 val_401
    +406 val_406 406 val_406
    +66 val_66 66 val_66
    +98 val_98 98 val_98
    +PREHOOK: query: SELECT distinct *
    +FROM src1 x JOIN src y ON (x.key = y.key)
    +JOIN srcpart z ON (x.value = z.value and z.ds='2008-04-08' and z.hr=11)
    +PREHOOK: type: QUERY
    +PREHOOK: Input: default@src
    +PREHOOK: Input: default@src1
    +PREHOOK: Input: default@srcpart
    +PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
    +#### A masked pattern was here ####
    +POSTHOOK: query: SELECT distinct *
    +FROM src1 x JOIN src y ON (x.key = y.key)
    +JOIN srcpart z ON (x.value = z.value and z.ds='2008-04-08' and z.hr=11)
    +POSTHOOK: type: QUERY
    +POSTHOOK: Input: default@src
    +POSTHOOK: Input: default@src1
    +POSTHOOK: Input: default@srcpart
    +POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
    +#### A masked pattern was here ####
    +146 val_146 2008-04-08 11 146 val_146 146 val_146
    +150 val_150 2008-04-08 11 150 val_150 150 val_150
    +213 val_213 2008-04-08 11 213 val_213 213 val_213
    +238 val_238 2008-04-08 11 238 val_238 238 val_238
    +255 val_255 2008-04-08 11 255 val_255 255 val_255
    +273 val_273 2008-04-08 11 273 val_273 273 val_273
    +278 val_278 2008-04-08 11 278 val_278 278 val_278
    +311 val_311 2008-04-08 11 311 val_311 311 val_311
    +401 val_401 2008-04-08 11 401 val_401 401 val_401
    +406 val_406 2008-04-08 11 406 val_406 406 val_406
    +66 val_66 2008-04-08 11 66 val_66 66 val_66
    +98 val_98 2008-04-08 11 98 val_98 98 val_98
    +PREHOOK: query: select * from (select distinct * from src)src1
    +join
    +(select distinct * from src)src2
    +on src1.key=src2.key
    +PREHOOK: type: QUERY
    +PREHOOK: Input: default@src
    +#### A masked pattern was here ####
    +POSTHOOK: query: select * from (select distinct * from src)src1
    +join
    +(select distinct * from src)src2
    +on src1.key=src2.key
    +POSTHOOK: type: QUERY
    +POSTHOOK: Input: default@src
    +#### A masked pattern was here ####
    +0 val_0 0 val_0
    +10 val_10 10 val_10
    +100 val_100 100 val_100
    +103 val_103 103 val_103
    +104 val_104 104 val_104
    +105 val_105 105 val_105
    +11 val_11 11 val_11
    +111 val_111 111 val_111
    +113 val_113 113 val_113
    +114 val_114 114 val_114
    +116 val_116 116 val_116
    +118 val_118 118 val_118
    +119 val_119 119 val_119
    +12 val_12 12 val_12
    +120 val_120 120 val_120
    +125 val_125 125 val_125
    +126 val_126 126 val_126
    +128 val_128 128 val_128
    +129 val_129 129 val_129
    +131 val_131 131 val_131
    +133 val_133 133 val_133
    +134 val_134 134 val_134
    +136 val_136 136 val_136
    +137 val_137 137 val_137
    +138 val_138 138 val_138
    +143 val_143 143 val_143
    +145 val_145 145 val_145
    +146 val_146 146 val_146
    +149 val_149 149 val_149
    +15 val_15 15 val_15
    +150 val_150 150 val_150
    +152 val_152 152 val_152
    +153 val_153 153 val_153
    +155 val_155 155 val_155
    +156 val_156 156 val_156
    +157 val_157 157 val_157
    +158 val_158 158 val_158
    +160 val_160 160 val_160
    +162 val_162 162 val_162
    +163 val_163 163 val_163
    +164 val_164 164 val_164
    +165 val_165 165 val_165
    +166 val_166 166 val_166
    +167 val_167 167 val_167
    +168 val_168 168 val_168
    +169 val_169 169 val_169
    +17 val_17 17 val_17
    +170 val_170 170 val_170
    +172 val_172 172 val_172
    +174 val_174 174 val_174
    +175 val_175 175 val_175
    +176 val_176 176 val_176
    +177 val_177 177 val_177
    +178 val_178 178 val_178
    +179 val_179 179 val_179
    +18 val_18 18 val_18
    +180 val_180 180 val_180
    +181 val_181 181 val_181
    +183 val_183 183 val_183
    +186 val_186 186 val_186
    +187 val_187 187 val_187
    +189 val_189 189 val_189
    +19 val_19 19 val_19
    +190 val_190 190 val_190
    +191 val_191 191 val_191
    +192 val_192 192 val_192
    +193 val_193 193 val_193
    +194 val_194 194 val_194
    +195 val_195 195 val_195
    +196 val_196 196 val_196
    +197 val_197 197 val_197
    +199 val_199 199 val_199
    +2 val_2 2 val_2
    +20 val_20 20 val_20
    +200 val_200 200 val_200
    +201 val_201 201 val_201
    +202 val_202 202 val_202
    +203 val_203 203 val_203
    +205 val_205 205 val_205
    +207 val_207 207 val_207
    +208 val_208 208 val_208
    +209 val_209 209 val_209
    +213 val_213 213 val_213
    +214 val_214 214 val_214
    +216 val_216 216 val_216
    +217 val_217 217 val_217
    +218 val_218 218 val_218
    +219 val_219 219 val_219
    +221 val_221 221 val_221
    +222 val_222 222 val_222
    +223 val_223 223 val_223
    +224 val_224 224 val_224
    +226 val_226 226 val_226
    +228 val_228 228 val_228
    +229 val_229 229 val_229
    +230 val_230 230 val_230
    +233 val_233 233 val_233
    +235 val_235 235 val_235
    +237 val_237 237 val_237
    +238 val_238 238 val_238
    +239 val_239 239 val_239
    +24 val_24 24 val_24
    +241 val_241 241 val_241
    +242 val_242 242 val_242
    +244 val_244 244 val_244
    +247 val_247 247 val_247
    +248 val_248 248 val_248
    +249 val_249 249 val_249
    +252 val_252 252 val_252
    +255 val_255 255 val_255
    +256 val_256 256 val_256
    +257 val_257 257 val_257
    +258 val_258 258 val_258
    +26 val_26 26 val_26
    +260 val_260 260 val_260
    +262 val_262 262 val_262
    +263 val_263 263 val_263
    +265 val_265 265 val_265
    +266 val_266 266 val_266
    +27 val_27 27 val_27
    +272 val_272 272 val_272
    +273 val_273 273 val_273
    +274 val_274 274 val_274
    +275 val_275 275 val_275
    +277 val_277 277 val_277
    +278 val_278 278 val_278
    +28 val_28 28 val_28
    +280 val_280 280 val_280
    +281 val_281 281 val_281
    +282 val_282 282 val_282
    +283 val_283 283 val_283
    +284 val_284 284 val_284
    +285 val_285 285 val_285
    +286 val_286 286 val_286
    +287 val_287 287 val_287
    +288 val_288 288 val_288
    +289 val_289 289 val_289
    +291 val_291 291 val_291
    +292 val_292 292 val_292
    +296 val_296 296 val_296
    +298 val_298 298 val_298
    +30 val_30 30 val_30
    +302 val_302 302 val_302
    +305 val_305 305 val_305
    +306 val_306 306 val_306
    +307 val_307 307 val_307
    +308 val_308 308 val_308
    +309 val_309 309 val_309
    +310 val_310 310 val_310
    +311 val_311 311 val_311
    +315 val_315 315 val_315
    +316 val_316 316 val_316
    +317 val_317 317 val_317
    +318 val_318 318 val_318
    +321 val_321 321 val_321
    +322 val_322 322 val_322
    +323 val_323 323 val_323
    +325 val_325 325 val_325
    +327 val_327 327 val_327
    +33 val_33 33 val_33
    +331 val_331 331 val_331
    +332 val_332 332 val_332
    +333 val_333 333 val_333
    +335 val_335 335 val_335
    +336 val_336 336 val_336
    +338 val_338 338 val_338
    +339 val_339 339 val_339
    +34 val_34 34 val_34
    +341 val_341 341 val_341
    +342 val_342 342 val_342
    +344 val_344 344 val_344
    +345 val_345 345 val_345
    +348 val_348 348 val_348
    +35 val_35 35 val_35
    +351 val_351 351 val_351
    +353 val_353 353 val_353
    +356 val_356 356 val_356
    +360 val_360 360 val_360
    +362 val_362 362 val_362
    +364 val_364 364 val_364
    +365 val_365 365 val_365
    +366 val_366 366 val_366
    +367 val_367 367 val_367
    +368 val_368 368 val_368
    +369 val_369 369 val_369
    +37 val_37 37 val_37
    +373 val_373 373 val_373
    +374 val_374 374 val_374
    +375 val_375 375 val_375
    +377 val_377 377 val_377
    +378 val_378 378 val_378
    +379 val_379 379 val_379
    +382 val_382 382 val_382
    +384 val_384 384 val_384
    +386 val_386 386 val_386
    +389 val_389 389 val_389
    +392 val_392 392 val_392
    +393 val_393 393 val_393
    +394 val_394 394 val_394
    +395 val_395 395 val_395
    +396 val_396 396 val_396
    +397 val_397 397 val_397
    +399 val_399 399 val_399
    +4 val_4 4 val_4
    +400 val_400 400 val_400
    +401 val_401 401 val_401
    +402 val_402 402 val_402
    +403 val_403 403 val_403
    +404 val_404 404 val_404
    +406 val_406 406 val_406
    +407 val_407 407 val_407
    +409 val_409 409 val_409
    +41 val_41 41 val_41
    +411 val_411 411 val_411
    +413 val_413 413 val_413
    +414 val_414 414 val_414
    +417 val_417 417 val_417
    +418 val_418 418 val_418
    +419 val_419 419 val_419
    +42 val_42 42 val_42
    +421 val_421 421 val_421
    +424 val_424 424 val_424
    +427 val_427 427 val_427
    +429 val_429 429 val_429
    +43 val_43 43 val_43
    +430 val_430 430 val_430
    +431 val_431 431 val_431
    +432 val_432 432 val_432
    +435 val_435 435 val_435
    +436 val_436 436 val_436
    +437 val_437 437 val_437
    +438 val_438 438 val_438
    +439 val_439 439 val_439
    +44 val_44 44 val_44
    +443 val_443 443 val_443
    +444 val_444 444 val_444
    +446 val_446 446 val_446
    +448 val_448 448 val_448
    +449 val_449 449 val_449
    +452 val_452 452 val_452
    +453 val_453 453 val_453
    +454 val_454 454 val_454
    +455 val_455 455 val_455
    +457 val_457 457 val_457
    +458 val_458 458 val_458
    +459 val_459 459 val_459
    +460 val_460 460 val_460
    +462 val_462 462 val_462
    +463 val_463 463 val_463
    +466 val_466 466 val_466
    +467 val_467 467 val_467
    +468 val_468 468 val_468
    +469 val_469 469 val_469
    +47 val_47 47 val_47
    +470 val_470 470 val_470
    +472 val_472 472 val_472
    +475 val_475 475 val_475
    +477 val_477 477 val_477
    +478 val_478 478 val_478
    +479 val_479 479 val_479
    +480 val_480 480 val_480
    +481 val_481 481 val_481
    +482 val_482 482 val_482
    +483 val_483 483 val_483
    +484 val_484 484 val_484
    +485 val_485 485 val_485
    +487 val_487 487 val_487
    +489 val_489 489 val_489
    +490 val_490 490 val_490
    +491 val_491 491 val_491
    +492 val_492 492 val_492
    +493 val_493 493 val_493
    +494 val_494 494 val_494
    +495 val_495 495 val_495
    +496 val_496 496 val_496
    +497 val_497 497 val_497
    +498 val_498 498 val_498
    +5 val_5 5 val_5
    +51 val_51 51 val_51
    +53 val_53 53 val_53
    +54 val_54 54 val_54
    +57 val_57 57 val_57
    +58 val_58 58 val_58
    +64 val_64 64 val_64
    +65 val_65 65 val_65
    +66 val_66 66 val_66
    +67 val_67 67 val_67
    +69 val_69 69 val_69
    +70 val_70 70 val_70
    +72 val_72 72 val_72
    +74 val_74 74 val_74
    +76 val_76 76 val_76
    +77 val_77 77 val_77
    +78 val_78 78 val_78
    +8 val_8 8 val_8
    +80 val_80 80 val_80
    +82 val_82 82 val_82
    +83 val_83 83 val_83
    +84 val_84 84 val_84
    +85 val_85 85 val_85
    +86 val_86 86 val_86
    +87 val_87 87 val_87
    +9 val_9 9 val_9
    +90 val_90 90 val_90
    +92 val_92 92 val_92
    +95 val_95 95 val_95
    +96 val_96 96 val_96
    +97 val_97 97 val_97
    +98 val_98 98 val_98
    +PREHOOK: query: select distinct * from (select distinct * from src)src1
    +PREHOOK: type: QUERY
    +PREHOOK: Input: default@src
    +#### A masked pattern was here ####
    +POSTHOOK: query: select distinct * from (select distinct * from src)src1
    +POSTHOOK: type: QUERY
    +POSTHOOK: Input: default@src
    +#### A masked pattern was here ####
    +0 val_0
    +10 val_10
    +100 val_100
    +103 val_103
    +104 val_104
    +105 val_105
    +11 val_11
    +111 val_111
    +113 val_113
    +114 val_114
    +116 val_116
    +118 val_118
    +119 val_119
    +12 val_12
    +120 val_120
    +125 val_125
    +126 val_126
    +128 val_128
    +129 val_129
    +131 val_131
    +133 val_133
    +134 val_134
    +136 val_136
    +137 val_137
    +138 val_138
    +143 val_143
    +145 val_145
    +146 val_146
    +149 val_149
    +15 val_15
    +150 val_150
    +152 val_152
    +153 val_153
    +155 val_155
    +156 val_156
    +157 val_157
    +158 val_158
    +160 val_160
    +162 val_162
    +163 val_163
    +164 val_164
    +165 val_165
    +166 val_166
    +167 val_167
    +168 val_168
    +169 val_169
    +17 val_17
    +170 val_170
    +172 val_172
    +174 val_174
    +175 val_175
    +176 val_176
    +177 val_177
    +178 val_178
    +179 val_179
    +18 val_18
    +180 val_180
    +181 val_181
    +183 val_183
    +186 val_186
    +187 val_187
    +189 val_189
    +19 val_19
    +190 val_190
    +191 val_191
    +192 val_192
    +193 val_193
    +194 val_194
    +195 val_195
    +196 val_196
    +197 val_197
    +199 val_199
    +2 val_2
    +20 val_20
    +200 val_200
    +201 val_201
    +202 val_202
    +203 val_203
    +205 val_205
    +207 val_207
    +208 val_208
    +209 val_209
    +213 val_213
    +214 val_214
    +216 val_216
    +217 val_217
    +218 val_218
    +219 val_219
    +221 val_221
    +222 val_222
    +223 val_223
    +224 val_224
    +226 val_226
    +228 val_228
    +229 val_229
    +230 val_230
    +233 val_233
    +235 val_235
    +237 val_237
    +238 val_238
    +239 val_239
    +24 val_24
    +241 val_241
    +242 val_242
    +244 val_244
    +247 val_247
    +248 val_248
    +249 val_249
    +252 val_252
    +255 val_255
    +256 val_256
    +257 val_257
    +258 val_258
    +26 val_26
    +260 val_260
    +262 val_262
    +263 val_263
    +265 val_265
    +266 val_266
    +27 val_27
    +272 val_272
    +273 val_273
    +274 val_274
    +275 val_275
    +277 val_277
    +278 val_278
    +28 val_28
    +280 val_280
    +281 val_281
    +282 val_282
    +283 val_283
    +284 val_284
    +285 val_285
    +286 val_286
    +287 val_287
    +288 val_288
    +289 val_289
    +291 val_291
    +292 val_292
    +296 val_296
    +298 val_298
    +30 val_30
    +302 val_302
    +305 val_305
    +306 val_306
    +307 val_307
    +308 val_308
    +309 val_309
    +310 val_310
    +311 val_311
    +315 val_315
    +316 val_316
    +317 val_317
    +318 val_318
    +321 val_321
    +322 val_322
    +323 val_323
    +325 val_325
    +327 val_327
    +33 val_33
    +331 val_331
    +332 val_332
    +333 val_333
    +335 val_335
    +336 val_336
    +338 val_338
    +339 val_339
    +34 val_34
    +341 val_341
    +342 val_342
    +344 val_344
    +345 val_345
    +348 val_348
    +35 val_35
    +351 val_351
    +353 val_353
    +356 val_356
    +360 val_360
    +362 val_362
    +364 val_364
    +365 val_365
    +366 val_366
    +367 val_367
    +368 val_368
    +369 val_369
    +37 val_37
    +373 val_373
    +374 val_374
    +375 val_375
    +377 val_377
    +378 val_378
    +379 val_379
    +382 val_382
    +384 val_384
    +386 val_386
    +389 val_389
    +392 val_392
    +393 val_393
    +394 val_394
    +395 val_395
    +396 val_396
    +397 val_397
    +399 val_399
    +4 val_4
    +400 val_400
    +401 val_401
    +402 val_402
    +403 val_403
    +404 val_404
    +406 val_406
    +407 val_407
    +409 val_409
    +41 val_41
    +411 val_411
    +413 val_413
    +414 val_414
    +417 val_417
    +418 val_418
    +419 val_419
    +42 val_42
    +421 val_421
    +424 val_424
    +427 val_427
    +429 val_429
    +43 val_43
    +430 val_430
    +431 val_431
    +432 val_432
    +435 val_435
    +436 val_436
    +437 val_437
    +438 val_438
    +439 val_439
    +44 val_44
    +443 val_443
    +444 val_444
    +446 val_446
    +448 val_448
    +449 val_449
    +452 val_452
    +453 val_453
    +454 val_454
    +455 val_455
    +457 val_457
    +458 val_458
    +459 val_459
    +460 val_460
    +462 val_462
    +463 val_463
    +466 val_466
    +467 val_467
    +468 val_468
    +469 val_469
    +47 val_47
    +470 val_470
    +472 val_472
    +475 val_475
    +477 val_477
    +478 val_478
    +479 val_479
    +480 val_480
    +481 val_481
    +482 val_482
    +483 val_483
    +484 val_484
    +485 val_485
    +487 val_487
    +489 val_489
    +490 val_490
    +491 val_491
    +492 val_492
    +493 val_493
    +494 val_494
    +495 val_495
    +496 val_496
    +497 val_497
    +498 val_498
    +5 val_5
    +51 val_51
    +53 val_53
    +54 val_54
    +57 val_57
    +58 val_58
    +64 val_64
    +65 val_65
    +66 val_66
    +67 val_67
    +69 val_69
    +70 val_70
    +72 val_72
    +74 val_74
    +76 val_76
    +77 val_77
    +78 val_78
    +8 val_8
    +80 val_80
    +82 val_82
    +83 val_83
    +84 val_84
    +85 val_85
    +86 val_86
    +87 val_87
    +9 val_9
    +90 val_90
    +92 val_92
    +95 val_95
    +96 val_96
    +97 val_97
    +98 val_98
    +PREHOOK: query: explain select distinct src.* from src
    +PREHOOK: type: QUERY
    +POSTHOOK: query: explain select distinct src.* from src
    +POSTHOOK: type: QUERY
    +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: src
    + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
    + Select Operator
    + expressions: key (type: string), value (type: string)
    + outputColumnNames: _col0, _col1
    + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
    + Group By Operator
    + keys: _col0 (type: string), _col1 (type: string)
    + mode: hash
    + outputColumnNames: _col0, _col1
    + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
    + Reduce Output Operator
    + key expressions: _col0 (type: string), _col1 (type: string)
    + sort order: ++
    + Map-reduce partition columns: _col0 (type: string), _col1 (type: string)
    + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
    + Reduce Operator Tree:
    + Group By Operator
    + keys: KEY._col0 (type: string), KEY._col1 (type: string)
    + mode: mergepartial
    + outputColumnNames: _col0, _col1
    + Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
    + Select Operator
    + expressions: _col0 (type: string), _col1 (type: string)
    + outputColumnNames: _col0, _col1
    + Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
    + File Output Operator
    + compressed: false
    + Statistics: Num rows: 250 Data size: 2656 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: -1
    + Processor Tree:
    + ListSink
    +
    +PREHOOK: query: select distinct src.* from src
    +PREHOOK: type: QUERY
    +PREHOOK: Input: default@src
    +#### A masked pattern was here ####
    +POSTHOOK: query: select distinct src.* from src
    +POSTHOOK: type: QUERY
    +POSTHOOK: Input: default@src
    +#### A masked pattern was here ####
    +0 val_0
    +10 val_10
    +100 val_100
    +103 val_103
    +104 val_104
    +105 val_105
    +11 val_11
    +111 val_111
    +113 val_113
    +114 val_114
    +116 val_116
    +118 val_118
    +119 val_119
    +12 val_12
    +120 val_120
    +125 val_125
    +126 val_126
    +128 val_128
    +129 val_129
    +131 val_131
    +133 val_133
    +134 val_134
    +136 val_136
    +137 val_137
    +138 val_138
    +143 val_143
    +145 val_145
    +146 val_146
    +149 val_149
    +15 val_15
    +150 val_150
    +152 val_152
    +153 val_153
    +155 val_155
    +156 val_156
    +157 val_157
    +158 val_158
    +160 val_160
    +162 val_162
    +163 val_163
    +164 val_164
    +165 val_165
    +166 val_166
    +167 val_167
    +168 val_168
    +169 val_169
    +17 val_17
    +170 val_170
    +172 val_172
    +174 val_174
    +175 val_175
    +176 val_176
    +177 val_177
    +178 val_178
    +179 val_179
    +18 val_18
    +180 val_180
    +181 val_181
    +183 val_183
    +186 val_186
    +187 val_187
    +189 val_189
    +19 val_19
    +190 val_190
    +191 val_191
    +192 val_192
    +193 val_193
    +194 val_194
    +195 val_195
    +196 val_196
    +197 val_197
    +199 val_199
    +2 val_2
    +20 val_20
    +200 val_200
    +201 val_201
    +202 val_202
    +203 val_203
    +205 val_205
    +207 val_207
    +208 val_208
    +209 val_209
    +213 val_213
    +214 val_214
    +216 val_216
    +217 val_217
    +218 val_218
    +219 val_219
    +221 val_221
    +222 val_222
    +223 val_223
    +224 val_224
    +226 val_226
    +228 val_228
    +229 val_229
    +230 val_230
    +233 val_233
    +235 val_235
    +237 val_237
    +238 val_238
    +239 val_239
    +24 val_24
    +241 val_241
    +242 val_242
    +244 val_244
    +247 val_247
    +248 val_248
    +249 val_249
    +252 val_252
    +255 val_255
    +256 val_256
    +257 val_257
    +258 val_258
    +26 val_26
    +260 val_260
    +262 val_262
    +263 val_263
    +265 val_265
    +266 val_266
    +27 val_27
    +272 val_272
    +273 val_273
    +274 val_274
    +275 val_275
    +277 val_277
    +278 val_278
    +28 val_28
    +280 val_280
    +281 val_281
    +282 val_282
    +283 val_283
    +284 val_284
    +285 val_285
    +286 val_286
    +287 val_287
    +288 val_288
    +289 val_289
    +291 val_291
    +292 val_292
    +296 val_296
    +298 val_298
    +30 val_30
    +302 val_302
    +305 val_305
    +306 val_306
    +307 val_307
    +308 val_308
    +309 val_309
    +310 val_310
    +311 val_311
    +315 val_315
    +316 val_316
    +317 val_317
    +318 val_318
    +321 val_321
    +322 val_322
    +323 val_323
    +325 val_325
    +327 val_327
    +33 val_33
    +331 val_331
    +332 val_332
    +333 val_333
    +335 val_335
    +336 val_336
    +338 val_338
    +339 val_339
    +34 val_34
    +341 val_341
    +342 val_342
    +344 val_344
    +345 val_345
    +348 val_348
    +35 val_35
    +351 val_351
    +353 val_353
    +356 val_356
    +360 val_360
    +362 val_362
    +364 val_364
    +365 val_365
    +366 val_366
    +367 val_367
    +368 val_368
    +369 val_369
    +37 val_37
    +373 val_373
    +374 val_374
    +375 val_375
    +377 val_377
    +378 val_378
    +379 val_379
    +382 val_382
    +384 val_384
    +386 val_386
    +389 val_389
    +392 val_392
    +393 val_393
    +394 val_394
    +395 val_395
    +396 val_396
    +397 val_397
    +399 val_399
    +4 val_4
    +400 val_400
    +401 val_401
    +402 val_402
    +403 val_403
    +404 val_404
    +406 val_406
    +407 val_407
    +409 val_409
    +41 val_41
    +411 val_411
    +413 val_413
    +414 val_414
    +417 val_417
    +418 val_418
    +419 val_419
    +42 val_42
    +421 val_421
    +424 val_424
    +427 val_427
    +429 val_429
    +43 val_43
    +430 val_430
    +431 val_431
    +432 val_432
    +435 val_435
    +436 val_436
    +437 val_437
    +438 val_438
    +439 val_439
    +44 val_44
    +443 val_443
    +444 val_444
    +446 val_446
    +448 val_448
    +449 val_449
    +452 val_452
    +453 val_453
    +454 val_454
    +455 val_455
    +457 val_457
    +458 val_458
    +459 val_459
    +460 val_460
    +462 val_462
    +463 val_463
    +466 val_466
    +467 val_467
    +468 val_468
    +469 val_469
    +47 val_47
    +470 val_470
    +472 val_472
    +475 val_475
    +477 val_477
    +478 val_478
    +479 val_479
    +480 val_480
    +481 val_481
    +482 val_482
    +483 val_483
    +484 val_484
    +485 val_485
    +487 val_487
    +489 val_489
    +490 val_490
    +491 val_491
    +492 val_492
    +493 val_493
    +494 val_494
    +495 val_495
    +496 val_496
    +497 val_497
    +498 val_498
    +5 val_5
    +51 val_51
    +53 val_53
    +54 val_54
    +57 val_57
    +58 val_58
    +64 val_64
    +65 val_65
    +66 val_66
    +67 val_67
    +69 val_69
    +70 val_70
    +72 val_72
    +74 val_74
    +76 val_76
    +77 val_77
    +78 val_78
    +8 val_8
    +80 val_80
    +82 val_82
    +83 val_83
    +84 val_84
    +85 val_85
    +86 val_86
    +87 val_87
    +9 val_9
    +90 val_90
    +92 val_92
    +95 val_95
    +96 val_96
    +97 val_97
    +98 val_98
    +PREHOOK: query: select distinct * from src
    +PREHOOK: type: QUERY
    +PREHOOK: Input: default@src
    +#### A masked pattern was here ####
    +POSTHOOK: query: select distinct * from src
    +POSTHOOK: type: QUERY
    +POSTHOOK: Input: default@src
    +#### A masked pattern was here ####
    +0 val_0
    +10 val_10
    +100 val_100
    +103 val_103
    +104 val_104
    +105 val_105
    +11 val_11
    +111 val_111
    +113 val_113
    +114 val_114
    +116 val_116
    +118 val_118
    +119 val_119
    +12 val_12
    +120 val_120
    +125 val_125
    +126 val_126
    +128 val_128
    +129 val_129
    +131 val_131
    +133 val_133
    +134 val_134
    +136 val_136
    +137 val_137
    +138 val_138
    +143 val_143
    +145 val_145
    +146 val_146
    +149 val_149
    +15 val_15
    +150 val_150
    +152 val_152
    +153 val_153
    +155 val_155
    +156 val_156
    +157 val_157
    +158 val_158
    +160 val_160
    +162 val_162
    +163 val_163
    +164 val_164
    +165 val_165
    +166 val_166
    +167 val_167
    +168 val_168
    +169 val_169
    +17 val_17
    +170 val_170
    +172 val_172
    +174 val_174
    +175 val_175
    +176 val_176
    +177 val_177
    +178 val_178
    +179 val_179
    +18 val_18
    +180 val_180
    +181 val_181
    +183 val_183
    +186 val_186
    +187 val_187
    +189 val_189
    +19 val_19
    +190 val_190
    +191 val_191
    +192 val_192
    +193 val_193
    +194 val_194
    +195 val_195
    +196 val_196
    +197 val_197
    +199 val_199
    +2 val_2
    +20 val_20
    +200 val_200
    +201 val_201
    +202 val_202
    +203 val_203
    +205 val_205
    +207 val_207
    +208 val_208
    +209 val_209
    +213 val_213
    +214 val_214
    +216 val_216
    +217 val_217
    +218 val_218
    +219 val_219
    +221 val_221
    +222 val_222
    +223 val_223
    +224 val_224
    +226 val_226
    +228 val_228
    +229 val_229
    +230 val_230
    +233 val_233
    +235 val_235
    +237 val_237
    +238 val_238
    +239 val_239
    +24 val_24
    +241 val_241
    +242 val_242
    +244 val_244
    +247 val_247
    +248 val_248
    +249 val_249
    +252 val_252
    +255 val_255
    +256 val_256
    +257 val_257
    +258 val_258
    +26 val_26
    +260 val_260
    +262 val_262
    +263 val_263
    +265 val_265
    +266 val_266
    +27 val_27
    +272 val_272
    +273 val_273
    +274 val_274
    +275 val_275
    +277 val_277
    +278 val_278
    +28 val_28
    +280 val_280
    +281 val_281
    +282 val_282
    +283 val_283
    +284 val_284
    +285 val_285
    +286 val_286
    +287 val_287
    +288 val_288
    +289 val_289
    +291 val_291
    +292 val_292
    +296 val_296
    +298 val_298
    +30 val_30
    +302 val_302
    +305 val_305
    +306 val_306
    +307 val_307
    +308 val_308
    +309 val_309
    +310 val_310
    +311 val_311
    +315 val_315
    +316 val_316
    +317 val_317
    +318 val_318
    +321 val_321
    +322 val_322
    +323 val_323
    +325 val_325
    +327 val_327
    +33 val_33
    +331 val_331
    +332 val_332
    +333 val_333
    +335 val_335
    +336 val_336
    +338 val_338
    +339 val_339
    +34 val_34
    +341 val_341
    +342 val_342
    +344 val_344
    +345 val_345
    +348 val_348
    +35 val_35
    +351 val_351
    +353 val_353
    +356 val_356
    +360 val_360
    +362 val_362
    +364 val_364
    +365 val_365
    +366 val_366
    +367 val_367
    +368 val_368
    +369 val_369
    +37 val_37
    +373 val_373
    +374 val_374
    +375 val_375
    +377 val_377
    +378 val_378
    +379 val_379
    +382 val_382
    +384 val_384
    +386 val_386
    +389 val_389
    +392 val_392
    +393 val_393
    +394 val_394
    +395 val_395
    +396 val_396
    +397 val_397
    +399 val_399
    +4 val_4
    +400 val_400
    +401 val_401
    +402 val_402
    +403 val_403
    +404 val_404
    +406 val_406
    +407 val_407
    +409 val_409
    +41 val_41
    +411 val_411
    +413 val_413
    +414 val_414
    +417 val_417
    +418 val_418
    +419 val_419
    +42 val_42
    +421 val_421
    +424 val_424
    +427 val_427
    +429 val_429
    +43 val_43
    +430 val_430
    +431 val_431
    +432 val_432
    +435 val_435
    +436 val_436
    +437 val_437
    +438 val_438
    +439 val_439
    +44 val_44
    +443 val_443
    +444 val_444
    +446 val_446
    +448 val_448
    +449 val_449
    +452 val_452
    +453 val_453
    +454 val_454
    +455 val_455
    +457 val_457
    +458 val_458
    +459 val_459
    +460 val_460
    +462 val_462
    +463 val_463
    +466 val_466
    +467 val_467
    +468 val_468
    +469 val_469
    +47 val_47
    +470 val_470
    +472 val_472
    +475 val_475
    +477 val_477
    +478 val_478
    +479 val_479
    +480 val_480
    +481 val_481
    +482 val_482
    +483 val_483
    +484 val_484
    +485 val_485
    +487 val_487
    +489 val_489
    +490 val_490
    +491 val_491
    +492 val_492
    +493 val_493
    +494 val_494
    +495 val_495
    +496 val_496
    +497 val_497
    +498 val_498
    +5 val_5
    +51 val_51
    +53 val_53
    +54 val_54
    +57 val_57
    +58 val_58
    +64 val_64
    +65 val_65
    +66 val_66
    +67 val_67
    +69 val_69
    +70 val_70
    +72 val_72
    +74 val_74
    +76 val_76
    +77 val_77
    +78 val_78
    +8 val_8
    +80 val_80
    +82 val_82
    +83 val_83
    +84 val_84
    +85 val_85
    +86 val_86
    +87 val_87
    +9 val_9
    +90 val_90
    +92 val_92
    +95 val_95
    +96 val_96
    +97 val_97
    +98 val_98
    +PREHOOK: query: explain select distinct * from src where key < '3'
    +PREHOOK: type: QUERY
    +POSTHOOK: query: explain select distinct * from src where key < '3'
    +POSTHOOK: type: QUERY
    +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: src
    + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
    + Filter Operator
    + predicate: (key < '3') (type: boolean)
    + Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
    + Select Operator
    + expressions: key (type: string), value (type: string)
    + outputColumnNames: _col0, _col1
    + Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
    + Group By Operator
    + keys: _col0 (type: string), _col1 (type: string)
    + mode: hash
    + outputColumnNames: _col0, _col1
    + Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
    + Reduce Output Operator
    + key expressions: _col0 (type: string), _col1 (type: string)
    + sort order: ++
    + Map-reduce partition columns: _col0 (type: string), _col1 (type: string)
    + Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
    + Reduce Operator Tree:
    + Group By Operator
    + keys: KEY._col0 (type: string), KEY._col1 (type: string)
    + mode: mergepartial
    + outputColumnNames: _col0, _col1
    + Statistics: Num rows: 83 Data size: 881 Basic stats: COMPLETE Column stats: NONE
    + Select Operator
    + expressions: _col0 (type: string), _col1 (type: string)
    + outputColumnNames: _col0, _col1
    + Statistics: Num rows: 83 Data size: 881 Basic stats: COMPLETE Column stats: NONE
    + File Output Operator
    + compressed: false
    + Statistics: Num rows: 83 Data size: 881 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: -1
    + Processor Tree:
    + ListSink
    +
    +PREHOOK: query: select distinct * from src where key < '3'
    +PREHOOK: type: QUERY
    +PREHOOK: Input: default@src
    +#### A masked pattern was here ####
    +POSTHOOK: query: select distinct * from src where key < '3'
    +POSTHOOK: type: QUERY
    +POSTHOOK: Input: default@src
    +#### A masked pattern was here ####
    +0 val_0
    +10 val_10
    +100 val_100
    +103 val_103
    +104 val_104
    +105 val_105
    +11 val_11
    +111 val_111
    +113 val_113
    +114 val_114
    +116 val_116
    +118 val_118
    +119 val_119
    +12 val_12
    +120 val_120
    +125 val_125
    +126 val_126
    +128 val_128
    +129 val_129
    +131 val_131
    +133 val_133
    +134 val_134
    +136 val_136
    +137 val_137
    +138 val_138
    +143 val_143
    +145 val_145
    +146 val_146
    +149 val_149
    +15 val_15
    +150 val_150
    +152 val_152
    +153 val_153
    +155 val_155
    +156 val_156
    +157 val_157
    +158 val_158
    +160 val_160
    +162 val_162
    +163 val_163
    +164 val_164
    +165 val_165
    +166 val_166
    +167 val_167
    +168 val_168
    +169 val_169
    +17 val_17
    +170 val_170
    +172 val_172
    +174 val_174
    +175 val_175
    +176 val_176
    +177 val_177
    +178 val_178
    +179 val_179
    +18 val_18
    +180 val_180
    +181 val_181
    +183 val_183
    +186 val_186
    +187 val_187
    +189 val_189
    +19 val_19
    +190 val_190
    +191 val_191
    +192 val_192
    +193 val_193
    +194 val_194
    +195 val_195
    +196 val_196
    +197 val_197
    +199 val_199
    +2 val_2
    +20 val_20
    +200 val_200
    +201 val_201
    +202 val_202
    +203 val_203
    +205 val_205
    +207 val_207
    +208 val_208
    +209 val_209
    +213 val_213
    +214 val_214
    +216 val_216
    +217 val_217
    +218 val_218
    +219 val_219
    +221 val_221
    +222 val_222
    +223 val_223
    +224 val_224
    +226 val_226
    +228 val_228
    +229 val_229
    +230 val_230
    +233 val_233
    +235 val_235
    +237 val_237
    +238 val_238
    +239 val_239
    +24 val_24
    +241 val_241
    +242 val_242
    +244 val_244
    +247 val_247
    +248 val_248
    +249 val_249
    +252 val_252
    +255 val_255
    +256 val_256
    +257 val_257
    +258 val_258
    +26 val_26
    +260 val_260
    +262 val_262
    +263 val_263
    +265 val_265
    +266 val_266
    +27 val_27
    +272 val_272
    +273 val_273
    +274 val_274
    +275 val_275
    +277 val_277
    +278 val_278
    +28 val_28
    +280 val_280
    +281 val_281
    +282 val_282
    +283 val_283
    +284 val_284
    +285 val_285
    +286 val_286
    +287 val_287
    +288 val_288
    +289 val_289
    +291 val_291
    +292 val_292
    +296 val_296
    +298 val_298
    +PREHOOK: query: from src a select distinct a.* where a.key = '238'
    +PREHOOK: type: QUERY
    +PREHOOK: Input: default@src
    +#### A masked pattern was here ####
    +POSTHOOK: query: from src a select distinct a.* where a.key = '238'
    +POSTHOOK: type: QUERY
    +POSTHOOK: Input: default@src
    +#### A masked pattern was here ####
    +238 val_238
    +PREHOOK: query: explain
    +SELECT distinct * from (
    +select * from src1
    +union all
    +select * from src )subq
    +PREHOOK: type: QUERY
    +POSTHOOK: query: explain
    +SELECT distinct * from (
    +select * from src1
    +union all
    +select * from src )subq
    +POSTHOOK: type: QUERY
    +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: src1
    + Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
    + Select Operator
    + expressions: key (type: string), value (type: string)
    + outputColumnNames: _col0, _col1
    + Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
    + Union
    + Statistics: Num rows: 525 Data size: 5503 Basic stats: COMPLETE Column stats: NONE
    + Group By Operator
    + keys: _col0 (type: string), _col1 (type: string)
    + mode: hash
    + outputColumnNames: _col0, _col1
    + Statistics: Num rows: 525 Data size: 5503 Basic stats: COMPLETE Column stats: NONE
    + Reduce Output Operator
    + key expressions: _col0 (type: string), _col1 (type: string)
    + sort order: ++
    + Map-reduce partition columns: _col0 (type: string), _col1 (type: string)
    + Statistics: Num rows: 525 Data size: 5503 Basic stats: COMPLETE Column stats: NONE
    + TableScan
    + alias: src
    + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
    + Select Operator
    + expressions: key (type: string), value (type: string)
    + outputColumnNames: _col0, _col1
    + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
    + Union
    + Statistics: Num rows: 525 Data size: 5503 Basic stats: COMPLETE Column stats: NONE
    + Group By Operator
    + keys: _col0 (type: string), _col1 (type: string)
    + mode: hash
    + outputColumnNames: _col0, _col1
    + Statistics: Num rows: 525 Data size: 5503 Basic stats: COMPLETE Column stats: NONE
    + Reduce Output Operator
    + key expressions: _col0 (type: string), _col1 (type: string)
    + sort order: ++
    + Map-reduce partition columns: _col0 (type: string), _col1 (type: string)
    + Statistics: Num rows: 525 Data size: 5503 Basic stats: COMPLETE Column stats: NONE
    + Reduce Operator Tree:
    + Group By Operator
    + keys: KEY._col0 (type: string), KEY._col1 (type: string)
    + mode: mergepartial
    + outputColumnNames: _col0, _col1
    + Statistics: Num rows: 262 Data size: 2746 Basic stats: COMPLETE Column stats: NONE
    + Select Operator
    + expressions: _col0 (type: string), _col1 (type: string)
    + outputColumnNames: _col0, _col1
    + Statistics: Num rows: 262 Data size: 2746 Basic stats: COMPLETE Column stats: NONE
    + File Output Operator
    + compressed: false
    + Statistics: Num rows: 262 Data size: 2746 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: -1
    + Processor Tree:
    + ListSink
    +
    +PREHOOK: query: SELECT distinct * from (
    +select * from src1
    +union all
    +select * from src )subq
    +PREHOOK: type: QUERY
    +PREHOOK: Input: default@src
    +PREHOOK: Input: default@src1
    +#### A masked pattern was here ####
    +POSTHOOK: query: SELECT distinct * from (
    +select * from src1
    +union all
    +select * from src )subq
    +POSTHOOK: type: QUERY
    +POSTHOOK: Input: default@src
    +POSTHOOK: Input: default@src1
    +#### A masked pattern was here ####
    +
    + val_165
    + val_193
    + val_265
    + val_27
    + val_409
    + val_484
    +0 val_0
    +10 val_10
    +100 val_100
    +103 val_103
    +104 val_104
    +105 val_105
    +11 val_11
    +111 val_111
    +113 val_113
    +114 val_114
    +116 val_116
    +118 val_118
    +119 val_119
    +12 val_12
    +120 val_120
    +125 val_125
    +126 val_126
    +128
    +128 val_128
    +129 val_129
    +131 val_131
    +133 val_133
    +134 val_134
    +136 val_136
    +137 val_137
    +138 val_138
    +143 val_143
    +145 val_145
    +146 val_146
    +149 val_149
    +15 val_15
    +150 val_150
    +152 val_152
    +153 val_153
    +155 val_155
    +156 val_156
    +157 val_157
    +158 val_158
    +160 val_160
    +162 val_162
    +163 val_163
    +164 val_164
    +165 val_165
    +166 val_166
    +167 val_167
    +168 val_168
    +169 val_169
    +17 val_17
    +170 val_170
    +172 val_172
    +174 val_174
    +175 val_175
    +176 val_176
    +177 val_177
    +178 val_178
    +179 val_179
    +18 val_18
    +180 val_180
    +181 val_181
    +183 val_183
    +186 val_186
    +187 val_187
    +189 val_189
    +19 val_19
    +190 val_190
    +191 val_191
    +192 val_192
    +193 val_193
    +194 val_194
    +195 val_195
    +196 val_196
    +197 val_197
    +199 val_199
    +2 val_2
    +20 val_20
    +200 val_200
    +201 val_201
    +202 val_202
    +203 val_203
    +205 val_205
    +207 val_207
    +208 val_208
    +209 val_209
    +213 val_213
    +214 val_214
    +216 val_216
    +217 val_217
    +218 val_218
    +219 val_219
    +221 val_221
    +222 val_222
    +223 val_223
    +224
    +224 val_224
    +226 val_226
    +228 val_228
    +229 val_229
    +230 val_230
    +233 val_233
    +235 val_235
    +237 val_237
    +238 val_238
    +239 val_239
    +24 val_24
    +241 val_241
    +242 val_242
    +244 val_244
    +247 val_247
    +248 val_248
    +249 val_249
    +252 val_252
    +255 val_255
    +256 val_256
    +257 val_257
    +258 val_258
    +26 val_26
    +260 val_260
    +262 val_262
    +263 val_263
    +265 val_265
    +266 val_266
    +27 val_27
    +272 val_272
    +273 val_273
    +274 val_274
    +275 val_275
    +277 val_277
    +278 val_278
    +28 val_28
    +280 val_280
    +281 val_281
    +282 val_282
    +283 val_283
    +284 val_284
    +285 val_285
    +286 val_286
    +287 val_287
    +288 val_288
    +289 val_289
    +291 val_291
    +292 val_292
    +296 val_296
    +298 val_298
    +30 val_30
    +302 val_302
    +305 val_305
    +306 val_306
    +307 val_307
    +308 val_308
    +309 val_309
    +310 val_310
    +311 val_311
    +315 val_315
    +316 val_316
    +317 val_317
    +318 val_318
    +321 val_321
    +322 val_322
    +323 val_323
    +325 val_325
    +327 val_327
    +33 val_33
    +331 val_331
    +332 val_332
    +333 val_333
    +335 val_335
    +336 val_336
    +338 val_338
    +339 val_339
    +34 val_34
    +341 val_341
    +342 val_342
    +344 val_344
    +345 val_345
    +348 val_348
    +35 val_35
    +351 val_351
    +353 val_353
    +356 val_356
    +360 val_360
    +362 val_362
    +364 val_364
    +365 val_365
    +366 val_366
    +367 val_367
    +368 val_368
    +369
    +369 val_369
    +37 val_37
    +373 val_373
    +374 val_374
    +375 val_375
    +377 val_377
    +378 val_378
    +379 val_379
    +382 val_382
    +384 val_384
    +386 val_386
    +389 val_389
    +392 val_392
    +393 val_393
    +394 val_394
    +395 val_395
    +396 val_396
    +397 val_397
    +399 val_399
    +4 val_4
    +400 val_400
    +401 val_401
    +402 val_402
    +403 val_403
    +404 val_404
    +406 val_406
    +407 val_407
    +409 val_409
    +41 val_41
    +411 val_411
    +413 val_413
    +414 val_414
    +417 val_417
    +418 val_418
    +419 val_419
    +42 val_42
    +421 val_421
    +424 val_424
    +427 val_427
    +429 val_429
    +43 val_43
    +430 val_430
    +431 val_431
    +432 val_432
    +435 val_435
    +436 val_436
    +437 val_437
    +438 val_438
    +439 val_439
    +44 val_44
    +443 val_443
    +444 val_444
    +446 val_446
    +448 val_448
    +449 val_449
    +452 val_452
    +453 val_453
    +454 val_454
    +455 val_455
    +457 val_457
    +458 val_458
    +459 val_459
    +460 val_460
    +462 val_462
    +463 val_463
    +466 val_466
    +467 val_467
    +468 val_468
    +469 val_469
    +47 val_47
    +470 val_470
    +472 val_472
    +475 val_475
    +477 val_477
    +478 val_478
    +479 val_479
    +480 val_480
    +481 val_481
    +482 val_482
    +483 val_483
    +484 val_484
    +485 val_485
    +487 val_487
    +489 val_489
    +490 val_490
    +491 val_491
    +492 val_492
    +493 val_493
    +494 val_494
    +495 val_495
    +496 val_496
    +497 val_497
    +498 val_498
    +5 val_5
    +51 val_51
    +53 val_53
    +54 val_54
    +57 val_57
    +58 val_58
    +64 val_64
    +65 val_65
    +66 val_66
    +67 val_67
    +69 val_69
    +70 val_70
    +72 val_72
    +74 val_74
    +76 val_76
    +77 val_77
    +78 val_78
    +8 val_8
    +80 val_80
    +82 val_82
    +83 val_83
    +84 val_84
    +85 val_85
    +86 val_86
    +87 val_87
    +9 val_9
    +90 val_90
    +92 val_92
    +95 val_95
    +96 val_96
    +97 val_97
    +98 val_98
    +PREHOOK: query: drop view if exists sdi
    +PREHOOK: type: DROPVIEW
    +PREHOOK: Input: default@sdi
    +PREHOOK: Output: default@sdi
    +POSTHOOK: query: drop view if exists sdi
    +POSTHOOK: type: DROPVIEW
    +POSTHOOK: Input: default@sdi
    +POSTHOOK: Output: default@sdi
    +PREHOOK: query: explain create view sdi as select distinct * from src order by key limit 2
    +PREHOOK: type: CREATEVIEW
    +POSTHOOK: query: explain create view sdi as select distinct * from src order by key limit 2
    +POSTHOOK: type: CREATEVIEW
    +STAGE DEPENDENCIES:
    + Stage-0 is a root stage
    +
    +STAGE PLANS:
    + Stage: Stage-0
    + Create View Operator:
    + Create View
    + or replace: false
    + columns: key string, value string
    + expanded text: select distinct `src`.`key`, `src`.`value` from `default`.`src` order by `src`.`key` limit 2
    + name: default.sdi
    + original text: select distinct * from src order by key limit 2
    +
    +PREHOOK: query: create view sdi as select distinct * from src order by key limit 2
    +PREHOOK: type: CREATEVIEW
    +PREHOOK: Input: default@src
    +PREHOOK: Output: database:default
    +PREHOOK: Output: default@sdi
    +POSTHOOK: query: create view sdi as select distinct * from src order by key limit 2
    +POSTHOOK: type: CREATEVIEW
    +POSTHOOK: Input: default@src
    +POSTHOOK: Output: database:default
    +POSTHOOK: Output: default@sdi
    +PREHOOK: query: describe extended sdi
    +PREHOOK: type: DESCTABLE
    +PREHOOK: Input: default@sdi
    +POSTHOOK: query: describe extended sdi
    +POSTHOOK: type: DESCTABLE
    +POSTHOOK: Input: default@sdi
    +key string
    +value string
    +
    +#### A masked pattern was here ####
    +PREHOOK: query: describe formatted sdi
    +PREHOOK: type: DESCTABLE
    +PREHOOK: Input: default@sdi
    +POSTHOOK: query: describe formatted sdi
    +POSTHOOK: type: DESCTABLE
    +POSTHOOK: Input: default@sdi
    +# col_name data_type comment
    +
    +key string
    +value string
    +
    +# Detailed Table Information
    +Database: default
    +#### A masked pattern was here ####
    +Protect Mode: None
    +Retention: 0
    +Table Type: VIRTUAL_VIEW
    +Table Parameters:
    +#### A masked pattern was here ####
    +
    +# Storage Information
    +SerDe Library: null
    +InputFormat: org.apache.hadoop.mapred.SequenceFileInputFormat
    +OutputFormat: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
    +Compressed: No
    +Num Buckets: -1
    +Bucket Columns: []
    +Sort Columns: []
    +
    +# View Information
    +View Original Text: select distinct * from src order by key limit 2
    +View Expanded Text: select distinct `src`.`key`, `src`.`value` from `default`.`src` order by `src`.`key` limit 2
    +PREHOOK: query: select * from sdi
    +PREHOOK: type: QUERY
    +PREHOOK: Input: default@sdi
    +PREHOOK: Input: default@src
    +#### A masked pattern was here ####
    +POSTHOOK: query: select * from sdi
    +POSTHOOK: type: QUERY
    +POSTHOOK: Input: default@sdi
    +POSTHOOK: Input: default@src
    +#### A masked pattern was here ####
    +0 val_0
    +10 val_10
    +PREHOOK: query: select distinct * from src union all select distinct * from src1
    +PREHOOK: type: QUERY
    +PREHOOK: Input: default@src
    +PREHOOK: Input: default@src1
    +#### A masked pattern was here ####
    +POSTHOOK: query: select distinct * from src union all select distinct * from src1
    +POSTHOOK: type: QUERY
    +POSTHOOK: Input: default@src
    +POSTHOOK: Input: default@src1
    +#### A masked pattern was here ####
    +0 val_0
    +10 val_10
    +100 val_100
    +103 val_103
    +104 val_104
    +105 val_105
    +11 val_11
    +111 val_111
    +113 val_113
    +114 val_114
    +116 val_116
    +118 val_118
    +119 val_119
    +12 val_12
    +120 val_120
    +125 val_125
    +126 val_126
    +128 val_128
    +129 val_129
    +131 val_131
    +133 val_133
    +134 val_134
    +136 val_136
    +137 val_137
    +138 val_138
    +143 val_143
    +145 val_145
    +146 val_146
    +149 val_149
    +15 val_15
    +150 val_150
    +152 val_152
    +153 val_153
    +155 val_155
    +156 val_156
    +157 val_157
    +158 val_158
    +160 val_160
    +162 val_162
    +163 val_163
    +164 val_164
    +165 val_165
    +166 val_166
    +167 val_167
    +168 val_168
    +169 val_169
    +17 val_17
    +170 val_170
    +172 val_172
    +174 val_174
    +175 val_175
    +176 val_176
    +177 val_177
    +178 val_178
    +179 val_179
    +18 val_18
    +180 val_180
    +181 val_181
    +183 val_183
    +186 val_186
    +187 val_187
    +189 val_189
    +19 val_19
    +190 val_190
    +191 val_191
    +192 val_192
    +193 val_193
    +194 val_194
    +195 val_195
    +196 val_196
    +197 val_197
    +199 val_199
    +2 val_2
    +20 val_20
    +200 val_200
    +201 val_201
    +202 val_202
    +203 val_203
    +205 val_205
    +207 val_207
    +208 val_208
    +209 val_209
    +213 val_213
    +214 val_214
    +216 val_216
    +217 val_217
    +218 val_218
    +219 val_219
    +221 val_221
    +222 val_222
    +223 val_223
    +224 val_224
    +226 val_226
    +228 val_228
    +229 val_229
    +230 val_230
    +233 val_233
    +235 val_235
    +237 val_237
    +238 val_238
    +239 val_239
    +24 val_24
    +241 val_241
    +242 val_242
    +244 val_244
    +247 val_247
    +248 val_248
    +249 val_249
    +252 val_252
    +255 val_255
    +256 val_256
    +257 val_257
    +258 val_258
    +26 val_26
    +260 val_260
    +262 val_262
    +263 val_263
    +265 val_265
    +266 val_266
    +27 val_27
    +272 val_272
    +273 val_273
    +274 val_274
    +275 val_275
    +277 val_277
    +278 val_278
    +28 val_28
    +280 val_280
    +281 val_281
    +282 val_282
    +283 val_283
    +284 val_284
    +285 val_285
    +286 val_286
    +287 val_287
    +288 val_288
    +289 val_289
    +291 val_291
    +292 val_292
    +296 val_296
    +298 val_298
    +30 val_30
    +302 val_302
    +305 val_305
    +306 val_306
    +307 val_307
    +308 val_308
    +309 val_309
    +310 val_310
    +311 val_311
    +315 val_315
    +316 val_316
    +317 val_317
    +318 val_318
    +321 val_321
    +322 val_322
    +323 val_323
    +325 val_325
    +327 val_327
    +33 val_33
    +331 val_331
    +332 val_332
    +333 val_333
    +335 val_335
    +336 val_336
    +338 val_338
    +339 val_339
    +34 val_34
    +341 val_341
    +342 val_342
    +344 val_344
    +345 val_345
    +348 val_348
    +35 val_35
    +351 val_351
    +353 val_353
    +356 val_356
    +360 val_360
    +362 val_362
    +364 val_364
    +365 val_365
    +366 val_366
    +367 val_367
    +368 val_368
    +369 val_369
    +37 val_37
    +373 val_373
    +374 val_374
    +375 val_375
    +377 val_377
    +378 val_378
    +379 val_379
    +382 val_382
    +384 val_384
    +386 val_386
    +389 val_389
    +392 val_392
    +393 val_393
    +394 val_394
    +395 val_395
    +396 val_396
    +397 val_397
    +399 val_399
    +4 val_4
    +400 val_400
    +401 val_401
    +402 val_402
    +403 val_403
    +404 val_404
    +406 val_406
    +407 val_407
    +409 val_409
    +41 val_41
    +411 val_411
    +413 val_413
    +414 val_414
    +417 val_417
    +418 val_418
    +419 val_419
    +42 val_42
    +421 val_421
    +424 val_424
    +427 val_427
    +429 val_429
    +43 val_43
    +430 val_430
    +431 val_431
    +432 val_432
    +435 val_435
    +436 val_436
    +437 val_437
    +438 val_438
    +439 val_439
    +44 val_44
    +443 val_443
    +444 val_444
    +446 val_446
    +448 val_448
    +449 val_449
    +452 val_452
    +453 val_453
    +454 val_454
    +455 val_455
    +457 val_457
    +458 val_458
    +459 val_459
    +460 val_460
    +462 val_462
    +463 val_463
    +466 val_466
    +467 val_467
    +468 val_468
    +469 val_469
    +47 val_47
    +470 val_470
    +472 val_472
    +475 val_475
    +477 val_477
    +478 val_478
    +479 val_479
    +480 val_480
    +481 val_481
    +482 val_482
    +483 val_483
    +484 val_484
    +485 val_485
    +487 val_487
    +489 val_489
    +490 val_490
    +491 val_491
    +492 val_492
    +493 val_493
    +494 val_494
    +495 val_495
    +496 val_496
    +497 val_497
    +498 val_498
    +5 val_5
    +51 val_51
    +53 val_53
    +54 val_54
    +57 val_57
    +58 val_58
    +64 val_64
    +65 val_65
    +66 val_66
    +67 val_67
    +69 val_69
    +70 val_70
    +72 val_72
    +74 val_74
    +76 val_76
    +77 val_77
    +78 val_78
    +8 val_8
    +80 val_80
    +82 val_82
    +83 val_83
    +84 val_84
    +85 val_85
    +86 val_86
    +87 val_87
    +9 val_9
    +90 val_90
    +92 val_92
    +95 val_95
    +96 val_96
    +97 val_97
    +98 val_98
    +
    + val_165
    + val_193
    + val_265
    + val_27
    + val_409
    + val_484
    +128
    +146 val_146
    +150 val_150
    +213 val_213
    +224
    +238 val_238
    +255 val_255
    +273 val_273
    +278 val_278
    +311 val_311
    +369
    +401 val_401
    +406 val_406
    +66 val_66
    +98 val_98
    +PREHOOK: query: select distinct * from src join src1 on src.key=src1.key
    +PREHOOK: type: QUERY
    +PREHOOK: Input: default@src
    +PREHOOK: Input: default@src1
    +#### A masked pattern was here ####
    +POSTHOOK: query: select distinct * from src join src1 on src.key=src1.key
    +POSTHOOK: type: QUERY
    +POSTHOOK: Input: default@src
    +POSTHOOK: Input: default@src1
    +#### A masked pattern was here ####
    +128 128 val_128
    +146 val_146 146 val_146
    +150 val_150 150 val_150
    +213 val_213 213 val_213
    +224 224 val_224
    +238 val_238 238 val_238
    +255 val_255 255 val_255
    +273 val_273 273 val_273
    +278 val_278 278 val_278
    +311 val_311 311 val_311
    +369 369 val_369
    +401 val_401 401 val_401
    +406 val_406 406 val_406
    +66 val_66 66 val_66
    +98 val_98 98 val_98
    +PREHOOK: query: SELECT distinct *
    +FROM src1 x JOIN src y ON (x.key = y.key)
    +JOIN srcpart z ON (x.value = z.value and z.ds='2008-04-08' and z.hr=11)
    +PREHOOK: type: QUERY
    +PREHOOK: Input: default@src
    +PREHOOK: Input: default@src1
    +PREHOOK: Input: default@srcpart
    +PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
    +#### A masked pattern was here ####
    +POSTHOOK: query: SELECT distinct *
    +FROM src1 x JOIN src y ON (x.key = y.key)
    +JOIN srcpart z ON (x.value = z.value and z.ds='2008-04-08' and z.hr=11)
    +POSTHOOK: type: QUERY
    +POSTHOOK: Input: default@src
    +POSTHOOK: Input: default@src1
    +POSTHOOK: Input: default@srcpart
    +POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
    +#### A masked pattern was here ####
    +146 val_146 2008-04-08 11 146 val_146 146 val_146
    +150 val_150 2008-04-08 11 150 val_150 150 val_150
    +213 val_213 2008-04-08 11 213 val_213 213 val_213
    +238 val_238 2008-04-08 11 238 val_238 238 val_238
    +255 val_255 2008-04-08 11 255 val_255 255 val_255
    +273 val_273 2008-04-08 11 273 val_273 273 val_273
    +278 val_278 2008-04-08 11 278 val_278 278 val_278
    +311 val_311 2008-04-08 11 311 val_311 311 val_311
    +401 val_401 2008-04-08 11 401 val_401 401 val_401
    +406 val_406 2008-04-08 11 406 val_406 406 val_406
    +66 val_66 2008-04-08 11 66 val_66 66 val_66
    +98 val_98 2008-04-08 11 98 val_98 98 val_98
    +PREHOOK: query: select * from (select distinct * from src)src1
    +join
    +(select distinct * from src)src2
    +on src1.key=src2.key
    +PREHOOK: type: QUERY
    +PREHOOK: Input: default@src
    +#### A masked pattern was here ####
    +POSTHOOK: query: select * from (select distinct * from src)src1
    +join
    +(select distinct * from src)src2
    +on src1.key=src2.key
    +POSTHOOK: type: QUERY
    +POSTHOOK: Input: default@src
    +#### A masked pattern was here ####
    +0 val_0 0 val_0
    +10 val_10 10 val_10
    +100 val_100 100 val_100
    +103 val_103 103 val_103
    +104 val_104 104 val_104
    +105 val_105 105 val_105
    +11 val_11 11 val_11
    +111 val_111 111 val_111
    +113 val_113 113 val_113
    +114 val_114 114 val_114
    +116 val_116 116 val_116
    +118 val_118 118 val_118
    +119 val_119 119 val_119
    +12 val_12 12 val_12
    +120 val_120 120 val_120
    +125 val_125 125 val_125
    +126 val_126 126 val_126
    +128 val_128 128 val_128
    +129 val_129 129 val_129
    +131 val_131 131 val_131
    +133 val_133 133 val_133
    +134 val_134 134 val_134
    +136 val_136 136 val_136
    +137 val_137 137 val_137
    +138 val_138 138 val_138
    +143 val_143 143 val_143
    +145 val_145 145 val_145
    +146 val_146 146 val_146
    +149 val_149 149 val_149
    +15 val_15 15 val_15
    +150 val_150 150 val_150
    +152 val_152 152 val_152
    +153 val_153 153 val_153
    +155 val_155 155 val_155
    +156 val_156 156 val_156
    +157 val_157 157 val_157
    +158 val_158 158 val_158
    +160 val_160 160 val_160
    +162 val_162 162 val_162
    +163 val_163 163 val_163
    +164 val_164 164 val_164
    +165 val_165 165 val_165
    +166 val_166 166 val_166
    +167 val_167 167 val_167
    +168 val_168 168 val_168
    +169 val_169 169 val_169
    +17 val_17 17 val_17
    +170 val_170 170 val_170
    +172 val_172 172 val_172
    +174 val_174 174 val_174
    +175 val_175 175 val_175
    +176 val_176 176 val_176
    +177 val_177 177 val_177
    +178 val_178 178 val_178
    +179 val_179 179 val_179
    +18 val_18 18 val_18
    +180 val_180 180 val_180
    +181 val_181 181 val_181
    +183 val_183 183 val_183
    +186 val_186 186 val_186
    +187 val_187 187 val_187
    +189 val_189 189 val_189
    +19 val_19 19 val_19
    +190 val_190 190 val_190
    +191 val_191 191 val_191
    +192 val_192 192 val_192
    +193 val_193 193 val_193
    +194 val_194 194 val_194
    +195 val_195 195 val_195
    +196 val_196 196 val_196
    +197 val_197 197 val_197
    +199 val_199 199 val_199
    +2 val_2 2 val_2
    +20 val_20 20 val_20
    +200 val_200 200 val_200
    +201 val_201 201 val_201
    +202 val_202 202 val_202
    +203 val_203 203 val_203
    +205 val_205 205 val_205
    +207 val_207 207 val_207
    +208 val_208 208 val_208
    +209 val_209 209 val_209
    +213 val_213 213 val_213
    +214 val_214 214 val_214
    +216 val_216 216 val_216
    +217 val_217 217 val_217
    +218 val_218 218 val_218
    +219 val_219 219 val_219
    +221 val_221 221 val_221
    +222 val_222 222 val_222
    +223 val_223 223 val_223
    +224 val_224 224 val_224
    +226 val_226 226 val_226
    +228 val_228 228 val_228
    +229 val_229 229 val_229
    +230 val_230 230 val_230
    +233 val_233 233 val_233
    +235 val_235 235 val_235
    +237 val_237 237 val_237
    +238 val_238 238 val_238
    +239 val_239 239 val_239
    +24 val_24 24 val_24
    +241 val_241 241 val_241
    +242 val_242 242 val_242
    +244 val_244 244 val_244
    +247 val_247 247 val_247
    +248 val_248 248 val_248
    +249 val_249 249 val_249
    +252 val_252 252 val_252
    +255 val_255 255 val_255
    +256 val_256 256 val_256
    +257 val_257 257 val_257
    +258 val_258 258 val_258
    +26 val_26 26 val_26
    +260 val_260 260 val_260
    +262 val_262 262 val_262
    +263 val_263 263 val_263
    +265 val_265 265 val_265
    +266 val_266 266 val_266
    +27 val_27 27 val_27
    +272 val_272 272 val_272
    +273 val_273 273 val_273
    +274 val_274 274 val_274
    +275 val_275 275 val_275
    +277 val_277 277 val_277
    +278 val_278 278 val_278
    +28 val_28 28 val_28
    +280 val_280 280 val_280
    +281 val_281 281 val_281
    +282 val_282 282 val_282
    +283 val_283 283 val_283
    +284 val_284 284 val_284
    +285 val_285 285 val_285
    +286 val_286 286 val_286
    +287 val_287 287 val_287
    +288 val_288 288 val_288
    +289 val_289 289 val_289
    +291 val_291 291 val_291
    +292 val_292 292 val_292
    +296 val_296 296 val_296
    +298 val_298 298 val_298
    +30 val_30 30 val_30
    +302 val_302 302 val_302
    +305 val_305 305 val_305
    +306 val_306 306 val_306
    +307 val_307 307 val_307
    +308 val_308 308 val_308
    +309 val_309 309 val_309
    +310 val_310 310 val_310
    +311 val_311 311 val_311
    +315 val_315 315 val_315
    +316 val_316 316 val_316
    +317 val_317 317 val_317
    +318 val_318 318 val_318
    +321 val_321 321 val_321
    +322 val_322 322 val_322
    +323 val_323 323 val_323
    +325 val_325 325 val_325
    +327 val_327 327 val_327
    +33 val_33 33 val_33
    +331 val_331 331 val_331
    +332 val_332 332 val_332
    +333 val_333 333 val_333
    +335 val_335 335 val_335
    +336 val_336 336 val_336
    +338 val_338 338 val_338
    +339 val_339 339 val_339
    +34 val_34 34 val_34
    +341 val_341 341 val_341
    +342 val_342 342 val_342
    +344 val_344 344 val_344
    +345 val_345 345 val_345
    +348 val_348 348 val_348
    +35 val_35 35 val_35
    +351 val_351 351 val_351
    +353 val_353 353 val_353
    +356 val_356 356 val_356
    +360 val_360 360 val_360
    +362 val_362 362 val_362
    +364 val_364 364 val_364
    +365 val_365 365 val_365
    +366 val_366 366 val_366
    +367 val_367 367 val_367
    +368 val_368 368 val_368
    +369 val_369 369 val_369
    +37 val_37 37 val_37
    +373 val_373 373 val_373
    +374 val_374 374 val_374
    +375 val_375 375 val_375
    +377 val_377 377 val_377
    +378 val_378 378 val_378
    +379 val_379 379 val_379
    +382 val_382 382 val_382
    +384 val_384 384 val_384
    +386 val_386 386 val_386
    +389 val_389 389 val_389
    +392 val_392 392 val_392
    +393 val_393 393 val_393
    +394 val_394 394 val_394
    +395 val_395 395 val_395
    +396 val_396 396 val_396
    +397 val_397 397 val_397
    +399 val_399 399 val_399
    +4 val_4 4 val_4
    +400 val_400 400 val_400
    +401 val_401 401 val_401
    +402 val_402 402 val_402
    +403 val_403 403 val_403
    +404 val_404 404 val_404
    +406 val_406 406 val_406
    +407 val_407 407 val_407
    +409 val_409 409 val_409
    +41 val_41 41 val_41
    +411 val_411 411 val_411
    +413 val_413 413 val_413
    +414 val_414 414 val_414
    +417 val_417 417 val_417
    +418 val_418 418 val_418
    +419 val_419 419 val_419
    +42 val_42 42 val_42
    +421 val_421 421 val_421
    +424 val_424 424 val_424
    +427 val_427 427 val_427
    +429 val_429 429 val_429
    +43 val_43 43 val_43
    +430 val_430 430 val_430
    +431 val_431 431 val_431
    +432 val_432 432 val_432
    +435 val_435 435 val_435
    +436 val_436 436 val_436
    +437 val_437 437 val_437
    +438 val_438 438 val_438
    +439 val_439 439 val_439
    +44 val_44 44 val_44
    +443 val_443 443 val_443
    +444 val_444 444 val_444
    +446 val_446 446 val_446
    +448 val_448 448 val_448
    +449 val_449 449 val_449
    +452 val_452 452 val_452
    +453 val_453 453 val_453
    +454 val_454 454 val_454
    +455 val_455 455 val_455
    +457 val_457 457 val_457
    +458 val_458 458 val_458
    +459 val_459 459 val_459
    +460 val_460 460 val_460
    +462 val_462 462 val_462
    +463 val_463 463 val_463
    +466 val_466 466 val_466
    +467 val_467 467 val_467
    +468 val_468 468 val_468
    +469 val_469 469 val_469
    +47 val_47 47 val_47
    +470 val_470 470 val_470
    +472 val_472 472 val_472
    +475 val_475 475 val_475
    +477 val_477 477 val_477
    +478 val_478 478 val_478
    +479 val_479 479 val_479
    +480 val_480 480 val_480
    +481 val_481 481 val_481
    +482 val_482 482 val_482
    +483 val_483 483 val_483
    +484 val_484 484 val_484
    +485 val_485 485 val_485
    +487 val_487 487 val_487
    +489 val_489 489 val_489
    +490 val_490 490 val_490
    +491 val_491 491 val_491
    +492 val_492 492 val_492
    +493 val_493 493 val_493
    +494 val_494 494 val_494
    +495 val_495 495 val_495
    +496 val_496 496 val_496
    +497 val_497 497 val_497
    +498 val_498 498 val_498
    +5 val_5 5 val_5
    +51 val_51 51 val_51
    +53 val_53 53 val_53
    +54 val_54 54 val_54
    +57 val_57 57 val_57
    +58 val_58 58 val_58
    +64 val_64 64 val_64
    +65 val_65 65 val_65
    +66 val_66 66 val_66
    +67 val_67 67 val_67
    +69 val_69 69 val_69
    +70 val_70 70 val_70
    +72 val_72 72 val_72
    +74 val_74 74 val_74
    +76 val_76 76 val_76
    +77 val_77 77 val_77
    +78 val_78 78 val_78
    +8 val_8 8 val_8
    +80 val_80 80 val_80
    +82 val_82 82 val_82
    +83 val_83 83 val_83
    +84 val_84 84 val_84
    +85 val_85 85 val_85
    +86 val_86 86 val_86
    +87 val_87 87 val_87
    +9 val_9 9 val_9
    +90 val_90 90 val_90
    +92 val_92 92 val_92
    +95 val_95 95 val_95
    +96 val_96 96 val_96
    +97 val_97 97 val_97
    +98 val_98 98 val_98
    +PREHOOK: query: select distinct * from (select distinct * from src)src1
    +PREHOOK: type: QUERY
    +PREHOOK: Input: default@src
    +#### A masked pattern was here ####
    +POSTHOOK: query: select distinct * from (select distinct * from src)src1
    +POSTHOOK: type: QUERY
    +POSTHOOK: Input: default@src
    +#### A masked pattern was here ####
    +0 val_0
    +10 val_10
    +100 val_100
    +103 val_103
    +104 val_104
    +105 val_105
    +11 val_11
    +111 val_111
    +113 val_113
    +114 val_114
    +116 val_116
    +118 val_118
    +119 val_119
    +12 val_12
    +120 val_120
    +125 val_125
    +126 val_126
    +128 val_128
    +129 val_129
    +131 val_131
    +133 val_133
    +134 val_134
    +136 val_136
    +137 val_137
    +138 val_138
    +143 val_143
    +145 val_145
    +146 val_146
    +149 val_149
    +15 val_15
    +150 val_150
    +152 val_152
    +153 val_153
    +155 val_155
    +156 val_156
    +157 val_157
    +158 val_158
    +160 val_160
    +162 val_162
    +163 val_163
    +164 val_164
    +165 val_165
    +166 val_166
    +167 val_167
    +168 val_168
    +169 val_169
    +17 val_17
    +170 val_170
    +172 val_172
    +174 val_174
    +175 val_175
    +176 val_176
    +177 val_177
    +178 val_178
    +179 val_179
    +18 val_18
    +180 val_180
    +181 val_181
    +183 val_183
    +186 val_186
    +187 val_187
    +189 val_189
    +19 val_19
    +190 val_190
    +191 val_191
    +192 val_192
    +193 val_193
    +194 val_194
    +195 val_195
    +196 val_196
    +197 val_197
    +199 val_199
    +2 val_2
    +20 val_20
    +200 val_200
    +201 val_201
    +202 val_202
    +203 val_203
    +205 val_205
    +207 val_207
    +208 val_208
    +209 val_209
    +213 val_213
    +214 val_214
    +216 val_216
    +217 val_217
    +218 val_218
    +219 val_219
    +221 val_221
    +222 val_222
    +223 val_223
    +224 val_224
    +226 val_226
    +228 val_228
    +229 val_229
    +230 val_230
    +233 val_233
    +235 val_235
    +237 val_237
    +238 val_238
    +239 val_239
    +24 val_24
    +241 val_241
    +242 val_242
    +244 val_244
    +247 val_247
    +248 val_248
    +249 val_249
    +252 val_252
    +255 val_255
    +256 val_256
    +257 val_257
    +258 val_258
    +26 val_26
    +260 val_260
    +262 val_262
    +263 val_263
    +265 val_265

    [... 192 lines stripped ...]
  • Jpullokk at Jan 15, 2015 at 10:15 pm
    Added: hive/trunk/ql/src/test/results/clientpositive/tez/selectDistinctStar.q.out
    URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/selectDistinctStar.q.out?rev=1652286&view=auto
    ==============================================================================
    --- hive/trunk/ql/src/test/results/clientpositive/tez/selectDistinctStar.q.out (added)
    +++ hive/trunk/ql/src/test/results/clientpositive/tez/selectDistinctStar.q.out Thu Jan 15 22:15:40 2015
    @@ -0,0 +1,4906 @@
    +PREHOOK: query: explain select distinct src.* from src
    +PREHOOK: type: QUERY
    +POSTHOOK: query: explain select distinct src.* from src
    +POSTHOOK: type: QUERY
    +STAGE DEPENDENCIES:
    + Stage-1 is a root stage
    + Stage-0 depends on stages: Stage-1
    +
    +STAGE PLANS:
    + Stage: Stage-1
    + Tez
    + Edges:
    + Reducer 2 <- Map 1 (SIMPLE_EDGE)
    +#### A masked pattern was here ####
    + Vertices:
    + Map 1
    + Map Operator Tree:
    + TableScan
    + alias: src
    + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
    + Select Operator
    + expressions: key (type: string), value (type: string)
    + outputColumnNames: _col0, _col1
    + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
    + Group By Operator
    + keys: _col0 (type: string), _col1 (type: string)
    + mode: hash
    + outputColumnNames: _col0, _col1
    + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
    + Reduce Output Operator
    + key expressions: _col0 (type: string), _col1 (type: string)
    + sort order: ++
    + Map-reduce partition columns: _col0 (type: string), _col1 (type: string)
    + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
    + Reducer 2
    + Reduce Operator Tree:
    + Group By Operator
    + keys: KEY._col0 (type: string), KEY._col1 (type: string)
    + mode: mergepartial
    + outputColumnNames: _col0, _col1
    + Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
    + Select Operator
    + expressions: _col0 (type: string), _col1 (type: string)
    + outputColumnNames: _col0, _col1
    + Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
    + File Output Operator
    + compressed: false
    + Statistics: Num rows: 250 Data size: 2656 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: -1
    + Processor Tree:
    + ListSink
    +
    +PREHOOK: query: select distinct src.* from src
    +PREHOOK: type: QUERY
    +PREHOOK: Input: default@src
    +#### A masked pattern was here ####
    +POSTHOOK: query: select distinct src.* from src
    +POSTHOOK: type: QUERY
    +POSTHOOK: Input: default@src
    +#### A masked pattern was here ####
    +0 val_0
    +10 val_10
    +100 val_100
    +103 val_103
    +104 val_104
    +105 val_105
    +11 val_11
    +111 val_111
    +113 val_113
    +114 val_114
    +116 val_116
    +118 val_118
    +119 val_119
    +12 val_12
    +120 val_120
    +125 val_125
    +126 val_126
    +128 val_128
    +129 val_129
    +131 val_131
    +133 val_133
    +134 val_134
    +136 val_136
    +137 val_137
    +138 val_138
    +143 val_143
    +145 val_145
    +146 val_146
    +149 val_149
    +15 val_15
    +150 val_150
    +152 val_152
    +153 val_153
    +155 val_155
    +156 val_156
    +157 val_157
    +158 val_158
    +160 val_160
    +162 val_162
    +163 val_163
    +164 val_164
    +165 val_165
    +166 val_166
    +167 val_167
    +168 val_168
    +169 val_169
    +17 val_17
    +170 val_170
    +172 val_172
    +174 val_174
    +175 val_175
    +176 val_176
    +177 val_177
    +178 val_178
    +179 val_179
    +18 val_18
    +180 val_180
    +181 val_181
    +183 val_183
    +186 val_186
    +187 val_187
    +189 val_189
    +19 val_19
    +190 val_190
    +191 val_191
    +192 val_192
    +193 val_193
    +194 val_194
    +195 val_195
    +196 val_196
    +197 val_197
    +199 val_199
    +2 val_2
    +20 val_20
    +200 val_200
    +201 val_201
    +202 val_202
    +203 val_203
    +205 val_205
    +207 val_207
    +208 val_208
    +209 val_209
    +213 val_213
    +214 val_214
    +216 val_216
    +217 val_217
    +218 val_218
    +219 val_219
    +221 val_221
    +222 val_222
    +223 val_223
    +224 val_224
    +226 val_226
    +228 val_228
    +229 val_229
    +230 val_230
    +233 val_233
    +235 val_235
    +237 val_237
    +238 val_238
    +239 val_239
    +24 val_24
    +241 val_241
    +242 val_242
    +244 val_244
    +247 val_247
    +248 val_248
    +249 val_249
    +252 val_252
    +255 val_255
    +256 val_256
    +257 val_257
    +258 val_258
    +26 val_26
    +260 val_260
    +262 val_262
    +263 val_263
    +265 val_265
    +266 val_266
    +27 val_27
    +272 val_272
    +273 val_273
    +274 val_274
    +275 val_275
    +277 val_277
    +278 val_278
    +28 val_28
    +280 val_280
    +281 val_281
    +282 val_282
    +283 val_283
    +284 val_284
    +285 val_285
    +286 val_286
    +287 val_287
    +288 val_288
    +289 val_289
    +291 val_291
    +292 val_292
    +296 val_296
    +298 val_298
    +30 val_30
    +302 val_302
    +305 val_305
    +306 val_306
    +307 val_307
    +308 val_308
    +309 val_309
    +310 val_310
    +311 val_311
    +315 val_315
    +316 val_316
    +317 val_317
    +318 val_318
    +321 val_321
    +322 val_322
    +323 val_323
    +325 val_325
    +327 val_327
    +33 val_33
    +331 val_331
    +332 val_332
    +333 val_333
    +335 val_335
    +336 val_336
    +338 val_338
    +339 val_339
    +34 val_34
    +341 val_341
    +342 val_342
    +344 val_344
    +345 val_345
    +348 val_348
    +35 val_35
    +351 val_351
    +353 val_353
    +356 val_356
    +360 val_360
    +362 val_362
    +364 val_364
    +365 val_365
    +366 val_366
    +367 val_367
    +368 val_368
    +369 val_369
    +37 val_37
    +373 val_373
    +374 val_374
    +375 val_375
    +377 val_377
    +378 val_378
    +379 val_379
    +382 val_382
    +384 val_384
    +386 val_386
    +389 val_389
    +392 val_392
    +393 val_393
    +394 val_394
    +395 val_395
    +396 val_396
    +397 val_397
    +399 val_399
    +4 val_4
    +400 val_400
    +401 val_401
    +402 val_402
    +403 val_403
    +404 val_404
    +406 val_406
    +407 val_407
    +409 val_409
    +41 val_41
    +411 val_411
    +413 val_413
    +414 val_414
    +417 val_417
    +418 val_418
    +419 val_419
    +42 val_42
    +421 val_421
    +424 val_424
    +427 val_427
    +429 val_429
    +43 val_43
    +430 val_430
    +431 val_431
    +432 val_432
    +435 val_435
    +436 val_436
    +437 val_437
    +438 val_438
    +439 val_439
    +44 val_44
    +443 val_443
    +444 val_444
    +446 val_446
    +448 val_448
    +449 val_449
    +452 val_452
    +453 val_453
    +454 val_454
    +455 val_455
    +457 val_457
    +458 val_458
    +459 val_459
    +460 val_460
    +462 val_462
    +463 val_463
    +466 val_466
    +467 val_467
    +468 val_468
    +469 val_469
    +47 val_47
    +470 val_470
    +472 val_472
    +475 val_475
    +477 val_477
    +478 val_478
    +479 val_479
    +480 val_480
    +481 val_481
    +482 val_482
    +483 val_483
    +484 val_484
    +485 val_485
    +487 val_487
    +489 val_489
    +490 val_490
    +491 val_491
    +492 val_492
    +493 val_493
    +494 val_494
    +495 val_495
    +496 val_496
    +497 val_497
    +498 val_498
    +5 val_5
    +51 val_51
    +53 val_53
    +54 val_54
    +57 val_57
    +58 val_58
    +64 val_64
    +65 val_65
    +66 val_66
    +67 val_67
    +69 val_69
    +70 val_70
    +72 val_72
    +74 val_74
    +76 val_76
    +77 val_77
    +78 val_78
    +8 val_8
    +80 val_80
    +82 val_82
    +83 val_83
    +84 val_84
    +85 val_85
    +86 val_86
    +87 val_87
    +9 val_9
    +90 val_90
    +92 val_92
    +95 val_95
    +96 val_96
    +97 val_97
    +98 val_98
    +PREHOOK: query: select distinct * from src
    +PREHOOK: type: QUERY
    +PREHOOK: Input: default@src
    +#### A masked pattern was here ####
    +POSTHOOK: query: select distinct * from src
    +POSTHOOK: type: QUERY
    +POSTHOOK: Input: default@src
    +#### A masked pattern was here ####
    +0 val_0
    +10 val_10
    +100 val_100
    +103 val_103
    +104 val_104
    +105 val_105
    +11 val_11
    +111 val_111
    +113 val_113
    +114 val_114
    +116 val_116
    +118 val_118
    +119 val_119
    +12 val_12
    +120 val_120
    +125 val_125
    +126 val_126
    +128 val_128
    +129 val_129
    +131 val_131
    +133 val_133
    +134 val_134
    +136 val_136
    +137 val_137
    +138 val_138
    +143 val_143
    +145 val_145
    +146 val_146
    +149 val_149
    +15 val_15
    +150 val_150
    +152 val_152
    +153 val_153
    +155 val_155
    +156 val_156
    +157 val_157
    +158 val_158
    +160 val_160
    +162 val_162
    +163 val_163
    +164 val_164
    +165 val_165
    +166 val_166
    +167 val_167
    +168 val_168
    +169 val_169
    +17 val_17
    +170 val_170
    +172 val_172
    +174 val_174
    +175 val_175
    +176 val_176
    +177 val_177
    +178 val_178
    +179 val_179
    +18 val_18
    +180 val_180
    +181 val_181
    +183 val_183
    +186 val_186
    +187 val_187
    +189 val_189
    +19 val_19
    +190 val_190
    +191 val_191
    +192 val_192
    +193 val_193
    +194 val_194
    +195 val_195
    +196 val_196
    +197 val_197
    +199 val_199
    +2 val_2
    +20 val_20
    +200 val_200
    +201 val_201
    +202 val_202
    +203 val_203
    +205 val_205
    +207 val_207
    +208 val_208
    +209 val_209
    +213 val_213
    +214 val_214
    +216 val_216
    +217 val_217
    +218 val_218
    +219 val_219
    +221 val_221
    +222 val_222
    +223 val_223
    +224 val_224
    +226 val_226
    +228 val_228
    +229 val_229
    +230 val_230
    +233 val_233
    +235 val_235
    +237 val_237
    +238 val_238
    +239 val_239
    +24 val_24
    +241 val_241
    +242 val_242
    +244 val_244
    +247 val_247
    +248 val_248
    +249 val_249
    +252 val_252
    +255 val_255
    +256 val_256
    +257 val_257
    +258 val_258
    +26 val_26
    +260 val_260
    +262 val_262
    +263 val_263
    +265 val_265
    +266 val_266
    +27 val_27
    +272 val_272
    +273 val_273
    +274 val_274
    +275 val_275
    +277 val_277
    +278 val_278
    +28 val_28
    +280 val_280
    +281 val_281
    +282 val_282
    +283 val_283
    +284 val_284
    +285 val_285
    +286 val_286
    +287 val_287
    +288 val_288
    +289 val_289
    +291 val_291
    +292 val_292
    +296 val_296
    +298 val_298
    +30 val_30
    +302 val_302
    +305 val_305
    +306 val_306
    +307 val_307
    +308 val_308
    +309 val_309
    +310 val_310
    +311 val_311
    +315 val_315
    +316 val_316
    +317 val_317
    +318 val_318
    +321 val_321
    +322 val_322
    +323 val_323
    +325 val_325
    +327 val_327
    +33 val_33
    +331 val_331
    +332 val_332
    +333 val_333
    +335 val_335
    +336 val_336
    +338 val_338
    +339 val_339
    +34 val_34
    +341 val_341
    +342 val_342
    +344 val_344
    +345 val_345
    +348 val_348
    +35 val_35
    +351 val_351
    +353 val_353
    +356 val_356
    +360 val_360
    +362 val_362
    +364 val_364
    +365 val_365
    +366 val_366
    +367 val_367
    +368 val_368
    +369 val_369
    +37 val_37
    +373 val_373
    +374 val_374
    +375 val_375
    +377 val_377
    +378 val_378
    +379 val_379
    +382 val_382
    +384 val_384
    +386 val_386
    +389 val_389
    +392 val_392
    +393 val_393
    +394 val_394
    +395 val_395
    +396 val_396
    +397 val_397
    +399 val_399
    +4 val_4
    +400 val_400
    +401 val_401
    +402 val_402
    +403 val_403
    +404 val_404
    +406 val_406
    +407 val_407
    +409 val_409
    +41 val_41
    +411 val_411
    +413 val_413
    +414 val_414
    +417 val_417
    +418 val_418
    +419 val_419
    +42 val_42
    +421 val_421
    +424 val_424
    +427 val_427
    +429 val_429
    +43 val_43
    +430 val_430
    +431 val_431
    +432 val_432
    +435 val_435
    +436 val_436
    +437 val_437
    +438 val_438
    +439 val_439
    +44 val_44
    +443 val_443
    +444 val_444
    +446 val_446
    +448 val_448
    +449 val_449
    +452 val_452
    +453 val_453
    +454 val_454
    +455 val_455
    +457 val_457
    +458 val_458
    +459 val_459
    +460 val_460
    +462 val_462
    +463 val_463
    +466 val_466
    +467 val_467
    +468 val_468
    +469 val_469
    +47 val_47
    +470 val_470
    +472 val_472
    +475 val_475
    +477 val_477
    +478 val_478
    +479 val_479
    +480 val_480
    +481 val_481
    +482 val_482
    +483 val_483
    +484 val_484
    +485 val_485
    +487 val_487
    +489 val_489
    +490 val_490
    +491 val_491
    +492 val_492
    +493 val_493
    +494 val_494
    +495 val_495
    +496 val_496
    +497 val_497
    +498 val_498
    +5 val_5
    +51 val_51
    +53 val_53
    +54 val_54
    +57 val_57
    +58 val_58
    +64 val_64
    +65 val_65
    +66 val_66
    +67 val_67
    +69 val_69
    +70 val_70
    +72 val_72
    +74 val_74
    +76 val_76
    +77 val_77
    +78 val_78
    +8 val_8
    +80 val_80
    +82 val_82
    +83 val_83
    +84 val_84
    +85 val_85
    +86 val_86
    +87 val_87
    +9 val_9
    +90 val_90
    +92 val_92
    +95 val_95
    +96 val_96
    +97 val_97
    +98 val_98
    +PREHOOK: query: explain select distinct * from src where key < '3'
    +PREHOOK: type: QUERY
    +POSTHOOK: query: explain select distinct * from src where key < '3'
    +POSTHOOK: type: QUERY
    +STAGE DEPENDENCIES:
    + Stage-1 is a root stage
    + Stage-0 depends on stages: Stage-1
    +
    +STAGE PLANS:
    + Stage: Stage-1
    + Tez
    + Edges:
    + Reducer 2 <- Map 1 (SIMPLE_EDGE)
    +#### A masked pattern was here ####
    + Vertices:
    + Map 1
    + Map Operator Tree:
    + TableScan
    + alias: src
    + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
    + Filter Operator
    + predicate: (key < '3') (type: boolean)
    + Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
    + Select Operator
    + expressions: key (type: string), value (type: string)
    + outputColumnNames: _col0, _col1
    + Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
    + Group By Operator
    + keys: _col0 (type: string), _col1 (type: string)
    + mode: hash
    + outputColumnNames: _col0, _col1
    + Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
    + Reduce Output Operator
    + key expressions: _col0 (type: string), _col1 (type: string)
    + sort order: ++
    + Map-reduce partition columns: _col0 (type: string), _col1 (type: string)
    + Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
    + Reducer 2
    + Reduce Operator Tree:
    + Group By Operator
    + keys: KEY._col0 (type: string), KEY._col1 (type: string)
    + mode: mergepartial
    + outputColumnNames: _col0, _col1
    + Statistics: Num rows: 83 Data size: 881 Basic stats: COMPLETE Column stats: NONE
    + Select Operator
    + expressions: _col0 (type: string), _col1 (type: string)
    + outputColumnNames: _col0, _col1
    + Statistics: Num rows: 83 Data size: 881 Basic stats: COMPLETE Column stats: NONE
    + File Output Operator
    + compressed: false
    + Statistics: Num rows: 83 Data size: 881 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: -1
    + Processor Tree:
    + ListSink
    +
    +PREHOOK: query: select distinct * from src where key < '3'
    +PREHOOK: type: QUERY
    +PREHOOK: Input: default@src
    +#### A masked pattern was here ####
    +POSTHOOK: query: select distinct * from src where key < '3'
    +POSTHOOK: type: QUERY
    +POSTHOOK: Input: default@src
    +#### A masked pattern was here ####
    +0 val_0
    +10 val_10
    +100 val_100
    +103 val_103
    +104 val_104
    +105 val_105
    +11 val_11
    +111 val_111
    +113 val_113
    +114 val_114
    +116 val_116
    +118 val_118
    +119 val_119
    +12 val_12
    +120 val_120
    +125 val_125
    +126 val_126
    +128 val_128
    +129 val_129
    +131 val_131
    +133 val_133
    +134 val_134
    +136 val_136
    +137 val_137
    +138 val_138
    +143 val_143
    +145 val_145
    +146 val_146
    +149 val_149
    +15 val_15
    +150 val_150
    +152 val_152
    +153 val_153
    +155 val_155
    +156 val_156
    +157 val_157
    +158 val_158
    +160 val_160
    +162 val_162
    +163 val_163
    +164 val_164
    +165 val_165
    +166 val_166
    +167 val_167
    +168 val_168
    +169 val_169
    +17 val_17
    +170 val_170
    +172 val_172
    +174 val_174
    +175 val_175
    +176 val_176
    +177 val_177
    +178 val_178
    +179 val_179
    +18 val_18
    +180 val_180
    +181 val_181
    +183 val_183
    +186 val_186
    +187 val_187
    +189 val_189
    +19 val_19
    +190 val_190
    +191 val_191
    +192 val_192
    +193 val_193
    +194 val_194
    +195 val_195
    +196 val_196
    +197 val_197
    +199 val_199
    +2 val_2
    +20 val_20
    +200 val_200
    +201 val_201
    +202 val_202
    +203 val_203
    +205 val_205
    +207 val_207
    +208 val_208
    +209 val_209
    +213 val_213
    +214 val_214
    +216 val_216
    +217 val_217
    +218 val_218
    +219 val_219
    +221 val_221
    +222 val_222
    +223 val_223
    +224 val_224
    +226 val_226
    +228 val_228
    +229 val_229
    +230 val_230
    +233 val_233
    +235 val_235
    +237 val_237
    +238 val_238
    +239 val_239
    +24 val_24
    +241 val_241
    +242 val_242
    +244 val_244
    +247 val_247
    +248 val_248
    +249 val_249
    +252 val_252
    +255 val_255
    +256 val_256
    +257 val_257
    +258 val_258
    +26 val_26
    +260 val_260
    +262 val_262
    +263 val_263
    +265 val_265
    +266 val_266
    +27 val_27
    +272 val_272
    +273 val_273
    +274 val_274
    +275 val_275
    +277 val_277
    +278 val_278
    +28 val_28
    +280 val_280
    +281 val_281
    +282 val_282
    +283 val_283
    +284 val_284
    +285 val_285
    +286 val_286
    +287 val_287
    +288 val_288
    +289 val_289
    +291 val_291
    +292 val_292
    +296 val_296
    +298 val_298
    +PREHOOK: query: from src a select distinct a.* where a.key = '238'
    +PREHOOK: type: QUERY
    +PREHOOK: Input: default@src
    +#### A masked pattern was here ####
    +POSTHOOK: query: from src a select distinct a.* where a.key = '238'
    +POSTHOOK: type: QUERY
    +POSTHOOK: Input: default@src
    +#### A masked pattern was here ####
    +238 val_238
    +PREHOOK: query: explain
    +SELECT distinct * from (
    +select * from src1
    +union all
    +select * from src )subq
    +PREHOOK: type: QUERY
    +POSTHOOK: query: explain
    +SELECT distinct * from (
    +select * from src1
    +union all
    +select * from src )subq
    +POSTHOOK: type: QUERY
    +STAGE DEPENDENCIES:
    + Stage-1 is a root stage
    + Stage-0 depends on stages: Stage-1
    +
    +STAGE PLANS:
    + Stage: Stage-1
    + Tez
    + Edges:
    + Map 1 <- Union 2 (CONTAINS)
    + Map 4 <- Union 2 (CONTAINS)
    + Reducer 3 <- Union 2 (SIMPLE_EDGE)
    +#### A masked pattern was here ####
    + Vertices:
    + Map 1
    + Map Operator Tree:
    + TableScan
    + alias: src1
    + Select Operator
    + expressions: key (type: string), value (type: string)
    + outputColumnNames: _col0, _col1
    + Group By Operator
    + keys: _col0 (type: string), _col1 (type: string)
    + mode: hash
    + outputColumnNames: _col0, _col1
    + Reduce Output Operator
    + key expressions: _col0 (type: string), _col1 (type: string)
    + sort order: ++
    + Map-reduce partition columns: _col0 (type: string), _col1 (type: string)
    + Map 4
    + Map Operator Tree:
    + TableScan
    + alias: src
    + Select Operator
    + expressions: key (type: string), value (type: string)
    + outputColumnNames: _col0, _col1
    + Group By Operator
    + keys: _col0 (type: string), _col1 (type: string)
    + mode: hash
    + outputColumnNames: _col0, _col1
    + Reduce Output Operator
    + key expressions: _col0 (type: string), _col1 (type: string)
    + sort order: ++
    + Map-reduce partition columns: _col0 (type: string), _col1 (type: string)
    + Reducer 3
    + Reduce Operator Tree:
    + Group By Operator
    + keys: KEY._col0 (type: string), KEY._col1 (type: string)
    + mode: mergepartial
    + outputColumnNames: _col0, _col1
    + Statistics: Num rows: 262 Data size: 2746 Basic stats: COMPLETE Column stats: NONE
    + Select Operator
    + expressions: _col0 (type: string), _col1 (type: string)
    + outputColumnNames: _col0, _col1
    + Statistics: Num rows: 262 Data size: 2746 Basic stats: COMPLETE Column stats: NONE
    + File Output Operator
    + compressed: false
    + Statistics: Num rows: 262 Data size: 2746 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
    + Union 2
    + Vertex: Union 2
    +
    + Stage: Stage-0
    + Fetch Operator
    + limit: -1
    + Processor Tree:
    + ListSink
    +
    +PREHOOK: query: SELECT distinct * from (
    +select * from src1
    +union all
    +select * from src )subq
    +PREHOOK: type: QUERY
    +PREHOOK: Input: default@src
    +PREHOOK: Input: default@src1
    +#### A masked pattern was here ####
    +POSTHOOK: query: SELECT distinct * from (
    +select * from src1
    +union all
    +select * from src )subq
    +POSTHOOK: type: QUERY
    +POSTHOOK: Input: default@src
    +POSTHOOK: Input: default@src1
    +#### A masked pattern was here ####
    +
    + val_165
    + val_193
    + val_265
    + val_27
    + val_409
    + val_484
    +0 val_0
    +10 val_10
    +100 val_100
    +103 val_103
    +104 val_104
    +105 val_105
    +11 val_11
    +111 val_111
    +113 val_113
    +114 val_114
    +116 val_116
    +118 val_118
    +119 val_119
    +12 val_12
    +120 val_120
    +125 val_125
    +126 val_126
    +128
    +128 val_128
    +129 val_129
    +131 val_131
    +133 val_133
    +134 val_134
    +136 val_136
    +137 val_137
    +138 val_138
    +143 val_143
    +145 val_145
    +146 val_146
    +149 val_149
    +15 val_15
    +150 val_150
    +152 val_152
    +153 val_153
    +155 val_155
    +156 val_156
    +157 val_157
    +158 val_158
    +160 val_160
    +162 val_162
    +163 val_163
    +164 val_164
    +165 val_165
    +166 val_166
    +167 val_167
    +168 val_168
    +169 val_169
    +17 val_17
    +170 val_170
    +172 val_172
    +174 val_174
    +175 val_175
    +176 val_176
    +177 val_177
    +178 val_178
    +179 val_179
    +18 val_18
    +180 val_180
    +181 val_181
    +183 val_183
    +186 val_186
    +187 val_187
    +189 val_189
    +19 val_19
    +190 val_190
    +191 val_191
    +192 val_192
    +193 val_193
    +194 val_194
    +195 val_195
    +196 val_196
    +197 val_197
    +199 val_199
    +2 val_2
    +20 val_20
    +200 val_200
    +201 val_201
    +202 val_202
    +203 val_203
    +205 val_205
    +207 val_207
    +208 val_208
    +209 val_209
    +213 val_213
    +214 val_214
    +216 val_216
    +217 val_217
    +218 val_218
    +219 val_219
    +221 val_221
    +222 val_222
    +223 val_223
    +224
    +224 val_224
    +226 val_226
    +228 val_228
    +229 val_229
    +230 val_230
    +233 val_233
    +235 val_235
    +237 val_237
    +238 val_238
    +239 val_239
    +24 val_24
    +241 val_241
    +242 val_242
    +244 val_244
    +247 val_247
    +248 val_248
    +249 val_249
    +252 val_252
    +255 val_255
    +256 val_256
    +257 val_257
    +258 val_258
    +26 val_26
    +260 val_260
    +262 val_262
    +263 val_263
    +265 val_265
    +266 val_266
    +27 val_27
    +272 val_272
    +273 val_273
    +274 val_274
    +275 val_275
    +277 val_277
    +278 val_278
    +28 val_28
    +280 val_280
    +281 val_281
    +282 val_282
    +283 val_283
    +284 val_284
    +285 val_285
    +286 val_286
    +287 val_287
    +288 val_288
    +289 val_289
    +291 val_291
    +292 val_292
    +296 val_296
    +298 val_298
    +30 val_30
    +302 val_302
    +305 val_305
    +306 val_306
    +307 val_307
    +308 val_308
    +309 val_309
    +310 val_310
    +311 val_311
    +315 val_315
    +316 val_316
    +317 val_317
    +318 val_318
    +321 val_321
    +322 val_322
    +323 val_323
    +325 val_325
    +327 val_327
    +33 val_33
    +331 val_331
    +332 val_332
    +333 val_333
    +335 val_335
    +336 val_336
    +338 val_338
    +339 val_339
    +34 val_34
    +341 val_341
    +342 val_342
    +344 val_344
    +345 val_345
    +348 val_348
    +35 val_35
    +351 val_351
    +353 val_353
    +356 val_356
    +360 val_360
    +362 val_362
    +364 val_364
    +365 val_365
    +366 val_366
    +367 val_367
    +368 val_368
    +369
    +369 val_369
    +37 val_37
    +373 val_373
    +374 val_374
    +375 val_375
    +377 val_377
    +378 val_378
    +379 val_379
    +382 val_382
    +384 val_384
    +386 val_386
    +389 val_389
    +392 val_392
    +393 val_393
    +394 val_394
    +395 val_395
    +396 val_396
    +397 val_397
    +399 val_399
    +4 val_4
    +400 val_400
    +401 val_401
    +402 val_402
    +403 val_403
    +404 val_404
    +406 val_406
    +407 val_407
    +409 val_409
    +41 val_41
    +411 val_411
    +413 val_413
    +414 val_414
    +417 val_417
    +418 val_418
    +419 val_419
    +42 val_42
    +421 val_421
    +424 val_424
    +427 val_427
    +429 val_429
    +43 val_43
    +430 val_430
    +431 val_431
    +432 val_432
    +435 val_435
    +436 val_436
    +437 val_437
    +438 val_438
    +439 val_439
    +44 val_44
    +443 val_443
    +444 val_444
    +446 val_446
    +448 val_448
    +449 val_449
    +452 val_452
    +453 val_453
    +454 val_454
    +455 val_455
    +457 val_457
    +458 val_458
    +459 val_459
    +460 val_460
    +462 val_462
    +463 val_463
    +466 val_466
    +467 val_467
    +468 val_468
    +469 val_469
    +47 val_47
    +470 val_470
    +472 val_472
    +475 val_475
    +477 val_477
    +478 val_478
    +479 val_479
    +480 val_480
    +481 val_481
    +482 val_482
    +483 val_483
    +484 val_484
    +485 val_485
    +487 val_487
    +489 val_489
    +490 val_490
    +491 val_491
    +492 val_492
    +493 val_493
    +494 val_494
    +495 val_495
    +496 val_496
    +497 val_497
    +498 val_498
    +5 val_5
    +51 val_51
    +53 val_53
    +54 val_54
    +57 val_57
    +58 val_58
    +64 val_64
    +65 val_65
    +66 val_66
    +67 val_67
    +69 val_69
    +70 val_70
    +72 val_72
    +74 val_74
    +76 val_76
    +77 val_77
    +78 val_78
    +8 val_8
    +80 val_80
    +82 val_82
    +83 val_83
    +84 val_84
    +85 val_85
    +86 val_86
    +87 val_87
    +9 val_9
    +90 val_90
    +92 val_92
    +95 val_95
    +96 val_96
    +97 val_97
    +98 val_98
    +PREHOOK: query: drop view if exists sdi
    +PREHOOK: type: DROPVIEW
    +POSTHOOK: query: drop view if exists sdi
    +POSTHOOK: type: DROPVIEW
    +PREHOOK: query: explain create view sdi as select distinct * from src order by key limit 2
    +PREHOOK: type: CREATEVIEW
    +POSTHOOK: query: explain create view sdi as select distinct * from src order by key limit 2
    +POSTHOOK: type: CREATEVIEW
    +STAGE DEPENDENCIES:
    + Stage-0 is a root stage
    +
    +STAGE PLANS:
    + Stage: Stage-0
    + Create View Operator:
    + Create View
    + or replace: false
    + columns: key string, value string
    + expanded text: select distinct `src`.`key`, `src`.`value` from `default`.`src` order by `src`.`key` limit 2
    + name: default.sdi
    + original text: select distinct * from src order by key limit 2
    +
    +PREHOOK: query: create view sdi as select distinct * from src order by key limit 2
    +PREHOOK: type: CREATEVIEW
    +PREHOOK: Input: default@src
    +PREHOOK: Output: database:default
    +PREHOOK: Output: default@sdi
    +POSTHOOK: query: create view sdi as select distinct * from src order by key limit 2
    +POSTHOOK: type: CREATEVIEW
    +POSTHOOK: Input: default@src
    +POSTHOOK: Output: database:default
    +POSTHOOK: Output: default@sdi
    +PREHOOK: query: describe extended sdi
    +PREHOOK: type: DESCTABLE
    +PREHOOK: Input: default@sdi
    +POSTHOOK: query: describe extended sdi
    +POSTHOOK: type: DESCTABLE
    +POSTHOOK: Input: default@sdi
    +key string
    +value string
    +
    +#### A masked pattern was here ####
    +PREHOOK: query: describe formatted sdi
    +PREHOOK: type: DESCTABLE
    +PREHOOK: Input: default@sdi
    +POSTHOOK: query: describe formatted sdi
    +POSTHOOK: type: DESCTABLE
    +POSTHOOK: Input: default@sdi
    +# col_name data_type comment
    +
    +key string
    +value string
    +
    +# Detailed Table Information
    +Database: default
    +#### A masked pattern was here ####
    +Protect Mode: None
    +Retention: 0
    +Table Type: VIRTUAL_VIEW
    +Table Parameters:
    +#### A masked pattern was here ####
    +
    +# Storage Information
    +SerDe Library: null
    +InputFormat: org.apache.hadoop.mapred.SequenceFileInputFormat
    +OutputFormat: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
    +Compressed: No
    +Num Buckets: -1
    +Bucket Columns: []
    +Sort Columns: []
    +
    +# View Information
    +View Original Text: select distinct * from src order by key limit 2
    +View Expanded Text: select distinct `src`.`key`, `src`.`value` from `default`.`src` order by `src`.`key` limit 2
    +PREHOOK: query: select * from sdi
    +PREHOOK: type: QUERY
    +PREHOOK: Input: default@sdi
    +PREHOOK: Input: default@src
    +#### A masked pattern was here ####
    +POSTHOOK: query: select * from sdi
    +POSTHOOK: type: QUERY
    +POSTHOOK: Input: default@sdi
    +POSTHOOK: Input: default@src
    +#### A masked pattern was here ####
    +0 val_0
    +10 val_10
    +PREHOOK: query: select distinct * from src union all select distinct * from src1
    +PREHOOK: type: QUERY
    +PREHOOK: Input: default@src
    +PREHOOK: Input: default@src1
    +#### A masked pattern was here ####
    +POSTHOOK: query: select distinct * from src union all select distinct * from src1
    +POSTHOOK: type: QUERY
    +POSTHOOK: Input: default@src
    +POSTHOOK: Input: default@src1
    +#### A masked pattern was here ####
    +0 val_0
    +10 val_10
    +100 val_100
    +103 val_103
    +104 val_104
    +105 val_105
    +11 val_11
    +111 val_111
    +113 val_113
    +114 val_114
    +116 val_116
    +118 val_118
    +119 val_119
    +12 val_12
    +120 val_120
    +125 val_125
    +126 val_126
    +128 val_128
    +129 val_129
    +131 val_131
    +133 val_133
    +134 val_134
    +136 val_136
    +137 val_137
    +138 val_138
    +143 val_143
    +145 val_145
    +146 val_146
    +149 val_149
    +15 val_15
    +150 val_150
    +152 val_152
    +153 val_153
    +155 val_155
    +156 val_156
    +157 val_157
    +158 val_158
    +160 val_160
    +162 val_162
    +163 val_163
    +164 val_164
    +165 val_165
    +166 val_166
    +167 val_167
    +168 val_168
    +169 val_169
    +17 val_17
    +170 val_170
    +172 val_172
    +174 val_174
    +175 val_175
    +176 val_176
    +177 val_177
    +178 val_178
    +179 val_179
    +18 val_18
    +180 val_180
    +181 val_181
    +183 val_183
    +186 val_186
    +187 val_187
    +189 val_189
    +19 val_19
    +190 val_190
    +191 val_191
    +192 val_192
    +193 val_193
    +194 val_194
    +195 val_195
    +196 val_196
    +197 val_197
    +199 val_199
    +2 val_2
    +20 val_20
    +200 val_200
    +201 val_201
    +202 val_202
    +203 val_203
    +205 val_205
    +207 val_207
    +208 val_208
    +209 val_209
    +213 val_213
    +214 val_214
    +216 val_216
    +217 val_217
    +218 val_218
    +219 val_219
    +221 val_221
    +222 val_222
    +223 val_223
    +224 val_224
    +226 val_226
    +228 val_228
    +229 val_229
    +230 val_230
    +233 val_233
    +235 val_235
    +237 val_237
    +238 val_238
    +239 val_239
    +24 val_24
    +241 val_241
    +242 val_242
    +244 val_244
    +247 val_247
    +248 val_248
    +249 val_249
    +252 val_252
    +255 val_255
    +256 val_256
    +257 val_257
    +258 val_258
    +26 val_26
    +260 val_260
    +262 val_262
    +263 val_263
    +265 val_265
    +266 val_266
    +27 val_27
    +272 val_272
    +273 val_273
    +274 val_274
    +275 val_275
    +277 val_277
    +278 val_278
    +28 val_28
    +280 val_280
    +281 val_281
    +282 val_282
    +283 val_283
    +284 val_284
    +285 val_285
    +286 val_286
    +287 val_287
    +288 val_288
    +289 val_289
    +291 val_291
    +292 val_292
    +296 val_296
    +298 val_298
    +30 val_30
    +302 val_302
    +305 val_305
    +306 val_306
    +307 val_307
    +308 val_308
    +309 val_309
    +310 val_310
    +311 val_311
    +315 val_315
    +316 val_316
    +317 val_317
    +318 val_318
    +321 val_321
    +322 val_322
    +323 val_323
    +325 val_325
    +327 val_327
    +33 val_33
    +331 val_331
    +332 val_332
    +333 val_333
    +335 val_335
    +336 val_336
    +338 val_338
    +339 val_339
    +34 val_34
    +341 val_341
    +342 val_342
    +344 val_344
    +345 val_345
    +348 val_348
    +35 val_35
    +351 val_351
    +353 val_353
    +356 val_356
    +360 val_360
    +362 val_362
    +364 val_364
    +365 val_365
    +366 val_366
    +367 val_367
    +368 val_368
    +369 val_369
    +37 val_37
    +373 val_373
    +374 val_374
    +375 val_375
    +377 val_377
    +378 val_378
    +379 val_379
    +382 val_382
    +384 val_384
    +386 val_386
    +389 val_389
    +392 val_392
    +393 val_393
    +394 val_394
    +395 val_395
    +396 val_396
    +397 val_397
    +399 val_399
    +4 val_4
    +400 val_400
    +401 val_401
    +402 val_402
    +403 val_403
    +404 val_404
    +406 val_406
    +407 val_407
    +409 val_409
    +41 val_41
    +411 val_411
    +413 val_413
    +414 val_414
    +417 val_417
    +418 val_418
    +419 val_419
    +42 val_42
    +421 val_421
    +424 val_424
    +427 val_427
    +429 val_429
    +43 val_43
    +430 val_430
    +431 val_431
    +432 val_432
    +435 val_435
    +436 val_436
    +437 val_437
    +438 val_438
    +439 val_439
    +44 val_44
    +443 val_443
    +444 val_444
    +446 val_446
    +448 val_448
    +449 val_449
    +452 val_452
    +453 val_453
    +454 val_454
    +455 val_455
    +457 val_457
    +458 val_458
    +459 val_459
    +460 val_460
    +462 val_462
    +463 val_463
    +466 val_466
    +467 val_467
    +468 val_468
    +469 val_469
    +47 val_47
    +470 val_470
    +472 val_472
    +475 val_475
    +477 val_477
    +478 val_478
    +479 val_479
    +480 val_480
    +481 val_481
    +482 val_482
    +483 val_483
    +484 val_484
    +485 val_485
    +487 val_487
    +489 val_489
    +490 val_490
    +491 val_491
    +492 val_492
    +493 val_493
    +494 val_494
    +495 val_495
    +496 val_496
    +497 val_497
    +498 val_498
    +5 val_5
    +51 val_51
    +53 val_53
    +54 val_54
    +57 val_57
    +58 val_58
    +64 val_64
    +65 val_65
    +66 val_66
    +67 val_67
    +69 val_69
    +70 val_70
    +72 val_72
    +74 val_74
    +76 val_76
    +77 val_77
    +78 val_78
    +8 val_8
    +80 val_80
    +82 val_82
    +83 val_83
    +84 val_84
    +85 val_85
    +86 val_86
    +87 val_87
    +9 val_9
    +90 val_90
    +92 val_92
    +95 val_95
    +96 val_96
    +97 val_97
    +98 val_98
    +
    + val_165
    + val_193
    + val_265
    + val_27
    + val_409
    + val_484
    +128
    +146 val_146
    +150 val_150
    +213 val_213
    +224
    +238 val_238
    +255 val_255
    +273 val_273
    +278 val_278
    +311 val_311
    +369
    +401 val_401
    +406 val_406
    +66 val_66
    +98 val_98
    +PREHOOK: query: select distinct * from src join src1 on src.key=src1.key
    +PREHOOK: type: QUERY
    +PREHOOK: Input: default@src
    +PREHOOK: Input: default@src1
    +#### A masked pattern was here ####
    +POSTHOOK: query: select distinct * from src join src1 on src.key=src1.key
    +POSTHOOK: type: QUERY
    +POSTHOOK: Input: default@src
    +POSTHOOK: Input: default@src1
    +#### A masked pattern was here ####
    +128 128 val_128
    +146 val_146 146 val_146
    +150 val_150 150 val_150
    +213 val_213 213 val_213
    +224 224 val_224
    +238 val_238 238 val_238
    +255 val_255 255 val_255
    +273 val_273 273 val_273
    +278 val_278 278 val_278
    +311 val_311 311 val_311
    +369 369 val_369
    +401 val_401 401 val_401
    +406 val_406 406 val_406
    +66 val_66 66 val_66
    +98 val_98 98 val_98
    +PREHOOK: query: SELECT distinct *
    +FROM src1 x JOIN src y ON (x.key = y.key)
    +JOIN srcpart z ON (x.value = z.value and z.ds='2008-04-08' and z.hr=11)
    +PREHOOK: type: QUERY
    +PREHOOK: Input: default@src
    +PREHOOK: Input: default@src1
    +PREHOOK: Input: default@srcpart
    +PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
    +#### A masked pattern was here ####
    +POSTHOOK: query: SELECT distinct *
    +FROM src1 x JOIN src y ON (x.key = y.key)
    +JOIN srcpart z ON (x.value = z.value and z.ds='2008-04-08' and z.hr=11)
    +POSTHOOK: type: QUERY
    +POSTHOOK: Input: default@src
    +POSTHOOK: Input: default@src1
    +POSTHOOK: Input: default@srcpart
    +POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
    +#### A masked pattern was here ####
    +146 val_146 2008-04-08 11 146 val_146 146 val_146
    +150 val_150 2008-04-08 11 150 val_150 150 val_150
    +213 val_213 2008-04-08 11 213 val_213 213 val_213
    +238 val_238 2008-04-08 11 238 val_238 238 val_238
    +255 val_255 2008-04-08 11 255 val_255 255 val_255
    +273 val_273 2008-04-08 11 273 val_273 273 val_273
    +278 val_278 2008-04-08 11 278 val_278 278 val_278
    +311 val_311 2008-04-08 11 311 val_311 311 val_311
    +401 val_401 2008-04-08 11 401 val_401 401 val_401
    +406 val_406 2008-04-08 11 406 val_406 406 val_406
    +66 val_66 2008-04-08 11 66 val_66 66 val_66
    +98 val_98 2008-04-08 11 98 val_98 98 val_98
    +PREHOOK: query: select * from (select distinct * from src)src1
    +join
    +(select distinct * from src)src2
    +on src1.key=src2.key
    +PREHOOK: type: QUERY
    +PREHOOK: Input: default@src
    +#### A masked pattern was here ####
    +POSTHOOK: query: select * from (select distinct * from src)src1
    +join
    +(select distinct * from src)src2
    +on src1.key=src2.key
    +POSTHOOK: type: QUERY
    +POSTHOOK: Input: default@src
    +#### A masked pattern was here ####
    +0 val_0 0 val_0
    +10 val_10 10 val_10
    +100 val_100 100 val_100
    +103 val_103 103 val_103
    +104 val_104 104 val_104
    +105 val_105 105 val_105
    +11 val_11 11 val_11
    +111 val_111 111 val_111
    +113 val_113 113 val_113
    +114 val_114 114 val_114
    +116 val_116 116 val_116
    +118 val_118 118 val_118
    +119 val_119 119 val_119
    +12 val_12 12 val_12
    +120 val_120 120 val_120
    +125 val_125 125 val_125
    +126 val_126 126 val_126
    +128 val_128 128 val_128
    +129 val_129 129 val_129
    +131 val_131 131 val_131
    +133 val_133 133 val_133
    +134 val_134 134 val_134
    +136 val_136 136 val_136
    +137 val_137 137 val_137
    +138 val_138 138 val_138
    +143 val_143 143 val_143
    +145 val_145 145 val_145
    +146 val_146 146 val_146
    +149 val_149 149 val_149
    +15 val_15 15 val_15
    +150 val_150 150 val_150
    +152 val_152 152 val_152
    +153 val_153 153 val_153
    +155 val_155 155 val_155
    +156 val_156 156 val_156
    +157 val_157 157 val_157
    +158 val_158 158 val_158
    +160 val_160 160 val_160
    +162 val_162 162 val_162
    +163 val_163 163 val_163
    +164 val_164 164 val_164
    +165 val_165 165 val_165
    +166 val_166 166 val_166
    +167 val_167 167 val_167
    +168 val_168 168 val_168
    +169 val_169 169 val_169
    +17 val_17 17 val_17
    +170 val_170 170 val_170
    +172 val_172 172 val_172
    +174 val_174 174 val_174
    +175 val_175 175 val_175
    +176 val_176 176 val_176
    +177 val_177 177 val_177
    +178 val_178 178 val_178
    +179 val_179 179 val_179
    +18 val_18 18 val_18
    +180 val_180 180 val_180
    +181 val_181 181 val_181
    +183 val_183 183 val_183
    +186 val_186 186 val_186
    +187 val_187 187 val_187
    +189 val_189 189 val_189
    +19 val_19 19 val_19
    +190 val_190 190 val_190
    +191 val_191 191 val_191
    +192 val_192 192 val_192
    +193 val_193 193 val_193
    +194 val_194 194 val_194
    +195 val_195 195 val_195
    +196 val_196 196 val_196
    +197 val_197 197 val_197
    +199 val_199 199 val_199
    +2 val_2 2 val_2
    +20 val_20 20 val_20
    +200 val_200 200 val_200
    +201 val_201 201 val_201
    +202 val_202 202 val_202
    +203 val_203 203 val_203
    +205 val_205 205 val_205
    +207 val_207 207 val_207
    +208 val_208 208 val_208
    +209 val_209 209 val_209
    +213 val_213 213 val_213
    +214 val_214 214 val_214
    +216 val_216 216 val_216
    +217 val_217 217 val_217
    +218 val_218 218 val_218
    +219 val_219 219 val_219
    +221 val_221 221 val_221
    +222 val_222 222 val_222
    +223 val_223 223 val_223
    +224 val_224 224 val_224
    +226 val_226 226 val_226
    +228 val_228 228 val_228
    +229 val_229 229 val_229
    +230 val_230 230 val_230
    +233 val_233 233 val_233
    +235 val_235 235 val_235
    +237 val_237 237 val_237
    +238 val_238 238 val_238
    +239 val_239 239 val_239
    +24 val_24 24 val_24
    +241 val_241 241 val_241
    +242 val_242 242 val_242
    +244 val_244 244 val_244
    +247 val_247 247 val_247
    +248 val_248 248 val_248
    +249 val_249 249 val_249
    +252 val_252 252 val_252
    +255 val_255 255 val_255
    +256 val_256 256 val_256
    +257 val_257 257 val_257
    +258 val_258 258 val_258
    +26 val_26 26 val_26
    +260 val_260 260 val_260
    +262 val_262 262 val_262
    +263 val_263 263 val_263
    +265 val_265 265 val_265
    +266 val_266 266 val_266
    +27 val_27 27 val_27
    +272 val_272 272 val_272
    +273 val_273 273 val_273
    +274 val_274 274 val_274
    +275 val_275 275 val_275
    +277 val_277 277 val_277
    +278 val_278 278 val_278
    +28 val_28 28 val_28
    +280 val_280 280 val_280
    +281 val_281 281 val_281
    +282 val_282 282 val_282
    +283 val_283 283 val_283
    +284 val_284 284 val_284
    +285 val_285 285 val_285
    +286 val_286 286 val_286
    +287 val_287 287 val_287
    +288 val_288 288 val_288
    +289 val_289 289 val_289
    +291 val_291 291 val_291
    +292 val_292 292 val_292
    +296 val_296 296 val_296
    +298 val_298 298 val_298
    +30 val_30 30 val_30
    +302 val_302 302 val_302
    +305 val_305 305 val_305
    +306 val_306 306 val_306
    +307 val_307 307 val_307
    +308 val_308 308 val_308
    +309 val_309 309 val_309
    +310 val_310 310 val_310
    +311 val_311 311 val_311
    +315 val_315 315 val_315
    +316 val_316 316 val_316
    +317 val_317 317 val_317
    +318 val_318 318 val_318
    +321 val_321 321 val_321
    +322 val_322 322 val_322
    +323 val_323 323 val_323
    +325 val_325 325 val_325
    +327 val_327 327 val_327
    +33 val_33 33 val_33
    +331 val_331 331 val_331
    +332 val_332 332 val_332
    +333 val_333 333 val_333
    +335 val_335 335 val_335
    +336 val_336 336 val_336
    +338 val_338 338 val_338
    +339 val_339 339 val_339
    +34 val_34 34 val_34
    +341 val_341 341 val_341
    +342 val_342 342 val_342
    +344 val_344 344 val_344
    +345 val_345 345 val_345
    +348 val_348 348 val_348
    +35 val_35 35 val_35
    +351 val_351 351 val_351
    +353 val_353 353 val_353
    +356 val_356 356 val_356
    +360 val_360 360 val_360
    +362 val_362 362 val_362
    +364 val_364 364 val_364
    +365 val_365 365 val_365
    +366 val_366 366 val_366
    +367 val_367 367 val_367
    +368 val_368 368 val_368
    +369 val_369 369 val_369
    +37 val_37 37 val_37
    +373 val_373 373 val_373
    +374 val_374 374 val_374
    +375 val_375 375 val_375
    +377 val_377 377 val_377
    +378 val_378 378 val_378
    +379 val_379 379 val_379
    +382 val_382 382 val_382
    +384 val_384 384 val_384
    +386 val_386 386 val_386
    +389 val_389 389 val_389
    +392 val_392 392 val_392
    +393 val_393 393 val_393
    +394 val_394 394 val_394
    +395 val_395 395 val_395
    +396 val_396 396 val_396
    +397 val_397 397 val_397
    +399 val_399 399 val_399
    +4 val_4 4 val_4
    +400 val_400 400 val_400
    +401 val_401 401 val_401
    +402 val_402 402 val_402
    +403 val_403 403 val_403
    +404 val_404 404 val_404
    +406 val_406 406 val_406
    +407 val_407 407 val_407
    +409 val_409 409 val_409
    +41 val_41 41 val_41
    +411 val_411 411 val_411
    +413 val_413 413 val_413
    +414 val_414 414 val_414
    +417 val_417 417 val_417
    +418 val_418 418 val_418
    +419 val_419 419 val_419
    +42 val_42 42 val_42
    +421 val_421 421 val_421
    +424 val_424 424 val_424
    +427 val_427 427 val_427
    +429 val_429 429 val_429
    +43 val_43 43 val_43
    +430 val_430 430 val_430
    +431 val_431 431 val_431
    +432 val_432 432 val_432
    +435 val_435 435 val_435
    +436 val_436 436 val_436
    +437 val_437 437 val_437
    +438 val_438 438 val_438
    +439 val_439 439 val_439
    +44 val_44 44 val_44
    +443 val_443 443 val_443
    +444 val_444 444 val_444
    +446 val_446 446 val_446
    +448 val_448 448 val_448
    +449 val_449 449 val_449
    +452 val_452 452 val_452
    +453 val_453 453 val_453
    +454 val_454 454 val_454
    +455 val_455 455 val_455
    +457 val_457 457 val_457
    +458 val_458 458 val_458
    +459 val_459 459 val_459
    +460 val_460 460 val_460
    +462 val_462 462 val_462
    +463 val_463 463 val_463
    +466 val_466 466 val_466
    +467 val_467 467 val_467
    +468 val_468 468 val_468
    +469 val_469 469 val_469
    +47 val_47 47 val_47
    +470 val_470 470 val_470
    +472 val_472 472 val_472
    +475 val_475 475 val_475
    +477 val_477 477 val_477
    +478 val_478 478 val_478
    +479 val_479 479 val_479
    +480 val_480 480 val_480
    +481 val_481 481 val_481
    +482 val_482 482 val_482
    +483 val_483 483 val_483
    +484 val_484 484 val_484
    +485 val_485 485 val_485
    +487 val_487 487 val_487
    +489 val_489 489 val_489
    +490 val_490 490 val_490
    +491 val_491 491 val_491
    +492 val_492 492 val_492
    +493 val_493 493 val_493
    +494 val_494 494 val_494
    +495 val_495 495 val_495
    +496 val_496 496 val_496
    +497 val_497 497 val_497
    +498 val_498 498 val_498
    +5 val_5 5 val_5
    +51 val_51 51 val_51
    +53 val_53 53 val_53
    +54 val_54 54 val_54
    +57 val_57 57 val_57
    +58 val_58 58 val_58
    +64 val_64 64 val_64
    +65 val_65 65 val_65
    +66 val_66 66 val_66
    +67 val_67 67 val_67
    +69 val_69 69 val_69
    +70 val_70 70 val_70
    +72 val_72 72 val_72
    +74 val_74 74 val_74
    +76 val_76 76 val_76
    +77 val_77 77 val_77
    +78 val_78 78 val_78
    +8 val_8 8 val_8
    +80 val_80 80 val_80
    +82 val_82 82 val_82
    +83 val_83 83 val_83
    +84 val_84 84 val_84
    +85 val_85 85 val_85
    +86 val_86 86 val_86
    +87 val_87 87 val_87
    +9 val_9 9 val_9
    +90 val_90 90 val_90
    +92 val_92 92 val_92
    +95 val_95 95 val_95
    +96 val_96 96 val_96
    +97 val_97 97 val_97
    +98 val_98 98 val_98
    +PREHOOK: query: select distinct * from (select distinct * from src)src1
    +PREHOOK: type: QUERY
    +PREHOOK: Input: default@src
    +#### A masked pattern was here ####
    +POSTHOOK: query: select distinct * from (select distinct * from src)src1
    +POSTHOOK: type: QUERY
    +POSTHOOK: Input: default@src
    +#### A masked pattern was here ####
    +0 val_0
    +10 val_10
    +100 val_100
    +103 val_103
    +104 val_104
    +105 val_105
    +11 val_11
    +111 val_111
    +113 val_113
    +114 val_114
    +116 val_116
    +118 val_118
    +119 val_119
    +12 val_12
    +120 val_120
    +125 val_125
    +126 val_126
    +128 val_128
    +129 val_129
    +131 val_131
    +133 val_133
    +134 val_134
    +136 val_136
    +137 val_137
    +138 val_138
    +143 val_143
    +145 val_145
    +146 val_146
    +149 val_149
    +15 val_15
    +150 val_150
    +152 val_152
    +153 val_153
    +155 val_155
    +156 val_156
    +157 val_157
    +158 val_158
    +160 val_160
    +162 val_162
    +163 val_163
    +164 val_164
    +165 val_165
    +166 val_166
    +167 val_167
    +168 val_168
    +169 val_169
    +17 val_17
    +170 val_170
    +172 val_172
    +174 val_174
    +175 val_175
    +176 val_176
    +177 val_177
    +178 val_178
    +179 val_179
    +18 val_18
    +180 val_180
    +181 val_181
    +183 val_183
    +186 val_186
    +187 val_187
    +189 val_189
    +19 val_19
    +190 val_190
    +191 val_191
    +192 val_192
    +193 val_193
    +194 val_194
    +195 val_195
    +196 val_196
    +197 val_197
    +199 val_199
    +2 val_2
    +20 val_20
    +200 val_200
    +201 val_201
    +202 val_202
    +203 val_203
    +205 val_205
    +207 val_207
    +208 val_208
    +209 val_209
    +213 val_213
    +214 val_214
    +216 val_216
    +217 val_217
    +218 val_218
    +219 val_219
    +221 val_221
    +222 val_222
    +223 val_223
    +224 val_224
    +226 val_226
    +228 val_228
    +229 val_229
    +230 val_230
    +233 val_233
    +235 val_235
    +237 val_237
    +238 val_238
    +239 val_239
    +24 val_24
    +241 val_241
    +242 val_242
    +244 val_244
    +247 val_247
    +248 val_248
    +249 val_249
    +252 val_252
    +255 val_255
    +256 val_256
    +257 val_257
    +258 val_258
    +26 val_26
    +260 val_260
    +262 val_262
    +263 val_263
    +265 val_265
    +266 val_266
    +27 val_27
    +272 val_272
    +273 val_273
    +274 val_274
    +275 val_275
    +277 val_277
    +278 val_278
    +28 val_28
    +280 val_280
    +281 val_281
    +282 val_282
    +283 val_283
    +284 val_284
    +285 val_285
    +286 val_286
    +287 val_287
    +288 val_288
    +289 val_289
    +291 val_291
    +292 val_292
    +296 val_296
    +298 val_298
    +30 val_30
    +302 val_302
    +305 val_305
    +306 val_306
    +307 val_307
    +308 val_308
    +309 val_309
    +310 val_310
    +311 val_311
    +315 val_315
    +316 val_316
    +317 val_317
    +318 val_318
    +321 val_321
    +322 val_322
    +323 val_323
    +325 val_325
    +327 val_327
    +33 val_33
    +331 val_331
    +332 val_332
    +333 val_333
    +335 val_335
    +336 val_336
    +338 val_338
    +339 val_339
    +34 val_34
    +341 val_341
    +342 val_342
    +344 val_344
    +345 val_345
    +348 val_348
    +35 val_35
    +351 val_351
    +353 val_353
    +356 val_356
    +360 val_360
    +362 val_362
    +364 val_364
    +365 val_365
    +366 val_366
    +367 val_367
    +368 val_368
    +369 val_369
    +37 val_37
    +373 val_373
    +374 val_374
    +375 val_375
    +377 val_377
    +378 val_378
    +379 val_379
    +382 val_382
    +384 val_384
    +386 val_386
    +389 val_389
    +392 val_392
    +393 val_393
    +394 val_394
    +395 val_395
    +396 val_396
    +397 val_397
    +399 val_399
    +4 val_4
    +400 val_400
    +401 val_401
    +402 val_402
    +403 val_403
    +404 val_404
    +406 val_406
    +407 val_407
    +409 val_409
    +41 val_41
    +411 val_411
    +413 val_413
    +414 val_414
    +417 val_417
    +418 val_418
    +419 val_419
    +42 val_42
    +421 val_421
    +424 val_424
    +427 val_427
    +429 val_429
    +43 val_43
    +430 val_430
    +431 val_431
    +432 val_432
    +435 val_435
    +436 val_436
    +437 val_437
    +438 val_438
    +439 val_439
    +44 val_44
    +443 val_443
    +444 val_444
    +446 val_446
    +448 val_448
    +449 val_449
    +452 val_452
    +453 val_453
    +454 val_454
    +455 val_455
    +457 val_457
    +458 val_458
    +459 val_459
    +460 val_460
    +462 val_462
    +463 val_463
    +466 val_466
    +467 val_467
    +468 val_468
    +469 val_469
    +47 val_47
    +470 val_470
    +472 val_472
    +475 val_475
    +477 val_477
    +478 val_478
    +479 val_479
    +480 val_480
    +481 val_481
    +482 val_482
    +483 val_483
    +484 val_484
    +485 val_485
    +487 val_487
    +489 val_489
    +490 val_490
    +491 val_491
    +492 val_492
    +493 val_493
    +494 val_494
    +495 val_495
    +496 val_496
    +497 val_497
    +498 val_498
    +5 val_5
    +51 val_51
    +53 val_53
    +54 val_54
    +57 val_57
    +58 val_58
    +64 val_64
    +65 val_65
    +66 val_66
    +67 val_67
    +69 val_69
    +70 val_70
    +72 val_72
    +74 val_74
    +76 val_76
    +77 val_77
    +78 val_78
    +8 val_8
    +80 val_80
    +82 val_82
    +83 val_83
    +84 val_84
    +85 val_85
    +86 val_86
    +87 val_87
    +9 val_9
    +90 val_90
    +92 val_92
    +95 val_95
    +96 val_96
    +97 val_97
    +98 val_98
    +PREHOOK: query: explain select distinct src.* from src
    +PREHOOK: type: QUERY
    +POSTHOOK: query: explain select distinct src.* from src
    +POSTHOOK: type: QUERY
    +STAGE DEPENDENCIES:
    + Stage-1 is a root stage
    + Stage-0 depends on stages: Stage-1
    +
    +STAGE PLANS:
    + Stage: Stage-1
    + Tez
    + Edges:
    + Reducer 2 <- Map 1 (SIMPLE_EDGE)
    +#### A masked pattern was here ####
    + Vertices:
    + Map 1
    + Map Operator Tree:
    + TableScan
    + alias: src
    + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
    + Select Operator
    + expressions: key (type: string), value (type: string)
    + outputColumnNames: _col0, _col1
    + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
    + Group By Operator
    + keys: _col0 (type: string), _col1 (type: string)
    + mode: hash
    + outputColumnNames: _col0, _col1
    + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
    + Reduce Output Operator
    + key expressions: _col0 (type: string), _col1 (type: string)
    + sort order: ++
    + Map-reduce partition columns: _col0 (type: string), _col1 (type: string)
    + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
    + Reducer 2
    + Reduce Operator Tree:
    + Group By Operator
    + keys: KEY._col0 (type: string), KEY._col1 (type: string)
    + mode: mergepartial
    + outputColumnNames: _col0, _col1
    + Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
    + Select Operator
    + expressions: _col0 (type: string), _col1 (type: string)
    + outputColumnNames: _col0, _col1
    + Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
    + File Output Operator
    + compressed: false
    + Statistics: Num rows: 250 Data size: 2656 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: -1
    + Processor Tree:
    + ListSink
    +
    +PREHOOK: query: select distinct src.* from src
    +PREHOOK: type: QUERY
    +PREHOOK: Input: default@src
    +#### A masked pattern was here ####
    +POSTHOOK: query: select distinct src.* from src
    +POSTHOOK: type: QUERY
    +POSTHOOK: Input: default@src
    +#### A masked pattern was here ####
    +0 val_0
    +10 val_10
    +100 val_100
    +103 val_103
    +104 val_104
    +105 val_105
    +11 val_11
    +111 val_111
    +113 val_113
    +114 val_114
    +116 val_116
    +118 val_118
    +119 val_119
    +12 val_12
    +120 val_120
    +125 val_125
    +126 val_126
    +128 val_128
    +129 val_129
    +131 val_131
    +133 val_133
    +134 val_134
    +136 val_136
    +137 val_137
    +138 val_138
    +143 val_143
    +145 val_145
    +146 val_146
    +149 val_149
    +15 val_15
    +150 val_150
    +152 val_152
    +153 val_153
    +155 val_155
    +156 val_156
    +157 val_157
    +158 val_158
    +160 val_160
    +162 val_162
    +163 val_163
    +164 val_164
    +165 val_165
    +166 val_166
    +167 val_167
    +168 val_168
    +169 val_169
    +17 val_17
    +170 val_170
    +172 val_172
    +174 val_174
    +175 val_175
    +176 val_176
    +177 val_177
    +178 val_178
    +179 val_179
    +18 val_18
    +180 val_180
    +181 val_181
    +183 val_183
    +186 val_186
    +187 val_187
    +189 val_189
    +19 val_19
    +190 val_190
    +191 val_191
    +192 val_192
    +193 val_193
    +194 val_194
    +195 val_195
    +196 val_196
    +197 val_197
    +199 val_199
    +2 val_2
    +20 val_20
    +200 val_200
    +201 val_201
    +202 val_202
    +203 val_203
    +205 val_205
    +207 val_207
    +208 val_208
    +209 val_209
    +213 val_213
    +214 val_214
    +216 val_216
    +217 val_217
    +218 val_218
    +219 val_219
    +221 val_221
    +222 val_222
    +223 val_223
    +224 val_224
    +226 val_226
    +228 val_228
    +229 val_229
    +230 val_230
    +233 val_233
    +235 val_235
    +237 val_237
    +238 val_238
    +239 val_239
    +24 val_24
    +241 val_241
    +242 val_242
    +244 val_244
    +247 val_247
    +248 val_248
    +249 val_249
    +252 val_252
    +255 val_255
    +256 val_256
    +257 val_257
    +258 val_258
    +26 val_26
    +260 val_260
    +262 val_262
    +263 val_263
    +265 val_265
    +266 val_266
    +27 val_27
    +272 val_272
    +273 val_273
    +274 val_274
    +275 val_275
    +277 val_277
    +278 val_278
    +28 val_28
    +280 val_280
    +281 val_281
    +282 val_282
    +283 val_283
    +284 val_284
    +285 val_285
    +286 val_286
    +287 val_287
    +288 val_288
    +289 val_289
    +291 val_291
    +292 val_292
    +296 val_296
    +298 val_298
    +30 val_30
    +302 val_302
    +305 val_305
    +306 val_306
    +307 val_307
    +308 val_308
    +309 val_309
    +310 val_310
    +311 val_311
    +315 val_315
    +316 val_316
    +317 val_317
    +318 val_318
    +321 val_321
    +322 val_322
    +323 val_323
    +325 val_325
    +327 val_327
    +33 val_33
    +331 val_331
    +332 val_332
    +333 val_333
    +335 val_335
    +336 val_336
    +338 val_338
    +339 val_339
    +34 val_34
    +341 val_341
    +342 val_342
    +344 val_344
    +345 val_345
    +348 val_348
    +35 val_35
    +351 val_351
    +353 val_353
    +356 val_356
    +360 val_360
    +362 val_362
    +364 val_364
    +365 val_365
    +366 val_366
    +367 val_367
    +368 val_368
    +369 val_369
    +37 val_37
    +373 val_373
    +374 val_374
    +375 val_375
    +377 val_377
    +378 val_378
    +379 val_379
    +382 val_382
    +384 val_384
    +386 val_386
    +389 val_389
    +392 val_392
    +393 val_393
    +394 val_394
    +395 val_395
    +396 val_396
    +397 val_397
    +399 val_399
    +4 val_4
    +400 val_400
    +401 val_401
    +402 val_402
    +403 val_403
    +404 val_404
    +406 val_406
    +407 val_407
    +409 val_409
    +41 val_41
    +411 val_411
    +413 val_413
    +414 val_414
    +417 val_417
    +418 val_418
    +419 val_419
    +42 val_42
    +421 val_421
    +424 val_424
    +427 val_427
    +429 val_429
    +43 val_43
    +430 val_430
    +431 val_431
    +432 val_432
    +435 val_435
    +436 val_436
    +437 val_437
    +438 val_438
    +439 val_439
    +44 val_44
    +443 val_443
    +444 val_444
    +446 val_446
    +448 val_448
    +449 val_449
    +452 val_452
    +453 val_453
    +454 val_454
    +455 val_455
    +457 val_457
    +458 val_458
    +459 val_459
    +460 val_460
    +462 val_462
    +463 val_463
    +466 val_466
    +467 val_467
    +468 val_468
    +469 val_469
    +47 val_47
    +470 val_470
    +472 val_472
    +475 val_475
    +477 val_477
    +478 val_478
    +479 val_479
    +480 val_480
    +481 val_481
    +482 val_482
    +483 val_483
    +484 val_484
    +485 val_485
    +487 val_487
    +489 val_489
    +490 val_490
    +491 val_491
    +492 val_492
    +493 val_493
    +494 val_494
    +495 val_495
    +496 val_496
    +497 val_497
    +498 val_498
    +5 val_5
    +51 val_51
    +53 val_53
    +54 val_54
    +57 val_57
    +58 val_58
    +64 val_64
    +65 val_65
    +66 val_66
    +67 val_67
    +69 val_69
    +70 val_70
    +72 val_72
    +74 val_74
    +76 val_76
    +77 val_77
    +78 val_78
    +8 val_8
    +80 val_80
    +82 val_82
    +83 val_83
    +84 val_84
    +85 val_85
    +86 val_86
    +87 val_87
    +9 val_9
    +90 val_90
    +92 val_92
    +95 val_95
    +96 val_96
    +97 val_97
    +98 val_98
    +PREHOOK: query: select distinct * from src
    +PREHOOK: type: QUERY
    +PREHOOK: Input: default@src
    +#### A masked pattern was here ####
    +POSTHOOK: query: select distinct * from src
    +POSTHOOK: type: QUERY
    +POSTHOOK: Input: default@src
    +#### A masked pattern was here ####
    +0 val_0
    +10 val_10
    +100 val_100
    +103 val_103
    +104 val_104
    +105 val_105
    +11 val_11
    +111 val_111
    +113 val_113
    +114 val_114
    +116 val_116
    +118 val_118
    +119 val_119
    +12 val_12
    +120 val_120
    +125 val_125
    +126 val_126
    +128 val_128
    +129 val_129
    +131 val_131
    +133 val_133
    +134 val_134
    +136 val_136
    +137 val_137
    +138 val_138
    +143 val_143
    +145 val_145
    +146 val_146
    +149 val_149
    +15 val_15
    +150 val_150
    +152 val_152
    +153 val_153
    +155 val_155
    +156 val_156
    +157 val_157
    +158 val_158
    +160 val_160
    +162 val_162
    +163 val_163
    +164 val_164
    +165 val_165
    +166 val_166
    +167 val_167
    +168 val_168
    +169 val_169
    +17 val_17
    +170 val_170
    +172 val_172
    +174 val_174
    +175 val_175
    +176 val_176
    +177 val_177
    +178 val_178
    +179 val_179
    +18 val_18
    +180 val_180
    +181 val_181
    +183 val_183
    +186 val_186
    +187 val_187
    +189 val_189
    +19 val_19
    +190 val_190
    +191 val_191
    +192 val_192
    +193 val_193
    +194 val_194
    +195 val_195
    +196 val_196
    +197 val_197
    +199 val_199
    +2 val_2
    +20 val_20
    +200 val_200
    +201 val_201
    +202 val_202
    +203 val_203
    +205 val_205
    +207 val_207
    +208 val_208
    +209 val_209
    +213 val_213
    +214 val_214
    +216 val_216
    +217 val_217
    +218 val_218
    +219 val_219
    +221 val_221
    +222 val_222
    +223 val_223
    +224 val_224
    +226 val_226
    +228 val_228
    +229 val_229
    +230 val_230
    +233 val_233
    +235 val_235
    +237 val_237
    +238 val_238
    +239 val_239
    +24 val_24
    +241 val_241
    +242 val_242
    +244 val_244
    +247 val_247
    +248 val_248
    +249 val_249
    +252 val_252
    +255 val_255
    +256 val_256
    +257 val_257
    +258 val_258
    +26 val_26
    +260 val_260
    +262 val_262
    +263 val_263
    +265 val_265
    +266 val_266
    +27 val_27
    +272 val_272
    +273 val_273
    +274 val_274
    +275 val_275
    +277 val_277
    +278 val_278
    +28 val_28
    +280 val_280
    +281 val_281
    +282 val_282
    +283 val_283
    +284 val_284
    +285 val_285
    +286 val_286
    +287 val_287
    +288 val_288
    +289 val_289
    +291 val_291
    +292 val_292
    +296 val_296
    +298 val_298
    +30 val_30
    +302 val_302
    +305 val_305
    +306 val_306
    +307 val_307
    +308 val_308
    +309 val_309
    +310 val_310
    +311 val_311
    +315 val_315
    +316 val_316
    +317 val_317
    +318 val_318
    +321 val_321
    +322 val_322
    +323 val_323
    +325 val_325
    +327 val_327
    +33 val_33
    +331 val_331
    +332 val_332
    +333 val_333
    +335 val_335
    +336 val_336
    +338 val_338
    +339 val_339
    +34 val_34
    +341 val_341
    +342 val_342
    +344 val_344
    +345 val_345
    +348 val_348
    +35 val_35
    +351 val_351
    +353 val_353
    +356 val_356
    +360 val_360
    +362 val_362
    +364 val_364
    +365 val_365
    +366 val_366
    +367 val_367
    +368 val_368
    +369 val_369
    +37 val_37
    +373 val_373
    +374 val_374
    +375 val_375
    +377 val_377
    +378 val_378
    +379 val_379
    +382 val_382
    +384 val_384
    +386 val_386
    +389 val_389
    +392 val_392
    +393 val_393
    +394 val_394
    +395 val_395
    +396 val_396
    +397 val_397
    +399 val_399
    +4 val_4
    +400 val_400
    +401 val_401
    +402 val_402
    +403 val_403
    +404 val_404
    +406 val_406
    +407 val_407
    +409 val_409
    +41 val_41
    +411 val_411
    +413 val_413
    +414 val_414
    +417 val_417
    +418 val_418
    +419 val_419
    +42 val_42
    +421 val_421
    +424 val_424
    +427 val_427
    +429 val_429
    +43 val_43
    +430 val_430
    +431 val_431
    +432 val_432
    +435 val_435
    +436 val_436
    +437 val_437
    +438 val_438
    +439 val_439
    +44 val_44
    +443 val_443
    +444 val_444
    +446 val_446
    +448 val_448
    +449 val_449
    +452 val_452
    +453 val_453
    +454 val_454
    +455 val_455
    +457 val_457
    +458 val_458
    +459 val_459
    +460 val_460
    +462 val_462
    +463 val_463
    +466 val_466
    +467 val_467
    +468 val_468
    +469 val_469
    +47 val_47
    +470 val_470
    +472 val_472
    +475 val_475
    +477 val_477
    +478 val_478
    +479 val_479
    +480 val_480
    +481 val_481
    +482 val_482
    +483 val_483
    +484 val_484
    +485 val_485
    +487 val_487
    +489 val_489
    +490 val_490
    +491 val_491
    +492 val_492
    +493 val_493
    +494 val_494
    +495 val_495
    +496 val_496
    +497 val_497
    +498 val_498
    +5 val_5
    +51 val_51
    +53 val_53
    +54 val_54
    +57 val_57
    +58 val_58
    +64 val_64
    +65 val_65
    +66 val_66
    +67 val_67
    +69 val_69
    +70 val_70
    +72 val_72
    +74 val_74
    +76 val_76
    +77 val_77
    +78 val_78
    +8 val_8
    +80 val_80
    +82 val_82
    +83 val_83
    +84 val_84
    +85 val_85
    +86 val_86
    +87 val_87
    +9 val_9
    +90 val_90
    +92 val_92
    +95 val_95
    +96 val_96
    +97 val_97
    +98 val_98
    +PREHOOK: query: explain select distinct * from src where key < '3'
    +PREHOOK: type: QUERY
    +POSTHOOK: query: explain select distinct * from src where key < '3'
    +POSTHOOK: type: QUERY
    +STAGE DEPENDENCIES:
    + Stage-1 is a root stage
    + Stage-0 depends on stages: Stage-1
    +
    +STAGE PLANS:
    + Stage: Stage-1
    + Tez
    + Edges:
    + Reducer 2 <- Map 1 (SIMPLE_EDGE)
    +#### A masked pattern was here ####
    + Vertices:
    + Map 1
    + Map Operator Tree:
    + TableScan
    + alias: src
    + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
    + Filter Operator
    + predicate: (key < '3') (type: boolean)
    + Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
    + Select Operator
    + expressions: key (type: string), value (type: string)
    + outputColumnNames: _col0, _col1
    + Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
    + Group By Operator
    + keys: _col0 (type: string), _col1 (type: string)
    + mode: hash
    + outputColumnNames: _col0, _col1
    + Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
    + Reduce Output Operator
    + key expressions: _col0 (type: string), _col1 (type: string)
    + sort order: ++
    + Map-reduce partition columns: _col0 (type: string), _col1 (type: string)
    + Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
    + Reducer 2
    + Reduce Operator Tree:
    + Group By Operator
    + keys: KEY._col0 (type: string), KEY._col1 (type: string)
    + mode: mergepartial
    + outputColumnNames: _col0, _col1
    + Statistics: Num rows: 83 Data size: 881 Basic stats: COMPLETE Column stats: NONE
    + Select Operator
    + expressions: _col0 (type: string), _col1 (type: string)
    + outputColumnNames: _col0, _col1
    + Statistics: Num rows: 83 Data size: 881 Basic stats: COMPLETE Column stats: NONE
    + File Output Operator
    + compressed: false
    + Statistics: Num rows: 83 Data size: 881 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: -1
    + Processor Tree:
    + ListSink
    +
    +PREHOOK: query: select distinct * from src where key < '3'
    +PREHOOK: type: QUERY
    +PREHOOK: Input: default@src
    +#### A masked pattern was here ####
    +POSTHOOK: query: select distinct * from src where key < '3'
    +POSTHOOK: type: QUERY
    +POSTHOOK: Input: default@src
    +#### A masked pattern was here ####
    +0 val_0
    +10 val_10
    +100 val_100
    +103 val_103
    +104 val_104
    +105 val_105
    +11 val_11
    +111 val_111
    +113 val_113
    +114 val_114
    +116 val_116
    +118 val_118
    +119 val_119
    +12 val_12
    +120 val_120
    +125 val_125
    +126 val_126
    +128 val_128
    +129 val_129
    +131 val_131
    +133 val_133
    +134 val_134
    +136 val_136
    +137 val_137
    +138 val_138
    +143 val_143
    +145 val_145
    +146 val_146
    +149 val_149
    +15 val_15
    +150 val_150
    +152 val_152
    +153 val_153
    +155 val_155
    +156 val_156
    +157 val_157
    +158 val_158
    +160 val_160
    +162 val_162
    +163 val_163
    +164 val_164
    +165 val_165
    +166 val_166
    +167 val_167
    +168 val_168
    +169 val_169
    +17 val_17
    +170 val_170
    +172 val_172
    +174 val_174
    +175 val_175
    +176 val_176
    +177 val_177
    +178 val_178
    +179 val_179
    +18 val_18
    +180 val_180
    +181 val_181
    +183 val_183
    +186 val_186
    +187 val_187
    +189 val_189
    +19 val_19
    +190 val_190
    +191 val_191
    +192 val_192
    +193 val_193
    +194 val_194
    +195 val_195
    +196 val_196
    +197 val_197
    +199 val_199
    +2 val_2
    +20 val_20
    +200 val_200
    +201 val_201
    +202 val_202
    +203 val_203
    +205 val_205
    +207 val_207
    +208 val_208
    +209 val_209
    +213 val_213
    +214 val_214
    +216 val_216
    +217 val_217
    +218 val_218
    +219 val_219
    +221 val_221
    +222 val_222
    +223 val_223
    +224 val_224
    +226 val_226
    +228 val_228
    +229 val_229
    +230 val_230
    +233 val_233
    +235 val_235
    +237 val_237
    +238 val_238
    +239 val_239
    +24 val_24
    +241 val_241
    +242 val_242
    +244 val_244
    +247 val_247
    +248 val_248
    +249 val_249
    +252 val_252
    +255 val_255
    +256 val_256
    +257 val_257
    +258 val_258
    +26 val_26
    +260 val_260
    +262 val_262
    +263 val_263
    +265 val_265
    +266 val_266
    +27 val_27
    +272 val_272
    +273 val_273
    +274 val_274
    +275 val_275
    +277 val_277
    +278 val_278
    +28 val_28
    +280 val_280
    +281 val_281
    +282 val_282
    +283 val_283
    +284 val_284
    +285 val_285
    +286 val_286
    +287 val_287
    +288 val_288
    +289 val_289
    +291 val_291
    +292 val_292
    +296 val_296
    +298 val_298
    +PREHOOK: query: from src a select distinct a.* where a.key = '238'
    +PREHOOK: type: QUERY
    +PREHOOK: Input: default@src
    +#### A masked pattern was here ####
    +POSTHOOK: query: from src a select distinct a.* where a.key = '238'
    +POSTHOOK: type: QUERY
    +POSTHOOK: Input: default@src
    +#### A masked pattern was here ####
    +238 val_238
    +PREHOOK: query: explain
    +SELECT distinct * from (
    +select * from src1
    +union all
    +select * from src )subq
    +PREHOOK: type: QUERY
    +POSTHOOK: query: explain
    +SELECT distinct * from (
    +select * from src1
    +union all
    +select * from src )subq
    +POSTHOOK: type: QUERY
    +STAGE DEPENDENCIES:
    + Stage-1 is a root stage
    + Stage-0 depends on stages: Stage-1
    +
    +STAGE PLANS:
    + Stage: Stage-1
    + Tez
    + Edges:
    + Map 1 <- Union 2 (CONTAINS)
    + Map 4 <- Union 2 (CONTAINS)
    + Reducer 3 <- Union 2 (SIMPLE_EDGE)
    +#### A masked pattern was here ####
    + Vertices:
    + Map 1
    + Map Operator Tree:
    + TableScan
    + alias: src1
    + Select Operator
    + expressions: key (type: string), value (type: string)
    + outputColumnNames: _col0, _col1
    + Group By Operator
    + keys: _col0 (type: string), _col1 (type: string)
    + mode: hash
    + outputColumnNames: _col0, _col1
    + Reduce Output Operator
    + key expressions: _col0 (type: string), _col1 (type: string)
    + sort order: ++
    + Map-reduce partition columns: _col0 (type: string), _col1 (type: string)
    + Map 4
    + Map Operator Tree:
    + TableScan
    + alias: src
    + Select Operator
    + expressions: key (type: string), value (type: string)
    + outputColumnNames: _col0, _col1
    + Group By Operator
    + keys: _col0 (type: string), _col1 (type: string)
    + mode: hash
    + outputColumnNames: _col0, _col1
    + Reduce Output Operator
    + key expressions: _col0 (type: string), _col1 (type: string)
    + sort order: ++
    + Map-reduce partition columns: _col0 (type: string), _col1 (type: string)
    + Reducer 3
    + Reduce Operator Tree:
    + Group By Operator
    + keys: KEY._col0 (type: string), KEY._col1 (type: string)
    + mode: mergepartial
    + outputColumnNames: _col0, _col1
    + Statistics: Num rows: 262 Data size: 2746 Basic stats: COMPLETE Column stats: NONE
    + Select Operator
    + expressions: _col0 (type: string), _col1 (type: string)
    + outputColumnNames: _col0, _col1
    + Statistics: Num rows: 262 Data size: 2746 Basic stats: COMPLETE Column stats: NONE
    + File Output Operator
    + compressed: false
    + Statistics: Num rows: 262 Data size: 2746 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
    + Union 2
    + Vertex: Union 2
    +
    + Stage: Stage-0
    + Fetch Operator
    + limit: -1
    + Processor Tree:
    + ListSink
    +
    +PREHOOK: query: SELECT distinct * from (
    +select * from src1
    +union all
    +select * from src )subq
    +PREHOOK: type: QUERY
    +PREHOOK: Input: default@src
    +PREHOOK: Input: default@src1
    +#### A masked pattern was here ####
    +POSTHOOK: query: SELECT distinct * from (
    +select * from src1
    +union all
    +select * from src )subq
    +POSTHOOK: type: QUERY
    +POSTHOOK: Input: default@src
    +POSTHOOK: Input: default@src1
    +#### A masked pattern was here ####
    +
    + val_165
    + val_193
    + val_265
    + val_27
    + val_409
    + val_484
    +0 val_0
    +10 val_10
    +100 val_100
    +103 val_103
    +104 val_104
    +105 val_105
    +11 val_11
    +111 val_111
    +113 val_113
    +114 val_114
    +116 val_116
    +118 val_118
    +119 val_119
    +12 val_12
    +120 val_120
    +125 val_125
    +126 val_126
    +128
    +128 val_128
    +129 val_129
    +131 val_131
    +133 val_133
    +134 val_134
    +136 val_136
    +137 val_137
    +138 val_138
    +143 val_143
    +145 val_145
    +146 val_146
    +149 val_149
    +15 val_15
    +150 val_150
    +152 val_152
    +153 val_153
    +155 val_155
    +156 val_156
    +157 val_157
    +158 val_158
    +160 val_160
    +162 val_162
    +163 val_163
    +164 val_164
    +165 val_165
    +166 val_166
    +167 val_167
    +168 val_168
    +169 val_169
    +17 val_17
    +170 val_170
    +172 val_172
    +174 val_174
    +175 val_175
    +176 val_176
    +177 val_177
    +178 val_178
    +179 val_179
    +18 val_18
    +180 val_180
    +181 val_181
    +183 val_183
    +186 val_186
    +187 val_187
    +189 val_189
    +19 val_19
    +190 val_190
    +191 val_191
    +192 val_192
    +193 val_193
    +194 val_194
    +195 val_195
    +196 val_196
    +197 val_197
    +199 val_199
    +2 val_2
    +20 val_20
    +200 val_200
    +201 val_201
    +202 val_202
    +203 val_203
    +205 val_205
    +207 val_207
    +208 val_208
    +209 val_209
    +213 val_213
    +214 val_214
    +216 val_216
    +217 val_217
    +218 val_218
    +219 val_219
    +221 val_221
    +222 val_222
    +223 val_223
    +224
    +224 val_224
    +226 val_226
    +228 val_228
    +229 val_229
    +230 val_230
    +233 val_233
    +235 val_235
    +237 val_237
    +238 val_238
    +239 val_239
    +24 val_24
    +241 val_241
    +242 val_242
    +244 val_244
    +247 val_247
    +248 val_248
    +249 val_249
    +252 val_252
    +255 val_255
    +256 val_256
    +257 val_257
    +258 val_258
    +26 val_26
    +260 val_260
    +262 val_262
    +263 val_263
    +265 val_265
    +266 val_266
    +27 val_27
    +272 val_272
    +273 val_273
    +274 val_274
    +275 val_275
    +277 val_277
    +278 val_278
    +28 val_28
    +280 val_280
    +281 val_281
    +282 val_282
    +283 val_283
    +284 val_284
    +285 val_285
    +286 val_286
    +287 val_287
    +288 val_288
    +289 val_289
    +291 val_291
    +292 val_292
    +296 val_296
    +298 val_298
    +30 val_30
    +302 val_302
    +305 val_305
    +306 val_306
    +307 val_307
    +308 val_308
    +309 val_309
    +310 val_310
    +311 val_311
    +315 val_315
    +316 val_316
    +317 val_317
    +318 val_318
    +321 val_321
    +322 val_322
    +323 val_323
    +325 val_325
    +327 val_327
    +33 val_33
    +331 val_331
    +332 val_332
    +333 val_333
    +335 val_335
    +336 val_336
    +338 val_338
    +339 val_339
    +34 val_34
    +341 val_341
    +342 val_342
    +344 val_344
    +345 val_345
    +348 val_348
    +35 val_35
    +351 val_351
    +353 val_353
    +356 val_356
    +360 val_360
    +362 val_362
    +364 val_364
    +365 val_365
    +366 val_366
    +367 val_367
    +368 val_368
    +369
    +369 val_369
    +37 val_37
    +373 val_373
    +374 val_374
    +375 val_375
    +377 val_377
    +378 val_378
    +379 val_379
    +382 val_382
    +384 val_384
    +386 val_386
    +389 val_389
    +392 val_392
    +393 val_393
    +394 val_394
    +395 val_395
    +396 val_396
    +397 val_397
    +399 val_399
    +4 val_4
    +400 val_400
    +401 val_401
    +402 val_402
    +403 val_403
    +404 val_404
    +406 val_406
    +407 val_407
    +409 val_409
    +41 val_41
    +411 val_411
    +413 val_413
    +414 val_414
    +417 val_417
    +418 val_418
    +419 val_419
    +42 val_42
    +421 val_421
    +424 val_424
    +427 val_427
    +429 val_429
    +43 val_43
    +430 val_430
    +431 val_431
    +432 val_432
    +435 val_435
    +436 val_436
    +437 val_437
    +438 val_438
    +439 val_439
    +44 val_44
    +443 val_443
    +444 val_444
    +446 val_446
    +448 val_448
    +449 val_449
    +452 val_452
    +453 val_453
    +454 val_454
    +455 val_455
    +457 val_457
    +458 val_458
    +459 val_459
    +460 val_460
    +462 val_462
    +463 val_463
    +466 val_466
    +467 val_467
    +468 val_468
    +469 val_469
    +47 val_47
    +470 val_470
    +472 val_472
    +475 val_475
    +477 val_477
    +478 val_478
    +479 val_479
    +480 val_480
    +481 val_481
    +482 val_482
    +483 val_483
    +484 val_484
    +485 val_485
    +487 val_487
    +489 val_489
    +490 val_490
    +491 val_491
    +492 val_492
    +493 val_493
    +494 val_494
    +495 val_495
    +496 val_496
    +497 val_497
    +498 val_498
    +5 val_5
    +51 val_51
    +53 val_53
    +54 val_54
    +57 val_57
    +58 val_58
    +64 val_64
    +65 val_65
    +66 val_66
    +67 val_67
    +69 val_69
    +70 val_70
    +72 val_72
    +74 val_74
    +76 val_76
    +77 val_77
    +78 val_78
    +8 val_8
    +80 val_80
    +82 val_82
    +83 val_83
    +84 val_84
    +85 val_85
    +86 val_86
    +87 val_87
    +9 val_9
    +90 val_90
    +92 val_92
    +95 val_95
    +96 val_96
    +97 val_97
    +98 val_98
    +PREHOOK: query: drop view if exists sdi
    +PREHOOK: type: DROPVIEW
    +PREHOOK: Input: default@sdi
    +PREHOOK: Output: default@sdi
    +POSTHOOK: query: drop view if exists sdi
    +POSTHOOK: type: DROPVIEW
    +POSTHOOK: Input: default@sdi
    +POSTHOOK: Output: default@sdi
    +PREHOOK: query: explain create view sdi as select distinct * from src order by key limit 2
    +PREHOOK: type: CREATEVIEW
    +POSTHOOK: query: explain create view sdi as select distinct * from src order by key limit 2
    +POSTHOOK: type: CREATEVIEW
    +STAGE DEPENDENCIES:
    + Stage-0 is a root stage
    +
    +STAGE PLANS:
    + Stage: Stage-0
    + Create View Operator:
    + Create View
    + or replace: false
    + columns: key string, value string
    + expanded text: select distinct `src`.`key`, `src`.`value` from `default`.`src` order by `src`.`key` limit 2
    + name: default.sdi
    + original text: select distinct * from src order by key limit 2
    +
    +PREHOOK: query: create view sdi as select distinct * from src order by key limit 2
    +PREHOOK: type: CREATEVIEW
    +PREHOOK: Input: default@src
    +PREHOOK: Output: database:default
    +PREHOOK: Output: default@sdi
    +POSTHOOK: query: create view sdi as select distinct * from src order by key limit 2
    +POSTHOOK: type: CREATEVIEW
    +POSTHOOK: Input: default@src
    +POSTHOOK: Output: database:default
    +POSTHOOK: Output: default@sdi
    +PREHOOK: query: describe extended sdi
    +PREHOOK: type: DESCTABLE
    +PREHOOK: Input: default@sdi
    +POSTHOOK: query: describe extended sdi
    +POSTHOOK: type: DESCTABLE
    +POSTHOOK: Input: default@sdi
    +key string
    +value string
    +
    +#### A masked pattern was here ####
    +PREHOOK: query: describe formatted sdi
    +PREHOOK: type: DESCTABLE
    +PREHOOK: Input: default@sdi
    +POSTHOOK: query: describe formatted sdi
    +POSTHOOK: type: DESCTABLE
    +POSTHOOK: Input: default@sdi
    +# col_name data_type comment
    +
    +key string
    +value string
    +
    +# Detailed Table Information
    +Database: default
    +#### A masked pattern was here ####
    +Protect Mode: None
    +Retention: 0
    +Table Type: VIRTUAL_VIEW
    +Table Parameters:
    +#### A masked pattern was here ####
    +
    +# Storage Information
    +SerDe Library: null
    +InputFormat: org.apache.hadoop.mapred.SequenceFileInputFormat
    +OutputFormat: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
    +Compressed: No
    +Num Buckets: -1
    +Bucket Columns: []
    +Sort Columns: []
    +
    +# View Information
    +View Original Text: select distinct * from src order by key limit 2
    +View Expanded Text: select distinct `src`.`key`, `src`.`value` from `default`.`src` order by `src`.`key` limit 2
    +PREHOOK: query: select * from sdi
    +PREHOOK: type: QUERY
    +PREHOOK: Input: default@sdi
    +PREHOOK: Input: default@src
    +#### A masked pattern was here ####
    +POSTHOOK: query: select * from sdi
    +POSTHOOK: type: QUERY
    +POSTHOOK: Input: default@sdi
    +POSTHOOK: Input: default@src
    +#### A masked pattern was here ####
    +0 val_0
    +10 val_10
    +PREHOOK: query: select distinct * from src union all select distinct * from src1
    +PREHOOK: type: QUERY
    +PREHOOK: Input: default@src
    +PREHOOK: Input: default@src1
    +#### A masked pattern was here ####
    +POSTHOOK: query: select distinct * from src union all select distinct * from src1
    +POSTHOOK: type: QUERY
    +POSTHOOK: Input: default@src
    +POSTHOOK: Input: default@src1
    +#### A masked pattern was here ####
    +0 val_0
    +10 val_10
    +100 val_100
    +103 val_103
    +104 val_104
    +105 val_105
    +11 val_11
    +111 val_111
    +113 val_113
    +114 val_114
    +116 val_116
    +118 val_118
    +119 val_119
    +12 val_12
    +120 val_120
    +125 val_125
    +126 val_126
    +128 val_128
    +129 val_129
    +131 val_131
    +133 val_133
    +134 val_134
    +136 val_136
    +137 val_137
    +138 val_138
    +143 val_143
    +145 val_145
    +146 val_146
    +149 val_149
    +15 val_15
    +150 val_150
    +152 val_152
    +153 val_153
    +155 val_155
    +156 val_156
    +157 val_157
    +158 val_158
    +160 val_160
    +162 val_162
    +163 val_163
    +164 val_164
    +165 val_165
    +166 val_166
    +167 val_167
    +168 val_168
    +169 val_169
    +17 val_17
    +170 val_170
    +172 val_172
    +174 val_174
    +175 val_175
    +176 val_176
    +177 val_177
    +178 val_178
    +179 val_179
    +18 val_18
    +180 val_180
    +181 val_181
    +183 val_183
    +186 val_186
    +187 val_187
    +189 val_189
    +19 val_19
    +190 val_190
    +191 val_191
    +192 val_192
    +193 val_193
    +194 val_194
    +195 val_195
    +196 val_196
    +197 val_197
    +199 val_199
    +2 val_2
    +20 val_20
    +200 val_200
    +201 val_201
    +202 val_202
    +203 val_203
    +205 val_205
    +207 val_207
    +208 val_208
    +209 val_209
    +213 val_213
    +214 val_214
    +216 val_216
    +217 val_217
    +218 val_218
    +219 val_219
    +221 val_221
    +222 val_222
    +223 val_223
    +224 val_224
    +226 val_226
    +228 val_228
    +229 val_229
    +230 val_230
    +233 val_233
    +235 val_235
    +237 val_237
    +238 val_238
    +239 val_239
    +24 val_24
    +241 val_241
    +242 val_242
    +244 val_244
    +247 val_247
    +248 val_248
    +249 val_249
    +252 val_252
    +255 val_255
    +256 val_256
    +257 val_257
    +258 val_258
    +26 val_26
    +260 val_260
    +262 val_262
    +263 val_263
    +265 val_265
    +266 val_266
    +27 val_27
    +272 val_272
    +273 val_273
    +274 val_274
    +275 val_275
    +277 val_277
    +278 val_278
    +28 val_28
    +280 val_280
    +281 val_281
    +282 val_282
    +283 val_283
    +284 val_284
    +285 val_285
    +286 val_286
    +287 val_287
    +288 val_288
    +289 val_289
    +291 val_291
    +292 val_292
    +296 val_296
    +298 val_298
    +30 val_30
    +302 val_302
    +305 val_305
    +306 val_306
    +307 val_307
    +308 val_308
    +309 val_309
    +310 val_310
    +311 val_311
    +315 val_315
    +316 val_316
    +317 val_317
    +318 val_318
    +321 val_321
    +322 val_322
    +323 val_323
    +325 val_325
    +327 val_327
    +33 val_33
    +331 val_331
    +332 val_332
    +333 val_333
    +335 val_335
    +336 val_336
    +338 val_338
    +339 val_339
    +34 val_34
    +341 val_341
    +342 val_342
    +344 val_344
    +345 val_345
    +348 val_348
    +35 val_35
    +351 val_351
    +353 val_353
    +356 val_356
    +360 val_360
    +362 val_362
    +364 val_364
    +365 val_365
    +366 val_366
    +367 val_367
    +368 val_368
    +369 val_369
    +37 val_37
    +373 val_373
    +374 val_374
    +375 val_375
    +377 val_377
    +378 val_378
    +379 val_379
    +382 val_382
    +384 val_384
    +386 val_386
    +389 val_389
    +392 val_392
    +393 val_393
    +394 val_394
    +395 val_395
    +396 val_396
    +397 val_397
    +399 val_399
    +4 val_4
    +400 val_400
    +401 val_401
    +402 val_402
    +403 val_403
    +404 val_404
    +406 val_406
    +407 val_407
    +409 val_409
    +41 val_41
    +411 val_411
    +413 val_413
    +414 val_414
    +417 val_417
    +418 val_418
    +419 val_419
    +42 val_42
    +421 val_421
    +424 val_424
    +427 val_427
    +429 val_429
    +43 val_43
    +430 val_430
    +431 val_431
    +432 val_432
    +435 val_435
    +436 val_436
    +437 val_437
    +438 val_438
    +439 val_439
    +44 val_44
    +443 val_443
    +444 val_444
    +446 val_446
    +448 val_448
    +449 val_449
    +452 val_452
    +453 val_453
    +454 val_454
    +455 val_455
    +457 val_457
    +458 val_458
    +459 val_459
    +460 val_460
    +462 val_462
    +463 val_463
    +466 val_466
    +467 val_467
    +468 val_468
    +469 val_469
    +47 val_47
    +470 val_470
    +472 val_472
    +475 val_475
    +477 val_477
    +478 val_478
    +479 val_479
    +480 val_480
    +481 val_481
    +482 val_482
    +483 val_483
    +484 val_484
    +485 val_485
    +487 val_487
    +489 val_489
    +490 val_490
    +491 val_491
    +492 val_492
    +493 val_493
    +494 val_494
    +495 val_495
    +496 val_496
    +497 val_497
    +498 val_498
    +5 val_5
    +51 val_51
    +53 val_53
    +54 val_54
    +57 val_57
    +58 val_58
    +64 val_64
    +65 val_65
    +66 val_66
    +67 val_67
    +69 val_69
    +70 val_70
    +72 val_72
    +74 val_74
    +76 val_76
    +77 val_77
    +78 val_78
    +8 val_8
    +80 val_80
    +82 val_82
    +83 val_83
    +84 val_84
    +85 val_85
    +86 val_86
    +87 val_87
    +9 val_9
    +90 val_90
    +92 val_92
    +95 val_95
    +96 val_96
    +97 val_97
    +98 val_98
    +
    + val_165
    + val_193
    + val_265
    + val_27
    + val_409
    + val_484
    +128
    +146 val_146
    +150 val_150
    +213 val_213
    +224
    +238 val_238
    +255 val_255
    +273 val_273
    +278 val_278
    +311 val_311
    +369
    +401 val_401
    +406 val_406
    +66 val_66
    +98 val_98
    +PREHOOK: query: select distinct * from src join src1 on src.key=src1.key
    +PREHOOK: type: QUERY
    +PREHOOK: Input: default@src
    +PREHOOK: Input: default@src1
    +#### A masked pattern was here ####
    +POSTHOOK: query: select distinct * from src join src1 on src.key=src1.key
    +POSTHOOK: type: QUERY
    +POSTHOOK: Input: default@src
    +POSTHOOK: Input: default@src1
    +#### A masked pattern was here ####
    +128 128 val_128
    +146 val_146 146 val_146
    +150 val_150 150 val_150
    +213 val_213 213 val_213
    +224 224 val_224
    +238 val_238 238 val_238
    +255 val_255 255 val_255
    +273 val_273 273 val_273
    +278 val_278 278 val_278
    +311 val_311 311 val_311
    +369 369 val_369
    +401 val_401 401 val_401
    +406 val_406 406 val_406
    +66 val_66 66 val_66
    +98 val_98 98 val_98
    +PREHOOK: query: SELECT distinct *
    +FROM src1 x JOIN src y ON (x.key = y.key)
    +JOIN srcpart z ON (x.value = z.value and z.ds='2008-04-08' and z.hr=11)
    +PREHOOK: type: QUERY
    +PREHOOK: Input: default@src
    +PREHOOK: Input: default@src1
    +PREHOOK: Input: default@srcpart
    +PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
    +#### A masked pattern was here ####
    +POSTHOOK: query: SELECT distinct *
    +FROM src1 x JOIN src y ON (x.key = y.key)
    +JOIN srcpart z ON (x.value = z.value and z.ds='2008-04-08' and z.hr=11)
    +POSTHOOK: type: QUERY
    +POSTHOOK: Input: default@src
    +POSTHOOK: Input: default@src1
    +POSTHOOK: Input: default@srcpart
    +POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
    +#### A masked pattern was here ####
    +146 val_146 2008-04-08 11 146 val_146 146 val_146
    +150 val_150 2008-04-08 11 150 val_150 150 val_150
    +213 val_213 2008-04-08 11 213 val_213 213 val_213
    +238 val_238 2008-04-08 11 238 val_238 238 val_238
    +255 val_255 2008-04-08 11 255 val_255 255 val_255
    +273 val_273 2008-04-08 11 273 val_273 273 val_273
    +278 val_278 2008-04-08 11 278 val_278 278 val_278
    +311 val_311 2008-04-08 11 311 val_311 311 val_311
    +401 val_401 2008-04-08 11 401 val_401 401 val_401
    +406 val_406 2008-04-08 11 406 val_406 406 val_406
    +66 val_66 2008-04-08 11 66 val_66 66 val_66
    +98 val_98 2008-04-08 11 98 val_98 98 val_98
    +PREHOOK: query: select * from (select distinct * from src)src1
    +join
    +(select distinct * from src)src2
    +on src1.key=src2.key
    +PREHOOK: type: QUERY
    +PREHOOK: Input: default@src
    +#### A masked pattern was here ####
    +POSTHOOK: query: select * from (select distinct * from src)src1
    +join
    +(select distinct * from src)src2
    +on src1.key=src2.key
    +POSTHOOK: type: QUERY
    +POSTHOOK: Input: default@src
    +#### A masked pattern was here ####
    +0 val_0 0 val_0
    +10 val_10 10 val_10
    +100 val_100 100 val_100
    +103 val_103 103 val_103
    +104 val_104 104 val_104
    +105 val_105 105 val_105
    +11 val_11 11 val_11
    +111 val_111 111 val_111
    +113 val_113 113 val_113
    +114 val_114 114 val_114
    +116 val_116 116 val_116
    +118 val_118 118 val_118
    +119 val_119 119 val_119
    +12 val_12 12 val_12
    +120 val_120 120 val_120
    +125 val_125 125 val_125
    +126 val_126 126 val_126
    +128 val_128 128 val_128
    +129 val_129 129 val_129
    +131 val_131 131 val_131
    +133 val_133 133 val_133
    +134 val_134 134 val_134
    +136 val_136 136 val_136
    +137 val_137 137 val_137
    +138 val_138 138 val_138
    +143 val_143 143 val_143
    +145 val_145 145 val_145
    +146 val_146 146 val_146
    +149 val_149 149 val_149
    +15 val_15 15 val_15
    +150 val_150 150 val_150
    +152 val_152 152 val_152
    +153 val_153 153 val_153
    +155 val_155 155 val_155
    +156 val_156 156 val_156
    +157 val_157 157 val_157
    +158 val_158 158 val_158
    +160 val_160 160 val_160
    +162 val_162 162 val_162
    +163 val_163 163 val_163
    +164 val_164 164 val_164
    +165 val_165 165 val_165
    +166 val_166 166 val_166
    +167 val_167 167 val_167
    +168 val_168 168 val_168
    +169 val_169 169 val_169
    +17 val_17 17 val_17
    +170 val_170 170 val_170
    +172 val_172 172 val_172
    +174 val_174 174 val_174
    +175 val_175 175 val_175
    +176 val_176 176 val_176
    +177 val_177 177 val_177
    +178 val_178 178 val_178
    +179 val_179 179 val_179
    +18 val_18 18 val_18
    +180 val_180 180 val_180
    +181 val_181 181 val_181
    +183 val_183 183 val_183
    +186 val_186 186 val_186
    +187 val_187 187 val_187
    +189 val_189 189 val_189
    +19 val_19 19 val_19
    +190 val_190 190 val_190
    +191 val_191 191 val_191
    +192 val_192 192 val_192
    +193 val_193 193 val_193
    +194 val_194 194 val_194
    +195 val_195 195 val_195
    +196 val_196 196 val_196
    +197 val_197 197 val_197
    +199 val_199 199 val_199
    +2 val_2 2 val_2
    +20 val_20 20 val_20
    +200 val_200 200 val_200
    +201 val_201 201 val_201
    +202 val_202 202 val_202
    +203 val_203 203 val_203
    +205 val_205 205 val_205
    +207 val_207 207 val_207
    +208 val_208 208 val_208
    +209 val_209 209 val_209
    +213 val_213 213 val_213
    +214 val_214 214 val_214
    +216 val_216 216 val_216
    +217 val_217 217 val_217
    +218 val_218 218 val_218
    +219 val_219 219 val_219
    +221 val_221 221 val_221
    +222 val_222 222 val_222
    +223 val_223 223 val_223
    +224 val_224 224 val_224
    +226 val_226 226 val_226
    +228 val_228 228 val_228
    +229 val_229 229 val_229
    +230 val_230 230 val_230
    +233 val_233 233 val_233
    +235 val_235 235 val_235
    +237 val_237 237 val_237
    +238 val_238 238 val_238
    +239 val_239 239 val_239
    +24 val_24 24 val_24
    +241 val_241 241 val_241
    +242 val_242 242 val_242
    +244 val_244 244 val_244
    +247 val_247 247 val_247
    +248 val_248 248 val_248
    +249 val_249 249 val_249
    +252 val_252 252 val_252
    +255 val_255 255 val_255
    +256 val_256 256 val_256
    +257 val_257 257 val_257
    +258 val_258 258 val_258
    +26 val_26 26 val_26
    +260 val_260 260 val_260
    +262 val_262 262 val_262
    +263 val_263 263 val_263
    +265 val_265 265 val_265
    +266 val_266 266 val_266
    +27 val_27 27 val_27
    +272 val_272 272 val_272
    +273 val_273 273 val_273
    +274 val_274 274 val_274
    +275 val_275 275 val_275
    +277 val_277 277 val_277
    +278 val_278 278 val_278
    +28 val_28 28 val_28
    +280 val_280 280 val_280
    +281 val_281 281 val_281
    +282 val_282 282 val_282
    +283 val_283 283 val_283
    +284 val_284 284 val_284
    +285 val_285 285 val_285
    +286 val_286 286 val_286
    +287 val_287 287 val_287
    +288 val_288 288 val_288
    +289 val_289 289 val_289
    +291 val_291 291 val_291
    +292 val_292 292 val_292
    +296 val_296 296 val_296
    +298 val_298 298 val_298
    +30 val_30 30 val_30
    +302 val_302 302 val_302
    +305 val_305 305 val_305
    +306 val_306 306 val_306
    +307 val_307 307 val_307
    +308 val_308 308 val_308
    +309 val_309 309 val_309
    +310 val_310 310 val_310
    +311 val_311 311 val_311
    +315 val_315 315 val_315
    +316 val_316 316 val_316
    +317 val_317 317 val_317
    +318 val_318 318 val_318
    +321 val_321 321 val_321
    +322 val_322 322 val_322
    +323 val_323 323 val_323
    +325 val_325 325 val_325
    +327 val_327 327 val_327
    +33 val_33 33 val_33
    +331 val_331 331 val_331
    +332 val_332 332 val_332
    +333 val_333 333 val_333
    +335 val_335 335 val_335
    +336 val_336 336 val_336
    +338 val_338 338 val_338
    +339 val_339 339 val_339
    +34 val_34 34 val_34
    +341 val_341 341 val_341
    +342 val_342 342 val_342
    +344 val_344 344 val_344
    +345 val_345 345 val_345
    +348 val_348 348 val_348
    +35 val_35 35 val_35
    +351 val_351 351 val_351
    +353 val_353 353 val_353
    +356 val_356 356 val_356
    +360 val_360 360 val_360
    +362 val_362 362 val_362
    +364 val_364 364 val_364
    +365 val_365 365 val_365
    +366 val_366 366 val_366
    +367 val_367 367 val_367
    +368 val_368 368 val_368
    +369 val_369 369 val_369
    +37 val_37 37 val_37
    +373 val_373 373 val_373
    +374 val_374 374 val_374
    +375 val_375 375 val_375
    +377 val_377 377 val_377
    +378 val_378 378 val_378
    +379 val_379 379 val_379
    +382 val_382 382 val_382
    +384 val_384 384 val_384
    +386 val_386 386 val_386
    +389 val_389 389 val_389
    +392 val_392 392 val_392
    +393 val_393 393 val_393
    +394 val_394 394 val_394
    +395 val_395 395 val_395
    +396 val_396 396 val_396
    +397 val_397 397 val_397
    +399 val_399 399 val_399
    +4 val_4 4 val_4
    +400 val_400 400 val_400
    +401 val_401 401 val_401
    +402 val_402 402 val_402
    +403 val_403 403 val_403
    +404 val_404 404 val_404
    +406 val_406 406 val_406
    +407 val_407 407 val_407
    +409 val_409 409 val_409
    +41 val_41 41 val_41
    +411 val_411 411 val_411
    +413 val_413 413 val_413
    +414 val_414 414 val_414
    +417 val_417 417 val_417
    +418 val_418 418 val_418
    +419 val_419 419 val_419
    +42 val_42 42 val_42
    +421 val_421 421 val_421
    +424 val_424 424 val_424
    +427 val_427 427 val_427
    +429 val_429 429 val_429
    +43 val_43 43 val_43
    +430 val_430 430 val_430
    +431 val_431 431 val_431
    +432 val_432 432 val_432
    +435 val_435 435 val_435
    +436 val_436 436 val_436
    +437 val_437 437 val_437
    +438 val_438 438 val_438
    +439 val_439 439 val_439
    +44 val_44 44 val_44
    +443 val_443 443 val_443
    +444 val_444 444 val_444
    +446 val_446 446 val_446
    +448 val_448 448 val_448
    +449 val_449 449 val_449
    +452 val_452 452 val_452
    +453 val_453 453 val_453
    +454 val_454 454 val_454
    +455 val_455 455 val_455
    +457 val_457 457 val_457
    +458 val_458 458 val_458
    +459 val_459 459 val_459
    +460 val_460 460 val_460
    +462 val_462 462 val_462
    +463 val_463 463 val_463
    +466 val_466 466 val_466
    +467 val_467 467 val_467
    +468 val_468 468 val_468
    +469 val_469 469 val_469
    +47 val_47 47 val_47
    +470 val_470 470 val_470
    +472 val_472 472 val_472
    +475 val_475 475 val_475
    +477 val_477 477 val_477
    +478 val_478 478 val_478
    +479 val_479 479 val_479
    +480 val_480 480 val_480
    +481 val_481 481 val_481
    +482 val_482 482 val_482
    +483 val_483 483 val_483
    +484 val_484 484 val_484
    +485 val_485 485 val_485
    +487 val_487 487 val_487
    +489 val_489 489 val_489
    +490 val_490 490 val_490
    +491 val_491 491 val_491
    +492 val_492 492 val_492
    +493 val_493 493 val_493
    +494 val_494 494 val_494
    +495 val_495 495 val_495
    +496 val_496 496 val_496
    +497 val_497 497 val_497
    +498 val_498 498 val_498
    +5 val_5 5 val_5
    +51 val_51 51 val_51
    +53 val_53 53 val_53
    +54 val_54 54 val_54
    +57 val_57 57 val_57
    +58 val_58 58 val_58
    +64 val_64 64 val_64
    +65 val_65 65 val_65
    +66 val_66 66 val_66
    +67 val_67 67 val_67
    +69 val_69 69 val_69
    +70 val_70 70 val_70
    +72 val_72 72 val_72
    +74 val_74 74 val_74
    +76 val_76 76 val_76
    +77 val_77 77 val_77
    +78 val_78 78 val_78
    +8 val_8 8 val_8
    +80 val_80 80 val_80
    +82 val_82 82 val_82
    +83 val_83 83 val_83
    +84 val_84 84 val_84
    +85 val_85 85 val_85
    +86 val_86 86 val_86
    +87 val_87 87 val_87
    +9 val_9 9 val_9
    +90 val_90 90 val_90
    +92 val_92 92 val_92
    +95 val_95 95 val_95
    +96 val_96 96 val_96
    +97 val_97 97 val_97
    +98 val_98 98 val_98
    +PREHOOK: query: select distinct * from (select distinct * from src)src1
    +PREHOOK: type: QUERY
    +PREHOOK: Input: default@src
    +#### A masked pattern was here ####
    +POSTHOOK: query: select distinct * from (select distinct * from src)src1
    +POSTHOOK: type: QUERY
    +POSTHOOK: Input: default@src
    +#### A masked pattern was here ####
    +0 val_0
    +10 val_10
    +100 val_100
    +103 val_103
    +104 val_104
    +105 val_105
    +11 val_11
    +111 val_111
    +113 val_113
    +114 val_114
    +116 val_116
    +118 val_118
    +119 val_119
    +12 val_12
    +120 val_120
    +125 val_125
    +126 val_126
    +128 val_128
    +129 val_129
    +131 val_131
    +133 val_133
    +134 val_134
    +136 val_136
    +137 val_137
    +138 val_138
    +143 val_143
    +145 val_145
    +146 val_146
    +149 val_149
    +15 val_15
    +150 val_150
    +152 val_152
    +153 val_153
    +155 val_155
    +156 val_156
    +157 val_157
    +158 val_158
    +160 val_160
    +162 val_162
    +163 val_163
    +164 val_164
    +165 val_165
    +166 val_166
    +167 val_167
    +168 val_168
    +169 val_169
    +17 val_17
    +170 val_170
    +172 val_172
    +174 val_174
    +175 val_175
    +176 val_176
    +177 val_177
    +178 val_178
    +179 val_179
    +18 val_18
    +180 val_180
    +181 val_181
    +183 val_183
    +186 val_186
    +187 val_187
    +189 val_189
    +19 val_19
    +190 val_190
    +191 val_191
    +192 val_192
    +193 val_193
    +194 val_194
    +195 val_195
    +196 val_196
    +197 val_197
    +199 val_199
    +2 val_2
    +20 val_20
    +200 val_200
    +201 val_201
    +202 val_202
    +203 val_203
    +205 val_205
    +207 val_207
    +208 val_208
    +209 val_209

    [... 228 lines stripped ...]

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupcommits @
categorieshive, hadoop
postedJan 15, '15 at 10:15p
activeJan 15, '15 at 10:15p
posts3
users1
websitehive.apache.org

1 user in discussion

Jpullokk: 3 posts

People

Translate

site design / logo © 2021 Grokbase