You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by at...@apache.org on 2009/04/09 20:05:53 UTC
svn commit: r763755 - in /hadoop/hive/trunk: ./
ql/src/test/queries/clientpositive/ ql/src/test/results/clientpositive/
Author: athusoo
Date: Thu Apr 9 18:05:53 2009
New Revision: 763755
URL: http://svn.apache.org/viewvc?rev=763755&view=rev
Log:
HIVE-390. Make partition pruner tests deterministic by ordering the
output results. (Namit Jain via athusoo)
Modified:
hadoop/hive/trunk/CHANGES.txt
hadoop/hive/trunk/ql/src/test/queries/clientpositive/input_part5.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/rand_partitionpruner2.q
hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part5.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/rand_partitionpruner2.q.out
Modified: hadoop/hive/trunk/CHANGES.txt
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/CHANGES.txt?rev=763755&r1=763754&r2=763755&view=diff
==============================================================================
--- hadoop/hive/trunk/CHANGES.txt (original)
+++ hadoop/hive/trunk/CHANGES.txt Thu Apr 9 18:05:53 2009
@@ -143,8 +143,17 @@
HIVE-394. Break plans in Cluster Mode. (Namit Jain via zshao)
+ HIVE-399. Fix timeout problems caused due to the bigdata test.
+ (Namit Jain via athusoo)
+
+ HIVE-397. Make union tests deterministic by ordering the
+ output results. (Namit Jain via athusoo)
+
HIVE-400. Fix bug in genColList. (Namit Jain via zshao)
+ HIVE-390. Make partition pruner tests deterministic by ordering the
+ output results. (Namit Jain via athusoo)
+
Release 0.2.0 - Unreleased
INCOMPATIBLE CHANGES
@@ -452,9 +461,3 @@
HIVE-283. Do case insensitive comparison of aliases in partition
pruning. (athusoo)
-
- HIVE-399. Fix timeout problems caused due to the bigdata test.
- (Namit Jain via athusoo)
-
- HIVE-397. Make union tests deterministic by ordering the
- output results. (Namit Jain via athusoo)
Modified: hadoop/hive/trunk/ql/src/test/queries/clientpositive/input_part5.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/input_part5.q?rev=763755&r1=763754&r2=763755&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/input_part5.q (original)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/input_part5.q Thu Apr 9 18:05:53 2009
@@ -1,4 +1,12 @@
+drop table tmptable;
+create table tmptable(key string, value string, hr string, ds string);
+
EXPLAIN
+insert overwrite table tmptable
SELECT x.* FROM SRCPART x WHERE x.ds = '2008-04-08' and x.key < 100;
+insert overwrite table tmptable
SELECT x.* FROM SRCPART x WHERE x.ds = '2008-04-08' and x.key < 100;
+
+select * from tmptable x sort by x.key;
+drop table tmptable;
Modified: hadoop/hive/trunk/ql/src/test/queries/clientpositive/rand_partitionpruner2.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/rand_partitionpruner2.q?rev=763755&r1=763754&r2=763755&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/rand_partitionpruner2.q (original)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/rand_partitionpruner2.q Thu Apr 9 18:05:53 2009
@@ -1,3 +1,14 @@
-- scanning partitioned data
-explain extended select a.* from srcpart a where rand(1) < 0.1 and a.ds = '2008-04-08';
+drop table tmptable;
+create table tmptable(key string, value string, hr string, ds string);
+
+explain extended
+insert overwrite table tmptable
select a.* from srcpart a where rand(1) < 0.1 and a.ds = '2008-04-08';
+
+
+insert overwrite table tmptable
+select a.* from srcpart a where rand(1) < 0.1 and a.ds = '2008-04-08';
+
+select * from tmptable x sort by x.key;
+drop table tmptable;
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part5.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part5.q.out?rev=763755&r1=763754&r2=763755&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part5.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part5.q.out Thu Apr 9 18:05:53 2009
@@ -1,9 +1,9 @@
ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_TABREF SRCPART x)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF x))) (TOK_WHERE (and (= (TOK_COLREF x ds) '2008-04-08') (< (TOK_COLREF x key) 100)))))
+ (TOK_QUERY (TOK_FROM (TOK_TABREF SRCPART x)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB tmptable)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF x))) (TOK_WHERE (and (= (TOK_COLREF x ds) '2008-04-08') (< (TOK_COLREF x key) 100)))))
STAGE DEPENDENCIES:
Stage-1 is a root stage
- Stage-0 is a root stage
+ Stage-0 depends on stages: Stage-1
STAGE PLANS:
Stage: Stage-1
@@ -26,181 +26,189 @@
type: string
File Output Operator
compressed: false
- GlobalTableId: 0
+ GlobalTableId: 1
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: tmptable
Stage: Stage-0
- Fetch Operator
- limit: -1
+ Move Operator
+ tables:
+ replace: true
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: tmptable
-86 val_86 2008-04-08 11
-27 val_27 2008-04-08 11
-98 val_98 2008-04-08 11
-66 val_66 2008-04-08 11
-37 val_37 2008-04-08 11
-15 val_15 2008-04-08 11
-82 val_82 2008-04-08 11
-17 val_17 2008-04-08 11
0 val_0 2008-04-08 11
-57 val_57 2008-04-08 11
-20 val_20 2008-04-08 11
-92 val_92 2008-04-08 11
-47 val_47 2008-04-08 11
-72 val_72 2008-04-08 11
-4 val_4 2008-04-08 11
-35 val_35 2008-04-08 11
-54 val_54 2008-04-08 11
-51 val_51 2008-04-08 11
-65 val_65 2008-04-08 11
-83 val_83 2008-04-08 11
-12 val_12 2008-04-08 11
-67 val_67 2008-04-08 11
-84 val_84 2008-04-08 11
-58 val_58 2008-04-08 11
-8 val_8 2008-04-08 11
-24 val_24 2008-04-08 11
-42 val_42 2008-04-08 11
0 val_0 2008-04-08 11
-96 val_96 2008-04-08 11
-26 val_26 2008-04-08 11
-51 val_51 2008-04-08 11
-43 val_43 2008-04-08 11
-95 val_95 2008-04-08 11
-98 val_98 2008-04-08 11
-85 val_85 2008-04-08 11
-77 val_77 2008-04-08 11
0 val_0 2008-04-08 11
-87 val_87 2008-04-08 11
-15 val_15 2008-04-08 11
-72 val_72 2008-04-08 11
-90 val_90 2008-04-08 11
-19 val_19 2008-04-08 11
+0 val_0 2008-04-08 12
+0 val_0 2008-04-08 12
+0 val_0 2008-04-08 12
+10 val_10 2008-04-08 12
10 val_10 2008-04-08 11
-5 val_5 2008-04-08 11
-58 val_58 2008-04-08 11
-35 val_35 2008-04-08 11
-95 val_95 2008-04-08 11
11 val_11 2008-04-08 11
-34 val_34 2008-04-08 11
-42 val_42 2008-04-08 11
-78 val_78 2008-04-08 11
-76 val_76 2008-04-08 11
-41 val_41 2008-04-08 11
-30 val_30 2008-04-08 11
-64 val_64 2008-04-08 11
-76 val_76 2008-04-08 11
-74 val_74 2008-04-08 11
-69 val_69 2008-04-08 11
-33 val_33 2008-04-08 11
-70 val_70 2008-04-08 11
-5 val_5 2008-04-08 11
-2 val_2 2008-04-08 11
-35 val_35 2008-04-08 11
-80 val_80 2008-04-08 11
-44 val_44 2008-04-08 11
-53 val_53 2008-04-08 11
-90 val_90 2008-04-08 11
+11 val_11 2008-04-08 12
+12 val_12 2008-04-08 12
+12 val_12 2008-04-08 12
12 val_12 2008-04-08 11
-5 val_5 2008-04-08 11
-70 val_70 2008-04-08 11
-24 val_24 2008-04-08 11
-70 val_70 2008-04-08 11
-83 val_83 2008-04-08 11
-26 val_26 2008-04-08 11
-67 val_67 2008-04-08 11
+12 val_12 2008-04-08 11
+15 val_15 2008-04-08 11
+15 val_15 2008-04-08 11
+15 val_15 2008-04-08 12
+15 val_15 2008-04-08 12
+17 val_17 2008-04-08 12
+17 val_17 2008-04-08 11
18 val_18 2008-04-08 11
-9 val_9 2008-04-08 11
18 val_18 2008-04-08 11
-97 val_97 2008-04-08 11
-84 val_84 2008-04-08 11
+18 val_18 2008-04-08 12
+18 val_18 2008-04-08 12
+19 val_19 2008-04-08 12
+19 val_19 2008-04-08 11
+2 val_2 2008-04-08 11
+2 val_2 2008-04-08 12
+20 val_20 2008-04-08 12
+20 val_20 2008-04-08 11
+24 val_24 2008-04-08 11
+24 val_24 2008-04-08 11
+24 val_24 2008-04-08 12
+24 val_24 2008-04-08 12
+26 val_26 2008-04-08 12
+26 val_26 2008-04-08 12
+26 val_26 2008-04-08 11
+26 val_26 2008-04-08 11
+27 val_27 2008-04-08 11
+27 val_27 2008-04-08 12
+28 val_28 2008-04-08 12
28 val_28 2008-04-08 11
+30 val_30 2008-04-08 11
+30 val_30 2008-04-08 12
+33 val_33 2008-04-08 12
+33 val_33 2008-04-08 11
+34 val_34 2008-04-08 11
+34 val_34 2008-04-08 12
+35 val_35 2008-04-08 12
+35 val_35 2008-04-08 12
+35 val_35 2008-04-08 12
+35 val_35 2008-04-08 11
+35 val_35 2008-04-08 11
+35 val_35 2008-04-08 11
+37 val_37 2008-04-08 11
37 val_37 2008-04-08 11
-90 val_90 2008-04-08 11
-97 val_97 2008-04-08 11
-86 val_86 2008-04-08 12
-27 val_27 2008-04-08 12
-98 val_98 2008-04-08 12
-66 val_66 2008-04-08 12
37 val_37 2008-04-08 12
-15 val_15 2008-04-08 12
-82 val_82 2008-04-08 12
-17 val_17 2008-04-08 12
-0 val_0 2008-04-08 12
-57 val_57 2008-04-08 12
-20 val_20 2008-04-08 12
-92 val_92 2008-04-08 12
-47 val_47 2008-04-08 12
-72 val_72 2008-04-08 12
+37 val_37 2008-04-08 12
4 val_4 2008-04-08 12
-35 val_35 2008-04-08 12
-54 val_54 2008-04-08 12
-51 val_51 2008-04-08 12
-65 val_65 2008-04-08 12
-83 val_83 2008-04-08 12
-12 val_12 2008-04-08 12
-67 val_67 2008-04-08 12
-84 val_84 2008-04-08 12
-58 val_58 2008-04-08 12
-8 val_8 2008-04-08 12
-24 val_24 2008-04-08 12
+4 val_4 2008-04-08 11
+41 val_41 2008-04-08 11
+41 val_41 2008-04-08 12
42 val_42 2008-04-08 12
-0 val_0 2008-04-08 12
-96 val_96 2008-04-08 12
-26 val_26 2008-04-08 12
-51 val_51 2008-04-08 12
+42 val_42 2008-04-08 12
+42 val_42 2008-04-08 11
+42 val_42 2008-04-08 11
+43 val_43 2008-04-08 11
43 val_43 2008-04-08 12
-95 val_95 2008-04-08 12
-98 val_98 2008-04-08 12
-85 val_85 2008-04-08 12
-77 val_77 2008-04-08 12
-0 val_0 2008-04-08 12
-87 val_87 2008-04-08 12
-15 val_15 2008-04-08 12
-72 val_72 2008-04-08 12
-90 val_90 2008-04-08 12
-19 val_19 2008-04-08 12
-10 val_10 2008-04-08 12
+44 val_44 2008-04-08 12
+44 val_44 2008-04-08 11
+47 val_47 2008-04-08 11
+47 val_47 2008-04-08 12
+5 val_5 2008-04-08 12
+5 val_5 2008-04-08 12
5 val_5 2008-04-08 12
+5 val_5 2008-04-08 11
+5 val_5 2008-04-08 11
+5 val_5 2008-04-08 11
+51 val_51 2008-04-08 11
+51 val_51 2008-04-08 11
+51 val_51 2008-04-08 12
+51 val_51 2008-04-08 12
+53 val_53 2008-04-08 12
+53 val_53 2008-04-08 11
+54 val_54 2008-04-08 11
+54 val_54 2008-04-08 12
+57 val_57 2008-04-08 12
+57 val_57 2008-04-08 11
+58 val_58 2008-04-08 11
+58 val_58 2008-04-08 11
+58 val_58 2008-04-08 12
58 val_58 2008-04-08 12
-35 val_35 2008-04-08 12
-95 val_95 2008-04-08 12
-11 val_11 2008-04-08 12
-34 val_34 2008-04-08 12
-42 val_42 2008-04-08 12
-78 val_78 2008-04-08 12
-76 val_76 2008-04-08 12
-41 val_41 2008-04-08 12
-30 val_30 2008-04-08 12
64 val_64 2008-04-08 12
-76 val_76 2008-04-08 12
-74 val_74 2008-04-08 12
+64 val_64 2008-04-08 11
+65 val_65 2008-04-08 11
+65 val_65 2008-04-08 12
+66 val_66 2008-04-08 12
+66 val_66 2008-04-08 11
+67 val_67 2008-04-08 11
+67 val_67 2008-04-08 11
+67 val_67 2008-04-08 12
+67 val_67 2008-04-08 12
69 val_69 2008-04-08 12
-33 val_33 2008-04-08 12
+69 val_69 2008-04-08 11
+70 val_70 2008-04-08 11
+70 val_70 2008-04-08 11
+70 val_70 2008-04-08 11
70 val_70 2008-04-08 12
-5 val_5 2008-04-08 12
-2 val_2 2008-04-08 12
-35 val_35 2008-04-08 12
-80 val_80 2008-04-08 12
-44 val_44 2008-04-08 12
-53 val_53 2008-04-08 12
-90 val_90 2008-04-08 12
-12 val_12 2008-04-08 12
-5 val_5 2008-04-08 12
70 val_70 2008-04-08 12
-24 val_24 2008-04-08 12
70 val_70 2008-04-08 12
+72 val_72 2008-04-08 12
+72 val_72 2008-04-08 12
+72 val_72 2008-04-08 11
+72 val_72 2008-04-08 11
+74 val_74 2008-04-08 11
+74 val_74 2008-04-08 12
+76 val_76 2008-04-08 12
+76 val_76 2008-04-08 12
+76 val_76 2008-04-08 11
+76 val_76 2008-04-08 11
+77 val_77 2008-04-08 11
+77 val_77 2008-04-08 12
+78 val_78 2008-04-08 12
+78 val_78 2008-04-08 11
+8 val_8 2008-04-08 11
+8 val_8 2008-04-08 12
+80 val_80 2008-04-08 12
+80 val_80 2008-04-08 11
+82 val_82 2008-04-08 11
+82 val_82 2008-04-08 12
83 val_83 2008-04-08 12
-26 val_26 2008-04-08 12
-67 val_67 2008-04-08 12
-18 val_18 2008-04-08 12
-9 val_9 2008-04-08 12
-18 val_18 2008-04-08 12
-97 val_97 2008-04-08 12
+83 val_83 2008-04-08 12
+83 val_83 2008-04-08 11
+83 val_83 2008-04-08 11
+84 val_84 2008-04-08 11
+84 val_84 2008-04-08 11
84 val_84 2008-04-08 12
-28 val_28 2008-04-08 12
-37 val_37 2008-04-08 12
+84 val_84 2008-04-08 12
+85 val_85 2008-04-08 12
+85 val_85 2008-04-08 11
+86 val_86 2008-04-08 11
+86 val_86 2008-04-08 12
+87 val_87 2008-04-08 12
+87 val_87 2008-04-08 11
+9 val_9 2008-04-08 11
+9 val_9 2008-04-08 12
+90 val_90 2008-04-08 12
90 val_90 2008-04-08 12
+90 val_90 2008-04-08 12
+90 val_90 2008-04-08 11
+90 val_90 2008-04-08 11
+90 val_90 2008-04-08 11
+92 val_92 2008-04-08 11
+92 val_92 2008-04-08 12
+95 val_95 2008-04-08 12
+95 val_95 2008-04-08 12
+95 val_95 2008-04-08 11
+95 val_95 2008-04-08 11
+96 val_96 2008-04-08 11
+96 val_96 2008-04-08 12
+97 val_97 2008-04-08 12
97 val_97 2008-04-08 12
+97 val_97 2008-04-08 11
+97 val_97 2008-04-08 11
+98 val_98 2008-04-08 11
+98 val_98 2008-04-08 11
+98 val_98 2008-04-08 12
+98 val_98 2008-04-08 12
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/rand_partitionpruner2.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/rand_partitionpruner2.q.out?rev=763755&r1=763754&r2=763755&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/rand_partitionpruner2.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/rand_partitionpruner2.q.out Thu Apr 9 18:05:53 2009
@@ -1,9 +1,9 @@
ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_TABREF srcpart a)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF a))) (TOK_WHERE (and (< (TOK_FUNCTION rand 1) 0.1) (= (TOK_COLREF a ds) '2008-04-08')))))
+ (TOK_QUERY (TOK_FROM (TOK_TABREF srcpart a)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB tmptable)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF a))) (TOK_WHERE (and (< (TOK_FUNCTION rand 1) 0.1) (= (TOK_COLREF a ds) '2008-04-08')))))
STAGE DEPENDENCIES:
Stage-1 is a root stage
- Stage-0 is a root stage
+ Stage-0 depends on stages: Stage-1
STAGE PLANS:
Stage: Stage-1
@@ -26,20 +26,30 @@
type: string
File Output Operator
compressed: false
- GlobalTableId: 0
- directory: /Users/rmurthy/workspace/hive-latest/ql/../build/ql/tmp/1173098600/505441477.10001.insclause-0
+ GlobalTableId: 1
+ directory: /data/users/njain/hive1/hive/ql/../build/ql/tmp/787149371/586711136.10000.insclause-0
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
properties:
- columns a.key,a.value,a.ds,a.hr
+ name tmptable
+ columns.types string:string:string:string
+ serialization.ddl struct tmptable { string key, string value, string hr, string ds}
serialization.format 1
+ columns key,value,hr,ds
+ bucket_count -1
+ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ location file:/data/users/njain/hive1/hive/build/ql/test/data/warehouse/tmptable
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: tmptable
Needs Tagging: false
Path -> Alias:
- file:/Users/rmurthy/workspace/hive-latest/build/ql/test/data/warehouse/srcpart/hr=11/ds=2008-04-08
- file:/Users/rmurthy/workspace/hive-latest/build/ql/test/data/warehouse/srcpart/hr=12/ds=2008-04-08
+ file:/data/users/njain/hive1/hive/build/ql/test/data/warehouse/srcpart/hr=11/ds=2008-04-08
+ file:/data/users/njain/hive1/hive/build/ql/test/data/warehouse/srcpart/hr=12/ds=2008-04-08
Path -> Partition:
- file:/Users/rmurthy/workspace/hive-latest/build/ql/test/data/warehouse/srcpart/hr=11/ds=2008-04-08
+ file:/data/users/njain/hive1/hive/build/ql/test/data/warehouse/srcpart/hr=11/ds=2008-04-08
Partition
partition values:
ds 2008-04-08
@@ -58,10 +68,10 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- location file:/Users/rmurthy/workspace/hive-latest/build/ql/test/data/warehouse/srcpart
+ location file:/data/users/njain/hive1/hive/build/ql/test/data/warehouse/srcpart
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcpart
- file:/Users/rmurthy/workspace/hive-latest/build/ql/test/data/warehouse/srcpart/hr=12/ds=2008-04-08
+ file:/data/users/njain/hive1/hive/build/ql/test/data/warehouse/srcpart/hr=12/ds=2008-04-08
Partition
partition values:
ds 2008-04-08
@@ -80,124 +90,142 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- location file:/Users/rmurthy/workspace/hive-latest/build/ql/test/data/warehouse/srcpart
+ location file:/data/users/njain/hive1/hive/build/ql/test/data/warehouse/srcpart
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcpart
Stage: Stage-0
- Fetch Operator
- limit: -1
+ Move Operator
+ tables:
+ replace: true
+ source: /data/users/njain/hive1/hive/ql/../build/ql/tmp/787149371/586711136.10000.insclause-0
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ properties:
+ name tmptable
+ columns.types string:string:string:string
+ serialization.ddl struct tmptable { string key, string value, string hr, string ds}
+ serialization.format 1
+ columns key,value,hr,ds
+ bucket_count -1
+ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ location file:/data/users/njain/hive1/hive/build/ql/test/data/warehouse/tmptable
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: tmptable
-409 val_409 2008-04-08 11
-429 val_429 2008-04-08 11
-209 val_209 2008-04-08 11
+103 val_103 2008-04-08 11
+103 val_103 2008-04-08 12
+133 val_133 2008-04-08 12
+133 val_133 2008-04-08 11
+134 val_134 2008-04-08 11
+134 val_134 2008-04-08 12
+138 val_138 2008-04-08 12
+138 val_138 2008-04-08 11
+152 val_152 2008-04-08 11
+152 val_152 2008-04-08 12
+153 val_153 2008-04-08 12
153 val_153 2008-04-08 11
-203 val_203 2008-04-08 11
+169 val_169 2008-04-08 11
+169 val_169 2008-04-08 12
+170 val_170 2008-04-08 12
170 val_170 2008-04-08 11
-489 val_489 2008-04-08 11
-378 val_378 2008-04-08 11
-221 val_221 2008-04-08 11
-498 val_498 2008-04-08 11
-469 val_469 2008-04-08 11
176 val_176 2008-04-08 11
176 val_176 2008-04-08 11
-384 val_384 2008-04-08 11
-217 val_217 2008-04-08 11
-431 val_431 2008-04-08 11
-51 val_51 2008-04-08 11
-288 val_288 2008-04-08 11
-457 val_457 2008-04-08 11
+176 val_176 2008-04-08 12
+176 val_176 2008-04-08 12
+18 val_18 2008-04-08 12
+18 val_18 2008-04-08 11
197 val_197 2008-04-08 11
-77 val_77 2008-04-08 11
-138 val_138 2008-04-08 11
-277 val_277 2008-04-08 11
-224 val_224 2008-04-08 11
-309 val_309 2008-04-08 11
-389 val_389 2008-04-08 11
-331 val_331 2008-04-08 11
-317 val_317 2008-04-08 11
-336 val_336 2008-04-08 11
-42 val_42 2008-04-08 11
-458 val_458 2008-04-08 11
-78 val_78 2008-04-08 11
-453 val_453 2008-04-08 11
-74 val_74 2008-04-08 11
-103 val_103 2008-04-08 11
-467 val_467 2008-04-08 11
-202 val_202 2008-04-08 11
-469 val_469 2008-04-08 11
-44 val_44 2008-04-08 11
-454 val_454 2008-04-08 11
-70 val_70 2008-04-08 11
-491 val_491 2008-04-08 11
+197 val_197 2008-04-08 12
+199 val_199 2008-04-08 12
199 val_199 2008-04-08 11
-169 val_169 2008-04-08 11
-310 val_310 2008-04-08 11
+202 val_202 2008-04-08 11
+202 val_202 2008-04-08 12
+203 val_203 2008-04-08 12
+203 val_203 2008-04-08 11
+209 val_209 2008-04-08 11
+209 val_209 2008-04-08 12
+217 val_217 2008-04-08 12
+217 val_217 2008-04-08 11
+221 val_221 2008-04-08 11
+221 val_221 2008-04-08 12
+224 val_224 2008-04-08 12
+224 val_224 2008-04-08 11
233 val_233 2008-04-08 11
-133 val_133 2008-04-08 11
+233 val_233 2008-04-08 12
+26 val_26 2008-04-08 12
26 val_26 2008-04-08 11
-134 val_134 2008-04-08 11
-18 val_18 2008-04-08 11
+277 val_277 2008-04-08 11
+277 val_277 2008-04-08 12
+288 val_288 2008-04-08 12
+288 val_288 2008-04-08 11
298 val_298 2008-04-08 11
+298 val_298 2008-04-08 12
+309 val_309 2008-04-08 12
+309 val_309 2008-04-08 11
+310 val_310 2008-04-08 11
+310 val_310 2008-04-08 12
+317 val_317 2008-04-08 12
+317 val_317 2008-04-08 11
+331 val_331 2008-04-08 11
+331 val_331 2008-04-08 12
+336 val_336 2008-04-08 12
+336 val_336 2008-04-08 11
348 val_348 2008-04-08 11
-469 val_469 2008-04-08 11
+348 val_348 2008-04-08 12
+37 val_37 2008-04-08 12
37 val_37 2008-04-08 11
-152 val_152 2008-04-08 11
+378 val_378 2008-04-08 11
+378 val_378 2008-04-08 12
+384 val_384 2008-04-08 12
+384 val_384 2008-04-08 11
+389 val_389 2008-04-08 11
+389 val_389 2008-04-08 12
+400 val_400 2008-04-08 12
400 val_400 2008-04-08 11
+409 val_409 2008-04-08 11
409 val_409 2008-04-08 12
+42 val_42 2008-04-08 12
+42 val_42 2008-04-08 11
+429 val_429 2008-04-08 11
429 val_429 2008-04-08 12
-209 val_209 2008-04-08 12
-153 val_153 2008-04-08 12
-203 val_203 2008-04-08 12
-170 val_170 2008-04-08 12
-489 val_489 2008-04-08 12
-378 val_378 2008-04-08 12
-221 val_221 2008-04-08 12
-498 val_498 2008-04-08 12
-469 val_469 2008-04-08 12
-176 val_176 2008-04-08 12
-176 val_176 2008-04-08 12
-384 val_384 2008-04-08 12
-217 val_217 2008-04-08 12
431 val_431 2008-04-08 12
-51 val_51 2008-04-08 12
-288 val_288 2008-04-08 12
+431 val_431 2008-04-08 11
+44 val_44 2008-04-08 11
+44 val_44 2008-04-08 12
+453 val_453 2008-04-08 12
+453 val_453 2008-04-08 11
+454 val_454 2008-04-08 11
+454 val_454 2008-04-08 12
457 val_457 2008-04-08 12
-197 val_197 2008-04-08 12
-77 val_77 2008-04-08 12
-138 val_138 2008-04-08 12
-277 val_277 2008-04-08 12
-224 val_224 2008-04-08 12
-309 val_309 2008-04-08 12
-389 val_389 2008-04-08 12
-331 val_331 2008-04-08 12
-317 val_317 2008-04-08 12
-336 val_336 2008-04-08 12
-42 val_42 2008-04-08 12
+457 val_457 2008-04-08 11
+458 val_458 2008-04-08 11
458 val_458 2008-04-08 12
-78 val_78 2008-04-08 12
-453 val_453 2008-04-08 12
-74 val_74 2008-04-08 12
-103 val_103 2008-04-08 12
467 val_467 2008-04-08 12
-202 val_202 2008-04-08 12
+467 val_467 2008-04-08 11
+469 val_469 2008-04-08 11
+469 val_469 2008-04-08 11
+469 val_469 2008-04-08 11
469 val_469 2008-04-08 12
-44 val_44 2008-04-08 12
-454 val_454 2008-04-08 12
-70 val_70 2008-04-08 12
-491 val_491 2008-04-08 12
-199 val_199 2008-04-08 12
-169 val_169 2008-04-08 12
-310 val_310 2008-04-08 12
-233 val_233 2008-04-08 12
-133 val_133 2008-04-08 12
-26 val_26 2008-04-08 12
-134 val_134 2008-04-08 12
-18 val_18 2008-04-08 12
-298 val_298 2008-04-08 12
-348 val_348 2008-04-08 12
469 val_469 2008-04-08 12
-37 val_37 2008-04-08 12
-152 val_152 2008-04-08 12
-400 val_400 2008-04-08 12
+469 val_469 2008-04-08 12
+489 val_489 2008-04-08 12
+489 val_489 2008-04-08 11
+491 val_491 2008-04-08 11
+491 val_491 2008-04-08 12
+498 val_498 2008-04-08 12
+498 val_498 2008-04-08 11
+51 val_51 2008-04-08 11
+51 val_51 2008-04-08 12
+70 val_70 2008-04-08 12
+70 val_70 2008-04-08 11
+74 val_74 2008-04-08 11
+74 val_74 2008-04-08 12
+77 val_77 2008-04-08 12
+77 val_77 2008-04-08 11
+78 val_78 2008-04-08 11
+78 val_78 2008-04-08 12