Modified: hive/branches/cbo/ql/src/test/queries/clientpositive/alter_char1.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientpositive/alter_char1.q?rev=1621031&r1=1621030&r2=1621031&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientpositive/alter_char1.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientpositive/alter_char1.q Thu Aug 28 03:15:13 2014 @@ -1,34 +1,35 @@ -- SORT_QUERY_RESULTS -drop table alter_char_1; +create database ac; -create table alter_char_1 (key string, value string); -insert overwrite table alter_char_1 +create table ac.alter_char_1 (key string, value string); +insert overwrite table ac.alter_char_1 select key, value from src order by key limit 5; -select * from alter_char_1; +select * from ac.alter_char_1; -- change column to char -alter table alter_char_1 change column value value char(20); +alter table ac.alter_char_1 change column value value char(20); -- contents should still look the same -select * from alter_char_1; +select * from ac.alter_char_1; -- change column to smaller char -alter table alter_char_1 change column value value char(3); +alter table ac.alter_char_1 change column value value char(3); -- value column should be truncated now -select * from alter_char_1; +select * from ac.alter_char_1; -- change back to bigger char -alter table alter_char_1 change column value value char(20); +alter table ac.alter_char_1 change column value value char(20); -- column values should be full size again -select * from alter_char_1; +select * from ac.alter_char_1; -- add char column -alter table alter_char_1 add columns (key2 int, value2 char(10)); -select * from alter_char_1; +alter table ac.alter_char_1 add columns (key2 int, value2 char(10)); +select * from ac.alter_char_1; -insert overwrite table alter_char_1 +insert overwrite table ac.alter_char_1 select key, value, key, value from src order by key limit 5; -select * from alter_char_1; +select * from ac.alter_char_1; -drop table alter_char_1; +drop table ac.alter_char_1; +drop database ac;
Modified: hive/branches/cbo/ql/src/test/queries/clientpositive/alter_index.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientpositive/alter_index.q?rev=1621031&r1=1621030&r2=1621031&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientpositive/alter_index.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientpositive/alter_index.q Thu Aug 28 03:15:13 2014 @@ -1,11 +1,11 @@ drop index src_index_8 on src; -create index src_index_8 on table src(key) as 'compact' WITH DEFERRED REBUILD IDXPROPERTIES ("prop1"="val1", "prop2"="val2"); +create index src_index_8 on table default.src(key) as 'compact' WITH DEFERRED REBUILD IDXPROPERTIES ("prop1"="val1", "prop2"="val2"); desc extended default__src_src_index_8__; -alter index src_index_8 on src set IDXPROPERTIES ("prop1"="val1_new", "prop3"="val3"); +alter index src_index_8 on default.src set IDXPROPERTIES ("prop1"="val1_new", "prop3"="val3"); desc extended default__src_src_index_8__; -drop index src_index_8 on src; +drop index src_index_8 on default.src; show tables; Modified: hive/branches/cbo/ql/src/test/queries/clientpositive/alter_partition_coltype.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientpositive/alter_partition_coltype.q?rev=1621031&r1=1621030&r2=1621031&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientpositive/alter_partition_coltype.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientpositive/alter_partition_coltype.q Thu Aug 28 03:15:13 2014 @@ -51,18 +51,23 @@ desc alter_coltype partition (dt='100', drop table alter_coltype; -create table alterdynamic_part_table(intcol string) partitioned by (partcol1 string, partcol2 string); +create database pt; + +create table pt.alterdynamic_part_table(intcol string) partitioned by (partcol1 string, partcol2 string); set hive.exec.dynamic.partition.mode=nonstrict; -insert into table alterdynamic_part_table partition(partcol1, partcol2) select '1', '1', '1' from src where key=150 limit 5; +insert into table pt.alterdynamic_part_table partition(partcol1, partcol2) select '1', '1', '1' from src where key=150 limit 5; + +insert into table pt.alterdynamic_part_table partition(partcol1, partcol2) select '1', '2', '1' from src where key=150 limit 5; +insert into table pt.alterdynamic_part_table partition(partcol1, partcol2) select NULL, '1', '1' from src where key=150 limit 5; -insert into table alterdynamic_part_table partition(partcol1, partcol2) select '1', '2', '1' from src where key=150 limit 5; -insert into table alterdynamic_part_table partition(partcol1, partcol2) select NULL, '1', '1' from src where key=150 limit 5; +alter table pt.alterdynamic_part_table partition column (partcol1 int); -alter table alterdynamic_part_table partition column (partcol1 int); +explain extended select intcol from pt.alterdynamic_part_table where partcol1='1' and partcol2='1'; -explain extended select intcol from alterdynamic_part_table where partcol1='1' and partcol2='1'; +explain extended select intcol from pt.alterdynamic_part_table where (partcol1='2' and partcol2='1')or (partcol1='1' and partcol2='__HIVE_DEFAULT_PARTITION__'); +select intcol from pt.alterdynamic_part_table where (partcol1='2' and partcol2='1')or (partcol1='1' and partcol2='__HIVE_DEFAULT_PARTITION__'); -explain extended select intcol from alterdynamic_part_table where (partcol1='2' and partcol2='1')or (partcol1='1' and partcol2='__HIVE_DEFAULT_PARTITION__'); -select intcol from alterdynamic_part_table where (partcol1='2' and partcol2='1')or (partcol1='1' and partcol2='__HIVE_DEFAULT_PARTITION__'); \ No newline at end of file +drop table pt.alterdynamic_part_table; +drop database pt; Modified: hive/branches/cbo/ql/src/test/queries/clientpositive/alter_skewed_table.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientpositive/alter_skewed_table.q?rev=1621031&r1=1621030&r2=1621031&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientpositive/alter_skewed_table.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientpositive/alter_skewed_table.q Thu Aug 28 03:15:13 2014 @@ -1,6 +1,6 @@ set hive.mapred.supports.subdirectories=true; -create table original (key STRING, value STRING); +create table original (key STRING, value STRING); describe formatted original; @@ -10,23 +10,27 @@ describe formatted original; drop table original; -create table original2 (key STRING, value STRING) ; +create database skew_test; -describe formatted original2; +create table skew_test.original2 (key STRING, value STRING) ; -alter table original2 SKEWED BY (key, value) ON ((1,1),(5,6)); +describe formatted skew_test.original2; -describe formatted original2; +alter table skew_test.original2 SKEWED BY (key, value) ON ((1,1),(5,6)); -drop table original2; +describe formatted skew_test.original2; -create table original3 (key STRING, value STRING) SKEWED BY (key, value) ON ((1,1),(5,6)); +drop table skew_test.original2; -describe formatted original3; +create table skew_test.original3 (key STRING, value STRING) SKEWED BY (key, value) ON ((1,1),(5,6)); -alter table original3 not skewed; +describe formatted skew_test.original3; -describe formatted original3; +alter table skew_test.original3 not skewed; -drop table original3; +describe formatted skew_test.original3; + +drop table skew_test.original3; + +drop database skew_test; Modified: hive/branches/cbo/ql/src/test/queries/clientpositive/alter_varchar1.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientpositive/alter_varchar1.q?rev=1621031&r1=1621030&r2=1621031&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientpositive/alter_varchar1.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientpositive/alter_varchar1.q Thu Aug 28 03:15:13 2014 @@ -1,34 +1,35 @@ -- SORT_QUERY_RESULTS -drop table alter_varchar_1; +create database avc; -create table alter_varchar_1 (key string, value string); -insert overwrite table alter_varchar_1 +create table avc.alter_varchar_1 (key string, value string); +insert overwrite table avc.alter_varchar_1 select key, value from src order by key limit 5; -select * from alter_varchar_1; +select * from avc.alter_varchar_1; -- change column to varchar -alter table alter_varchar_1 change column value value varchar(20); +alter table avc.alter_varchar_1 change column value value varchar(20); -- contents should still look the same -select * from alter_varchar_1; +select * from avc.alter_varchar_1; -- change column to smaller varchar -alter table alter_varchar_1 change column value value varchar(3); +alter table avc.alter_varchar_1 change column value value varchar(3); -- value column should be truncated now -select * from alter_varchar_1; +select * from avc.alter_varchar_1; -- change back to bigger varchar -alter table alter_varchar_1 change column value value varchar(20); +alter table avc.alter_varchar_1 change column value value varchar(20); -- column values should be full size again -select * from alter_varchar_1; +select * from avc.alter_varchar_1; -- add varchar column -alter table alter_varchar_1 add columns (key2 int, value2 varchar(10)); -select * from alter_varchar_1; +alter table avc.alter_varchar_1 add columns (key2 int, value2 varchar(10)); +select * from avc.alter_varchar_1; -insert overwrite table alter_varchar_1 +insert overwrite table avc.alter_varchar_1 select key, value, key, value from src order by key limit 5; -select * from alter_varchar_1; +select * from avc.alter_varchar_1; -drop table alter_varchar_1; +drop table avc.alter_varchar_1; +drop database avc; Modified: hive/branches/cbo/ql/src/test/queries/clientpositive/alter_view_as_select.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientpositive/alter_view_as_select.q?rev=1621031&r1=1621030&r2=1621031&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientpositive/alter_view_as_select.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientpositive/alter_view_as_select.q Thu Aug 28 03:15:13 2014 @@ -1,13 +1,16 @@ -DROP VIEW testView; -CREATE VIEW testView as SELECT * FROM srcpart; -DESCRIBE FORMATTED testView; +CREATE DATABASE tv; +CREATE VIEW tv.testView as SELECT * FROM srcpart; +DESCRIBE FORMATTED tv.testView; -ALTER VIEW testView AS SELECT value FROM src WHERE key=86; -DESCRIBE FORMATTED testView; +ALTER VIEW tv.testView AS SELECT value FROM src WHERE key=86; +DESCRIBE FORMATTED tv.testView; -ALTER VIEW testView AS +ALTER VIEW tv.testView AS SELECT * FROM src WHERE key > 80 AND key < 100 ORDER BY key, value LIMIT 10; -DESCRIBE FORMATTED testView; +DESCRIBE FORMATTED tv.testView; + +DROP VIEW tv.testView; +DROP DATABASE tv; \ No newline at end of file Modified: hive/branches/cbo/ql/src/test/queries/clientpositive/alter_view_rename.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientpositive/alter_view_rename.q?rev=1621031&r1=1621030&r2=1621031&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientpositive/alter_view_rename.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientpositive/alter_view_rename.q Thu Aug 28 03:15:13 2014 @@ -1,10 +1,16 @@ +CREATE DATABASE tv1; +CREATE DATABASE tv2; + CREATE TABLE invites (foo INT, bar STRING) PARTITIONED BY (ds STRING); -CREATE VIEW view1 as SELECT * FROM invites; -DESCRIBE EXTENDED view1; +CREATE VIEW tv1.view1 as SELECT * FROM invites; +DESCRIBE EXTENDED tv1.view1; -ALTER VIEW view1 RENAME TO view2; -DESCRIBE EXTENDED view2; -SELECT * FROM view2; +ALTER VIEW tv1.view1 RENAME TO tv2.view2; +DESCRIBE EXTENDED tv2.view2; +SELECT * FROM tv2.view2; DROP TABLE invites; -DROP VIEW view2; \ No newline at end of file +DROP VIEW tv2.view2; + +DROP DATABASE tv1; +DROP DATABASE tv2; Modified: hive/branches/cbo/ql/src/test/queries/clientpositive/archive_multi.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientpositive/archive_multi.q?rev=1621031&r1=1621030&r2=1621031&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientpositive/archive_multi.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientpositive/archive_multi.q Thu Aug 28 03:15:13 2014 @@ -1,42 +1,41 @@ set hive.archive.enabled = true; set hive.enforce.bucketing = true; -drop table tstsrc; -drop table tstsrcpart; +create database ac_test; -create table tstsrc like src; -insert overwrite table tstsrc select key, value from src; +create table ac_test.tstsrc like default.src; +insert overwrite table ac_test.tstsrc select key, value from default.src; -create table tstsrcpart like srcpart; +create table ac_test.tstsrcpart like default.srcpart; -insert overwrite table tstsrcpart partition (ds='2008-04-08', hr='11') -select key, value from srcpart where ds='2008-04-08' and hr='11'; +insert overwrite table ac_test.tstsrcpart partition (ds='2008-04-08', hr='11') +select key, value from default.srcpart where ds='2008-04-08' and hr='11'; -insert overwrite table tstsrcpart partition (ds='2008-04-08', hr='12') -select key, value from srcpart where ds='2008-04-08' and hr='12'; +insert overwrite table ac_test.tstsrcpart partition (ds='2008-04-08', hr='12') +select key, value from default.srcpart where ds='2008-04-08' and hr='12'; -insert overwrite table tstsrcpart partition (ds='2008-04-09', hr='11') -select key, value from srcpart where ds='2008-04-09' and hr='11'; +insert overwrite table ac_test.tstsrcpart partition (ds='2008-04-09', hr='11') +select key, value from default.srcpart where ds='2008-04-09' and hr='11'; -insert overwrite table tstsrcpart partition (ds='2008-04-09', hr='12') -select key, value from srcpart where ds='2008-04-09' and hr='12'; +insert overwrite table ac_test.tstsrcpart partition (ds='2008-04-09', hr='12') +select key, value from default.srcpart where ds='2008-04-09' and hr='12'; -- EXCLUDE_HADOOP_MAJOR_VERSIONS(0.17, 0.18, 0.19) SELECT SUM(hash(col)) FROM (SELECT transform(*) using 'tr "\t" "_"' AS col -FROM (SELECT * FROM tstsrcpart WHERE ds='2008-04-08') subq1) subq2; +FROM (SELECT * FROM ac_test.tstsrcpart WHERE ds='2008-04-08') subq1) subq2; -ALTER TABLE tstsrcpart ARCHIVE PARTITION (ds='2008-04-08'); +ALTER TABLE ac_test.tstsrcpart ARCHIVE PARTITION (ds='2008-04-08'); SELECT SUM(hash(col)) FROM (SELECT transform(*) using 'tr "\t" "_"' AS col -FROM (SELECT * FROM tstsrcpart WHERE ds='2008-04-08') subq1) subq2; +FROM (SELECT * FROM ac_test.tstsrcpart WHERE ds='2008-04-08') subq1) subq2; -SELECT key, count(1) FROM tstsrcpart WHERE ds='2008-04-08' AND hr='12' AND key='0' GROUP BY key; +SELECT key, count(1) FROM ac_test.tstsrcpart WHERE ds='2008-04-08' AND hr='12' AND key='0' GROUP BY key; -SELECT * FROM tstsrcpart a JOIN tstsrc b ON a.key=b.key +SELECT * FROM ac_test.tstsrcpart a JOIN ac_test.tstsrc b ON a.key=b.key WHERE a.ds='2008-04-08' AND a.hr='12' AND a.key='0'; -ALTER TABLE tstsrcpart UNARCHIVE PARTITION (ds='2008-04-08'); +ALTER TABLE ac_test.tstsrcpart UNARCHIVE PARTITION (ds='2008-04-08'); SELECT SUM(hash(col)) FROM (SELECT transform(*) using 'tr "\t" "_"' AS col -FROM (SELECT * FROM tstsrcpart WHERE ds='2008-04-08') subq1) subq2; +FROM (SELECT * FROM ac_test.tstsrcpart WHERE ds='2008-04-08') subq1) subq2; Modified: hive/branches/cbo/ql/src/test/queries/clientpositive/create_or_replace_view.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientpositive/create_or_replace_view.q?rev=1621031&r1=1621030&r2=1621031&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientpositive/create_or_replace_view.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientpositive/create_or_replace_view.q Thu Aug 28 03:15:13 2014 @@ -1,32 +1,39 @@ -drop view v; -create view v as select * from srcpart; -describe formatted v; +create database vt; + +create view vt.v as select * from srcpart; +describe formatted vt.v; -- modifying definition of unpartitioned view -create or replace view v partitioned on (ds, hr) as select * from srcpart; -alter view v add partition (ds='2008-04-08',hr='11'); -alter view v add partition (ds='2008-04-08',hr='12'); -select * from v where value='val_409' and ds='2008-04-08' and hr='11'; -describe formatted v; -show partitions v; +create or replace view vt.v partitioned on (ds, hr) as select * from srcpart; +alter view vt.v add partition (ds='2008-04-08',hr='11'); +alter view vt.v add partition (ds='2008-04-08',hr='12'); +select * from vt.v where value='val_409' and ds='2008-04-08' and hr='11'; +describe formatted vt.v; +show partitions vt.v; + +alter view vt.v drop partition (ds='2008-04-08',hr='11'); +alter view vt.v drop partition (ds='2008-04-08',hr='12'); +show partitions vt.v; -- altering partitioned view 1 -create or replace view v partitioned on (ds, hr) as select value, ds, hr from srcpart; -select * from v where value='val_409' and ds='2008-04-08' and hr='11'; -describe formatted v; -show partitions v; +create or replace view vt.v partitioned on (ds, hr) as select value, ds, hr from srcpart; +select * from vt.v where value='val_409' and ds='2008-04-08' and hr='11'; +describe formatted vt.v; +show partitions vt.v; -- altering partitioned view 2 -create or replace view v partitioned on (ds, hr) as select key, value, ds, hr from srcpart; -select * from v where value='val_409' and ds='2008-04-08' and hr='11'; -describe formatted v; -show partitions v; -drop view v; +create or replace view vt.v partitioned on (ds, hr) as select key, value, ds, hr from srcpart; +select * from vt.v where value='val_409' and ds='2008-04-08' and hr='11'; +describe formatted vt.v; +show partitions vt.v; +drop view vt.v; -- updating to fix view with invalid definition create table srcpart_temp like srcpart; -create view v partitioned on (ds, hr) as select * from srcpart_temp; -drop table srcpart_temp; -- v is now invalid -create or replace view v partitioned on (ds, hr) as select * from srcpart; -describe formatted v; -drop view v; \ No newline at end of file +create view vt.v partitioned on (ds, hr) as select * from srcpart_temp; +drop table srcpart_temp; -- vt.v is now invalid +create or replace view vt.v partitioned on (ds, hr) as select * from srcpart; +describe formatted vt.v; +drop view vt.v; + +drop database vt; \ No newline at end of file Modified: hive/branches/cbo/ql/src/test/queries/clientpositive/drop_multi_partitions.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientpositive/drop_multi_partitions.q?rev=1621031&r1=1621030&r2=1621031&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientpositive/drop_multi_partitions.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientpositive/drop_multi_partitions.q Thu Aug 28 03:15:13 2014 @@ -1,17 +1,23 @@ -create table mp (a string) partitioned by (b string, c string); +create database dmp; -alter table mp add partition (b='1', c='1'); -alter table mp add partition (b='1', c='2'); -alter table mp add partition (b='2', c='2'); +create table dmp.mp (a string) partitioned by (b string, c string); -show partitions mp; +alter table dmp.mp add partition (b='1', c='1'); +alter table dmp.mp add partition (b='1', c='2'); +alter table dmp.mp add partition (b='2', c='2'); -explain extended alter table mp drop partition (b='1'); -alter table mp drop partition (b='1'); +show partitions dmp.mp; -show partitions mp; +explain extended alter table dmp.mp drop partition (b='1'); +alter table dmp.mp drop partition (b='1'); + +show partitions dmp.mp; set hive.exec.drop.ignorenonexistent=false; -alter table mp drop if exists partition (b='3'); +alter table dmp.mp drop if exists partition (b='3'); + +show partitions dmp.mp; + +drop table dmp.mp; -show partitions mp; +drop database dmp; Modified: hive/branches/cbo/ql/src/test/queries/clientpositive/exchange_partition.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientpositive/exchange_partition.q?rev=1621031&r1=1621030&r2=1621031&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientpositive/exchange_partition.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientpositive/exchange_partition.q Thu Aug 28 03:15:13 2014 @@ -1,12 +1,15 @@ -CREATE TABLE exchange_part_test1 (f1 string) PARTITIONED BY (ds STRING); -CREATE TABLE exchange_part_test2 (f1 string) PARTITIONED BY (ds STRING); -SHOW PARTITIONS exchange_part_test1; -SHOW PARTITIONS exchange_part_test2; +create database ex1; +create database ex2; -ALTER TABLE exchange_part_test2 ADD PARTITION (ds='2013-04-05'); -SHOW PARTITIONS exchange_part_test1; -SHOW PARTITIONS exchange_part_test2; +CREATE TABLE ex1.exchange_part_test1 (f1 string) PARTITIONED BY (ds STRING); +CREATE TABLE ex2.exchange_part_test2 (f1 string) PARTITIONED BY (ds STRING); +SHOW PARTITIONS ex1.exchange_part_test1; +SHOW PARTITIONS ex2.exchange_part_test2; -ALTER TABLE exchange_part_test1 EXCHANGE PARTITION (ds='2013-04-05') WITH TABLE exchange_part_test2; -SHOW PARTITIONS exchange_part_test1; -SHOW PARTITIONS exchange_part_test2; +ALTER TABLE ex2.exchange_part_test2 ADD PARTITION (ds='2013-04-05'); +SHOW PARTITIONS ex1.exchange_part_test1; +SHOW PARTITIONS ex2.exchange_part_test2; + +ALTER TABLE ex1.exchange_part_test1 EXCHANGE PARTITION (ds='2013-04-05') WITH TABLE ex2.exchange_part_test2; +SHOW PARTITIONS ex1.exchange_part_test1; +SHOW PARTITIONS ex2.exchange_part_test2; Modified: hive/branches/cbo/ql/src/test/queries/clientpositive/index_auto_empty.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientpositive/index_auto_empty.q?rev=1621031&r1=1621030&r2=1621031&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientpositive/index_auto_empty.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientpositive/index_auto_empty.q Thu Aug 28 03:15:13 2014 @@ -1,22 +1,25 @@ -- Test to ensure that an empty index result is propagated correctly +CREATE DATABASE it; -- Create temp, and populate it with some values in src. -CREATE TABLE temp(key STRING, val STRING) STORED AS TEXTFILE; +CREATE TABLE it.temp(key STRING, val STRING) STORED AS TEXTFILE; set hive.stats.dbclass=fs; --- Build an index on temp. -CREATE INDEX temp_index ON TABLE temp(key) as 'COMPACT' WITH DEFERRED REBUILD; -ALTER INDEX temp_index ON temp REBUILD; +-- Build an index on it.temp. +CREATE INDEX temp_index ON TABLE it.temp(key) as 'COMPACT' WITH DEFERRED REBUILD; +ALTER INDEX temp_index ON it.temp REBUILD; SET hive.input.format=org.apache.hadoop.hive.ql.io.HiveInputFormat; SET hive.optimize.index.filter=true; SET hive.optimize.index.filter.compact.minsize=0; -- query should not return any values -SELECT * FROM default__temp_temp_index__ WHERE key = 86; -EXPLAIN SELECT * FROM temp WHERE key = 86; -SELECT * FROM temp WHERE key = 86; +SELECT * FROM it.it__temp_temp_index__ WHERE key = 86; +EXPLAIN SELECT * FROM it.temp WHERE key = 86; +SELECT * FROM it.temp WHERE key = 86; SET hive.input.format=org.apache.hadoop.hive.ql.io.HiveInputFormat; SET hive.optimize.index.filter=false; -DROP table temp; +DROP table it.temp; + +DROP DATABASE it; Modified: hive/branches/cbo/ql/src/test/queries/clientpositive/input46.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientpositive/input46.q?rev=1621031&r1=1621030&r2=1621031&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientpositive/input46.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientpositive/input46.q Thu Aug 28 03:15:13 2014 @@ -1,6 +1,6 @@ create database if not exists table_in_database_creation; create table table_in_database_creation.test1 as select * from src limit 1; -create table `table_in_database_creation.test2` as select * from src limit 1; +create table `table_in_database_creation`.`test2` as select * from src limit 1; create table table_in_database_creation.test3 (a string); -create table `table_in_database_creation.test4` (a string); +create table `table_in_database_creation`.`test4` (a string); drop database table_in_database_creation cascade; \ No newline at end of file Modified: hive/branches/cbo/ql/src/test/queries/clientpositive/optimize_nullscan.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientpositive/optimize_nullscan.q?rev=1621031&r1=1621030&r2=1621031&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientpositive/optimize_nullscan.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientpositive/optimize_nullscan.q Thu Aug 28 03:15:13 2014 @@ -1,3 +1,5 @@ +-- SORT_BEFORE_DIFF + explain extended select key from src where false; select key from src where false; Modified: hive/branches/cbo/ql/src/test/queries/clientpositive/touch.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientpositive/touch.q?rev=1621031&r1=1621030&r2=1621031&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientpositive/touch.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientpositive/touch.q Thu Aug 28 03:15:13 2014 @@ -1,17 +1,17 @@ -drop table tstsrc; -drop table tstsrcpart; +create database tc; -create table tstsrc like src; -insert overwrite table tstsrc select key, value from src; +create table tc.tstsrc like default.src; +insert overwrite table tc.tstsrc select key, value from default.src; -create table tstsrcpart like srcpart; -insert overwrite table tstsrcpart partition (ds='2008-04-08', hr='12') -select key, value from srcpart where ds='2008-04-08' and hr='12'; +create table tc.tstsrcpart like default.srcpart; +insert overwrite table tc.tstsrcpart partition (ds='2008-04-08', hr='12') +select key, value from default.srcpart where ds='2008-04-08' and hr='12'; +ALTER TABLE tc.tstsrc TOUCH; +ALTER TABLE tc.tstsrcpart TOUCH; +ALTER TABLE tc.tstsrcpart TOUCH PARTITION (ds='2008-04-08', hr='12'); -ALTER TABLE tstsrc TOUCH; -ALTER TABLE tstsrcpart TOUCH; -ALTER TABLE tstsrcpart TOUCH PARTITION (ds='2008-04-08', hr='12'); +drop table tc.tstsrc; +drop table tc.tstsrcpart; -drop table tstsrc; -drop table tstsrcpart; +drop database tc; Modified: hive/branches/cbo/ql/src/test/queries/clientpositive/unset_table_view_property.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientpositive/unset_table_view_property.q?rev=1621031&r1=1621030&r2=1621031&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientpositive/unset_table_view_property.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientpositive/unset_table_view_property.q Thu Aug 28 03:15:13 2014 @@ -1,64 +1,71 @@ -CREATE TABLE testTable(col1 INT, col2 INT); -SHOW TBLPROPERTIES testTable; +CREATE DATABASE vt; + +CREATE TABLE vt.testTable(col1 INT, col2 INT); +SHOW TBLPROPERTIES vt.testTable; -- UNSET TABLE PROPERTIES -ALTER TABLE testTable SET TBLPROPERTIES ('a'='1', 'c'='3'); -SHOW TBLPROPERTIES testTable; +ALTER TABLE vt.testTable SET TBLPROPERTIES ('a'='1', 'c'='3'); +SHOW TBLPROPERTIES vt.testTable; -- UNSET all the properties -ALTER TABLE testTable UNSET TBLPROPERTIES ('a', 'c'); -SHOW TBLPROPERTIES testTable; +ALTER TABLE vt.testTable UNSET TBLPROPERTIES ('a', 'c'); +SHOW TBLPROPERTIES vt.testTable; -ALTER TABLE testTable SET TBLPROPERTIES ('a'='1', 'c'='3', 'd'='4'); -SHOW TBLPROPERTIES testTable; +ALTER TABLE vt.testTable SET TBLPROPERTIES ('a'='1', 'c'='3', 'd'='4'); +SHOW TBLPROPERTIES vt.testTable; -- UNSET a subset of the properties -ALTER TABLE testTable UNSET TBLPROPERTIES ('a', 'd'); -SHOW TBLPROPERTIES testTable; +ALTER TABLE vt.testTable UNSET TBLPROPERTIES ('a', 'd'); +SHOW TBLPROPERTIES vt.testTable; -- the same property being UNSET multiple times -ALTER TABLE testTable UNSET TBLPROPERTIES ('c', 'c', 'c'); -SHOW TBLPROPERTIES testTable; +ALTER TABLE vt.testTable UNSET TBLPROPERTIES ('c', 'c', 'c'); +SHOW TBLPROPERTIES vt.testTable; -ALTER TABLE testTable SET TBLPROPERTIES ('a'='1', 'b' = '2', 'c'='3', 'd'='4'); -SHOW TBLPROPERTIES testTable; +ALTER TABLE vt.testTable SET TBLPROPERTIES ('a'='1', 'b' = '2', 'c'='3', 'd'='4'); +SHOW TBLPROPERTIES vt.testTable; -- UNSET a subset of the properties and some non-existed properties using IF EXISTS -ALTER TABLE testTable UNSET TBLPROPERTIES IF EXISTS ('b', 'd', 'b', 'f'); -SHOW TBLPROPERTIES testTable; +ALTER TABLE vt.testTable UNSET TBLPROPERTIES IF EXISTS ('b', 'd', 'b', 'f'); +SHOW TBLPROPERTIES vt.testTable; -- UNSET a subset of the properties and some non-existed properties using IF EXISTS -ALTER TABLE testTable UNSET TBLPROPERTIES IF EXISTS ('b', 'd', 'c', 'f', 'x', 'y', 'z'); -SHOW TBLPROPERTIES testTable; +ALTER TABLE vt.testTable UNSET TBLPROPERTIES IF EXISTS ('b', 'd', 'c', 'f', 'x', 'y', 'z'); +SHOW TBLPROPERTIES vt.testTable; + +DROP TABLE vt.testTable; -- UNSET VIEW PROPERTIES -CREATE VIEW testView AS SELECT value FROM src WHERE key=86; -ALTER VIEW testView SET TBLPROPERTIES ('propA'='100', 'propB'='200'); -SHOW TBLPROPERTIES testView; +CREATE VIEW vt.testView AS SELECT value FROM src WHERE key=86; +ALTER VIEW vt.testView SET TBLPROPERTIES ('propA'='100', 'propB'='200'); +SHOW TBLPROPERTIES vt.testView; -- UNSET all the properties -ALTER VIEW testView UNSET TBLPROPERTIES ('propA', 'propB'); -SHOW TBLPROPERTIES testView; +ALTER VIEW vt.testView UNSET TBLPROPERTIES ('propA', 'propB'); +SHOW TBLPROPERTIES vt.testView; -ALTER VIEW testView SET TBLPROPERTIES ('propA'='100', 'propC'='300', 'propD'='400'); -SHOW TBLPROPERTIES testView; +ALTER VIEW vt.testView SET TBLPROPERTIES ('propA'='100', 'propC'='300', 'propD'='400'); +SHOW TBLPROPERTIES vt.testView; -- UNSET a subset of the properties -ALTER VIEW testView UNSET TBLPROPERTIES ('propA', 'propC'); -SHOW TBLPROPERTIES testView; +ALTER VIEW vt.testView UNSET TBLPROPERTIES ('propA', 'propC'); +SHOW TBLPROPERTIES vt.testView; -- the same property being UNSET multiple times -ALTER VIEW testView UNSET TBLPROPERTIES ('propD', 'propD', 'propD'); -SHOW TBLPROPERTIES testView; +ALTER VIEW vt.testView UNSET TBLPROPERTIES ('propD', 'propD', 'propD'); +SHOW TBLPROPERTIES vt.testView; -ALTER VIEW testView SET TBLPROPERTIES ('propA'='100', 'propB' = '200', 'propC'='300', 'propD'='400'); -SHOW TBLPROPERTIES testView; +ALTER VIEW vt.testView SET TBLPROPERTIES ('propA'='100', 'propB' = '200', 'propC'='300', 'propD'='400'); +SHOW TBLPROPERTIES vt.testView; -- UNSET a subset of the properties and some non-existed properties using IF EXISTS -ALTER VIEW testView UNSET TBLPROPERTIES IF EXISTS ('propC', 'propD', 'propD', 'propC', 'propZ'); -SHOW TBLPROPERTIES testView; +ALTER VIEW vt.testView UNSET TBLPROPERTIES IF EXISTS ('propC', 'propD', 'propD', 'propC', 'propZ'); +SHOW TBLPROPERTIES vt.testView; -- UNSET a subset of the properties and some non-existed properties using IF EXISTS -ALTER VIEW testView UNSET TBLPROPERTIES IF EXISTS ('propB', 'propC', 'propD', 'propF'); -SHOW TBLPROPERTIES testView; +ALTER VIEW vt.testView UNSET TBLPROPERTIES IF EXISTS ('propB', 'propC', 'propD', 'propF'); +SHOW TBLPROPERTIES vt.testView; + +DROP VIEW vt.testView; +DROP DATABASE vt; \ No newline at end of file Modified: hive/branches/cbo/ql/src/test/resources/orc-file-dump-dictionary-threshold.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/resources/orc-file-dump-dictionary-threshold.out?rev=1621031&r1=1621030&r2=1621031&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/resources/orc-file-dump-dictionary-threshold.out (original) +++ hive/branches/cbo/ql/src/test/resources/orc-file-dump-dictionary-threshold.out Thu Aug 28 03:15:13 2014 @@ -38,72 +38,150 @@ File Statistics: Column 3: count: 21000 min: Darkness,-230 max: worst-54-290-346-648-908-996-1038-1080-1560-1584-1620-1744-1770-1798-1852-1966-2162-2244-2286-2296-2534-2660-3114-3676-3788-4068-4150-4706-4744-5350-5420-5582-5696-5726-6006-6020-6024-6098-6184-6568-6636-6802-6994-7004-7318-7498-7758-7780-7798-7920-7952-7960-7988-8232-8256-8390-8416-8478-8620-8840-8984-9038-9128-9236-9248-9344-9594-9650-9714-9928-9938-10178-10368-10414-10502-10732-10876-11008-11158-11410-11722-11836-11964-12054-12096-12126-12136-12202-12246-12298-12616-12774-12782-12790-12802-12976-13216-13246-13502-13766-14454-14974-15004-15124-15252-15294-15356-15530-15610-16316-16936-17024-17122-17214-17310-17528-17682-17742-17870-17878-18010-18410-18524-18788-19204-19254-19518-19596-19786-19874-19904-20390-20752-20936 sum: 6910238 Stripes: - Stripe: offset: 3 data: 144733 rows: 5000 tail: 68 index: 235 - Stream: column 0 section ROW_INDEX start: 3 length 10 - Stream: column 1 section ROW_INDEX start: 13 length 36 - Stream: column 2 section ROW_INDEX start: 49 length 39 - Stream: column 3 section ROW_INDEX start: 88 length 150 - Stream: column 1 section DATA start: 238 length 20029 - Stream: column 2 section DATA start: 20267 length 40035 - Stream: column 3 section DATA start: 60302 length 80382 - Stream: column 3 section LENGTH start: 140684 length 4287 + Stripe: offset: 3 data: 144733 rows: 5000 tail: 68 index: 693 + Stream: column 0 section ROW_INDEX start: 3 length 15 + Stream: column 1 section ROW_INDEX start: 18 length 156 + Stream: column 2 section ROW_INDEX start: 174 length 170 + Stream: column 3 section ROW_INDEX start: 344 length 352 + Stream: column 1 section DATA start: 696 length 20029 + Stream: column 2 section DATA start: 20725 length 40035 + Stream: column 3 section DATA start: 60760 length 80382 + Stream: column 3 section LENGTH start: 141142 length 4287 Encoding column 0: DIRECT Encoding column 1: DIRECT_V2 Encoding column 2: DIRECT_V2 Encoding column 3: DIRECT_V2 - Stripe: offset: 145039 data: 321684 rows: 5000 tail: 68 index: 415 - Stream: column 0 section ROW_INDEX start: 145039 length 10 - Stream: column 1 section ROW_INDEX start: 145049 length 35 - Stream: column 2 section ROW_INDEX start: 145084 length 39 - Stream: column 3 section ROW_INDEX start: 145123 length 331 - Stream: column 1 section DATA start: 145454 length 20029 - Stream: column 2 section DATA start: 165483 length 40035 - Stream: column 3 section DATA start: 205518 length 256119 - Stream: column 3 section LENGTH start: 461637 length 5501 + Row group index column 1: + Entry 0: count: 1000 min: -2132329551 max: 2145911404 positions: 0,0,0 + Entry 1: count: 1000 min: -2138433136 max: 2145210552 positions: 0,2050,488 + Entry 2: count: 1000 min: -2147115959 max: 2137805337 positions: 0,6150,464 + Entry 3: count: 1000 min: -2137828953 max: 2145877119 positions: 10003,250,440 + Entry 4: count: 1000 min: -2146452517 max: 2142394906 positions: 10003,4350,416 + Row group index column 2: + Entry 0: count: 1000 min: -9206837518492372266 max: 9169230975203934579 positions: 0,0,0 + Entry 1: count: 1000 min: -9188878639954124284 max: 9213664245516510068 positions: 0,4098,488 + Entry 2: count: 1000 min: -9211329013123260308 max: 9217851628057711416 positions: 10003,2294,464 + Entry 3: count: 1000 min: -9185745718227889962 max: 9181722705210917931 positions: 20006,490,440 + Entry 4: count: 1000 min: -9216505819108477308 max: 9196474183833079923 positions: 20006,8686,416 + Row group index column 3: + Entry 0: count: 1000 min: Darkness,-230 max: worst-54-290-346-648-908-996 positions: 0,0,0,0,0 + Entry 1: count: 1000 min: Darkness,-230-368-488-586-862-930-1686 max: worst-54-290-346-648-908-996-1038-1080-1560-1584-1620-1744-1770-1798-1852-1966 positions: 2083,8442,0,696,18 + Entry 2: count: 1000 min: Darkness,-230-368-488-586-862-930-1686-2044 max: worst-54-290-346-648-908-996-1038-1080-1560-1584-1620-1744-1770-1798-1852-1966-2162-2244-2286-2296-2534-2660 positions: 11712,4780,0,1555,14 + Entry 3: count: 1000 min: Darkness,-230-368-488-586-862-930-1686-2044-2636-2652-2872-3108 max: worst-54-290-346-648-908-996-1038-1080-1560-1584-1620-1744-1770-1798-1852-1966-2162-2244-2286-2296-2534-2660-3114-3676-3788 positions: 28297,228,0,2373,90 + Entry 4: count: 1000 min: Darkness,-230-368-488-586-862-930-1686-2044-2636-2652-2872-3108-3162-3192-3404-3442-3508-3542-3550-3712-3980-4146 max: worst-54-290-346-648-908-996-1038-1080-1560-1584-1620-1744-1770-1798-1852-1966-2162-2244-2286-2296-2534-2660-3114-3676-3788-4068-4150-4706-4744 positions: 49599,5096,0,3355,108 + Stripe: offset: 145497 data: 321684 rows: 5000 tail: 68 index: 907 + Stream: column 0 section ROW_INDEX start: 145497 length 15 + Stream: column 1 section ROW_INDEX start: 145512 length 150 + Stream: column 2 section ROW_INDEX start: 145662 length 167 + Stream: column 3 section ROW_INDEX start: 145829 length 575 + Stream: column 1 section DATA start: 146404 length 20029 + Stream: column 2 section DATA start: 166433 length 40035 + Stream: column 3 section DATA start: 206468 length 256119 + Stream: column 3 section LENGTH start: 462587 length 5501 Encoding column 0: DIRECT Encoding column 1: DIRECT_V2 Encoding column 2: DIRECT_V2 Encoding column 3: DIRECT_V2 - Stripe: offset: 467206 data: 531773 rows: 5000 tail: 69 index: 569 - Stream: column 0 section ROW_INDEX start: 467206 length 10 - Stream: column 1 section ROW_INDEX start: 467216 length 36 - Stream: column 2 section ROW_INDEX start: 467252 length 39 - Stream: column 3 section ROW_INDEX start: 467291 length 484 - Stream: column 1 section DATA start: 467775 length 20029 - Stream: column 2 section DATA start: 487804 length 40035 - Stream: column 3 section DATA start: 527839 length 466002 - Stream: column 3 section LENGTH start: 993841 length 5707 + Row group index column 1: + Entry 0: count: 1000 min: -2146021688 max: 2146838901 positions: 0,0,0 + Entry 1: count: 1000 min: -2143569489 max: 2141223179 positions: 0,2050,488 + Entry 2: count: 1000 min: -2140649392 max: 2146301701 positions: 0,6150,464 + Entry 3: count: 1000 min: -2147390285 max: 2146299933 positions: 10003,250,440 + Entry 4: count: 1000 min: -2145928262 max: 2147224606 positions: 10003,4350,416 + Row group index column 2: + Entry 0: count: 1000 min: -9222178666167296739 max: 9191250610515369723 positions: 0,0,0 + Entry 1: count: 1000 min: -9220148577547102875 max: 9213945522531717278 positions: 0,4098,488 + Entry 2: count: 1000 min: -9220818777591257749 max: 9221301751385928177 positions: 10003,2294,464 + Entry 3: count: 1000 min: -9220031433030423388 max: 9207856144487414148 positions: 20006,490,440 + Entry 4: count: 1000 min: -9201438531577205959 max: 9212462124593119846 positions: 20006,8686,416 + Row group index column 3: + Entry 0: count: 1000 min: Darkness,-230-368-488-586-862-930-1686-2044-2636-2652-2872-3108-3162-3192-3404-3442-3508-3542-3550-3712-3980-4146-4204-4336-4390-4418-4424-4490-4512-4650-4768-4924-4950-5210 max: worst-54-290-346-648-908-996-1038-1080-1560-1584-1620-1744-1770-1798-1852-1966-2162-2244-2286-2296-2534-2660-3114-3676-3788-4068-4150-4706-4744-5350-5420-5582-5696-5726 positions: 0,0,0,0,0 + Entry 1: count: 1000 min: Darkness,-230-368-488-586-862-930-1686-2044-2636-2652-2872-3108-3162-3192-3404-3442-3508-3542-3550-3712-3980-4146-4204-4336-4390-4418-4424-4490-4512-4650-4768-4924-4950-5210-5524-5630-5678-5710-5758-5952-6238 max: worst-54-290-346-648-908-996-1038-1080-1560-1584-1620-1744-1770-1798-1852-1966-2162-2244-2286-2296-2534-2660-3114-3676-3788-4068-4150-4706-4744-5350-5420-5582-5696-5726-6006-6020-6024-6098-6184-6568-6636-6802-6994 positions: 35030,6320,0,967,90 + Entry 2: count: 1000 min: Darkness,-230-368-488-586-862-930-1686-2044-2636-2652-2872-3108-3162-3192-3404-3442-3508-3542-3550-3712-3980-4146-4204-4336-4390-4418-4424-4490-4512-4650-4768-4924-4950-5210-5524-5630-5678-5710-5758-5952-6238-6252-6300-6366-6668-6712-6926-6942-7100 max: worst-54-290-346-648-908-996-1038-1080-1560-1584-1620-1744-1770-1798-1852-1966-2162-2244-2286-2296-2534-2660-3114-3676-3788-4068-4150-4706-4744-5350-5420-5582-5696-5726-6006-6020-6024-6098-6184-6568-6636-6802-6994-7004-7318-7498-7758-7780-7798-7920-7952-7960-7988 positions: 76249,9756,0,1945,222 + Entry 3: count: 1000 min: Darkness,-230-368-488-586-862-930-1686-2044-2636-2652-2872-3108-3162-3192-3404-3442-3508-3542-3550-3712-3980-4146-4204-4336-4390-4418-4424-4490-4512-4650-4768-4924-4950-5210-5524-5630-5678-5710-5758-5952-6238-6252-6300-6366-6668-6712-6926-6942-7100-7194-7802-8030 max: worst-54-290-346-648-908-996-1038-1080-1560-1584-1620-1744-1770-1798-1852-1966-2162-2244-2286-2296-2534-2660-3114-3676-3788-4068-4150-4706-4744-5350-5420-5582-5696-5726-6006-6020-6024-6098-6184-6568-6636-6802-6994-7004-7318-7498-7758-7780-7798-7920-7952-7960-7988-8232-8256-8390-8416-8478-8620-8840-8984 positions: 129633,4496,0,3268,48 + Entry 4: count: 1000 min: Darkness,-230-368-488-586-862-930-1686-2044-2636-2652-2872-3108-3162-3192-3404-3442-3508-3542-3550-3712-3980-4146-4204-4336-4390-4418-4424-4490-4512-4650-4768-4924-4950-5210-5524-5630-5678-5710-5758-5952-6238-6252-6300-6366-6668-6712-6926-6942-7100-7194-7802-8030-8452-8608-8640-8862-8868-9134 max: worst-54-290-346-648-908-996-1038-1080-1560-1584-1620-1744-1770-1798-1852-1966-2162-2244-2286-2296-2534-2660-3114-3676-3788-4068-4150-4706-4744-5350-5420-5582-5696-5726-6006-6020-6024-6098-6184-6568-6636-6802-6994-7004-7318-7498-7758-7780-7798-7920-7952-7960-7988-8232-8256-8390-8416-8478-8620-8840-8984-9038-9128-9236-9248-9344-9594-9650-9714-9928-9938 positions: 187250,6590,0,4064,342 + Stripe: offset: 468156 data: 531773 rows: 5000 tail: 69 index: 1101 + Stream: column 0 section ROW_INDEX start: 468156 length 15 + Stream: column 1 section ROW_INDEX start: 468171 length 159 + Stream: column 2 section ROW_INDEX start: 468330 length 169 + Stream: column 3 section ROW_INDEX start: 468499 length 758 + Stream: column 1 section DATA start: 469257 length 20029 + Stream: column 2 section DATA start: 489286 length 40035 + Stream: column 3 section DATA start: 529321 length 466002 + Stream: column 3 section LENGTH start: 995323 length 5707 Encoding column 0: DIRECT Encoding column 1: DIRECT_V2 Encoding column 2: DIRECT_V2 Encoding column 3: DIRECT_V2 - Stripe: offset: 999617 data: 751374 rows: 5000 tail: 69 index: 734 - Stream: column 0 section ROW_INDEX start: 999617 length 10 - Stream: column 1 section ROW_INDEX start: 999627 length 36 - Stream: column 2 section ROW_INDEX start: 999663 length 39 - Stream: column 3 section ROW_INDEX start: 999702 length 649 - Stream: column 1 section DATA start: 1000351 length 20029 - Stream: column 2 section DATA start: 1020380 length 40035 - Stream: column 3 section DATA start: 1060415 length 685567 - Stream: column 3 section LENGTH start: 1745982 length 5743 + Row group index column 1: + Entry 0: count: 1000 min: -2138229212 max: 2144818981 positions: 0,0,0 + Entry 1: count: 1000 min: -2145842720 max: 2144179881 positions: 0,2050,488 + Entry 2: count: 1000 min: -2143045885 max: 2146718321 positions: 0,6150,464 + Entry 3: count: 1000 min: -2144745617 max: 2146570474 positions: 10003,250,440 + Entry 4: count: 1000 min: -2140127150 max: 2135081620 positions: 10003,4350,416 + Row group index column 2: + Entry 0: count: 1000 min: -9204340807292138409 max: 9208698732685326961 positions: 0,0,0 + Entry 1: count: 1000 min: -9221963099397084326 max: 9222722740629726770 positions: 0,4098,488 + Entry 2: count: 1000 min: -9210480084701091299 max: 9207767402467343058 positions: 10003,2294,464 + Entry 3: count: 1000 min: -9195038026813631215 max: 9199201928563274421 positions: 20006,490,440 + Entry 4: count: 1000 min: -9215483580266514322 max: 9220102792864959501 positions: 20006,8686,416 + Row group index column 3: + Entry 0: count: 1000 min: Darkness,-230-368-488-586-862-930-1686-2044-2636-2652-2872-3108-3162-3192-3404-3442-3508-3542-3550-3712-3980-4146-4204-4336-4390-4418-4424-4490-4512-4650-4768-4924-4950-5210-5524-5630-5678-5710-5758-5952-6238-6252-6300-6366-6668-6712-6926-6942-7100-7194-7802-8030-8452-8608-8640-8862-8868-9134-9234-9412-9602-9608-9642-9678-9740-9780-10426 max: worst-54-290-346-648-908-996-1038-1080-1560-1584-1620-1744-1770-1798-1852-1966-2162-2244-2286-2296-2534-2660-3114-3676-3788-4068-4150-4706-4744-5350-5420-5582-5696-5726-6006-6020-6024-6098-6184-6568-6636-6802-6994-7004-7318-7498-7758-7780-7798-7920-7952-7960-7988-8232-8256-8390-8416-8478-8620-8840-8984-9038-9128-9236-9248-9344-9594-9650-9714-9928-9938-10178-10368-10414-10502-10732-10876 positions: 0,0,0,0,0 + Entry 1: count: 1000 min: Darkness,-230-368-488-586-862-930-1686-2044-2636-2652-2872-3108-3162-3192-3404-3442-3508-3542-3550-3712-3980-4146-4204-4336-4390-4418-4424-4490-4512-4650-4768-4924-4950-5210-5524-5630-5678-5710-5758-5952-6238-6252-6300-6366-6668-6712-6926-6942-7100-7194-7802-8030-8452-8608-8640-8862-8868-9134-9234-9412-9602-9608-9642-9678-9740-9780-10426-10510-10514-10706-10814-10870-10942-11028 max: worst-54-290-346-648-908-996-1038-1080-1560-1584-1620-1744-1770-1798-1852-1966-2162-2244-2286-2296-2534-2660-3114-3676-3788-4068-4150-4706-4744-5350-5420-5582-5696-5726-6006-6020-6024-6098-6184-6568-6636-6802-6994-7004-7318-7498-7758-7780-7798-7920-7952-7960-7988-8232-8256-8390-8416-8478-8620-8840-8984-9038-9128-9236-9248-9344-9594-9650-9714-9928-9938-10178-10368-10414-10502-10732-10876-11008-11158-11410-11722-11836-11964 positions: 76243,3880,0,1097,28 + Entry 2: count: 1000 min: Darkness,-230-368-488-586-862-930-1686-2044-2636-2652-2872-3108-3162-3192-3404-3442-3508-3542-3550-3712-3980-4146-4204-4336-4390-4418-4424-4490-4512-4650-4768-4924-4950-5210-5524-5630-5678-5710-5758-5952-6238-6252-6300-6366-6668-6712-6926-6942-7100-7194-7802-8030-8452-8608-8640-8862-8868-9134-9234-9412-9602-9608-9642-9678-9740-9780-10426-10510-10514-10706-10814-10870-10942-11028-11244-11326-11462-11496-11656-11830-12022 max: worst-54-290-346-648-908-996-1038-1080-1560-1584-1620-1744-1770-1798-1852-1966-2162-2244-2286-2296-2534-2660-3114-3676-3788-4068-4150-4706-4744-5350-5420-5582-5696-5726-6006-6020-6024-6098-6184-6568-6636-6802-6994-7004-7318-7498-7758-7780-7798-7920-7952-7960-7988-8232-8256-8390-8416-8478-8620-8840-8984-9038-9128-9236-9248-9344-9594-9650-9714-9928-9938-10178-10368-10414-10502-10732-10876-11008-11158-11410-11722-11836-11964-12054-12096-12126-12136-12202-12246-12298-12616-12774-12782-12790-12802-12976 positions: 161945,3422,0,2077,16 2 + Entry 3: count: 1000 min: Darkness,-230-368-488-586-862-930-1686-2044-2636-2652-2872-3108-3162-3192-3404-3442-3508-3542-3550-3712-3980-4146-4204-4336-4390-4418-4424-4490-4512-4650-4768-4924-4950-5210-5524-5630-5678-5710-5758-5952-6238-6252-6300-6366-6668-6712-6926-6942-7100-7194-7802-8030-8452-8608-8640-8862-8868-9134-9234-9412-9602-9608-9642-9678-9740-9780-10426-10510-10514-10706-10814-10870-10942-11028-11244-11326-11462-11496-11656-11830-12022-12178-12418-12832-13304 max: worst-54-290-346-648-908-996-1038-1080-1560-1584-1620-1744-1770-1798-1852-1966-2162-2244-2286-2296-2534-2660-3114-3676-3788-4068-4150-4706-4744-5350-5420-5582-5696-5726-6006-6020-6024-6098-6184-6568-6636-6802-6994-7004-7318-7498-7758-7780-7798-7920-7952-7960-7988-8232-8256-8390-8416-8478-8620-8840-8984-9038-9128-9236-9248-9344-9594-9650-9714-9928-9938-10178-10368-10414-10502-10732-10876-11008-11158-11410-11722-11836-11964-12054-12096-12126-12136-12202-12246-12298-12616-12774-12782-12790-12802-12976-13216-13 246-13502-13766 positions: 254465,9960,0,3369,16 + Entry 4: count: 1000 min: Darkness,-230-368-488-586-862-930-1686-2044-2636-2652-2872-3108-3162-3192-3404-3442-3508-3542-3550-3712-3980-4146-4204-4336-4390-4418-4424-4490-4512-4650-4768-4924-4950-5210-5524-5630-5678-5710-5758-5952-6238-6252-6300-6366-6668-6712-6926-6942-7100-7194-7802-8030-8452-8608-8640-8862-8868-9134-9234-9412-9602-9608-9642-9678-9740-9780-10426-10510-10514-10706-10814-10870-10942-11028-11244-11326-11462-11496-11656-11830-12022-12178-12418-12832-13304-13448-13590-13618-13908-14188 max: worst-54-290-346-648-908-996-1038-1080-1560-1584-1620-1744-1770-1798-1852-1966-2162-2244-2286-2296-2534-2660-3114-3676-3788-4068-4150-4706-4744-5350-5420-5582-5696-5726-6006-6020-6024-6098-6184-6568-6636-6802-6994-7004-7318-7498-7758-7780-7798-7920-7952-7960-7988-8232-8256-8390-8416-8478-8620-8840-8984-9038-9128-9236-9248-9344-9594-9650-9714-9928-9938-10178-10368-10414-10502-10732-10876-11008-11158-11410-11722-11836-11964-12054-12096-12126-12136-12202-12246-12298-12616-12774-12 782-12790-12802-12976-13216-13246-13502-13766-14454-14974 positions: 357930,1620,0,4041,470 + Stripe: offset: 1001099 data: 751374 rows: 5000 tail: 69 index: 1278 + Stream: column 0 section ROW_INDEX start: 1001099 length 15 + Stream: column 1 section ROW_INDEX start: 1001114 length 149 + Stream: column 2 section ROW_INDEX start: 1001263 length 170 + Stream: column 3 section ROW_INDEX start: 1001433 length 944 + Stream: column 1 section DATA start: 1002377 length 20029 + Stream: column 2 section DATA start: 1022406 length 40035 + Stream: column 3 section DATA start: 1062441 length 685567 + Stream: column 3 section LENGTH start: 1748008 length 5743 Encoding column 0: DIRECT Encoding column 1: DIRECT_V2 Encoding column 2: DIRECT_V2 Encoding column 3: DIRECT_V2 - Stripe: offset: 1751794 data: 177935 rows: 1000 tail: 67 index: 813 - Stream: column 0 section ROW_INDEX start: 1751794 length 10 - Stream: column 1 section ROW_INDEX start: 1751804 length 36 - Stream: column 2 section ROW_INDEX start: 1751840 length 39 - Stream: column 3 section ROW_INDEX start: 1751879 length 728 - Stream: column 1 section DATA start: 1752607 length 4007 - Stream: column 2 section DATA start: 1756614 length 8007 - Stream: column 3 section DATA start: 1764621 length 164661 - Stream: column 3 section LENGTH start: 1929282 length 1260 + Row group index column 1: + Entry 0: count: 1000 min: -2145319330 max: 2146998132 positions: 0,0,0 + Entry 1: count: 1000 min: -2134288866 max: 2147453086 positions: 0,2050,488 + Entry 2: count: 1000 min: -2139010804 max: 2144727593 positions: 0,6150,464 + Entry 3: count: 1000 min: -2145378214 max: 2144098933 positions: 10003,250,440 + Entry 4: count: 1000 min: -2140494429 max: 2144595861 positions: 10003,4350,416 + Row group index column 2: + Entry 0: count: 1000 min: -9172774601303513941 max: 9212917101275642143 positions: 0,0,0 + Entry 1: count: 1000 min: -9218164880949195469 max: 9222919052987871506 positions: 0,4098,488 + Entry 2: count: 1000 min: -9222731174895935707 max: 9214167447015056056 positions: 10003,2294,464 + Entry 3: count: 1000 min: -9196276654247395117 max: 9210639275226058005 positions: 20006,490,440 + Entry 4: count: 1000 min: -9197393848859294562 max: 9208134757538374043 positions: 20006,8686,416 + Row group index column 3: + Entry 0: count: 1000 min: Darkness,-230-368-488-586-862-930-1686-2044-2636-2652-2872-3108-3162-3192-3404-3442-3508-3542-3550-3712-3980-4146-4204-4336-4390-4418-4424-4490-4512-4650-4768-4924-4950-5210-5524-5630-5678-5710-5758-5952-6238-6252-6300-6366-6668-6712-6926-6942-7100-7194-7802-8030-8452-8608-8640-8862-8868-9134-9234-9412-9602-9608-9642-9678-9740-9780-10426-10510-10514-10706-10814-10870-10942-11028-11244-11326-11462-11496-11656-11830-12022-12178-12418-12832-13304-13448-13590-13618-13908-14188-14246-14340-14364-14394-14762-14850-14964-15048 max: worst-54-290-346-648-908-996-1038-1080-1560-1584-1620-1744-1770-1798-1852-1966-2162-2244-2286-2296-2534-2660-3114-3676-3788-4068-4150-4706-4744-5350-5420-5582-5696-5726-6006-6020-6024-6098-6184-6568-6636-6802-6994-7004-7318-7498-7758-7780-7798-7920-7952-7960-7988-8232-8256-8390-8416-8478-8620-8840-8984-9038-9128-9236-9248-9344-9594-9650-9714-9928-9938-10178-10368-10414-10502-10732-10876-11008-11158-11410-11722-11836-11964-12054-12 096-12126-12136-12202-12246-12298-12616-12774-12782-12790-12802-12976-13216-13246-13502-13766-14454-14974-15004-15124-15252-15294-15356-15530-15610 positions: 0,0,0,0,0 + Entry 1: count: 1000 min: Darkness,-230-368-488-586-862-930-1686-2044-2636-2652-2872-3108-3162-3192-3404-3442-3508-3542-3550-3712-3980-4146-4204-4336-4390-4418-4424-4490-4512-4650-4768-4924-4950-5210-5524-5630-5678-5710-5758-5952-6238-6252-6300-6366-6668-6712-6926-6942-7100-7194-7802-8030-8452-8608-8640-8862-8868-9134-9234-9412-9602-9608-9642-9678-9740-9780-10426-10510-10514-10706-10814-10870-10942-11028-11244-11326-11462-11496-11656-11830-12022-12178-12418-12832-13304-13448-13590-13618-13908-14188-14246-14340-14364-14394-14762-14850-14964-15048-15494-15674-15726-16006 max: worst-54-290-346-648-908-996-1038-1080-1560-1584-1620-1744-1770-1798-1852-1966-2162-2244-2286-2296-2534-2660-3114-3676-3788-4068-4150-4706-4744-5350-5420-5582-5696-5726-6006-6020-6024-6098-6184-6568-6636-6802-6994-7004-7318-7498-7758-7780-7798-7920-7952-7960-7988-8232-8256-8390-8416-8478-8620-8840-8984-9038-9128-9236-9248-9344-9594-9650-9714-9928-9938-10178-10368-10414-10502-10732-10876-11008-11158-11410-11 722-11836-11964-12054-12096-12126-12136-12202-12246-12298-12616-12774-12782-12790-12802-12976-13216-13246-13502-13766-14454-14974-15004-15124-15252-15294-15356-15530-15610-16316-16936 positions: 120094,2916,0,1077,140 + Entry 2: count: 1000 min: Darkness,-230-368-488-586-862-930-1686-2044-2636-2652-2872-3108-3162-3192-3404-3442-3508-3542-3550-3712-3980-4146-4204-4336-4390-4418-4424-4490-4512-4650-4768-4924-4950-5210-5524-5630-5678-5710-5758-5952-6238-6252-6300-6366-6668-6712-6926-6942-7100-7194-7802-8030-8452-8608-8640-8862-8868-9134-9234-9412-9602-9608-9642-9678-9740-9780-10426-10510-10514-10706-10814-10870-10942-11028-11244-11326-11462-11496-11656-11830-12022-12178-12418-12832-13304-13448-13590-13618-13908-14188-14246-14340-14364-14394-14762-14850-14964-15048-15494-15674-15726-16006-16056-16180-16304-16332-16452-16598-16730-16810-16994-17210 max: worst-54-290-346-648-908-996-1038-1080-1560-1584-1620-1744-1770-1798-1852-1966-2162-2244-2286-2296-2534-2660-3114-3676-3788-4068-4150-4706-4744-5350-5420-5582-5696-5726-6006-6020-6024-6098-6184-6568-6636-6802-6994-7004-7318-7498-7758-7780-7798-7920-7952-7960-7988-8232-8256-8390-8416-8478-8620-8840-8984-9038-9128-9236-9248-9344-9594-9650-9714-9928-9 938-10178-10368-10414-10502-10732-10876-11008-11158-11410-11722-11836-11964-12054-12096-12126-12136-12202-12246-12298-12616-12774-12782-12790-12802-12976-13216-13246-13502-13766-14454-14974-15004-15124-15252-15294-15356-15530-15610-16316-16936-17024-17122-17214-17310-17528-17682-17742-17870-17878 positions: 248557,206,0,1926,462 + Entry 3: count: 1000 min: Darkness,-230-368-488-586-862-930-1686-2044-2636-2652-2872-3108-3162-3192-3404-3442-3508-3542-3550-3712-3980-4146-4204-4336-4390-4418-4424-4490-4512-4650-4768-4924-4950-5210-5524-5630-5678-5710-5758-5952-6238-6252-6300-6366-6668-6712-6926-6942-7100-7194-7802-8030-8452-8608-8640-8862-8868-9134-9234-9412-9602-9608-9642-9678-9740-9780-10426-10510-10514-10706-10814-10870-10942-11028-11244-11326-11462-11496-11656-11830-12022-12178-12418-12832-13304-13448-13590-13618-13908-14188-14246-14340-14364-14394-14762-14850-14964-15048-15494-15674-15726-16006-16056-16180-16304-16332-16452-16598-16730-16810-16994-17210-17268-17786-17962-18214 max: worst-54-290-346-648-908-996-1038-1080-1560-1584-1620-1744-1770-1798-1852-1966-2162-2244-2286-2296-2534-2660-3114-3676-3788-4068-4150-4706-4744-5350-5420-5582-5696-5726-6006-6020-6024-6098-6184-6568-6636-6802-6994-7004-7318-7498-7758-7780-7798-7920-7952-7960-7988-8232-8256-8390-8416-8478-8620-8840-8984-9038-9128-9236-9248-93 44-9594-9650-9714-9928-9938-10178-10368-10414-10502-10732-10876-11008-11158-11410-11722-11836-11964-12054-12096-12126-12136-12202-12246-12298-12616-12774-12782-12790-12802-12976-13216-13246-13502-13766-14454-14974-15004-15124-15252-15294-15356-15530-15610-16316-16936-17024-17122-17214-17310-17528-17682-17742-17870-17878-18010-18410-18524-18788 positions: 384576,8480,0,3444,250 + Entry 4: count: 1000 min: Darkness,-230-368-488-586-862-930-1686-2044-2636-2652-2872-3108-3162-3192-3404-3442-3508-3542-3550-3712-3980-4146-4204-4336-4390-4418-4424-4490-4512-4650-4768-4924-4950-5210-5524-5630-5678-5710-5758-5952-6238-6252-6300-6366-6668-6712-6926-6942-7100-7194-7802-8030-8452-8608-8640-8862-8868-9134-9234-9412-9602-9608-9642-9678-9740-9780-10426-10510-10514-10706-10814-10870-10942-11028-11244-11326-11462-11496-11656-11830-12022-12178-12418-12832-13304-13448-13590-13618-13908-14188-14246-14340-14364-14394-14762-14850-14964-15048-15494-15674-15726-16006-16056-16180-16304-16332-16452-16598-16730-16810-16994-17210-17268-17786-17962-18214-18444-18446-18724-18912-18952-19164 max: worst-54-290-346-648-908-996-1038-1080-1560-1584-1620-1744-1770-1798-1852-1966-2162-2244-2286-2296-2534-2660-3114-3676-3788-4068-4150-4706-4744-5350-5420-5582-5696-5726-6006-6020-6024-6098-6184-6568-6636-6802-6994-7004-7318-7498-7758-7780-7798-7920-7952-7960-7988-8232-8256-8390-8416-8478-8 620-8840-8984-9038-9128-9236-9248-9344-9594-9650-9714-9928-9938-10178-10368-10414-10502-10732-10876-11008-11158-11410-11722-11836-11964-12054-12096-12126-12136-12202-12246-12298-12616-12774-12782-12790-12802-12976-13216-13246-13502-13766-14454-14974-15004-15124-15252-15294-15356-15530-15610-16316-16936-17024-17122-17214-17310-17528-17682-17742-17870-17878-18010-18410-18524-18788-19204-19254-19518-19596-19786-19874-19904 positions: 530195,3058,0,4643,292 + Stripe: offset: 1753820 data: 177935 rows: 1000 tail: 67 index: 813 + Stream: column 0 section ROW_INDEX start: 1753820 length 10 + Stream: column 1 section ROW_INDEX start: 1753830 length 36 + Stream: column 2 section ROW_INDEX start: 1753866 length 39 + Stream: column 3 section ROW_INDEX start: 1753905 length 728 + Stream: column 1 section DATA start: 1754633 length 4007 + Stream: column 2 section DATA start: 1758640 length 8007 + Stream: column 3 section DATA start: 1766647 length 164661 + Stream: column 3 section LENGTH start: 1931308 length 1260 Encoding column 0: DIRECT Encoding column 1: DIRECT_V2 Encoding column 2: DIRECT_V2 Encoding column 3: DIRECT_V2 + Row group index column 1: + Entry 0: count: 1000 min: -2143595397 max: 2136858458 positions: 0,0,0 + Row group index column 2: + Entry 0: count: 1000 min: -9212379634781416464 max: 9197412874152820822 positions: 0,0,0 + Row group index column 3: + Entry 0: count: 1000 min: Darkness,-230-368-488-586-862-930-1686-2044-2636-2652-2872-3108-3162-3192-3404-3442-3508-3542-3550-3712-3980-4146-4204-4336-4390-4418-4424-4490-4512-4650-4768-4924-4950-5210-5524-5630-5678-5710-5758-5952-6238-6252-6300-6366-6668-6712-6926-6942-7100-7194-7802-8030-8452-8608-8640-8862-8868-9134-9234-9412-9602-9608-9642-9678-9740-9780-10426-10510-10514-10706-10814-10870-10942-11028-11244-11326-11462-11496-11656-11830-12022-12178-12418-12832-13304-13448-13590-13618-13908-14188-14246-14340-14364-14394-14762-14850-14964-15048-15494-15674-15726-16006-16056-16180-16304-16332-16452-16598-16730-16810-16994-17210-17268-17786-17962-18214-18444-18446-18724-18912-18952-19164-19348-19400-19546-19776-19896-20084 max: worst-54-290-346-648-908-996-1038-1080-1560-1584-1620-1744-1770-1798-1852-1966-2162-2244-2286-2296-2534-2660-3114-3676-3788-4068-4150-4706-4744-5350-5420-5582-5696-5726-6006-6020-6024-6098-6184-6568-6636-6802-6994-7004-7318-7498-7758-7780-7798-7920-7952- 7960-7988-8232-8256-8390-8416-8478-8620-8840-8984-9038-9128-9236-9248-9344-9594-9650-9714-9928-9938-10178-10368-10414-10502-10732-10876-11008-11158-11410-11722-11836-11964-12054-12096-12126-12136-12202-12246-12298-12616-12774-12782-12790-12802-12976-13216-13246-13502-13766-14454-14974-15004-15124-15252-15294-15356-15530-15610-16316-16936-17024-17122-17214-17310-17528-17682-17742-17870-17878-18010-18410-18524-18788-19204-19254-19518-19596-19786-19874-19904-20390-20752-20936 positions: 0,0,0,0,0 -File length: 1932446 bytes +File length: 1934469 bytes Padding length: 0 bytes Padding ratio: 0% Modified: hive/branches/cbo/ql/src/test/resources/orc-file-dump.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/resources/orc-file-dump.out?rev=1621031&r1=1621030&r2=1621031&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/resources/orc-file-dump.out (original) +++ hive/branches/cbo/ql/src/test/resources/orc-file-dump.out Thu Aug 28 03:15:13 2014 @@ -38,77 +38,155 @@ File Statistics: Column 3: count: 21000 min: Darkness, max: worst sum: 81761 Stripes: - Stripe: offset: 3 data: 63766 rows: 5000 tail: 74 index: 123 - Stream: column 0 section ROW_INDEX start: 3 length 10 - Stream: column 1 section ROW_INDEX start: 13 length 35 - Stream: column 2 section ROW_INDEX start: 48 length 39 - Stream: column 3 section ROW_INDEX start: 87 length 39 - Stream: column 1 section DATA start: 126 length 20029 - Stream: column 2 section DATA start: 20155 length 40035 - Stream: column 3 section DATA start: 60190 length 3544 - Stream: column 3 section LENGTH start: 63734 length 25 - Stream: column 3 section DICTIONARY_DATA start: 63759 length 133 + Stripe: offset: 3 data: 63766 rows: 5000 tail: 79 index: 426 + Stream: column 0 section ROW_INDEX start: 3 length 15 + Stream: column 1 section ROW_INDEX start: 18 length 158 + Stream: column 2 section ROW_INDEX start: 176 length 170 + Stream: column 3 section ROW_INDEX start: 346 length 83 + Stream: column 1 section DATA start: 429 length 20029 + Stream: column 2 section DATA start: 20458 length 40035 + Stream: column 3 section DATA start: 60493 length 3544 + Stream: column 3 section LENGTH start: 64037 length 25 + Stream: column 3 section DICTIONARY_DATA start: 64062 length 133 Encoding column 0: DIRECT Encoding column 1: DIRECT_V2 Encoding column 2: DIRECT_V2 Encoding column 3: DICTIONARY_V2[35] - Stripe: offset: 63966 data: 63755 rows: 5000 tail: 74 index: 122 - Stream: column 0 section ROW_INDEX start: 63966 length 10 - Stream: column 1 section ROW_INDEX start: 63976 length 34 - Stream: column 2 section ROW_INDEX start: 64010 length 39 - Stream: column 3 section ROW_INDEX start: 64049 length 39 - Stream: column 1 section DATA start: 64088 length 20029 - Stream: column 2 section DATA start: 84117 length 40035 - Stream: column 3 section DATA start: 124152 length 3533 - Stream: column 3 section LENGTH start: 127685 length 25 - Stream: column 3 section DICTIONARY_DATA start: 127710 length 133 + Row group index column 1: + Entry 0: count: 1000 min: -2145365268 max: 2135491313 positions: 0,0,0 + Entry 1: count: 1000 min: -2139452528 max: 2147223299 positions: 0,2050,488 + Entry 2: count: 1000 min: -2142420586 max: 2143898386 positions: 0,6150,464 + Entry 3: count: 1000 min: -2137233441 max: 2144267163 positions: 10003,250,440 + Entry 4: count: 1000 min: -2146021688 max: 2146838901 positions: 10003,4350,416 + Row group index column 2: + Entry 0: count: 1000 min: -9200577545527640566 max: 9175500305011173751 positions: 0,0,0 + Entry 1: count: 1000 min: -9203618157670445774 max: 9208123824411178101 positions: 0,4098,488 + Entry 2: count: 1000 min: -9218592812243954469 max: 9221351515892923972 positions: 10003,2294,464 + Entry 3: count: 1000 min: -9206585617947511272 max: 9167703224425685487 positions: 20006,490,440 + Entry 4: count: 1000 min: -9206645795733282496 max: 9221614132680747961 positions: 20006,8686,416 + Row group index column 3: + Entry 0: count: 1000 min: Darkness, max: worst positions: 0,0,0 + Entry 1: count: 1000 min: Darkness, max: worst positions: 0,659,149 + Entry 2: count: 1000 min: Darkness, max: worst positions: 0,1531,3 + Entry 3: count: 1000 min: Darkness, max: worst positions: 0,2282,32 + Entry 4: count: 1000 min: Darkness, max: worst positions: 0,3034,45 + Stripe: offset: 64274 data: 63755 rows: 5000 tail: 79 index: 421 + Stream: column 0 section ROW_INDEX start: 64274 length 15 + Stream: column 1 section ROW_INDEX start: 64289 length 157 + Stream: column 2 section ROW_INDEX start: 64446 length 169 + Stream: column 3 section ROW_INDEX start: 64615 length 80 + Stream: column 1 section DATA start: 64695 length 20029 + Stream: column 2 section DATA start: 84724 length 40035 + Stream: column 3 section DATA start: 124759 length 3533 + Stream: column 3 section LENGTH start: 128292 length 25 + Stream: column 3 section DICTIONARY_DATA start: 128317 length 133 Encoding column 0: DIRECT Encoding column 1: DIRECT_V2 Encoding column 2: DIRECT_V2 Encoding column 3: DICTIONARY_V2[35] - Stripe: offset: 127917 data: 63766 rows: 5000 tail: 74 index: 124 - Stream: column 0 section ROW_INDEX start: 127917 length 10 - Stream: column 1 section ROW_INDEX start: 127927 length 36 - Stream: column 2 section ROW_INDEX start: 127963 length 39 - Stream: column 3 section ROW_INDEX start: 128002 length 39 - Stream: column 1 section DATA start: 128041 length 20029 - Stream: column 2 section DATA start: 148070 length 40035 - Stream: column 3 section DATA start: 188105 length 3544 - Stream: column 3 section LENGTH start: 191649 length 25 - Stream: column 3 section DICTIONARY_DATA start: 191674 length 133 + Row group index column 1: + Entry 0: count: 1000 min: -2143799121 max: 2145249879 positions: 0,0,0 + Entry 1: count: 1000 min: -2146733128 max: 2147001622 positions: 0,2050,488 + Entry 2: count: 1000 min: -2144302712 max: 2146299933 positions: 0,6150,464 + Entry 3: count: 1000 min: -2145172948 max: 2144335014 positions: 10003,250,440 + Entry 4: count: 1000 min: -2146428427 max: 2144067253 positions: 10003,4350,416 + Row group index column 2: + Entry 0: count: 1000 min: -9218450653857701562 max: 9189819526332228512 positions: 0,0,0 + Entry 1: count: 1000 min: -9220818777591257749 max: 9178821722829648113 positions: 0,4098,488 + Entry 2: count: 1000 min: -9220031433030423388 max: 9210838931786956852 positions: 10003,2294,464 + Entry 3: count: 1000 min: -9208195729739635607 max: 9222259462014003839 positions: 20006,490,440 + Entry 4: count: 1000 min: -9174271499932339698 max: 9212277876771676916 positions: 20006,8686,416 + Row group index column 3: + Entry 0: count: 1000 min: Darkness, max: worst positions: 0,0,0 + Entry 1: count: 1000 min: Darkness, max: worst positions: 0,761,12 + Entry 2: count: 1000 min: Darkness, max: worst positions: 0,1472,70 + Entry 3: count: 1000 min: Darkness, max: worst positions: 0,2250,43 + Entry 4: count: 1000 min: Darkness, max: worst positions: 0,2979,88 + Stripe: offset: 128529 data: 63766 rows: 5000 tail: 79 index: 421 + Stream: column 0 section ROW_INDEX start: 128529 length 15 + Stream: column 1 section ROW_INDEX start: 128544 length 153 + Stream: column 2 section ROW_INDEX start: 128697 length 169 + Stream: column 3 section ROW_INDEX start: 128866 length 84 + Stream: column 1 section DATA start: 128950 length 20029 + Stream: column 2 section DATA start: 148979 length 40035 + Stream: column 3 section DATA start: 189014 length 3544 + Stream: column 3 section LENGTH start: 192558 length 25 + Stream: column 3 section DICTIONARY_DATA start: 192583 length 133 Encoding column 0: DIRECT Encoding column 1: DIRECT_V2 Encoding column 2: DIRECT_V2 Encoding column 3: DICTIONARY_V2[35] - Stripe: offset: 191881 data: 63796 rows: 5000 tail: 74 index: 123 - Stream: column 0 section ROW_INDEX start: 191881 length 10 - Stream: column 1 section ROW_INDEX start: 191891 length 35 - Stream: column 2 section ROW_INDEX start: 191926 length 39 - Stream: column 3 section ROW_INDEX start: 191965 length 39 - Stream: column 1 section DATA start: 192004 length 20029 - Stream: column 2 section DATA start: 212033 length 40035 - Stream: column 3 section DATA start: 252068 length 3574 - Stream: column 3 section LENGTH start: 255642 length 25 - Stream: column 3 section DICTIONARY_DATA start: 255667 length 133 + Row group index column 1: + Entry 0: count: 1000 min: -2146993718 max: 2144179881 positions: 0,0,0 + Entry 1: count: 1000 min: -2144095505 max: 2144883384 positions: 0,2050,488 + Entry 2: count: 1000 min: -2144113995 max: 2143773575 positions: 0,6150,464 + Entry 3: count: 1000 min: -2146954065 max: 2146794873 positions: 10003,250,440 + Entry 4: count: 1000 min: -2135511523 max: 2147378179 positions: 10003,4350,416 + Row group index column 2: + Entry 0: count: 1000 min: -9211978436552246208 max: 9179058898902097152 positions: 0,0,0 + Entry 1: count: 1000 min: -9195645160817780503 max: 9189147759444307708 positions: 0,4098,488 + Entry 2: count: 1000 min: -9202888157616520823 max: 9193561362676960747 positions: 10003,2294,464 + Entry 3: count: 1000 min: -9216318198067839390 max: 9221286760675829363 positions: 20006,490,440 + Entry 4: count: 1000 min: -9218342074710552826 max: 9222303228623055266 positions: 20006,8686,416 + Row group index column 3: + Entry 0: count: 1000 min: Darkness, max: worst positions: 0,0,0 + Entry 1: count: 1000 min: Darkness, max: worst positions: 0,634,174 + Entry 2: count: 1000 min: Darkness, max: worst positions: 0,1469,69 + Entry 3: count: 1000 min: Darkness, max: worst positions: 0,2133,194 + Entry 4: count: 1000 min: Darkness, max: worst positions: 0,3005,43 + Stripe: offset: 192795 data: 63796 rows: 5000 tail: 79 index: 425 + Stream: column 0 section ROW_INDEX start: 192795 length 15 + Stream: column 1 section ROW_INDEX start: 192810 length 156 + Stream: column 2 section ROW_INDEX start: 192966 length 168 + Stream: column 3 section ROW_INDEX start: 193134 length 86 + Stream: column 1 section DATA start: 193220 length 20029 + Stream: column 2 section DATA start: 213249 length 40035 + Stream: column 3 section DATA start: 253284 length 3574 + Stream: column 3 section LENGTH start: 256858 length 25 + Stream: column 3 section DICTIONARY_DATA start: 256883 length 133 Encoding column 0: DIRECT Encoding column 1: DIRECT_V2 Encoding column 2: DIRECT_V2 Encoding column 3: DICTIONARY_V2[35] - Stripe: offset: 255874 data: 12940 rows: 1000 tail: 71 index: 123 - Stream: column 0 section ROW_INDEX start: 255874 length 10 - Stream: column 1 section ROW_INDEX start: 255884 length 36 - Stream: column 2 section ROW_INDEX start: 255920 length 39 - Stream: column 3 section ROW_INDEX start: 255959 length 38 - Stream: column 1 section DATA start: 255997 length 4007 - Stream: column 2 section DATA start: 260004 length 8007 - Stream: column 3 section DATA start: 268011 length 768 - Stream: column 3 section LENGTH start: 268779 length 25 - Stream: column 3 section DICTIONARY_DATA start: 268804 length 133 + Row group index column 1: + Entry 0: count: 1000 min: -2141355639 max: 2145520931 positions: 0,0,0 + Entry 1: count: 1000 min: -2138324170 max: 2140167376 positions: 0,2050,488 + Entry 2: count: 1000 min: -2146658006 max: 2144329742 positions: 0,6150,464 + Entry 3: count: 1000 min: -2144207593 max: 2139456355 positions: 10003,250,440 + Entry 4: count: 1000 min: -2145744719 max: 2145417153 positions: 10003,4350,416 + Row group index column 2: + Entry 0: count: 1000 min: -9222731174895935707 max: 9214167447015056056 positions: 0,0,0 + Entry 1: count: 1000 min: -9222758097219661129 max: 9221043130193737406 positions: 0,4098,488 + Entry 2: count: 1000 min: -9174483776261243438 max: 9208134757538374043 positions: 10003,2294,464 + Entry 3: count: 1000 min: -9174329712613510612 max: 9197412874152820822 positions: 20006,490,440 + Entry 4: count: 1000 min: -9221162005892422758 max: 9220625004936875965 positions: 20006,8686,416 + Row group index column 3: + Entry 0: count: 1000 min: Darkness, max: worst positions: 0,0,0 + Entry 1: count: 1000 min: Darkness, max: worst positions: 0,431,431 + Entry 2: count: 1000 min: Darkness, max: worst positions: 0,1485,52 + Entry 3: count: 1000 min: Darkness, max: worst positions: 0,2196,104 + Entry 4: count: 1000 min: Darkness, max: worst positions: 0,2934,131 + Stripe: offset: 257095 data: 12940 rows: 1000 tail: 71 index: 123 + Stream: column 0 section ROW_INDEX start: 257095 length 10 + Stream: column 1 section ROW_INDEX start: 257105 length 36 + Stream: column 2 section ROW_INDEX start: 257141 length 39 + Stream: column 3 section ROW_INDEX start: 257180 length 38 + Stream: column 1 section DATA start: 257218 length 4007 + Stream: column 2 section DATA start: 261225 length 8007 + Stream: column 3 section DATA start: 269232 length 768 + Stream: column 3 section LENGTH start: 270000 length 25 + Stream: column 3 section DICTIONARY_DATA start: 270025 length 133 Encoding column 0: DIRECT Encoding column 1: DIRECT_V2 Encoding column 2: DIRECT_V2 Encoding column 3: DICTIONARY_V2[35] + Row group index column 1: + Entry 0: count: 1000 min: -2146245500 max: 2146378640 positions: 0,0,0 + Row group index column 2: + Entry 0: count: 1000 min: -9208193203370316142 max: 9218567213558056476 positions: 0,0,0 + Row group index column 3: + Entry 0: count: 1000 min: Darkness, max: worst positions: 0,0,0 -File length: 269529 bytes +File length: 270756 bytes Padding length: 0 bytes Padding ratio: 0% Modified: hive/branches/cbo/ql/src/test/results/clientnegative/alter_view_as_select_not_exist.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientnegative/alter_view_as_select_not_exist.q.out?rev=1621031&r1=1621030&r2=1621031&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientnegative/alter_view_as_select_not_exist.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientnegative/alter_view_as_select_not_exist.q.out Thu Aug 28 03:15:13 2014 @@ -3,4 +3,4 @@ PREHOOK: type: DROPVIEW POSTHOOK: query: DROP VIEW testView POSTHOOK: type: DROPVIEW FAILED: SemanticException [Error 10216]: Cannot ALTER VIEW AS SELECT if view currently does not exist - The following view does not exist: testView + The following view does not exist: default.testView Modified: hive/branches/cbo/ql/src/test/results/clientnegative/alter_view_as_select_with_partition.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientnegative/alter_view_as_select_with_partition.q.out?rev=1621031&r1=1621030&r2=1621031&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientnegative/alter_view_as_select_with_partition.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientnegative/alter_view_as_select_with_partition.q.out Thu Aug 28 03:15:13 2014 @@ -5,6 +5,8 @@ FROM src WHERE key=86 PREHOOK: type: CREATEVIEW PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@testViewPart POSTHOOK: query: CREATE VIEW testViewPart PARTITIONED ON (value) AS SELECT key, value @@ -12,6 +14,7 @@ FROM src WHERE key=86 POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@testViewPart PREHOOK: query: ALTER VIEW testViewPart ADD PARTITION (value='val_86') PARTITION (value='val_xyz') @@ -68,4 +71,4 @@ View Expanded Text: SELECT `src`.`key`, FROM `default`.`src` WHERE `src`.`key`=86 FAILED: SemanticException [Error 10217]: Cannot replace a view with CREATE VIEW or REPLACE VIEW or ALTER VIEW AS SELECT if the view has partitions - The following view has partition, it could not be replaced: testViewPart + The following view has partition, it could not be replaced: default.testViewPart Modified: hive/branches/cbo/ql/src/test/results/clientnegative/alter_view_failure.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientnegative/alter_view_failure.q.out?rev=1621031&r1=1621030&r2=1621031&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientnegative/alter_view_failure.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientnegative/alter_view_failure.q.out Thu Aug 28 03:15:13 2014 @@ -5,8 +5,11 @@ POSTHOOK: type: DROPVIEW PREHOOK: query: CREATE VIEW xxx3 AS SELECT * FROM src PREHOOK: type: CREATEVIEW PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@xxx3 POSTHOOK: query: CREATE VIEW xxx3 AS SELECT * FROM src POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@xxx3 FAILED: SemanticException [Error 10131]: To alter a view you need to use the ALTER VIEW command. Modified: hive/branches/cbo/ql/src/test/results/clientnegative/alter_view_failure2.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientnegative/alter_view_failure2.q.out?rev=1621031&r1=1621030&r2=1621031&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientnegative/alter_view_failure2.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientnegative/alter_view_failure2.q.out Thu Aug 28 03:15:13 2014 @@ -8,11 +8,14 @@ AS SELECT * FROM src PREHOOK: type: CREATEVIEW PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@xxx4 POSTHOOK: query: CREATE VIEW xxx4 PARTITIONED ON (value) AS SELECT * FROM src POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@xxx4 FAILED: SemanticException [Error 10131]: To alter a view you need to use the ALTER VIEW command. Modified: hive/branches/cbo/ql/src/test/results/clientnegative/alter_view_failure4.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientnegative/alter_view_failure4.q.out?rev=1621031&r1=1621030&r2=1621031&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientnegative/alter_view_failure4.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientnegative/alter_view_failure4.q.out Thu Aug 28 03:15:13 2014 @@ -8,11 +8,14 @@ AS SELECT * FROM src PREHOOK: type: CREATEVIEW PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@xxx5 POSTHOOK: query: CREATE VIEW xxx5 PARTITIONED ON (value) AS SELECT * FROM src POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@xxx5 FAILED: SemanticException LOCATION clause illegal for view partition Modified: hive/branches/cbo/ql/src/test/results/clientnegative/alter_view_failure5.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientnegative/alter_view_failure5.q.out?rev=1621031&r1=1621030&r2=1621031&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientnegative/alter_view_failure5.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientnegative/alter_view_failure5.q.out Thu Aug 28 03:15:13 2014 @@ -8,11 +8,14 @@ AS SELECT * FROM src PREHOOK: type: CREATEVIEW PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@xxx6 POSTHOOK: query: CREATE VIEW xxx6 PARTITIONED ON (value) AS SELECT * FROM src POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@xxx6 FAILED: SemanticException Partition spec {v=val_86} contains non-partition columns Modified: hive/branches/cbo/ql/src/test/results/clientnegative/alter_view_failure6.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientnegative/alter_view_failure6.q.out?rev=1621031&r1=1621030&r2=1621031&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientnegative/alter_view_failure6.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientnegative/alter_view_failure6.q.out Thu Aug 28 03:15:13 2014 @@ -8,12 +8,15 @@ AS SELECT hr,key FROM srcpart PREHOOK: type: CREATEVIEW PREHOOK: Input: default@srcpart +PREHOOK: Output: database:default +PREHOOK: Output: default@xxx7 POSTHOOK: query: CREATE VIEW xxx7 PARTITIONED ON (key) AS SELECT hr,key FROM srcpart POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@srcpart +POSTHOOK: Output: database:default POSTHOOK: Output: default@xxx7 FAILED: SemanticException [Error 10041]: No partition predicate found for Alias "default.xxx7:srcpart" Table "srcpart" FAILED: SemanticException [Error 10056]: The query does not reference any valid partition. To run this query, set hive.mapred.mode=nonstrict Modified: hive/branches/cbo/ql/src/test/results/clientnegative/alter_view_failure7.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientnegative/alter_view_failure7.q.out?rev=1621031&r1=1621030&r2=1621031&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientnegative/alter_view_failure7.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientnegative/alter_view_failure7.q.out Thu Aug 28 03:15:13 2014 @@ -8,11 +8,14 @@ AS SELECT key,ds,hr FROM srcpart PREHOOK: type: CREATEVIEW PREHOOK: Input: default@srcpart +PREHOOK: Output: database:default +PREHOOK: Output: default@xxx8 POSTHOOK: query: CREATE VIEW xxx8 PARTITIONED ON (ds,hr) AS SELECT key,ds,hr FROM srcpart POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@srcpart +POSTHOOK: Output: database:default POSTHOOK: Output: default@xxx8 FAILED: SemanticException partition spec {ds=2011-01-01} doesn't contain all (2) partition columns Modified: hive/branches/cbo/ql/src/test/results/clientnegative/alter_view_failure9.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientnegative/alter_view_failure9.q.out?rev=1621031&r1=1621030&r2=1621031&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientnegative/alter_view_failure9.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientnegative/alter_view_failure9.q.out Thu Aug 28 03:15:13 2014 @@ -7,10 +7,13 @@ AS SELECT * FROM src PREHOOK: type: CREATEVIEW PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@xxx4 POSTHOOK: query: CREATE VIEW xxx4 AS SELECT * FROM src POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@xxx4 FAILED: SemanticException [Error 10131]: To alter a view you need to use the ALTER VIEW command. Modified: hive/branches/cbo/ql/src/test/results/clientnegative/analyze_view.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientnegative/analyze_view.q.out?rev=1621031&r1=1621030&r2=1621031&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientnegative/analyze_view.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientnegative/analyze_view.q.out Thu Aug 28 03:15:13 2014 @@ -5,8 +5,11 @@ POSTHOOK: type: DROPVIEW PREHOOK: query: CREATE VIEW av AS SELECT * FROM src PREHOOK: type: CREATEVIEW PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@av POSTHOOK: query: CREATE VIEW av AS SELECT * FROM src POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@av FAILED: SemanticException [Error 10091]: ANALYZE is not supported for views Modified: hive/branches/cbo/ql/src/test/results/clientnegative/authorization_drop_db_cascade.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientnegative/authorization_drop_db_cascade.q.out?rev=1621031&r1=1621030&r2=1621031&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientnegative/authorization_drop_db_cascade.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientnegative/authorization_drop_db_cascade.q.out Thu Aug 28 03:15:13 2014 @@ -9,11 +9,10 @@ POSTHOOK: Output: database:dba1 PREHOOK: query: create table dba1.tab1(i int) PREHOOK: type: CREATETABLE PREHOOK: Output: database:dba1 -PREHOOK: Output: dba1@dba1.tab1 +PREHOOK: Output: dba1@tab1 POSTHOOK: query: create table dba1.tab1(i int) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:dba1 -POSTHOOK: Output: dba1@dba1.tab1 POSTHOOK: Output: dba1@tab1 PREHOOK: query: drop database dba1 cascade PREHOOK: type: DROPDATABASE @@ -36,11 +35,10 @@ POSTHOOK: Output: database:dba2 PREHOOK: query: create table dba2.tab2(i int) PREHOOK: type: CREATETABLE PREHOOK: Output: database:dba2 -PREHOOK: Output: dba2@dba2.tab2 +PREHOOK: Output: dba2@tab2 POSTHOOK: query: create table dba2.tab2(i int) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:dba2 -POSTHOOK: Output: dba2@dba2.tab2 POSTHOOK: Output: dba2@tab2 PREHOOK: query: set role ADMIN PREHOOK: type: SHOW_ROLES Modified: hive/branches/cbo/ql/src/test/results/clientnegative/authorization_not_owner_drop_view.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientnegative/authorization_not_owner_drop_view.q.out?rev=1621031&r1=1621030&r2=1621031&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientnegative/authorization_not_owner_drop_view.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientnegative/authorization_not_owner_drop_view.q.out Thu Aug 28 03:15:13 2014 @@ -11,8 +11,11 @@ POSTHOOK: Output: default@t1 PREHOOK: query: create view vt1 as select * from t1 PREHOOK: type: CREATEVIEW PREHOOK: Input: default@t1 +PREHOOK: Output: database:default +PREHOOK: Output: default@vt1 POSTHOOK: query: create view vt1 as select * from t1 POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@t1 +POSTHOOK: Output: database:default POSTHOOK: Output: default@vt1 FAILED: HiveAccessControlException Permission denied: Principal [name=user2, type=USER] does not have following privileges for operation DROPVIEW [[OBJECT OWNERSHIP] on Object [type=TABLE_OR_VIEW, name=default.vt1], [OBJECT OWNERSHIP] on Object [type=TABLE_OR_VIEW, name=default.vt1]] Modified: hive/branches/cbo/ql/src/test/results/clientnegative/authorization_part.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientnegative/authorization_part.q.out?rev=1621031&r1=1621030&r2=1621031&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientnegative/authorization_part.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientnegative/authorization_part.q.out Thu Aug 28 03:15:13 2014 @@ -21,9 +21,12 @@ POSTHOOK: Output: default@authorization_ PREHOOK: query: create table src_auth as select * from src PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@src_auth POSTHOOK: query: create table src_auth as select * from src POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@src_auth PREHOOK: query: grant Create on table authorization_part_fail to user hive_test_user PREHOOK: type: GRANT_PRIVILEGE