You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by gu...@apache.org on 2014/08/28 05:15:19 UTC
svn commit: r1621031 [4/10] - in /hive/branches/cbo: ./
common/src/java/org/apache/hadoop/hive/conf/
contrib/src/test/results/clientnegative/
contrib/src/test/results/clientpositive/ data/files/
hbase-handler/src/test/results/negative/ hcatalog/core/sr...
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