You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by jv...@apache.org on 2011/08/04 18:57:21 UTC
svn commit: r1153926 [1/14] - in /hive/trunk:
cli/src/java/org/apache/hadoop/hive/cli/
ql/src/java/org/apache/hadoop/hive/ql/ ql/src/test/queries/clientpositive/
ql/src/test/results/clientnegative/ ql/src/test/results/clientpositive/
Author: jvs
Date: Thu Aug 4 16:57:17 2011
New Revision: 1153926
URL: http://svn.apache.org/viewvc?rev=1153926&view=rev
Log:
HIVE-2286. ClassCastException when building index with security.authorization
turned on
(Syed Albiz via jvs)
Added:
hive/trunk/ql/src/test/queries/clientpositive/index_auth.q
hive/trunk/ql/src/test/results/clientpositive/index_auth.q.out
Modified:
hive/trunk/cli/src/java/org/apache/hadoop/hive/cli/CliDriver.java
hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/Driver.java
hive/trunk/ql/src/test/results/clientnegative/alter_view_failure2.q.out
hive/trunk/ql/src/test/results/clientnegative/alter_view_failure4.q.out
hive/trunk/ql/src/test/results/clientnegative/create_or_replace_view1.q.out
hive/trunk/ql/src/test/results/clientnegative/create_or_replace_view2.q.out
hive/trunk/ql/src/test/results/clientnegative/index_compact_entry_limit.q.out
hive/trunk/ql/src/test/results/clientnegative/index_compact_size_limit.q.out
hive/trunk/ql/src/test/results/clientpositive/create_or_replace_view.q.out
hive/trunk/ql/src/test/results/clientpositive/create_view_partitioned.q.out
hive/trunk/ql/src/test/results/clientpositive/index_auto.q.out
hive/trunk/ql/src/test/results/clientpositive/index_auto_file_format.q.out
hive/trunk/ql/src/test/results/clientpositive/index_auto_mult_tables.q.out
hive/trunk/ql/src/test/results/clientpositive/index_auto_mult_tables_compact.q.out
hive/trunk/ql/src/test/results/clientpositive/index_auto_multiple.q.out
hive/trunk/ql/src/test/results/clientpositive/index_auto_partitioned.q.out
hive/trunk/ql/src/test/results/clientpositive/index_auto_self_join.q.out
hive/trunk/ql/src/test/results/clientpositive/index_auto_unused.q.out
hive/trunk/ql/src/test/results/clientpositive/index_bitmap.q.out
hive/trunk/ql/src/test/results/clientpositive/index_bitmap1.q.out
hive/trunk/ql/src/test/results/clientpositive/index_bitmap2.q.out
hive/trunk/ql/src/test/results/clientpositive/index_bitmap3.q.out
hive/trunk/ql/src/test/results/clientpositive/index_bitmap_auto.q.out
hive/trunk/ql/src/test/results/clientpositive/index_bitmap_auto_partitioned.q.out
hive/trunk/ql/src/test/results/clientpositive/index_bitmap_compression.q.out
hive/trunk/ql/src/test/results/clientpositive/index_bitmap_rc.q.out
hive/trunk/ql/src/test/results/clientpositive/index_compact.q.out
hive/trunk/ql/src/test/results/clientpositive/index_compact_1.q.out
hive/trunk/ql/src/test/results/clientpositive/index_compact_2.q.out
hive/trunk/ql/src/test/results/clientpositive/index_compact_3.q.out
hive/trunk/ql/src/test/results/clientpositive/index_compression.q.out
hive/trunk/ql/src/test/results/clientpositive/index_creation.q.out
hive/trunk/ql/src/test/results/clientpositive/show_indexes_edge_cases.q.out
hive/trunk/ql/src/test/results/clientpositive/show_indexes_syntax.q.out
Modified: hive/trunk/cli/src/java/org/apache/hadoop/hive/cli/CliDriver.java
URL: http://svn.apache.org/viewvc/hive/trunk/cli/src/java/org/apache/hadoop/hive/cli/CliDriver.java?rev=1153926&r1=1153925&r2=1153926&view=diff
==============================================================================
--- hive/trunk/cli/src/java/org/apache/hadoop/hive/cli/CliDriver.java (original)
+++ hive/trunk/cli/src/java/org/apache/hadoop/hive/cli/CliDriver.java Thu Aug 4 16:57:17 2011
@@ -359,6 +359,9 @@ public class CliDriver {
}
ret = processCmd(command);
+ //wipe cli query state
+ SessionState ss = SessionState.get();
+ ss.setCommandType(null);
command = "";
lastRet = ret;
boolean ignoreErrors = HiveConf.getBoolVar(conf, HiveConf.ConfVars.CLIIGNOREERRORS);
Modified: hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/Driver.java
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/Driver.java?rev=1153926&r1=1153925&r2=1153926&view=diff
==============================================================================
--- hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/Driver.java (original)
+++ hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/Driver.java Thu Aug 4 16:57:17 2011
@@ -24,6 +24,7 @@ import java.io.FileOutputStream;
import java.io.IOException;
import java.io.Serializable;
import java.util.ArrayList;
+import java.util.Stack;
import java.util.HashMap;
import java.util.HashSet;
import java.util.Iterator;
@@ -336,6 +337,52 @@ public class Driver implements CommandPr
}
/**
+ * Hold state variables specific to each query being executed, that may not
+ * be consistent in the overall SessionState
+ */
+ private static class QueryState {
+ private HiveOperation op;
+ private String cmd;
+ private boolean init = false;
+
+ /**
+ * Initialize the queryState with the query state variables
+ */
+ public void init(HiveOperation op, String cmd) {
+ this.op = op;
+ this.cmd = cmd;
+ this.init = true;
+ }
+
+ public boolean isInitialized() {
+ return this.init;
+ }
+
+ public HiveOperation getOp() {
+ return this.op;
+ }
+
+ public String getCmd() {
+ return this.cmd;
+ }
+ }
+
+ public void saveSession(QueryState qs) {
+ SessionState oldss = SessionState.get();
+ if (oldss != null && oldss.getHiveOperation() != null) {
+ qs.init(oldss.getHiveOperation(), oldss.getCmd());
+ }
+ }
+
+ public void restoreSession(QueryState qs) {
+ SessionState ss = SessionState.get();
+ if (ss != null && qs != null && qs.isInitialized()) {
+ ss.setCmd(qs.getCmd());
+ ss.setCommandType(qs.getOp());
+ }
+ }
+
+ /**
* Compile a new query, but potentially reset taskID counter. Not resetting task counter
* is useful for generating re-entrant QL queries.
* @param command The HiveQL query to compile
@@ -345,6 +392,8 @@ public class Driver implements CommandPr
public int compile(String command, boolean resetTaskIds) {
Utilities.PerfLogBegin(LOG, "compile");
+ //holder for parent command type/string when executing reentrant queries
+ QueryState queryState = new QueryState();
if (plan != null) {
close();
@@ -352,8 +401,9 @@ public class Driver implements CommandPr
}
if (resetTaskIds) {
- TaskFactory.resetId();
+ TaskFactory.resetId();
}
+ saveSession(queryState);
try {
command = new VariableSubstitution().substitute(conf,command);
@@ -438,6 +488,8 @@ public class Driver implements CommandPr
}
}
+ //restore state after we're done executing a specific query
+
return 0;
} catch (SemanticException e) {
errorMessage = "FAILED: Error in semantic analysis: " + e.getMessage();
@@ -458,6 +510,7 @@ public class Driver implements CommandPr
+ org.apache.hadoop.util.StringUtils.stringifyException(e));
return (12);
} finally {
+ restoreSession(queryState);
Utilities.PerfLogEnd(LOG, "compile");
}
}
Added: hive/trunk/ql/src/test/queries/clientpositive/index_auth.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/index_auth.q?rev=1153926&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/index_auth.q (added)
+++ hive/trunk/ql/src/test/queries/clientpositive/index_auth.q Thu Aug 4 16:57:17 2011
@@ -0,0 +1,15 @@
+SET hive.input.format=org.apache.hadoop.hive.ql.io.HiveInputFormat;
+create table foobar(key int, value string) PARTITIONED BY (ds string, hr string);
+alter table foobar add partition (ds='2008-04-08',hr='12');
+
+CREATE INDEX srcpart_auth_index ON TABLE foobar(key) as 'BITMAP' WITH DEFERRED REBUILD;
+grant select on table foobar to user hive_test_user;
+grant select on table default__foobar_srcpart_auth_index__ to user hive_test_user;
+grant update on table default__foobar_srcpart_auth_index__ to user hive_test_user;
+grant create on table default__foobar_srcpart_auth_index__ to user hive_test_user;
+set hive.security.authorization.enabled=true;
+
+ALTER INDEX srcpart_auth_index ON foobar PARTITION (ds='2008-04-08',hr='12') REBUILD;
+set hive.security.authorization.enabled=false;
+DROP INDEX srcpart_auth_index on foobar;
+DROP TABLE foobar;
Modified: hive/trunk/ql/src/test/results/clientnegative/alter_view_failure2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientnegative/alter_view_failure2.q.out?rev=1153926&r1=1153925&r2=1153926&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientnegative/alter_view_failure2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientnegative/alter_view_failure2.q.out Thu Aug 4 16:57:17 2011
@@ -7,17 +7,17 @@ PARTITIONED ON (value)
AS
SELECT * FROM src
PREHOOK: type: CREATEVIEW
-PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-02-10_12-58-02_930_3490345072474460874/-mr-10000
+PREHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_16-12-55_273_3019518550411272365/-mr-10000
POSTHOOK: query: CREATE VIEW xxx4
PARTITIONED ON (value)
AS
SELECT * FROM src
POSTHOOK: type: CREATEVIEW
POSTHOOK: Output: default@xxx4
-POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-02-10_12-58-02_930_3490345072474460874/-mr-10000
+POSTHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_16-12-55_273_3019518550411272365/-mr-10000
PREHOOK: query: -- should fail: need to use ALTER VIEW, not ALTER TABLE
ALTER TABLE xxx4 ADD PARTITION (value='val_86')
-PREHOOK: type: QUERY
+PREHOOK: type: ALTERTABLE_ADDPARTS
PREHOOK: Input: default@src
PREHOOK: Input: default@xxx4
FAILED: Error in metadata: Cannot alter a view with ALTER TABLE
Modified: hive/trunk/ql/src/test/results/clientnegative/alter_view_failure4.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientnegative/alter_view_failure4.q.out?rev=1153926&r1=1153925&r2=1153926&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientnegative/alter_view_failure4.q.out (original)
+++ hive/trunk/ql/src/test/results/clientnegative/alter_view_failure4.q.out Thu Aug 4 16:57:17 2011
@@ -7,17 +7,17 @@ PARTITIONED ON (value)
AS
SELECT * FROM src
PREHOOK: type: CREATEVIEW
-PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-02-10_12-59-39_789_5581361064099423922/-mr-10000
+PREHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_16-12-55_917_1648946579211365076/-mr-10000
POSTHOOK: query: CREATE VIEW xxx5
PARTITIONED ON (value)
AS
SELECT * FROM src
POSTHOOK: type: CREATEVIEW
POSTHOOK: Output: default@xxx5
-POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-02-10_12-59-39_789_5581361064099423922/-mr-10000
+POSTHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_16-12-55_917_1648946579211365076/-mr-10000
PREHOOK: query: -- should fail: LOCATION clause is illegal
ALTER VIEW xxx5 ADD PARTITION (value='val_86') LOCATION '/foo/bar/baz'
-PREHOOK: type: QUERY
+PREHOOK: type: ALTERTABLE_ADDPARTS
PREHOOK: Input: default@src
PREHOOK: Input: default@xxx5
FAILED: Error in metadata: LOCATION clause illegal for view partition
Modified: hive/trunk/ql/src/test/results/clientnegative/create_or_replace_view1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientnegative/create_or_replace_view1.q.out?rev=1153926&r1=1153925&r2=1153926&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientnegative/create_or_replace_view1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientnegative/create_or_replace_view1.q.out Thu Aug 4 16:57:17 2011
@@ -8,20 +8,20 @@ drop view v
POSTHOOK: type: DROPVIEW
PREHOOK: query: create view v partitioned on (ds, hr) as select * from srcpart
PREHOOK: type: CREATEVIEW
-PREHOOK: Output: file:/var/folders/fe/fefl-ow3ElaEd1ns0G7jB0uewEQ/-Tmp-/charleschen/hive_2011-07-19_17-36-03_886_5641638152163785475/-mr-10000
+PREHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_16-13-56_957_1955443226150142083/-mr-10000
POSTHOOK: query: create view v partitioned on (ds, hr) as select * from srcpart
POSTHOOK: type: CREATEVIEW
POSTHOOK: Output: default@v
-POSTHOOK: Output: file:/var/folders/fe/fefl-ow3ElaEd1ns0G7jB0uewEQ/-Tmp-/charleschen/hive_2011-07-19_17-36-03_886_5641638152163785475/-mr-10000
+POSTHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_16-13-56_957_1955443226150142083/-mr-10000
PREHOOK: query: alter view v add partition (ds='1',hr='2')
-PREHOOK: type: QUERY
+PREHOOK: type: ALTERTABLE_ADDPARTS
PREHOOK: Input: default@v
POSTHOOK: query: alter view v add partition (ds='1',hr='2')
-POSTHOOK: type: QUERY
+POSTHOOK: type: ALTERTABLE_ADDPARTS
POSTHOOK: Input: default@v
POSTHOOK: Output: default@v@ds=1/hr=2
PREHOOK: query: create or replace view v as select * from srcpart
PREHOOK: type: CREATEVIEW
-PREHOOK: Output: file:/var/folders/fe/fefl-ow3ElaEd1ns0G7jB0uewEQ/-Tmp-/charleschen/hive_2011-07-19_17-36-04_296_7084494219990814004/-mr-10000
+PREHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_16-13-57_152_1055947460038057038/-mr-10000
FAILED: Error in metadata: Cannot add or drop partition columns with CREATE OR REPLACE VIEW if partitions currently exist
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask
Modified: hive/trunk/ql/src/test/results/clientnegative/create_or_replace_view2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientnegative/create_or_replace_view2.q.out?rev=1153926&r1=1153925&r2=1153926&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientnegative/create_or_replace_view2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientnegative/create_or_replace_view2.q.out Thu Aug 4 16:57:17 2011
@@ -8,20 +8,20 @@ drop view v
POSTHOOK: type: DROPVIEW
PREHOOK: query: create view v partitioned on (ds, hr) as select * from srcpart
PREHOOK: type: CREATEVIEW
-PREHOOK: Output: file:/var/folders/fe/fefl-ow3ElaEd1ns0G7jB0uewEQ/-Tmp-/charleschen/hive_2011-07-19_17-36-58_232_8111009537092703310/-mr-10000
+PREHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_16-13-57_421_5329923480305070124/-mr-10000
POSTHOOK: query: create view v partitioned on (ds, hr) as select * from srcpart
POSTHOOK: type: CREATEVIEW
POSTHOOK: Output: default@v
-POSTHOOK: Output: file:/var/folders/fe/fefl-ow3ElaEd1ns0G7jB0uewEQ/-Tmp-/charleschen/hive_2011-07-19_17-36-58_232_8111009537092703310/-mr-10000
+POSTHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_16-13-57_421_5329923480305070124/-mr-10000
PREHOOK: query: alter view v add partition (ds='1',hr='2')
-PREHOOK: type: QUERY
+PREHOOK: type: ALTERTABLE_ADDPARTS
PREHOOK: Input: default@v
POSTHOOK: query: alter view v add partition (ds='1',hr='2')
-POSTHOOK: type: QUERY
+POSTHOOK: type: ALTERTABLE_ADDPARTS
POSTHOOK: Input: default@v
POSTHOOK: Output: default@v@ds=1/hr=2
PREHOOK: query: create or replace view v partitioned on (hr) as select * from srcpart
PREHOOK: type: CREATEVIEW
-PREHOOK: Output: file:/var/folders/fe/fefl-ow3ElaEd1ns0G7jB0uewEQ/-Tmp-/charleschen/hive_2011-07-19_17-36-58_637_5038612564681921162/-mr-10000
+PREHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_16-13-57_632_8177289347251099189/-mr-10000
FAILED: Error in metadata: Cannot add or drop partition columns with CREATE OR REPLACE VIEW if partitions currently exist
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask
Modified: hive/trunk/ql/src/test/results/clientnegative/index_compact_entry_limit.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientnegative/index_compact_entry_limit.q.out?rev=1153926&r1=1153925&r2=1153926&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientnegative/index_compact_entry_limit.q.out (original)
+++ hive/trunk/ql/src/test/results/clientnegative/index_compact_entry_limit.q.out Thu Aug 4 16:57:17 2011
@@ -7,21 +7,21 @@ PREHOOK: type: CREATEINDEX
POSTHOOK: query: CREATE INDEX src_index ON TABLE src(key) as 'COMPACT' WITH DEFERRED REBUILD
POSTHOOK: type: CREATEINDEX
PREHOOK: query: ALTER INDEX src_index ON src REBUILD
-PREHOOK: type: QUERY
+PREHOOK: type: ALTERINDEX_REBUILD
PREHOOK: Input: default@src
PREHOOK: Output: default@default__src_src_index__
POSTHOOK: query: ALTER INDEX src_index ON src REBUILD
-POSTHOOK: type: QUERY
+POSTHOOK: type: ALTERINDEX_REBUILD
POSTHOOK: Input: default@src
POSTHOOK: Output: default@default__src_src_index__
POSTHOOK: Lineage: default__src_src_index__._bucketname SIMPLE [(src)src.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
POSTHOOK: Lineage: default__src_src_index__._offsets EXPRESSION [(src)src.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), ]
POSTHOOK: Lineage: default__src_src_index__.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-PREHOOK: query: INSERT OVERWRITE DIRECTORY "/tmp/index_result" SELECT `_bucketname` , `_offsets` FROM default__src_src_index__ WHERE key
+PREHOOK: query: INSERT OVERWRITE DIRECTORY "/tmp/index_result" SELECT `_bucketname` , `_offsets` FROM default__src_src_index__ WHERE key<1000
PREHOOK: type: QUERY
PREHOOK: Input: default@default__src_src_index__
PREHOOK: Output: /tmp/index_result
-POSTHOOK: query: INSERT OVERWRITE DIRECTORY "/tmp/index_result" SELECT `_bucketname` , `_offsets` FROM default__src_src_index__ WHERE key
+POSTHOOK: query: INSERT OVERWRITE DIRECTORY "/tmp/index_result" SELECT `_bucketname` , `_offsets` FROM default__src_src_index__ WHERE key<1000
POSTHOOK: type: QUERY
POSTHOOK: Input: default@default__src_src_index__
POSTHOOK: Output: /tmp/index_result
@@ -31,5 +31,5 @@ POSTHOOK: Lineage: default__src_src_inde
PREHOOK: query: SELECT key, value FROM src WHERE key=100 ORDER BY key
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/tmp/wgaluba/hive_2011-05-09_20-23-26_023_6902661313242990836/-mr-10000
+PREHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_16-15-31_393_2323708709856396072/-mr-10000
FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.MapRedTask
Modified: hive/trunk/ql/src/test/results/clientnegative/index_compact_size_limit.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientnegative/index_compact_size_limit.q.out?rev=1153926&r1=1153925&r2=1153926&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientnegative/index_compact_size_limit.q.out (original)
+++ hive/trunk/ql/src/test/results/clientnegative/index_compact_size_limit.q.out Thu Aug 4 16:57:17 2011
@@ -7,21 +7,21 @@ PREHOOK: type: CREATEINDEX
POSTHOOK: query: CREATE INDEX src_index ON TABLE src(key) as 'COMPACT' WITH DEFERRED REBUILD
POSTHOOK: type: CREATEINDEX
PREHOOK: query: ALTER INDEX src_index ON src REBUILD
-PREHOOK: type: QUERY
+PREHOOK: type: ALTERINDEX_REBUILD
PREHOOK: Input: default@src
PREHOOK: Output: default@default__src_src_index__
POSTHOOK: query: ALTER INDEX src_index ON src REBUILD
-POSTHOOK: type: QUERY
+POSTHOOK: type: ALTERINDEX_REBUILD
POSTHOOK: Input: default@src
POSTHOOK: Output: default@default__src_src_index__
POSTHOOK: Lineage: default__src_src_index__._bucketname SIMPLE [(src)src.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
POSTHOOK: Lineage: default__src_src_index__._offsets EXPRESSION [(src)src.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), ]
POSTHOOK: Lineage: default__src_src_index__.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-PREHOOK: query: INSERT OVERWRITE DIRECTORY "/tmp/index_result" SELECT `_bucketname` , `_offsets` FROM default__src_src_index__ WHERE key
+PREHOOK: query: INSERT OVERWRITE DIRECTORY "/tmp/index_result" SELECT `_bucketname` , `_offsets` FROM default__src_src_index__ WHERE key<1000
PREHOOK: type: QUERY
PREHOOK: Input: default@default__src_src_index__
PREHOOK: Output: /tmp/index_result
-POSTHOOK: query: INSERT OVERWRITE DIRECTORY "/tmp/index_result" SELECT `_bucketname` , `_offsets` FROM default__src_src_index__ WHERE key
+POSTHOOK: query: INSERT OVERWRITE DIRECTORY "/tmp/index_result" SELECT `_bucketname` , `_offsets` FROM default__src_src_index__ WHERE key<1000
POSTHOOK: type: QUERY
POSTHOOK: Input: default@default__src_src_index__
POSTHOOK: Output: /tmp/index_result
@@ -31,5 +31,5 @@ POSTHOOK: Lineage: default__src_src_inde
PREHOOK: query: SELECT key, value FROM src WHERE key=100 ORDER BY key
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/tmp/wgaluba/hive_2011-05-09_20-23-26_023_6902661313242990836/-mr-10000
+PREHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_16-15-40_648_4958727540603697272/-mr-10000
FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.MapRedTask
Modified: hive/trunk/ql/src/test/results/clientpositive/create_or_replace_view.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/create_or_replace_view.q.out?rev=1153926&r1=1153925&r2=1153926&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/create_or_replace_view.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/create_or_replace_view.q.out Thu Aug 4 16:57:17 2011
@@ -4,11 +4,11 @@ POSTHOOK: query: drop view v
POSTHOOK: type: DROPVIEW
PREHOOK: query: create view v as select * from srcpart
PREHOOK: type: CREATEVIEW
-PREHOOK: Output: file:/var/folders/fe/fefl-ow3ElaEd1ns0G7jB0uewEQ/-Tmp-/charleschen/hive_2011-07-19_17-34-54_878_6732266159103898080/-mr-10000
+PREHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_13-18-48_459_8863944425018360291/-mr-10000
POSTHOOK: query: create view v as select * from srcpart
POSTHOOK: type: CREATEVIEW
POSTHOOK: Output: default@v
-POSTHOOK: Output: file:/var/folders/fe/fefl-ow3ElaEd1ns0G7jB0uewEQ/-Tmp-/charleschen/hive_2011-07-19_17-34-54_878_6732266159103898080/-mr-10000
+POSTHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_13-18-48_459_8863944425018360291/-mr-10000
PREHOOK: query: describe formatted v
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe formatted v
@@ -22,14 +22,14 @@ hr string
# Detailed Table Information
Database: default
-Owner: charleschen
-CreateTime: Tue Jul 19 17:34:54 PDT 2011
+Owner: salbiz
+CreateTime: Mon Aug 01 13:18:48 PDT 2011
LastAccessTime: UNKNOWN
Protect Mode: None
Retention: 0
Table Type: VIRTUAL_VIEW
Table Parameters:
- transient_lastDdlTime 1311122094
+ transient_lastDdlTime 1312229928
# Storage Information
SerDe Library: null
@@ -46,38 +46,38 @@ View Expanded Text: select `srcpart`.`k
PREHOOK: query: -- modifying definition of unpartitioned view
create or replace view v partitioned on (ds, hr) as select * from srcpart
PREHOOK: type: CREATEVIEW
-PREHOOK: Output: file:/var/folders/fe/fefl-ow3ElaEd1ns0G7jB0uewEQ/-Tmp-/charleschen/hive_2011-07-19_17-34-55_095_6852446605722181312/-mr-10000
+PREHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_13-18-48_577_8276668796293491021/-mr-10000
POSTHOOK: query: -- modifying definition of unpartitioned view
create or replace view v partitioned on (ds, hr) as select * from srcpart
POSTHOOK: type: CREATEVIEW
POSTHOOK: Output: default@v
-POSTHOOK: Output: file:/var/folders/fe/fefl-ow3ElaEd1ns0G7jB0uewEQ/-Tmp-/charleschen/hive_2011-07-19_17-34-55_095_6852446605722181312/-mr-10000
+POSTHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_13-18-48_577_8276668796293491021/-mr-10000
PREHOOK: query: alter view v add partition (ds='2008-04-08',hr='11')
-PREHOOK: type: QUERY
+PREHOOK: type: ALTERTABLE_ADDPARTS
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
PREHOOK: Input: default@v
POSTHOOK: query: alter view v add partition (ds='2008-04-08',hr='11')
-POSTHOOK: type: QUERY
+POSTHOOK: type: ALTERTABLE_ADDPARTS
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
POSTHOOK: Input: default@v
POSTHOOK: Output: default@v@ds=2008-04-08/hr=11
PREHOOK: query: alter view v add partition (ds='2008-04-08',hr='12')
-PREHOOK: type: QUERY
+PREHOOK: type: ALTERTABLE_ADDPARTS
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
PREHOOK: Input: default@v
POSTHOOK: query: alter view v add partition (ds='2008-04-08',hr='12')
-POSTHOOK: type: QUERY
+POSTHOOK: type: ALTERTABLE_ADDPARTS
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
POSTHOOK: Input: default@v
POSTHOOK: Output: default@v@ds=2008-04-08/hr=12
PREHOOK: query: select * from v where value='val_409' and ds='2008-04-08' and hr='11'
PREHOOK: type: QUERY
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
-PREHOOK: Output: file:/var/folders/fe/fefl-ow3ElaEd1ns0G7jB0uewEQ/-Tmp-/charleschen/hive_2011-07-19_17-34-55_760_500788128633787119/-mr-10000
+PREHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_13-18-48_962_3363144480244368033/-mr-10000
POSTHOOK: query: select * from v where value='val_409' and ds='2008-04-08' and hr='11'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
-POSTHOOK: Output: file:/var/folders/fe/fefl-ow3ElaEd1ns0G7jB0uewEQ/-Tmp-/charleschen/hive_2011-07-19_17-34-55_760_500788128633787119/-mr-10000
+POSTHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_13-18-48_962_3363144480244368033/-mr-10000
409 val_409 2008-04-08 11
409 val_409 2008-04-08 11
409 val_409 2008-04-08 11
@@ -98,14 +98,14 @@ hr string
# Detailed Table Information
Database: default
-Owner: charleschen
-CreateTime: Tue Jul 19 17:34:54 PDT 2011
+Owner: salbiz
+CreateTime: Mon Aug 01 13:18:48 PDT 2011
LastAccessTime: UNKNOWN
Protect Mode: None
Retention: 0
Table Type: VIRTUAL_VIEW
Table Parameters:
- transient_lastDdlTime 1311122095
+ transient_lastDdlTime 1312229928
# Storage Information
SerDe Library: null
@@ -128,20 +128,20 @@ ds=2008-04-08/hr=12
PREHOOK: query: -- altering partitioned view 1
create or replace view v partitioned on (ds, hr) as select value, ds, hr from srcpart
PREHOOK: type: CREATEVIEW
-PREHOOK: Output: file:/var/folders/fe/fefl-ow3ElaEd1ns0G7jB0uewEQ/-Tmp-/charleschen/hive_2011-07-19_17-35-01_367_3079170845179274932/-mr-10000
+PREHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_13-18-52_062_767516020030392810/-mr-10000
POSTHOOK: query: -- altering partitioned view 1
create or replace view v partitioned on (ds, hr) as select value, ds, hr from srcpart
POSTHOOK: type: CREATEVIEW
POSTHOOK: Output: default@v
-POSTHOOK: Output: file:/var/folders/fe/fefl-ow3ElaEd1ns0G7jB0uewEQ/-Tmp-/charleschen/hive_2011-07-19_17-35-01_367_3079170845179274932/-mr-10000
+POSTHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_13-18-52_062_767516020030392810/-mr-10000
PREHOOK: query: select * from v where value='val_409' and ds='2008-04-08' and hr='11'
PREHOOK: type: QUERY
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
-PREHOOK: Output: file:/var/folders/fe/fefl-ow3ElaEd1ns0G7jB0uewEQ/-Tmp-/charleschen/hive_2011-07-19_17-35-01_478_4136837350460982570/-mr-10000
+PREHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_13-18-52_118_4756632495796303928/-mr-10000
POSTHOOK: query: select * from v where value='val_409' and ds='2008-04-08' and hr='11'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
-POSTHOOK: Output: file:/var/folders/fe/fefl-ow3ElaEd1ns0G7jB0uewEQ/-Tmp-/charleschen/hive_2011-07-19_17-35-01_478_4136837350460982570/-mr-10000
+POSTHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_13-18-52_118_4756632495796303928/-mr-10000
val_409 2008-04-08 11
val_409 2008-04-08 11
val_409 2008-04-08 11
@@ -161,14 +161,14 @@ hr string
# Detailed Table Information
Database: default
-Owner: charleschen
-CreateTime: Tue Jul 19 17:34:54 PDT 2011
+Owner: salbiz
+CreateTime: Mon Aug 01 13:18:48 PDT 2011
LastAccessTime: UNKNOWN
Protect Mode: None
Retention: 0
Table Type: VIRTUAL_VIEW
Table Parameters:
- transient_lastDdlTime 1311122101
+ transient_lastDdlTime 1312229932
# Storage Information
SerDe Library: null
@@ -191,20 +191,20 @@ ds=2008-04-08/hr=12
PREHOOK: query: -- altering partitioned view 2
create or replace view v partitioned on (ds, hr) as select key, value, ds, hr from srcpart
PREHOOK: type: CREATEVIEW
-PREHOOK: Output: file:/var/folders/fe/fefl-ow3ElaEd1ns0G7jB0uewEQ/-Tmp-/charleschen/hive_2011-07-19_17-35-06_293_404398995477036687/-mr-10000
+PREHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_13-18-55_240_6937978698463164642/-mr-10000
POSTHOOK: query: -- altering partitioned view 2
create or replace view v partitioned on (ds, hr) as select key, value, ds, hr from srcpart
POSTHOOK: type: CREATEVIEW
POSTHOOK: Output: default@v
-POSTHOOK: Output: file:/var/folders/fe/fefl-ow3ElaEd1ns0G7jB0uewEQ/-Tmp-/charleschen/hive_2011-07-19_17-35-06_293_404398995477036687/-mr-10000
+POSTHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_13-18-55_240_6937978698463164642/-mr-10000
PREHOOK: query: select * from v where value='val_409' and ds='2008-04-08' and hr='11'
PREHOOK: type: QUERY
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
-PREHOOK: Output: file:/var/folders/fe/fefl-ow3ElaEd1ns0G7jB0uewEQ/-Tmp-/charleschen/hive_2011-07-19_17-35-06_369_6280534937916662695/-mr-10000
+PREHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_13-18-55_292_2125979258209260060/-mr-10000
POSTHOOK: query: select * from v where value='val_409' and ds='2008-04-08' and hr='11'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
-POSTHOOK: Output: file:/var/folders/fe/fefl-ow3ElaEd1ns0G7jB0uewEQ/-Tmp-/charleschen/hive_2011-07-19_17-35-06_369_6280534937916662695/-mr-10000
+POSTHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_13-18-55_292_2125979258209260060/-mr-10000
409 val_409 2008-04-08 11
409 val_409 2008-04-08 11
409 val_409 2008-04-08 11
@@ -225,14 +225,14 @@ hr string
# Detailed Table Information
Database: default
-Owner: charleschen
-CreateTime: Tue Jul 19 17:34:54 PDT 2011
+Owner: salbiz
+CreateTime: Mon Aug 01 13:18:48 PDT 2011
LastAccessTime: UNKNOWN
Protect Mode: None
Retention: 0
Table Type: VIRTUAL_VIEW
Table Parameters:
- transient_lastDdlTime 1311122106
+ transient_lastDdlTime 1312229935
# Storage Information
SerDe Library: null
@@ -269,11 +269,11 @@ POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@srcpart_temp
PREHOOK: query: create view v partitioned on (ds, hr) as select * from srcpart_temp
PREHOOK: type: CREATEVIEW
-PREHOOK: Output: file:/var/folders/fe/fefl-ow3ElaEd1ns0G7jB0uewEQ/-Tmp-/charleschen/hive_2011-07-19_17-35-11_359_8793253638417040051/-mr-10000
+PREHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_13-18-58_553_1250088755088975045/-mr-10000
POSTHOOK: query: create view v partitioned on (ds, hr) as select * from srcpart_temp
POSTHOOK: type: CREATEVIEW
POSTHOOK: Output: default@v
-POSTHOOK: Output: file:/var/folders/fe/fefl-ow3ElaEd1ns0G7jB0uewEQ/-Tmp-/charleschen/hive_2011-07-19_17-35-11_359_8793253638417040051/-mr-10000
+POSTHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_13-18-58_553_1250088755088975045/-mr-10000
PREHOOK: query: drop table srcpart_temp
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@srcpart_temp
@@ -285,12 +285,12 @@ POSTHOOK: Output: default@srcpart_temp
PREHOOK: query: -- v is now invalid
create or replace view v partitioned on (ds, hr) as select * from srcpart
PREHOOK: type: CREATEVIEW
-PREHOOK: Output: file:/var/folders/fe/fefl-ow3ElaEd1ns0G7jB0uewEQ/-Tmp-/charleschen/hive_2011-07-19_17-35-11_545_8300926509521526863/-mr-10000
+PREHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_13-18-58_663_3867562912120990708/-mr-10000
POSTHOOK: query: -- v is now invalid
create or replace view v partitioned on (ds, hr) as select * from srcpart
POSTHOOK: type: CREATEVIEW
POSTHOOK: Output: default@v
-POSTHOOK: Output: file:/var/folders/fe/fefl-ow3ElaEd1ns0G7jB0uewEQ/-Tmp-/charleschen/hive_2011-07-19_17-35-11_545_8300926509521526863/-mr-10000
+POSTHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_13-18-58_663_3867562912120990708/-mr-10000
PREHOOK: query: describe formatted v
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe formatted v
@@ -308,14 +308,14 @@ hr string
# Detailed Table Information
Database: default
-Owner: charleschen
-CreateTime: Tue Jul 19 17:35:11 PDT 2011
+Owner: salbiz
+CreateTime: Mon Aug 01 13:18:58 PDT 2011
LastAccessTime: UNKNOWN
Protect Mode: None
Retention: 0
Table Type: VIRTUAL_VIEW
Table Parameters:
- transient_lastDdlTime 1311122111
+ transient_lastDdlTime 1312229938
# Storage Information
SerDe Library: null
Modified: hive/trunk/ql/src/test/results/clientpositive/create_view_partitioned.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/create_view_partitioned.q.out?rev=1153926&r1=1153925&r2=1153926&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/create_view_partitioned.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/create_view_partitioned.q.out Thu Aug 4 16:57:17 2011
@@ -19,7 +19,7 @@ SELECT key, value
FROM src
WHERE key=86
PREHOOK: type: CREATEVIEW
-PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-02-09_12-39-20_202_459725770522554343/-mr-10000
+PREHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_13-20-47_043_6776108679163894004/-mr-10000
POSTHOOK: query: -- test partitioned view definition
-- (underlying table is not actually partitioned)
CREATE VIEW vp1
@@ -30,7 +30,7 @@ FROM src
WHERE key=86
POSTHOOK: type: CREATEVIEW
POSTHOOK: Output: default@vp1
-POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-02-09_12-39-20_202_459725770522554343/-mr-10000
+POSTHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_13-20-47_043_6776108679163894004/-mr-10000
PREHOOK: query: DESCRIBE EXTENDED vp1
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED vp1
@@ -38,7 +38,7 @@ POSTHOOK: type: DESCTABLE
key string
value string
-Detailed Table Information Table(tableName:vp1, dbName:default, owner:jsichi, createTime:1297283960, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:null), FieldSchema(name:value, type:string, comment:null)], location:null, inputFormat:org.apache.hadoop.mapred.SequenceFileInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:null, parameters:{}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[FieldSchema(name:value, type:string, comment:null)], parameters:{transient_lastDdlTime=1297283960}, viewOriginalText:SELECT key, value
+Detailed Table Information Table(tableName:vp1, dbName:default, owner:salbiz, createTime:1312230047, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:null), FieldSchema(name:value, type:string, comment:null)], location:null, inputFormat:org.apache.hadoop.mapred.SequenceFileInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:null, parameters:{}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[FieldSchema(name:value, type:string, comment:null)], parameters:{transient_lastDdlTime=1312230047}, viewOriginalText:SELECT key, value
FROM src
WHERE key=86, viewExpandedText:SELECT `src`.`key`, `src`.`value`
FROM `src`
@@ -58,14 +58,14 @@ value string
# Detailed Table Information
Database: default
-Owner: jsichi
-CreateTime: Wed Feb 09 12:39:20 PST 2011
+Owner: salbiz
+CreateTime: Mon Aug 01 13:20:47 PDT 2011
LastAccessTime: UNKNOWN
Protect Mode: None
Retention: 0
Table Type: VIRTUAL_VIEW
Table Parameters:
- transient_lastDdlTime 1297283960
+ transient_lastDdlTime 1312230047
# Storage Information
SerDe Library: null
@@ -86,38 +86,38 @@ WHERE `src`.`key`=86
PREHOOK: query: SELECT * FROM vp1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-02-09_12-39-20_956_4791033359314261882/-mr-10000
+PREHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_13-20-47_275_6455230636774618368/-mr-10000
POSTHOOK: query: SELECT * FROM vp1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-02-09_12-39-20_956_4791033359314261882/-mr-10000
+POSTHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_13-20-47_275_6455230636774618368/-mr-10000
86 val_86
PREHOOK: query: SELECT key FROM vp1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-02-09_12-39-28_000_2791859544795907188/-mr-10000
+PREHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_13-20-50_160_5990941147297889722/-mr-10000
POSTHOOK: query: SELECT key FROM vp1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-02-09_12-39-28_000_2791859544795907188/-mr-10000
+POSTHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_13-20-50_160_5990941147297889722/-mr-10000
86
PREHOOK: query: SELECT value FROM vp1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-02-09_12-39-34_032_4697733201868315411/-mr-10000
+PREHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_13-20-53_015_3606687068113847171/-mr-10000
POSTHOOK: query: SELECT value FROM vp1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-02-09_12-39-34_032_4697733201868315411/-mr-10000
+POSTHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_13-20-53_015_3606687068113847171/-mr-10000
val_86
PREHOOK: query: ALTER VIEW vp1
ADD PARTITION (value='val_86') PARTITION (value='val_xyz')
-PREHOOK: type: QUERY
+PREHOOK: type: ALTERTABLE_ADDPARTS
PREHOOK: Input: default@src
PREHOOK: Input: default@vp1
POSTHOOK: query: ALTER VIEW vp1
ADD PARTITION (value='val_86') PARTITION (value='val_xyz')
-POSTHOOK: type: QUERY
+POSTHOOK: type: ALTERTABLE_ADDPARTS
POSTHOOK: Input: default@src
POSTHOOK: Input: default@vp1
POSTHOOK: Output: default@vp1@value=val_86
@@ -125,14 +125,14 @@ POSTHOOK: Output: default@vp1@value=val_
PREHOOK: query: -- should work since we use IF NOT EXISTS
ALTER VIEW vp1
ADD IF NOT EXISTS PARTITION (value='val_xyz')
-PREHOOK: type: QUERY
+PREHOOK: type: ALTERTABLE_ADDPARTS
PREHOOK: Input: default@src
PREHOOK: Input: default@vp1
PREHOOK: Output: default@vp1@value=val_xyz
POSTHOOK: query: -- should work since we use IF NOT EXISTS
ALTER VIEW vp1
ADD IF NOT EXISTS PARTITION (value='val_xyz')
-POSTHOOK: type: QUERY
+POSTHOOK: type: ALTERTABLE_ADDPARTS
POSTHOOK: Input: default@src
POSTHOOK: Input: default@vp1
POSTHOOK: Output: default@vp1@value=val_xyz
@@ -152,7 +152,7 @@ PREHOOK: type: SHOW_TABLESTATUS
POSTHOOK: query: SHOW TABLE EXTENDED LIKE vp1
POSTHOOK: type: SHOW_TABLESTATUS
tableName:vp1
-owner:jsichi
+owner:salbiz
location:null
inputformat:org.apache.hadoop.mapred.SequenceFileInputFormat
outputformat:org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -165,7 +165,7 @@ PREHOOK: type: SHOW_TABLESTATUS
POSTHOOK: query: SHOW TABLE EXTENDED LIKE vp1 PARTITION(value='val_86')
POSTHOOK: type: SHOW_TABLESTATUS
tableName:vp1
-owner:jsichi
+owner:salbiz
location:null
inputformat:org.apache.hadoop.mapred.SequenceFileInputFormat
outputformat:org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -205,7 +205,7 @@ PREHOOK: query: -- Even though no partit
SELECT * FROM vp1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-02-09_12-39-41_066_3753395059950041338/-mr-10000
+PREHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_13-20-56_950_8837426272844736658/-mr-10000
POSTHOOK: query: -- Even though no partition predicate is specified in the next query,
-- the WHERE clause inside of the view should satisfy strict mode.
-- In other words, strict only applies to underlying tables
@@ -213,7 +213,7 @@ POSTHOOK: query: -- Even though no parti
SELECT * FROM vp1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-02-09_12-39-41_066_3753395059950041338/-mr-10000
+POSTHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_13-20-56_950_8837426272844736658/-mr-10000
86 val_86
PREHOOK: query: -- test a partitioned view on top of an underlying partitioned table,
-- but with only a suffix of the partitioning columns
@@ -221,7 +221,7 @@ CREATE VIEW vp2
PARTITIONED ON (hr)
AS SELECT * FROM srcpart WHERE key < 10
PREHOOK: type: CREATEVIEW
-PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-02-09_12-39-46_912_6988747758977470257/-mr-10000
+PREHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_13-20-59_803_7746731020346622943/-mr-10000
POSTHOOK: query: -- test a partitioned view on top of an underlying partitioned table,
-- but with only a suffix of the partitioning columns
CREATE VIEW vp2
@@ -229,7 +229,7 @@ PARTITIONED ON (hr)
AS SELECT * FROM srcpart WHERE key < 10
POSTHOOK: type: CREATEVIEW
POSTHOOK: Output: default@vp2
-POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-02-09_12-39-46_912_6988747758977470257/-mr-10000
+POSTHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_13-20-59_803_7746731020346622943/-mr-10000
PREHOOK: query: DESCRIBE FORMATTED vp2
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE FORMATTED vp2
@@ -247,14 +247,14 @@ hr string
# Detailed Table Information
Database: default
-Owner: jsichi
-CreateTime: Wed Feb 09 12:39:46 PST 2011
+Owner: salbiz
+CreateTime: Mon Aug 01 13:20:59 PDT 2011
LastAccessTime: UNKNOWN
Protect Mode: None
Retention: 0
Table Type: VIRTUAL_VIEW
Table Parameters:
- transient_lastDdlTime 1297283986
+ transient_lastDdlTime 1312230059
# Storage Information
SerDe Library: null
@@ -269,14 +269,14 @@ Sort Columns: []
View Original Text: SELECT * FROM srcpart WHERE key < 10
View Expanded Text: SELECT `srcpart`.`key`, `srcpart`.`value`, `srcpart`.`ds`, `srcpart`.`hr` FROM `srcpart` WHERE `srcpart`.`key` < 10
PREHOOK: query: ALTER VIEW vp2 ADD PARTITION (hr='11') PARTITION (hr='12')
-PREHOOK: type: QUERY
+PREHOOK: type: ALTERTABLE_ADDPARTS
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
PREHOOK: Input: default@vp2
POSTHOOK: query: ALTER VIEW vp2 ADD PARTITION (hr='11') PARTITION (hr='12')
-POSTHOOK: type: QUERY
+POSTHOOK: type: ALTERTABLE_ADDPARTS
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
@@ -288,12 +288,12 @@ PREHOOK: query: SELECT key FROM vp2 WHER
PREHOOK: type: QUERY
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
-PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-02-09_12-39-47_562_328778258675461955/-mr-10000
+PREHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_13-21-00_238_6603731309838545679/-mr-10000
POSTHOOK: query: SELECT key FROM vp2 WHERE hr='12' ORDER BY key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
-POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-02-09_12-39-47_562_328778258675461955/-mr-10000
+POSTHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_13-21-00_238_6603731309838545679/-mr-10000
0
0
0
@@ -323,7 +323,7 @@ SELECT key, value
FROM src
WHERE key=86
PREHOOK: type: CREATEVIEW
-PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-02-09_12-39-55_502_5144513026720493384/-mr-10000
+PREHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_13-21-03_359_4244173375300491792/-mr-10000
POSTHOOK: query: -- test a partitioned view where the PARTITIONED ON clause references
-- an imposed column name
CREATE VIEW vp3(k,v)
@@ -334,7 +334,7 @@ FROM src
WHERE key=86
POSTHOOK: type: CREATEVIEW
POSTHOOK: Output: default@vp3
-POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-02-09_12-39-55_502_5144513026720493384/-mr-10000
+POSTHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_13-21-03_359_4244173375300491792/-mr-10000
PREHOOK: query: DESCRIBE FORMATTED vp3
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE FORMATTED vp3
@@ -350,14 +350,14 @@ v string
# Detailed Table Information
Database: default
-Owner: jsichi
-CreateTime: Wed Feb 09 12:39:55 PST 2011
+Owner: salbiz
+CreateTime: Mon Aug 01 13:21:03 PDT 2011
LastAccessTime: UNKNOWN
Protect Mode: None
Retention: 0
Table Type: VIRTUAL_VIEW
Table Parameters:
- transient_lastDdlTime 1297283995
+ transient_lastDdlTime 1312230063
# Storage Information
SerDe Library: null
@@ -377,12 +377,12 @@ FROM `src`
WHERE `src`.`key`=86) `vp3`
PREHOOK: query: ALTER VIEW vp3
ADD PARTITION (v='val_86')
-PREHOOK: type: QUERY
+PREHOOK: type: ALTERTABLE_ADDPARTS
PREHOOK: Input: default@src
PREHOOK: Input: default@vp3
POSTHOOK: query: ALTER VIEW vp3
ADD PARTITION (v='val_86')
-POSTHOOK: type: QUERY
+POSTHOOK: type: ALTERTABLE_ADDPARTS
POSTHOOK: Input: default@src
POSTHOOK: Input: default@vp3
POSTHOOK: Output: default@vp3@v=val_86
Added: hive/trunk/ql/src/test/results/clientpositive/index_auth.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/index_auth.q.out?rev=1153926&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/index_auth.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/index_auth.q.out Thu Aug 4 16:57:17 2011
@@ -0,0 +1,72 @@
+PREHOOK: query: create table foobar(key int, value string) PARTITIONED BY (ds string, hr string)
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: create table foobar(key int, value string) PARTITIONED BY (ds string, hr string)
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: default@foobar
+PREHOOK: query: alter table foobar add partition (ds='2008-04-08',hr='12')
+PREHOOK: type: ALTERTABLE_ADDPARTS
+PREHOOK: Input: default@foobar
+POSTHOOK: query: alter table foobar add partition (ds='2008-04-08',hr='12')
+POSTHOOK: type: ALTERTABLE_ADDPARTS
+POSTHOOK: Input: default@foobar
+POSTHOOK: Output: default@foobar@ds=2008-04-08/hr=12
+PREHOOK: query: CREATE INDEX srcpart_auth_index ON TABLE foobar(key) as 'BITMAP' WITH DEFERRED REBUILD
+PREHOOK: type: CREATEINDEX
+POSTHOOK: query: CREATE INDEX srcpart_auth_index ON TABLE foobar(key) as 'BITMAP' WITH DEFERRED REBUILD
+POSTHOOK: type: CREATEINDEX
+PREHOOK: query: grant select on table foobar to user hive_test_user
+PREHOOK: type: GRANT_PRIVILEGE
+PREHOOK: Output: default@foobar
+POSTHOOK: query: grant select on table foobar to user hive_test_user
+POSTHOOK: type: GRANT_PRIVILEGE
+POSTHOOK: Output: default@foobar
+PREHOOK: query: grant select on table default__foobar_srcpart_auth_index__ to user hive_test_user
+PREHOOK: type: GRANT_PRIVILEGE
+PREHOOK: Output: default@default__foobar_srcpart_auth_index__
+POSTHOOK: query: grant select on table default__foobar_srcpart_auth_index__ to user hive_test_user
+POSTHOOK: type: GRANT_PRIVILEGE
+POSTHOOK: Output: default@default__foobar_srcpart_auth_index__
+PREHOOK: query: grant update on table default__foobar_srcpart_auth_index__ to user hive_test_user
+PREHOOK: type: GRANT_PRIVILEGE
+PREHOOK: Output: default@default__foobar_srcpart_auth_index__
+POSTHOOK: query: grant update on table default__foobar_srcpart_auth_index__ to user hive_test_user
+POSTHOOK: type: GRANT_PRIVILEGE
+POSTHOOK: Output: default@default__foobar_srcpart_auth_index__
+PREHOOK: query: grant create on table default__foobar_srcpart_auth_index__ to user hive_test_user
+PREHOOK: type: GRANT_PRIVILEGE
+PREHOOK: Output: default@default__foobar_srcpart_auth_index__
+POSTHOOK: query: grant create on table default__foobar_srcpart_auth_index__ to user hive_test_user
+POSTHOOK: type: GRANT_PRIVILEGE
+POSTHOOK: Output: default@default__foobar_srcpart_auth_index__
+PREHOOK: query: ALTER INDEX srcpart_auth_index ON foobar PARTITION (ds='2008-04-08',hr='12') REBUILD
+PREHOOK: type: ALTERINDEX_REBUILD
+PREHOOK: Input: default@foobar@ds=2008-04-08/hr=12
+PREHOOK: Output: default@default__foobar_srcpart_auth_index__@ds=2008-04-08/hr=12
+POSTHOOK: query: ALTER INDEX srcpart_auth_index ON foobar PARTITION (ds='2008-04-08',hr='12') REBUILD
+POSTHOOK: type: ALTERINDEX_REBUILD
+POSTHOOK: Input: default@foobar@ds=2008-04-08/hr=12
+POSTHOOK: Output: default@default__foobar_srcpart_auth_index__@ds=2008-04-08/hr=12
+POSTHOOK: Lineage: default__foobar_srcpart_auth_index__ PARTITION(ds=2008-04-08,hr=12)._bitmaps EXPRESSION [(foobar)foobar.FieldSchema(name:ROW__OFFSET__INSIDE__BLOCK, type:bigint, comment:), ]
+POSTHOOK: Lineage: default__foobar_srcpart_auth_index__ PARTITION(ds=2008-04-08,hr=12)._bucketname SIMPLE [(foobar)foobar.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
+POSTHOOK: Lineage: default__foobar_srcpart_auth_index__ PARTITION(ds=2008-04-08,hr=12)._offset SIMPLE [(foobar)foobar.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), ]
+POSTHOOK: Lineage: default__foobar_srcpart_auth_index__ PARTITION(ds=2008-04-08,hr=12).key SIMPLE [(foobar)foobar.FieldSchema(name:key, type:int, comment:null), ]
+PREHOOK: query: DROP INDEX srcpart_auth_index on foobar
+PREHOOK: type: DROPINDEX
+POSTHOOK: query: DROP INDEX srcpart_auth_index on foobar
+POSTHOOK: type: DROPINDEX
+POSTHOOK: Lineage: default__foobar_srcpart_auth_index__ PARTITION(ds=2008-04-08,hr=12)._bitmaps EXPRESSION [(foobar)foobar.FieldSchema(name:ROW__OFFSET__INSIDE__BLOCK, type:bigint, comment:), ]
+POSTHOOK: Lineage: default__foobar_srcpart_auth_index__ PARTITION(ds=2008-04-08,hr=12)._bucketname SIMPLE [(foobar)foobar.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
+POSTHOOK: Lineage: default__foobar_srcpart_auth_index__ PARTITION(ds=2008-04-08,hr=12)._offset SIMPLE [(foobar)foobar.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), ]
+POSTHOOK: Lineage: default__foobar_srcpart_auth_index__ PARTITION(ds=2008-04-08,hr=12).key SIMPLE [(foobar)foobar.FieldSchema(name:key, type:int, comment:null), ]
+PREHOOK: query: DROP TABLE foobar
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@foobar
+PREHOOK: Output: default@foobar
+POSTHOOK: query: DROP TABLE foobar
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@foobar
+POSTHOOK: Output: default@foobar
+POSTHOOK: Lineage: default__foobar_srcpart_auth_index__ PARTITION(ds=2008-04-08,hr=12)._bitmaps EXPRESSION [(foobar)foobar.FieldSchema(name:ROW__OFFSET__INSIDE__BLOCK, type:bigint, comment:), ]
+POSTHOOK: Lineage: default__foobar_srcpart_auth_index__ PARTITION(ds=2008-04-08,hr=12)._bucketname SIMPLE [(foobar)foobar.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
+POSTHOOK: Lineage: default__foobar_srcpart_auth_index__ PARTITION(ds=2008-04-08,hr=12)._offset SIMPLE [(foobar)foobar.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), ]
+POSTHOOK: Lineage: default__foobar_srcpart_auth_index__ PARTITION(ds=2008-04-08,hr=12).key SIMPLE [(foobar)foobar.FieldSchema(name:key, type:int, comment:null), ]
Modified: hive/trunk/ql/src/test/results/clientpositive/index_auto.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/index_auto.q.out?rev=1153926&r1=1153925&r2=1153926&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/index_auto.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/index_auto.q.out Thu Aug 4 16:57:17 2011
@@ -4,14 +4,14 @@ PREHOOK: query: -- try the query without
SELECT key, value FROM src WHERE key > 80 AND key < 100 ORDER BY key
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/var/folders/5V/5V4Zq77qGD4aSK9m8V3frVsFdRU/-Tmp-/salbiz/hive_2011-06-16_11-31-55_780_4816519858356075154/-mr-10000
+PREHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_13-37-00_120_1845343812793757087/-mr-10000
POSTHOOK: query: -- try the query without indexing, with manual indexing, and with automatic indexing
-- without indexing
SELECT key, value FROM src WHERE key > 80 AND key < 100 ORDER BY key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/var/folders/5V/5V4Zq77qGD4aSK9m8V3frVsFdRU/-Tmp-/salbiz/hive_2011-06-16_11-31-55_780_4816519858356075154/-mr-10000
+POSTHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_13-37-00_120_1845343812793757087/-mr-10000
82 val_82
83 val_83
83 val_83
@@ -36,11 +36,11 @@ PREHOOK: type: CREATEINDEX
POSTHOOK: query: CREATE INDEX src_index ON TABLE src(key) as 'COMPACT' WITH DEFERRED REBUILD
POSTHOOK: type: CREATEINDEX
PREHOOK: query: ALTER INDEX src_index ON src REBUILD
-PREHOOK: type: QUERY
+PREHOOK: type: ALTERINDEX_REBUILD
PREHOOK: Input: default@src
PREHOOK: Output: default@default__src_src_index__
POSTHOOK: query: ALTER INDEX src_index ON src REBUILD
-POSTHOOK: type: QUERY
+POSTHOOK: type: ALTERINDEX_REBUILD
POSTHOOK: Input: default@src
POSTHOOK: Output: default@default__src_src_index__
POSTHOOK: Lineage: default__src_src_index__._bucketname SIMPLE [(src)src.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
@@ -119,11 +119,11 @@ STAGE PLANS:
PREHOOK: query: SELECT key, value FROM src WHERE key > 80 AND key < 100 ORDER BY key
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/var/folders/5V/5V4Zq77qGD4aSK9m8V3frVsFdRU/-Tmp-/salbiz/hive_2011-06-16_11-32-19_097_338721874120393596/-mr-10000
+PREHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_13-37-10_468_944814349250189106/-mr-10000
POSTHOOK: query: SELECT key, value FROM src WHERE key > 80 AND key < 100 ORDER BY key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/var/folders/5V/5V4Zq77qGD4aSK9m8V3frVsFdRU/-Tmp-/salbiz/hive_2011-06-16_11-32-19_097_338721874120393596/-mr-10000
+POSTHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_13-37-10_468_944814349250189106/-mr-10000
POSTHOOK: Lineage: default__src_src_index__._bucketname SIMPLE [(src)src.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
POSTHOOK: Lineage: default__src_src_index__._offsets EXPRESSION [(src)src.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), ]
POSTHOOK: Lineage: default__src_src_index__.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
@@ -202,13 +202,13 @@ STAGE PLANS:
Move Operator
files:
hdfs directory: true
- destination: file:/Users/salbiz/dev/hive/build/ql/scratchdir/hive_2011-06-16_11-32-26_654_6395896159951974498/-ext-10000
+ destination: file:/data/users/salbiz/apache-hive/build/ql/scratchdir/hive_2011-08-01_13-37-13_653_5881274831276521153/-ext-10000
Stage: Stage-2
Move Operator
files:
hdfs directory: true
- destination: file:/var/folders/5V/5V4Zq77qGD4aSK9m8V3frVsFdRU/-Tmp-/salbiz/hive_2011-06-16_11-32-26_508_4648561266114809466/-mr-10002
+ destination: file:/tmp/salbiz/hive_2011-08-01_13-37-13_483_7682220259922771428/-mr-10002
Stage: Stage-1
Map Reduce
@@ -253,7 +253,7 @@ STAGE PLANS:
Stage: Stage-4
Map Reduce
Alias -> Map Operator Tree:
- file:/Users/salbiz/dev/hive/build/ql/scratchdir/hive_2011-06-16_11-32-26_654_6395896159951974498/-ext-10001
+ file:/data/users/salbiz/apache-hive/build/ql/scratchdir/hive_2011-08-01_13-37-13_653_5881274831276521153/-ext-10001
File Output Operator
compressed: false
GlobalTableId: 0
@@ -270,12 +270,12 @@ PREHOOK: query: SELECT key, value FROM s
PREHOOK: type: QUERY
PREHOOK: Input: default@default__src_src_index__
PREHOOK: Input: default@src
-PREHOOK: Output: file:/var/folders/5V/5V4Zq77qGD4aSK9m8V3frVsFdRU/-Tmp-/salbiz/hive_2011-06-16_11-32-26_783_5543392894671342055/-mr-10000
+PREHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_13-37-13_735_2387366913526120875/-mr-10000
POSTHOOK: query: SELECT key, value FROM src WHERE key > 80 AND key < 100 ORDER BY key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@default__src_src_index__
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/var/folders/5V/5V4Zq77qGD4aSK9m8V3frVsFdRU/-Tmp-/salbiz/hive_2011-06-16_11-32-26_783_5543392894671342055/-mr-10000
+POSTHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_13-37-13_735_2387366913526120875/-mr-10000
POSTHOOK: Lineage: default__src_src_index__._bucketname SIMPLE [(src)src.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
POSTHOOK: Lineage: default__src_src_index__._offsets EXPRESSION [(src)src.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), ]
POSTHOOK: Lineage: default__src_src_index__.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
Modified: hive/trunk/ql/src/test/results/clientpositive/index_auto_file_format.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/index_auto_file_format.q.out?rev=1153926&r1=1153925&r2=1153926&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/index_auto_file_format.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/index_auto_file_format.q.out Thu Aug 4 16:57:17 2011
@@ -5,11 +5,11 @@ POSTHOOK: query: -- test automatic use o
CREATE INDEX src_index ON TABLE src(key) as 'COMPACT' WITH DEFERRED REBUILD
POSTHOOK: type: CREATEINDEX
PREHOOK: query: ALTER INDEX src_index ON src REBUILD
-PREHOOK: type: QUERY
+PREHOOK: type: ALTERINDEX_REBUILD
PREHOOK: Input: default@src
PREHOOK: Output: default@default__src_src_index__
POSTHOOK: query: ALTER INDEX src_index ON src REBUILD
-POSTHOOK: type: QUERY
+POSTHOOK: type: ALTERINDEX_REBUILD
POSTHOOK: Input: default@src
POSTHOOK: Output: default@default__src_src_index__
POSTHOOK: Lineage: default__src_src_index__._bucketname SIMPLE [(src)src.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
@@ -69,13 +69,13 @@ STAGE PLANS:
Move Operator
files:
hdfs directory: true
- destination: file:/Users/salbiz/dev/hive/build/ql/scratchdir/hive_2011-06-15_16-16-40_411_4815505312955631583/-ext-10000
+ destination: file:/data/users/salbiz/apache-hive/build/ql/scratchdir/hive_2011-08-01_13-37-24_381_685307162174223318/-ext-10000
Stage: Stage-2
Move Operator
files:
hdfs directory: true
- destination: file:/var/folders/5V/5V4Zq77qGD4aSK9m8V3frVsFdRU/-Tmp-/salbiz/hive_2011-06-15_16-16-40_275_2821007696524201513/-mr-10002
+ destination: file:/tmp/salbiz/hive_2011-08-01_13-37-24_263_9017662523845199950/-mr-10002
Stage: Stage-1
Map Reduce
@@ -120,7 +120,7 @@ STAGE PLANS:
Stage: Stage-4
Map Reduce
Alias -> Map Operator Tree:
- file:/Users/salbiz/dev/hive/build/ql/scratchdir/hive_2011-06-15_16-16-40_411_4815505312955631583/-ext-10001
+ file:/data/users/salbiz/apache-hive/build/ql/scratchdir/hive_2011-08-01_13-37-24_381_685307162174223318/-ext-10001
File Output Operator
compressed: false
GlobalTableId: 0
@@ -137,12 +137,12 @@ PREHOOK: query: SELECT key, value FROM s
PREHOOK: type: QUERY
PREHOOK: Input: default@default__src_src_index__
PREHOOK: Input: default@src
-PREHOOK: Output: file:/var/folders/5V/5V4Zq77qGD4aSK9m8V3frVsFdRU/-Tmp-/salbiz/hive_2011-06-15_16-16-40_552_3841543983008204664/-mr-10000
+PREHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_13-37-24_461_5373775406213291047/-mr-10000
POSTHOOK: query: SELECT key, value FROM src WHERE key=86 ORDER BY key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@default__src_src_index__
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/var/folders/5V/5V4Zq77qGD4aSK9m8V3frVsFdRU/-Tmp-/salbiz/hive_2011-06-15_16-16-40_552_3841543983008204664/-mr-10000
+POSTHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_13-37-24_461_5373775406213291047/-mr-10000
POSTHOOK: Lineage: default__src_src_index__._bucketname SIMPLE [(src)src.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
POSTHOOK: Lineage: default__src_src_index__._offsets EXPRESSION [(src)src.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), ]
POSTHOOK: Lineage: default__src_src_index__.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
@@ -201,13 +201,13 @@ STAGE PLANS:
Move Operator
files:
hdfs directory: true
- destination: file:/Users/salbiz/dev/hive/build/ql/scratchdir/hive_2011-06-15_16-16-55_117_7145184773994968051/-ext-10000
+ destination: file:/data/users/salbiz/apache-hive/build/ql/scratchdir/hive_2011-08-01_13-37-30_303_4801597731332090380/-ext-10000
Stage: Stage-2
Move Operator
files:
hdfs directory: true
- destination: file:/var/folders/5V/5V4Zq77qGD4aSK9m8V3frVsFdRU/-Tmp-/salbiz/hive_2011-06-15_16-16-54_980_8246330207973926102/-mr-10002
+ destination: file:/tmp/salbiz/hive_2011-08-01_13-37-30_186_8063570361706828169/-mr-10002
Stage: Stage-1
Map Reduce
@@ -252,7 +252,7 @@ STAGE PLANS:
Stage: Stage-4
Map Reduce
Alias -> Map Operator Tree:
- file:/Users/salbiz/dev/hive/build/ql/scratchdir/hive_2011-06-15_16-16-55_117_7145184773994968051/-ext-10001
+ file:/data/users/salbiz/apache-hive/build/ql/scratchdir/hive_2011-08-01_13-37-30_303_4801597731332090380/-ext-10001
File Output Operator
compressed: false
GlobalTableId: 0
@@ -269,12 +269,12 @@ PREHOOK: query: SELECT key, value FROM s
PREHOOK: type: QUERY
PREHOOK: Input: default@default__src_src_index__
PREHOOK: Input: default@src
-PREHOOK: Output: file:/var/folders/5V/5V4Zq77qGD4aSK9m8V3frVsFdRU/-Tmp-/salbiz/hive_2011-06-15_16-16-55_246_5645043276355070579/-mr-10000
+PREHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_13-37-30_383_864005246441147882/-mr-10000
POSTHOOK: query: SELECT key, value FROM src WHERE key=86 ORDER BY key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@default__src_src_index__
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/var/folders/5V/5V4Zq77qGD4aSK9m8V3frVsFdRU/-Tmp-/salbiz/hive_2011-06-15_16-16-55_246_5645043276355070579/-mr-10000
+POSTHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_13-37-30_383_864005246441147882/-mr-10000
POSTHOOK: Lineage: default__src_src_index__._bucketname SIMPLE [(src)src.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
POSTHOOK: Lineage: default__src_src_index__._offsets EXPRESSION [(src)src.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), ]
POSTHOOK: Lineage: default__src_src_index__.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
Modified: hive/trunk/ql/src/test/results/clientpositive/index_auto_mult_tables.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/index_auto_mult_tables.q.out?rev=1153926&r1=1153925&r2=1153926&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/index_auto_mult_tables.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/index_auto_mult_tables.q.out Thu Aug 4 16:57:17 2011
@@ -86,7 +86,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/heyongqiang/hive_2011-08-02_16-19-55_365_8913305197058109052/-mr-10002
+ file:/tmp/salbiz/hive_2011-08-03_11-40-52_874_7254064139212481338/-mr-10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -119,7 +119,7 @@ PREHOOK: Input: default@srcpart@ds=2008-
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
-PREHOOK: Output: file:/tmp/heyongqiang/hive_2011-08-02_16-19-55_771_8532877932740371902/-mr-10000
+PREHOOK: Output: file:/tmp/salbiz/hive_2011-08-03_11-40-53_275_1751206294928260840/-mr-10000
POSTHOOK: query: SELECT a.key, a.value FROM src a JOIN srcpart b ON (a.key = b.key) WHERE a.key > 80 AND a.key < 100 AND b.key > 70 AND b.key < 90 ORDER BY a.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
@@ -127,7 +127,7 @@ POSTHOOK: Input: default@srcpart@ds=2008
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
-POSTHOOK: Output: file:/tmp/heyongqiang/hive_2011-08-02_16-19-55_771_8532877932740371902/-mr-10000
+POSTHOOK: Output: file:/tmp/salbiz/hive_2011-08-03_11-40-53_275_1751206294928260840/-mr-10000
82 val_82
82 val_82
82 val_82
@@ -181,11 +181,11 @@ PREHOOK: type: CREATEINDEX
POSTHOOK: query: CREATE INDEX src_index ON TABLE src(key) as 'BITMAP' WITH DEFERRED REBUILD
POSTHOOK: type: CREATEINDEX
PREHOOK: query: ALTER INDEX src_index ON src REBUILD
-PREHOOK: type: QUERY
+PREHOOK: type: ALTERINDEX_REBUILD
PREHOOK: Input: default@src
PREHOOK: Output: default@default__src_src_index__
POSTHOOK: query: ALTER INDEX src_index ON src REBUILD
-POSTHOOK: type: QUERY
+POSTHOOK: type: ALTERINDEX_REBUILD
POSTHOOK: Input: default@src
POSTHOOK: Output: default@default__src_src_index__
POSTHOOK: Lineage: default__src_src_index__._bitmaps EXPRESSION [(src)src.FieldSchema(name:ROW__OFFSET__INSIDE__BLOCK, type:bigint, comment:), ]
@@ -201,7 +201,7 @@ POSTHOOK: Lineage: default__src_src_inde
POSTHOOK: Lineage: default__src_src_index__._offset SIMPLE [(src)src.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), ]
POSTHOOK: Lineage: default__src_src_index__.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
PREHOOK: query: ALTER INDEX srcpart_index ON srcpart REBUILD
-PREHOOK: type: QUERY
+PREHOOK: type: ALTERINDEX_REBUILD
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
@@ -211,7 +211,7 @@ PREHOOK: Output: default@default__srcpar
PREHOOK: Output: default@default__srcpart_srcpart_index__@ds=2008-04-09/hr=11
PREHOOK: Output: default@default__srcpart_srcpart_index__@ds=2008-04-09/hr=12
POSTHOOK: query: ALTER INDEX srcpart_index ON srcpart REBUILD
-POSTHOOK: type: QUERY
+POSTHOOK: type: ALTERINDEX_REBUILD
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
@@ -338,7 +338,7 @@ STAGE PLANS:
Move Operator
files:
hdfs directory: true
- destination: file:/tmp/heyongqiang/hive_2011-08-02_16-20-29_082_9210885468563163297/-mr-10003
+ destination: file:/tmp/salbiz/hive_2011-08-03_11-41-25_407_3322108409707049422/-mr-10003
Stage: Stage-1
Map Reduce
@@ -415,7 +415,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/heyongqiang/hive_2011-08-02_16-20-29_082_9210885468563163297/-mr-10002
+ file:/tmp/salbiz/hive_2011-08-03_11-41-25_407_3322108409707049422/-mr-10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -521,7 +521,7 @@ STAGE PLANS:
Move Operator
files:
hdfs directory: true
- destination: file:/tmp/heyongqiang/hive_2011-08-02_16-20-29_082_9210885468563163297/-mr-10004
+ destination: file:/tmp/salbiz/hive_2011-08-03_11-41-25_407_3322108409707049422/-mr-10004
Stage: Stage-0
Fetch Operator
@@ -540,7 +540,7 @@ PREHOOK: Input: default@srcpart@ds=2008-
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
-PREHOOK: Output: file:/tmp/heyongqiang/hive_2011-08-02_16-20-29_990_218311290925215201/-mr-10000
+PREHOOK: Output: file:/tmp/salbiz/hive_2011-08-03_11-41-26_398_2468484527777301186/-mr-10000
POSTHOOK: query: SELECT a.key, a.value FROM src a JOIN srcpart b ON (a.key = b.key) WHERE a.key > 80 AND a.key < 100 AND b.key > 70 AND b.key < 90 ORDER BY a.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@default__src_src_index__
@@ -553,7 +553,7 @@ POSTHOOK: Input: default@srcpart@ds=2008
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
-POSTHOOK: Output: file:/tmp/heyongqiang/hive_2011-08-02_16-20-29_990_218311290925215201/-mr-10000
+POSTHOOK: Output: file:/tmp/salbiz/hive_2011-08-03_11-41-26_398_2468484527777301186/-mr-10000
POSTHOOK: Lineage: default__src_src_index__._bitmaps EXPRESSION [(src)src.FieldSchema(name:ROW__OFFSET__INSIDE__BLOCK, type:bigint, comment:), ]
POSTHOOK: Lineage: default__src_src_index__._bucketname SIMPLE [(src)src.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
POSTHOOK: Lineage: default__src_src_index__._offset SIMPLE [(src)src.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), ]
Modified: hive/trunk/ql/src/test/results/clientpositive/index_auto_mult_tables_compact.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/index_auto_mult_tables_compact.q.out?rev=1153926&r1=1153925&r2=1153926&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/index_auto_mult_tables_compact.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/index_auto_mult_tables_compact.q.out Thu Aug 4 16:57:17 2011
@@ -86,7 +86,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/var/folders/5V/5V4Zq77qGD4aSK9m8V3frVsFdRU/-Tmp-/salbiz/hive_2011-07-25_11-50-36_433_5542638095321427981/-mr-10002
+ file:/tmp/salbiz/hive_2011-08-03_11-41-42_789_1684955694193338986/-mr-10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -119,7 +119,7 @@ PREHOOK: Input: default@srcpart@ds=2008-
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
-PREHOOK: Output: file:/var/folders/5V/5V4Zq77qGD4aSK9m8V3frVsFdRU/-Tmp-/salbiz/hive_2011-07-25_11-50-36_581_3747634705901315299/-mr-10000
+PREHOOK: Output: file:/tmp/salbiz/hive_2011-08-03_11-41-42_970_2859185952217320568/-mr-10000
POSTHOOK: query: SELECT a.key, a.value FROM src a JOIN srcpart b ON (a.key = b.key) WHERE a.key > 80 AND a.key < 100 AND b.key > 70 AND b.key < 90 ORDER BY a.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
@@ -127,7 +127,7 @@ POSTHOOK: Input: default@srcpart@ds=2008
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
-POSTHOOK: Output: file:/var/folders/5V/5V4Zq77qGD4aSK9m8V3frVsFdRU/-Tmp-/salbiz/hive_2011-07-25_11-50-36_581_3747634705901315299/-mr-10000
+POSTHOOK: Output: file:/tmp/salbiz/hive_2011-08-03_11-41-42_970_2859185952217320568/-mr-10000
82 val_82
82 val_82
82 val_82
@@ -181,11 +181,11 @@ PREHOOK: type: CREATEINDEX
POSTHOOK: query: CREATE INDEX src_index ON TABLE src(key) as 'COMPACT' WITH DEFERRED REBUILD
POSTHOOK: type: CREATEINDEX
PREHOOK: query: ALTER INDEX src_index ON src REBUILD
-PREHOOK: type: QUERY
+PREHOOK: type: ALTERINDEX_REBUILD
PREHOOK: Input: default@src
PREHOOK: Output: default@default__src_src_index__
POSTHOOK: query: ALTER INDEX src_index ON src REBUILD
-POSTHOOK: type: QUERY
+POSTHOOK: type: ALTERINDEX_REBUILD
POSTHOOK: Input: default@src
POSTHOOK: Output: default@default__src_src_index__
POSTHOOK: Lineage: default__src_src_index__._bucketname SIMPLE [(src)src.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
@@ -199,7 +199,7 @@ POSTHOOK: Lineage: default__src_src_inde
POSTHOOK: Lineage: default__src_src_index__._offsets EXPRESSION [(src)src.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), ]
POSTHOOK: Lineage: default__src_src_index__.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
PREHOOK: query: ALTER INDEX srcpart_index ON srcpart REBUILD
-PREHOOK: type: QUERY
+PREHOOK: type: ALTERINDEX_REBUILD
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
@@ -209,7 +209,7 @@ PREHOOK: Output: default@default__srcpar
PREHOOK: Output: default@default__srcpart_srcpart_index__@ds=2008-04-09/hr=11
PREHOOK: Output: default@default__srcpart_srcpart_index__@ds=2008-04-09/hr=12
POSTHOOK: query: ALTER INDEX srcpart_index ON srcpart REBUILD
-POSTHOOK: type: QUERY
+POSTHOOK: type: ALTERINDEX_REBUILD
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
@@ -289,13 +289,13 @@ STAGE PLANS:
Move Operator
files:
hdfs directory: true
- destination: file:/Users/salbiz/dev/hive/build/ql/scratchdir/hive_2011-07-25_11-51-35_494_7032523871014076058/-ext-10000
+ destination: file:/data/users/salbiz/apache-hive/build/ql/scratchdir/hive_2011-08-03_11-42-13_662_1841905286836798924/-ext-10000
Stage: Stage-4
Move Operator
files:
hdfs directory: true
- destination: file:/var/folders/5V/5V4Zq77qGD4aSK9m8V3frVsFdRU/-Tmp-/salbiz/hive_2011-07-25_11-51-34_909_919679217594371878/-mr-10003
+ destination: file:/tmp/salbiz/hive_2011-08-03_11-42-12_993_7173516009867952993/-mr-10003
Stage: Stage-1
Map Reduce
@@ -372,7 +372,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/var/folders/5V/5V4Zq77qGD4aSK9m8V3frVsFdRU/-Tmp-/salbiz/hive_2011-07-25_11-51-34_909_919679217594371878/-mr-10002
+ file:/tmp/salbiz/hive_2011-08-03_11-42-12_993_7173516009867952993/-mr-10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -396,7 +396,7 @@ STAGE PLANS:
Stage: Stage-6
Map Reduce
Alias -> Map Operator Tree:
- file:/Users/salbiz/dev/hive/build/ql/scratchdir/hive_2011-07-25_11-51-35_494_7032523871014076058/-ext-10001
+ file:/data/users/salbiz/apache-hive/build/ql/scratchdir/hive_2011-08-03_11-42-13_662_1841905286836798924/-ext-10001
File Output Operator
compressed: false
GlobalTableId: 0
@@ -438,18 +438,18 @@ STAGE PLANS:
Move Operator
files:
hdfs directory: true
- destination: file:/Users/salbiz/dev/hive/build/ql/scratchdir/hive_2011-07-25_11-51-35_590_77690777312722941/-ext-10000
+ destination: file:/data/users/salbiz/apache-hive/build/ql/scratchdir/hive_2011-08-03_11-42-13_773_6752137651963996196/-ext-10000
Stage: Stage-9
Move Operator
files:
hdfs directory: true
- destination: file:/var/folders/5V/5V4Zq77qGD4aSK9m8V3frVsFdRU/-Tmp-/salbiz/hive_2011-07-25_11-51-34_909_919679217594371878/-mr-10004
+ destination: file:/tmp/salbiz/hive_2011-08-03_11-42-12_993_7173516009867952993/-mr-10004
Stage: Stage-11
Map Reduce
Alias -> Map Operator Tree:
- file:/Users/salbiz/dev/hive/build/ql/scratchdir/hive_2011-07-25_11-51-35_590_77690777312722941/-ext-10001
+ file:/data/users/salbiz/apache-hive/build/ql/scratchdir/hive_2011-08-03_11-42-13_773_6752137651963996196/-ext-10001
File Output Operator
compressed: false
GlobalTableId: 0
@@ -474,7 +474,7 @@ PREHOOK: Input: default@srcpart@ds=2008-
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
-PREHOOK: Output: file:/var/folders/5V/5V4Zq77qGD4aSK9m8V3frVsFdRU/-Tmp-/salbiz/hive_2011-07-25_11-51-35_695_2966341580180350713/-mr-10000
+PREHOOK: Output: file:/tmp/salbiz/hive_2011-08-03_11-42-13_878_115379500838443509/-mr-10000
POSTHOOK: query: SELECT a.key, a.value FROM src a JOIN srcpart b ON (a.key = b.key) WHERE a.key > 80 AND a.key < 100 AND b.key > 70 AND b.key < 90 ORDER BY a.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@default__src_src_index__
@@ -487,7 +487,7 @@ POSTHOOK: Input: default@srcpart@ds=2008
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
-POSTHOOK: Output: file:/var/folders/5V/5V4Zq77qGD4aSK9m8V3frVsFdRU/-Tmp-/salbiz/hive_2011-07-25_11-51-35_695_2966341580180350713/-mr-10000
+POSTHOOK: Output: file:/tmp/salbiz/hive_2011-08-03_11-42-13_878_115379500838443509/-mr-10000
POSTHOOK: Lineage: default__src_src_index__._bucketname SIMPLE [(src)src.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
POSTHOOK: Lineage: default__src_src_index__._offsets EXPRESSION [(src)src.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), ]
POSTHOOK: Lineage: default__src_src_index__.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
Modified: hive/trunk/ql/src/test/results/clientpositive/index_auto_multiple.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/index_auto_multiple.q.out?rev=1153926&r1=1153925&r2=1153926&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/index_auto_multiple.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/index_auto_multiple.q.out Thu Aug 4 16:57:17 2011
@@ -11,22 +11,22 @@ PREHOOK: type: CREATEINDEX
POSTHOOK: query: CREATE INDEX src_val_index ON TABLE src(value) as 'COMPACT' WITH DEFERRED REBUILD
POSTHOOK: type: CREATEINDEX
PREHOOK: query: ALTER INDEX src_key_index ON src REBUILD
-PREHOOK: type: QUERY
+PREHOOK: type: ALTERINDEX_REBUILD
PREHOOK: Input: default@src
PREHOOK: Output: default@default__src_src_key_index__
POSTHOOK: query: ALTER INDEX src_key_index ON src REBUILD
-POSTHOOK: type: QUERY
+POSTHOOK: type: ALTERINDEX_REBUILD
POSTHOOK: Input: default@src
POSTHOOK: Output: default@default__src_src_key_index__
POSTHOOK: Lineage: default__src_src_key_index__._bucketname SIMPLE [(src)src.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
POSTHOOK: Lineage: default__src_src_key_index__._offsets EXPRESSION [(src)src.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), ]
POSTHOOK: Lineage: default__src_src_key_index__.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
PREHOOK: query: ALTER INDEX src_val_index ON src REBUILD
-PREHOOK: type: QUERY
+PREHOOK: type: ALTERINDEX_REBUILD
PREHOOK: Input: default@src
PREHOOK: Output: default@default__src_src_val_index__
POSTHOOK: query: ALTER INDEX src_val_index ON src REBUILD
-POSTHOOK: type: QUERY
+POSTHOOK: type: ALTERINDEX_REBUILD
POSTHOOK: Input: default@src
POSTHOOK: Output: default@default__src_src_val_index__
POSTHOOK: Lineage: default__src_src_key_index__._bucketname SIMPLE [(src)src.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
@@ -92,13 +92,13 @@ STAGE PLANS:
Move Operator
files:
hdfs directory: true
- destination: file:/Users/salbiz/dev/hive/build/ql/scratchdir/hive_2011-06-15_16-17-27_086_2000600421786753633/-ext-10000
+ destination: file:/data/users/salbiz/apache-hive/build/ql/scratchdir/hive_2011-08-01_13-37-45_571_1388780604523388920/-ext-10000
Stage: Stage-2
Move Operator
files:
hdfs directory: true
- destination: file:/var/folders/5V/5V4Zq77qGD4aSK9m8V3frVsFdRU/-Tmp-/salbiz/hive_2011-06-15_16-17-26_945_142379732782210508/-mr-10002
+ destination: file:/tmp/salbiz/hive_2011-08-01_13-37-45_441_8809194499630065291/-mr-10002
Stage: Stage-1
Map Reduce
@@ -143,7 +143,7 @@ STAGE PLANS:
Stage: Stage-4
Map Reduce
Alias -> Map Operator Tree:
- file:/Users/salbiz/dev/hive/build/ql/scratchdir/hive_2011-06-15_16-17-27_086_2000600421786753633/-ext-10001
+ file:/data/users/salbiz/apache-hive/build/ql/scratchdir/hive_2011-08-01_13-37-45_571_1388780604523388920/-ext-10001
File Output Operator
compressed: false
GlobalTableId: 0
@@ -160,12 +160,12 @@ PREHOOK: query: SELECT key, value FROM s
PREHOOK: type: QUERY
PREHOOK: Input: default@default__src_src_key_index__
PREHOOK: Input: default@src
-PREHOOK: Output: file:/var/folders/5V/5V4Zq77qGD4aSK9m8V3frVsFdRU/-Tmp-/salbiz/hive_2011-06-15_16-17-27_239_7970970441956583684/-mr-10000
+PREHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_13-37-45_651_8938647545203357334/-mr-10000
POSTHOOK: query: SELECT key, value FROM src WHERE key=86 ORDER BY key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@default__src_src_key_index__
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/var/folders/5V/5V4Zq77qGD4aSK9m8V3frVsFdRU/-Tmp-/salbiz/hive_2011-06-15_16-17-27_239_7970970441956583684/-mr-10000
+POSTHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_13-37-45_651_8938647545203357334/-mr-10000
POSTHOOK: Lineage: default__src_src_key_index__._bucketname SIMPLE [(src)src.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
POSTHOOK: Lineage: default__src_src_key_index__._offsets EXPRESSION [(src)src.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), ]
POSTHOOK: Lineage: default__src_src_key_index__.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
Modified: hive/trunk/ql/src/test/results/clientpositive/index_auto_partitioned.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/index_auto_partitioned.q.out?rev=1153926&r1=1153925&r2=1153926&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/index_auto_partitioned.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/index_auto_partitioned.q.out Thu Aug 4 16:57:17 2011
@@ -5,7 +5,7 @@ POSTHOOK: query: -- test automatic use o
CREATE INDEX src_part_index ON TABLE srcpart(key) as 'COMPACT' WITH DEFERRED REBUILD
POSTHOOK: type: CREATEINDEX
PREHOOK: query: ALTER INDEX src_part_index ON srcpart REBUILD
-PREHOOK: type: QUERY
+PREHOOK: type: ALTERINDEX_REBUILD
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
@@ -15,7 +15,7 @@ PREHOOK: Output: default@default__srcpar
PREHOOK: Output: default@default__srcpart_src_part_index__@ds=2008-04-09/hr=11
PREHOOK: Output: default@default__srcpart_src_part_index__@ds=2008-04-09/hr=12
POSTHOOK: query: ALTER INDEX src_part_index ON srcpart REBUILD
-POSTHOOK: type: QUERY
+POSTHOOK: type: ALTERINDEX_REBUILD
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
@@ -81,13 +81,13 @@ STAGE PLANS:
Move Operator
files:
hdfs directory: true
- destination: file:/Users/salbiz/dev/hive/build/ql/scratchdir/hive_2011-06-15_16-00-25_190_7313794997314528333/-ext-10000
+ destination: file:/data/users/salbiz/apache-hive/build/ql/scratchdir/hive_2011-08-01_13-38-11_108_7095217129648103584/-ext-10000
Stage: Stage-2
Move Operator
files:
hdfs directory: true
- destination: file:/var/folders/5V/5V4Zq77qGD4aSK9m8V3frVsFdRU/-Tmp-/salbiz/hive_2011-06-15_16-00-24_901_7521678807552233457/-mr-10002
+ destination: file:/tmp/salbiz/hive_2011-08-01_13-38-10_834_396766414838846531/-mr-10002
Stage: Stage-1
Map Reduce
@@ -132,7 +132,7 @@ STAGE PLANS:
Stage: Stage-4
Map Reduce
Alias -> Map Operator Tree:
- file:/Users/salbiz/dev/hive/build/ql/scratchdir/hive_2011-06-15_16-00-25_190_7313794997314528333/-ext-10001
+ file:/data/users/salbiz/apache-hive/build/ql/scratchdir/hive_2011-08-01_13-38-11_108_7095217129648103584/-ext-10001
File Output Operator
compressed: false
GlobalTableId: 0
@@ -151,14 +151,14 @@ PREHOOK: Input: default@default__srcpart
PREHOOK: Input: default@default__srcpart_src_part_index__@ds=2008-04-09/hr=12
PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
-PREHOOK: Output: file:/var/folders/5V/5V4Zq77qGD4aSK9m8V3frVsFdRU/-Tmp-/salbiz/hive_2011-06-15_16-00-25_389_6851974893264734752/-mr-10000
+PREHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_13-38-11_214_7966551397812297662/-mr-10000
POSTHOOK: query: SELECT key, value FROM srcpart WHERE key=86 AND ds='2008-04-09' ORDER BY key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@default__srcpart_src_part_index__@ds=2008-04-09/hr=11
POSTHOOK: Input: default@default__srcpart_src_part_index__@ds=2008-04-09/hr=12
POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
-POSTHOOK: Output: file:/var/folders/5V/5V4Zq77qGD4aSK9m8V3frVsFdRU/-Tmp-/salbiz/hive_2011-06-15_16-00-25_389_6851974893264734752/-mr-10000
+POSTHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_13-38-11_214_7966551397812297662/-mr-10000
POSTHOOK: Lineage: default__srcpart_src_part_index__ PARTITION(ds=2008-04-09,hr=12)._bucketname SIMPLE [(srcpart)srcpart.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
POSTHOOK: Lineage: default__srcpart_src_part_index__ PARTITION(ds=2008-04-09,hr=12)._offsets EXPRESSION [(srcpart)srcpart.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), ]
POSTHOOK: Lineage: default__srcpart_src_part_index__ PARTITION(ds=2008-04-09,hr=12).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]