hadoop-hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From athu...@apache.org
Subject svn commit: r763755 - in /hadoop/hive/trunk: ./ ql/src/test/queries/clientpositive/ ql/src/test/results/clientpositive/
Date Thu, 09 Apr 2009 18:05:53 GMT
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



Mime
View raw message