http://git-wip-us.apache.org/repos/asf/hive/blob/187eb760/itests/hive-blobstore/src/test/results/clientpositive/import_addpartition_blobstore_to_local.q.out ---------------------------------------------------------------------- diff --git a/itests/hive-blobstore/src/test/results/clientpositive/import_addpartition_blobstore_to_local.q.out b/itests/hive-blobstore/src/test/results/clientpositive/import_addpartition_blobstore_to_local.q.out new file mode 100644 index 0000000..4d296da --- /dev/null +++ b/itests/hive-blobstore/src/test/results/clientpositive/import_addpartition_blobstore_to_local.q.out @@ -0,0 +1,283 @@ +PREHOOK: query: DROP TABLE exim_employee +PREHOOK: type: DROPTABLE +POSTHOOK: query: DROP TABLE exim_employee +POSTHOOK: type: DROPTABLE +PREHOOK: query: CREATE TABLE exim_employee (emp_id int COMMENT "employee id") +COMMENT "employee table" +PARTITIONED BY (emp_country string COMMENT "two char iso code") +STORED AS TEXTFILE +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@exim_employee +POSTHOOK: query: CREATE TABLE exim_employee (emp_id int COMMENT "employee id") +COMMENT "employee table" +PARTITIONED BY (emp_country string COMMENT "two char iso code") +STORED AS TEXTFILE +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@exim_employee +PREHOOK: query: LOAD DATA LOCAL INPATH "../../data/files/test.dat" +INTO TABLE exim_employee PARTITION (emp_country="in") +PREHOOK: type: LOAD +#### A masked pattern was here #### +PREHOOK: Output: default@exim_employee +POSTHOOK: query: LOAD DATA LOCAL INPATH "../../data/files/test.dat" +INTO TABLE exim_employee PARTITION (emp_country="in") +POSTHOOK: type: LOAD +#### A masked pattern was here #### +POSTHOOK: Output: default@exim_employee +POSTHOOK: Output: default@exim_employee@emp_country=in +PREHOOK: query: LOAD DATA LOCAL INPATH "../../data/files/test.dat" +INTO TABLE exim_employee PARTITION (emp_country="us") +PREHOOK: type: LOAD +#### A masked pattern was here #### +PREHOOK: Output: default@exim_employee +POSTHOOK: query: LOAD DATA LOCAL INPATH "../../data/files/test.dat" +INTO TABLE exim_employee PARTITION (emp_country="us") +POSTHOOK: type: LOAD +#### A masked pattern was here #### +POSTHOOK: Output: default@exim_employee +POSTHOOK: Output: default@exim_employee@emp_country=us +PREHOOK: query: LOAD DATA LOCAL INPATH "../../data/files/test.dat" +INTO TABLE exim_employee PARTITION (emp_country="cz") +PREHOOK: type: LOAD +#### A masked pattern was here #### +PREHOOK: Output: default@exim_employee +POSTHOOK: query: LOAD DATA LOCAL INPATH "../../data/files/test.dat" +INTO TABLE exim_employee PARTITION (emp_country="cz") +POSTHOOK: type: LOAD +#### A masked pattern was here #### +POSTHOOK: Output: default@exim_employee +POSTHOOK: Output: default@exim_employee@emp_country=cz +PREHOOK: query: DESCRIBE EXTENDED exim_employee +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@exim_employee +POSTHOOK: query: DESCRIBE EXTENDED exim_employee +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@exim_employee +emp_id int employee id +emp_country string two char iso code + +# Partition Information +# col_name data_type comment + +emp_country string two char iso code + +#### A masked pattern was here #### +PREHOOK: query: SELECT * FROM exim_employee +PREHOOK: type: QUERY +PREHOOK: Input: default@exim_employee +PREHOOK: Input: default@exim_employee@emp_country=cz +PREHOOK: Input: default@exim_employee@emp_country=in +PREHOOK: Input: default@exim_employee@emp_country=us +#### A masked pattern was here #### +POSTHOOK: query: SELECT * FROM exim_employee +POSTHOOK: type: QUERY +POSTHOOK: Input: default@exim_employee +POSTHOOK: Input: default@exim_employee@emp_country=cz +POSTHOOK: Input: default@exim_employee@emp_country=in +POSTHOOK: Input: default@exim_employee@emp_country=us +#### A masked pattern was here #### +1 cz +2 cz +3 cz +4 cz +5 cz +6 cz +1 in +2 in +3 in +4 in +5 in +6 in +1 us +2 us +3 us +4 us +5 us +6 us +PREHOOK: query: EXPORT TABLE exim_employee +TO '### test.blobstore.path ###/import_addpartition_blobstore_to_local/export/exim_employee' +PREHOOK: type: EXPORT +PREHOOK: Input: default@exim_employee@emp_country=cz +PREHOOK: Input: default@exim_employee@emp_country=in +PREHOOK: Input: default@exim_employee@emp_country=us +PREHOOK: Output: ### test.blobstore.path ###/import_addpartition_blobstore_to_local/export/exim_employee +POSTHOOK: query: EXPORT TABLE exim_employee +TO '### test.blobstore.path ###/import_addpartition_blobstore_to_local/export/exim_employee' +POSTHOOK: type: EXPORT +POSTHOOK: Input: default@exim_employee@emp_country=cz +POSTHOOK: Input: default@exim_employee@emp_country=in +POSTHOOK: Input: default@exim_employee@emp_country=us +POSTHOOK: Output: ### test.blobstore.path ###/import_addpartition_blobstore_to_local/export/exim_employee +PREHOOK: query: DROP TABLE exim_employee +PREHOOK: type: DROPTABLE +PREHOOK: Input: default@exim_employee +PREHOOK: Output: default@exim_employee +POSTHOOK: query: DROP TABLE exim_employee +POSTHOOK: type: DROPTABLE +POSTHOOK: Input: default@exim_employee +POSTHOOK: Output: default@exim_employee +PREHOOK: query: IMPORT TABLE exim_employee PARTITION (emp_country='us') +FROM '### test.blobstore.path ###/import_addpartition_blobstore_to_local/export/exim_employee' +#### A masked pattern was here #### +PREHOOK: type: IMPORT +#### A masked pattern was here #### +PREHOOK: Input: ### test.blobstore.path ###/import_addpartition_blobstore_to_local/export/exim_employee +PREHOOK: Output: database:default +POSTHOOK: query: IMPORT TABLE exim_employee PARTITION (emp_country='us') +FROM '### test.blobstore.path ###/import_addpartition_blobstore_to_local/export/exim_employee' +#### A masked pattern was here #### +POSTHOOK: type: IMPORT +#### A masked pattern was here #### +POSTHOOK: Input: ### test.blobstore.path ###/import_addpartition_blobstore_to_local/export/exim_employee +POSTHOOK: Output: database:default +POSTHOOK: Output: default@exim_employee +POSTHOOK: Output: default@exim_employee@emp_country=us +PREHOOK: query: DESCRIBE EXTENDED exim_employee +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@exim_employee +POSTHOOK: query: DESCRIBE EXTENDED exim_employee +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@exim_employee +emp_id int employee id +emp_country string two char iso code + +# Partition Information +# col_name data_type comment + +emp_country string two char iso code + +#### A masked pattern was here #### +PREHOOK: query: SELECT * FROM exim_employee +PREHOOK: type: QUERY +PREHOOK: Input: default@exim_employee +PREHOOK: Input: default@exim_employee@emp_country=us +#### A masked pattern was here #### +POSTHOOK: query: SELECT * FROM exim_employee +POSTHOOK: type: QUERY +POSTHOOK: Input: default@exim_employee +POSTHOOK: Input: default@exim_employee@emp_country=us +#### A masked pattern was here #### +1 us +2 us +3 us +4 us +5 us +6 us +PREHOOK: query: IMPORT TABLE exim_employee PARTITION (emp_country='cz') +FROM '### test.blobstore.path ###/import_addpartition_blobstore_to_local/export/exim_employee' +#### A masked pattern was here #### +PREHOOK: type: IMPORT +#### A masked pattern was here #### +PREHOOK: Input: ### test.blobstore.path ###/import_addpartition_blobstore_to_local/export/exim_employee +PREHOOK: Output: default@exim_employee +POSTHOOK: query: IMPORT TABLE exim_employee PARTITION (emp_country='cz') +FROM '### test.blobstore.path ###/import_addpartition_blobstore_to_local/export/exim_employee' +#### A masked pattern was here #### +POSTHOOK: type: IMPORT +#### A masked pattern was here #### +POSTHOOK: Input: ### test.blobstore.path ###/import_addpartition_blobstore_to_local/export/exim_employee +POSTHOOK: Output: default@exim_employee +POSTHOOK: Output: default@exim_employee@emp_country=cz +PREHOOK: query: DESCRIBE EXTENDED exim_employee +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@exim_employee +POSTHOOK: query: DESCRIBE EXTENDED exim_employee +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@exim_employee +emp_id int employee id +emp_country string two char iso code + +# Partition Information +# col_name data_type comment + +emp_country string two char iso code + +#### A masked pattern was here #### +PREHOOK: query: SELECT * FROM exim_employee +PREHOOK: type: QUERY +PREHOOK: Input: default@exim_employee +PREHOOK: Input: default@exim_employee@emp_country=cz +PREHOOK: Input: default@exim_employee@emp_country=us +#### A masked pattern was here #### +POSTHOOK: query: SELECT * FROM exim_employee +POSTHOOK: type: QUERY +POSTHOOK: Input: default@exim_employee +POSTHOOK: Input: default@exim_employee@emp_country=cz +POSTHOOK: Input: default@exim_employee@emp_country=us +#### A masked pattern was here #### +1 cz +2 cz +3 cz +4 cz +5 cz +6 cz +1 us +2 us +3 us +4 us +5 us +6 us +PREHOOK: query: IMPORT TABLE exim_employee PARTITION (emp_country='in') +FROM '### test.blobstore.path ###/import_addpartition_blobstore_to_local/export/exim_employee' +#### A masked pattern was here #### +PREHOOK: type: IMPORT +#### A masked pattern was here #### +PREHOOK: Input: ### test.blobstore.path ###/import_addpartition_blobstore_to_local/export/exim_employee +PREHOOK: Output: default@exim_employee +POSTHOOK: query: IMPORT TABLE exim_employee PARTITION (emp_country='in') +FROM '### test.blobstore.path ###/import_addpartition_blobstore_to_local/export/exim_employee' +#### A masked pattern was here #### +POSTHOOK: type: IMPORT +#### A masked pattern was here #### +POSTHOOK: Input: ### test.blobstore.path ###/import_addpartition_blobstore_to_local/export/exim_employee +POSTHOOK: Output: default@exim_employee +POSTHOOK: Output: default@exim_employee@emp_country=in +PREHOOK: query: DESCRIBE EXTENDED exim_employee +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@exim_employee +POSTHOOK: query: DESCRIBE EXTENDED exim_employee +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@exim_employee +emp_id int employee id +emp_country string two char iso code + +# Partition Information +# col_name data_type comment + +emp_country string two char iso code + +#### A masked pattern was here #### +PREHOOK: query: SELECT * FROM exim_employee +PREHOOK: type: QUERY +PREHOOK: Input: default@exim_employee +PREHOOK: Input: default@exim_employee@emp_country=cz +PREHOOK: Input: default@exim_employee@emp_country=in +PREHOOK: Input: default@exim_employee@emp_country=us +#### A masked pattern was here #### +POSTHOOK: query: SELECT * FROM exim_employee +POSTHOOK: type: QUERY +POSTHOOK: Input: default@exim_employee +POSTHOOK: Input: default@exim_employee@emp_country=cz +POSTHOOK: Input: default@exim_employee@emp_country=in +POSTHOOK: Input: default@exim_employee@emp_country=us +#### A masked pattern was here #### +1 cz +2 cz +3 cz +4 cz +5 cz +6 cz +1 in +2 in +3 in +4 in +5 in +6 in +1 us +2 us +3 us +4 us +5 us +6 us
http://git-wip-us.apache.org/repos/asf/hive/blob/187eb760/itests/hive-blobstore/src/test/results/clientpositive/import_addpartition_blobstore_to_warehouse.q.out ---------------------------------------------------------------------- diff --git a/itests/hive-blobstore/src/test/results/clientpositive/import_addpartition_blobstore_to_warehouse.q.out b/itests/hive-blobstore/src/test/results/clientpositive/import_addpartition_blobstore_to_warehouse.q.out new file mode 100644 index 0000000..fce5ffe --- /dev/null +++ b/itests/hive-blobstore/src/test/results/clientpositive/import_addpartition_blobstore_to_warehouse.q.out @@ -0,0 +1,271 @@ +PREHOOK: query: DROP TABLE exim_employee +PREHOOK: type: DROPTABLE +POSTHOOK: query: DROP TABLE exim_employee +POSTHOOK: type: DROPTABLE +PREHOOK: query: CREATE TABLE exim_employee (emp_id int COMMENT "employee id") +COMMENT "employee table" +PARTITIONED BY (emp_country string COMMENT "two char iso code") +STORED AS TEXTFILE +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@exim_employee +POSTHOOK: query: CREATE TABLE exim_employee (emp_id int COMMENT "employee id") +COMMENT "employee table" +PARTITIONED BY (emp_country string COMMENT "two char iso code") +STORED AS TEXTFILE +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@exim_employee +PREHOOK: query: LOAD DATA LOCAL INPATH "../../data/files/test.dat" +INTO TABLE exim_employee PARTITION (emp_country="in") +PREHOOK: type: LOAD +#### A masked pattern was here #### +PREHOOK: Output: default@exim_employee +POSTHOOK: query: LOAD DATA LOCAL INPATH "../../data/files/test.dat" +INTO TABLE exim_employee PARTITION (emp_country="in") +POSTHOOK: type: LOAD +#### A masked pattern was here #### +POSTHOOK: Output: default@exim_employee +POSTHOOK: Output: default@exim_employee@emp_country=in +PREHOOK: query: LOAD DATA LOCAL INPATH "../../data/files/test.dat" +INTO TABLE exim_employee PARTITION (emp_country="us") +PREHOOK: type: LOAD +#### A masked pattern was here #### +PREHOOK: Output: default@exim_employee +POSTHOOK: query: LOAD DATA LOCAL INPATH "../../data/files/test.dat" +INTO TABLE exim_employee PARTITION (emp_country="us") +POSTHOOK: type: LOAD +#### A masked pattern was here #### +POSTHOOK: Output: default@exim_employee +POSTHOOK: Output: default@exim_employee@emp_country=us +PREHOOK: query: LOAD DATA LOCAL INPATH "../../data/files/test.dat" +INTO TABLE exim_employee PARTITION (emp_country="cz") +PREHOOK: type: LOAD +#### A masked pattern was here #### +PREHOOK: Output: default@exim_employee +POSTHOOK: query: LOAD DATA LOCAL INPATH "../../data/files/test.dat" +INTO TABLE exim_employee PARTITION (emp_country="cz") +POSTHOOK: type: LOAD +#### A masked pattern was here #### +POSTHOOK: Output: default@exim_employee +POSTHOOK: Output: default@exim_employee@emp_country=cz +PREHOOK: query: DESCRIBE EXTENDED exim_employee +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@exim_employee +POSTHOOK: query: DESCRIBE EXTENDED exim_employee +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@exim_employee +emp_id int employee id +emp_country string two char iso code + +# Partition Information +# col_name data_type comment + +emp_country string two char iso code + +#### A masked pattern was here #### +PREHOOK: query: SELECT * FROM exim_employee +PREHOOK: type: QUERY +PREHOOK: Input: default@exim_employee +PREHOOK: Input: default@exim_employee@emp_country=cz +PREHOOK: Input: default@exim_employee@emp_country=in +PREHOOK: Input: default@exim_employee@emp_country=us +#### A masked pattern was here #### +POSTHOOK: query: SELECT * FROM exim_employee +POSTHOOK: type: QUERY +POSTHOOK: Input: default@exim_employee +POSTHOOK: Input: default@exim_employee@emp_country=cz +POSTHOOK: Input: default@exim_employee@emp_country=in +POSTHOOK: Input: default@exim_employee@emp_country=us +#### A masked pattern was here #### +1 cz +2 cz +3 cz +4 cz +5 cz +6 cz +1 in +2 in +3 in +4 in +5 in +6 in +1 us +2 us +3 us +4 us +5 us +6 us +PREHOOK: query: EXPORT TABLE exim_employee +TO '### test.blobstore.path ###/import_addpartition_blobstore_to_warehouse/export/exim_employee' +PREHOOK: type: EXPORT +PREHOOK: Input: default@exim_employee@emp_country=cz +PREHOOK: Input: default@exim_employee@emp_country=in +PREHOOK: Input: default@exim_employee@emp_country=us +PREHOOK: Output: ### test.blobstore.path ###/import_addpartition_blobstore_to_warehouse/export/exim_employee +POSTHOOK: query: EXPORT TABLE exim_employee +TO '### test.blobstore.path ###/import_addpartition_blobstore_to_warehouse/export/exim_employee' +POSTHOOK: type: EXPORT +POSTHOOK: Input: default@exim_employee@emp_country=cz +POSTHOOK: Input: default@exim_employee@emp_country=in +POSTHOOK: Input: default@exim_employee@emp_country=us +POSTHOOK: Output: ### test.blobstore.path ###/import_addpartition_blobstore_to_warehouse/export/exim_employee +PREHOOK: query: DROP TABLE exim_employee +PREHOOK: type: DROPTABLE +PREHOOK: Input: default@exim_employee +PREHOOK: Output: default@exim_employee +POSTHOOK: query: DROP TABLE exim_employee +POSTHOOK: type: DROPTABLE +POSTHOOK: Input: default@exim_employee +POSTHOOK: Output: default@exim_employee +PREHOOK: query: IMPORT TABLE exim_employee PARTITION (emp_country='us') +FROM '### test.blobstore.path ###/import_addpartition_blobstore_to_warehouse/export/exim_employee' +PREHOOK: type: IMPORT +PREHOOK: Input: ### test.blobstore.path ###/import_addpartition_blobstore_to_warehouse/export/exim_employee +PREHOOK: Output: database:default +POSTHOOK: query: IMPORT TABLE exim_employee PARTITION (emp_country='us') +FROM '### test.blobstore.path ###/import_addpartition_blobstore_to_warehouse/export/exim_employee' +POSTHOOK: type: IMPORT +POSTHOOK: Input: ### test.blobstore.path ###/import_addpartition_blobstore_to_warehouse/export/exim_employee +POSTHOOK: Output: database:default +POSTHOOK: Output: default@exim_employee +POSTHOOK: Output: default@exim_employee@emp_country=us +PREHOOK: query: DESCRIBE EXTENDED exim_employee +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@exim_employee +POSTHOOK: query: DESCRIBE EXTENDED exim_employee +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@exim_employee +emp_id int employee id +emp_country string two char iso code + +# Partition Information +# col_name data_type comment + +emp_country string two char iso code + +#### A masked pattern was here #### +PREHOOK: query: SELECT * FROM exim_employee +PREHOOK: type: QUERY +PREHOOK: Input: default@exim_employee +PREHOOK: Input: default@exim_employee@emp_country=us +#### A masked pattern was here #### +POSTHOOK: query: SELECT * FROM exim_employee +POSTHOOK: type: QUERY +POSTHOOK: Input: default@exim_employee +POSTHOOK: Input: default@exim_employee@emp_country=us +#### A masked pattern was here #### +1 us +2 us +3 us +4 us +5 us +6 us +PREHOOK: query: IMPORT TABLE exim_employee PARTITION (emp_country='cz') +FROM '### test.blobstore.path ###/import_addpartition_blobstore_to_warehouse/export/exim_employee' +PREHOOK: type: IMPORT +PREHOOK: Input: ### test.blobstore.path ###/import_addpartition_blobstore_to_warehouse/export/exim_employee +PREHOOK: Output: default@exim_employee +POSTHOOK: query: IMPORT TABLE exim_employee PARTITION (emp_country='cz') +FROM '### test.blobstore.path ###/import_addpartition_blobstore_to_warehouse/export/exim_employee' +POSTHOOK: type: IMPORT +POSTHOOK: Input: ### test.blobstore.path ###/import_addpartition_blobstore_to_warehouse/export/exim_employee +POSTHOOK: Output: default@exim_employee +POSTHOOK: Output: default@exim_employee@emp_country=cz +PREHOOK: query: DESCRIBE EXTENDED exim_employee +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@exim_employee +POSTHOOK: query: DESCRIBE EXTENDED exim_employee +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@exim_employee +emp_id int employee id +emp_country string two char iso code + +# Partition Information +# col_name data_type comment + +emp_country string two char iso code + +#### A masked pattern was here #### +PREHOOK: query: SELECT * FROM exim_employee +PREHOOK: type: QUERY +PREHOOK: Input: default@exim_employee +PREHOOK: Input: default@exim_employee@emp_country=cz +PREHOOK: Input: default@exim_employee@emp_country=us +#### A masked pattern was here #### +POSTHOOK: query: SELECT * FROM exim_employee +POSTHOOK: type: QUERY +POSTHOOK: Input: default@exim_employee +POSTHOOK: Input: default@exim_employee@emp_country=cz +POSTHOOK: Input: default@exim_employee@emp_country=us +#### A masked pattern was here #### +1 cz +2 cz +3 cz +4 cz +5 cz +6 cz +1 us +2 us +3 us +4 us +5 us +6 us +PREHOOK: query: IMPORT TABLE exim_employee PARTITION (emp_country='in') +FROM '### test.blobstore.path ###/import_addpartition_blobstore_to_warehouse/export/exim_employee' +PREHOOK: type: IMPORT +PREHOOK: Input: ### test.blobstore.path ###/import_addpartition_blobstore_to_warehouse/export/exim_employee +PREHOOK: Output: default@exim_employee +POSTHOOK: query: IMPORT TABLE exim_employee PARTITION (emp_country='in') +FROM '### test.blobstore.path ###/import_addpartition_blobstore_to_warehouse/export/exim_employee' +POSTHOOK: type: IMPORT +POSTHOOK: Input: ### test.blobstore.path ###/import_addpartition_blobstore_to_warehouse/export/exim_employee +POSTHOOK: Output: default@exim_employee +POSTHOOK: Output: default@exim_employee@emp_country=in +PREHOOK: query: DESCRIBE EXTENDED exim_employee +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@exim_employee +POSTHOOK: query: DESCRIBE EXTENDED exim_employee +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@exim_employee +emp_id int employee id +emp_country string two char iso code + +# Partition Information +# col_name data_type comment + +emp_country string two char iso code + +#### A masked pattern was here #### +PREHOOK: query: SELECT * FROM exim_employee +PREHOOK: type: QUERY +PREHOOK: Input: default@exim_employee +PREHOOK: Input: default@exim_employee@emp_country=cz +PREHOOK: Input: default@exim_employee@emp_country=in +PREHOOK: Input: default@exim_employee@emp_country=us +#### A masked pattern was here #### +POSTHOOK: query: SELECT * FROM exim_employee +POSTHOOK: type: QUERY +POSTHOOK: Input: default@exim_employee +POSTHOOK: Input: default@exim_employee@emp_country=cz +POSTHOOK: Input: default@exim_employee@emp_country=in +POSTHOOK: Input: default@exim_employee@emp_country=us +#### A masked pattern was here #### +1 cz +2 cz +3 cz +4 cz +5 cz +6 cz +1 in +2 in +3 in +4 in +5 in +6 in +1 us +2 us +3 us +4 us +5 us +6 us http://git-wip-us.apache.org/repos/asf/hive/blob/187eb760/itests/hive-blobstore/src/test/results/clientpositive/import_addpartition_local_to_blobstore.q.out ---------------------------------------------------------------------- diff --git a/itests/hive-blobstore/src/test/results/clientpositive/import_addpartition_local_to_blobstore.q.out b/itests/hive-blobstore/src/test/results/clientpositive/import_addpartition_local_to_blobstore.q.out new file mode 100644 index 0000000..72068c5 --- /dev/null +++ b/itests/hive-blobstore/src/test/results/clientpositive/import_addpartition_local_to_blobstore.q.out @@ -0,0 +1,277 @@ +PREHOOK: query: DROP TABLE exim_employee +PREHOOK: type: DROPTABLE +POSTHOOK: query: DROP TABLE exim_employee +POSTHOOK: type: DROPTABLE +PREHOOK: query: CREATE TABLE exim_employee (emp_id int COMMENT "employee id") +COMMENT "employee table" +PARTITIONED BY (emp_country string COMMENT "two char iso code") +STORED AS TEXTFILE +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@exim_employee +POSTHOOK: query: CREATE TABLE exim_employee (emp_id int COMMENT "employee id") +COMMENT "employee table" +PARTITIONED BY (emp_country string COMMENT "two char iso code") +STORED AS TEXTFILE +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@exim_employee +PREHOOK: query: LOAD DATA LOCAL INPATH "../../data/files/test.dat" +INTO TABLE exim_employee PARTITION (emp_country="in") +PREHOOK: type: LOAD +#### A masked pattern was here #### +PREHOOK: Output: default@exim_employee +POSTHOOK: query: LOAD DATA LOCAL INPATH "../../data/files/test.dat" +INTO TABLE exim_employee PARTITION (emp_country="in") +POSTHOOK: type: LOAD +#### A masked pattern was here #### +POSTHOOK: Output: default@exim_employee +POSTHOOK: Output: default@exim_employee@emp_country=in +PREHOOK: query: LOAD DATA LOCAL INPATH "../../data/files/test.dat" +INTO TABLE exim_employee PARTITION (emp_country="us") +PREHOOK: type: LOAD +#### A masked pattern was here #### +PREHOOK: Output: default@exim_employee +POSTHOOK: query: LOAD DATA LOCAL INPATH "../../data/files/test.dat" +INTO TABLE exim_employee PARTITION (emp_country="us") +POSTHOOK: type: LOAD +#### A masked pattern was here #### +POSTHOOK: Output: default@exim_employee +POSTHOOK: Output: default@exim_employee@emp_country=us +PREHOOK: query: LOAD DATA LOCAL INPATH "../../data/files/test.dat" +INTO TABLE exim_employee PARTITION (emp_country="cz") +PREHOOK: type: LOAD +#### A masked pattern was here #### +PREHOOK: Output: default@exim_employee +POSTHOOK: query: LOAD DATA LOCAL INPATH "../../data/files/test.dat" +INTO TABLE exim_employee PARTITION (emp_country="cz") +POSTHOOK: type: LOAD +#### A masked pattern was here #### +POSTHOOK: Output: default@exim_employee +POSTHOOK: Output: default@exim_employee@emp_country=cz +PREHOOK: query: DESCRIBE EXTENDED exim_employee +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@exim_employee +POSTHOOK: query: DESCRIBE EXTENDED exim_employee +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@exim_employee +emp_id int employee id +emp_country string two char iso code + +# Partition Information +# col_name data_type comment + +emp_country string two char iso code + +#### A masked pattern was here #### +PREHOOK: query: SELECT * FROM exim_employee +PREHOOK: type: QUERY +PREHOOK: Input: default@exim_employee +PREHOOK: Input: default@exim_employee@emp_country=cz +PREHOOK: Input: default@exim_employee@emp_country=in +PREHOOK: Input: default@exim_employee@emp_country=us +#### A masked pattern was here #### +POSTHOOK: query: SELECT * FROM exim_employee +POSTHOOK: type: QUERY +POSTHOOK: Input: default@exim_employee +POSTHOOK: Input: default@exim_employee@emp_country=cz +POSTHOOK: Input: default@exim_employee@emp_country=in +POSTHOOK: Input: default@exim_employee@emp_country=us +#### A masked pattern was here #### +1 cz +2 cz +3 cz +4 cz +5 cz +6 cz +1 in +2 in +3 in +4 in +5 in +6 in +1 us +2 us +3 us +4 us +5 us +6 us +PREHOOK: query: EXPORT TABLE exim_employee +#### A masked pattern was here #### +PREHOOK: type: EXPORT +PREHOOK: Input: default@exim_employee@emp_country=cz +PREHOOK: Input: default@exim_employee@emp_country=in +PREHOOK: Input: default@exim_employee@emp_country=us +#### A masked pattern was here #### +POSTHOOK: query: EXPORT TABLE exim_employee +#### A masked pattern was here #### +POSTHOOK: type: EXPORT +POSTHOOK: Input: default@exim_employee@emp_country=cz +POSTHOOK: Input: default@exim_employee@emp_country=in +POSTHOOK: Input: default@exim_employee@emp_country=us +#### A masked pattern was here #### +PREHOOK: query: DROP TABLE exim_employee +PREHOOK: type: DROPTABLE +PREHOOK: Input: default@exim_employee +PREHOOK: Output: default@exim_employee +POSTHOOK: query: DROP TABLE exim_employee +POSTHOOK: type: DROPTABLE +POSTHOOK: Input: default@exim_employee +POSTHOOK: Output: default@exim_employee +PREHOOK: query: IMPORT TABLE exim_employee PARTITION (emp_country='us') +#### A masked pattern was here #### +PREHOOK: type: IMPORT +#### A masked pattern was here #### +PREHOOK: Input: ### test.blobstore.path ###/import_addpartition_local_to_blobstore/import/exim_employee +PREHOOK: Output: database:default +POSTHOOK: query: IMPORT TABLE exim_employee PARTITION (emp_country='us') +#### A masked pattern was here #### +POSTHOOK: type: IMPORT +#### A masked pattern was here #### +POSTHOOK: Input: ### test.blobstore.path ###/import_addpartition_local_to_blobstore/import/exim_employee +POSTHOOK: Output: database:default +POSTHOOK: Output: default@exim_employee +POSTHOOK: Output: default@exim_employee@emp_country=us +PREHOOK: query: DESCRIBE EXTENDED exim_employee +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@exim_employee +POSTHOOK: query: DESCRIBE EXTENDED exim_employee +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@exim_employee +emp_id int employee id +emp_country string two char iso code + +# Partition Information +# col_name data_type comment + +emp_country string two char iso code + +#### A masked pattern was here #### +PREHOOK: query: SELECT * FROM exim_employee +PREHOOK: type: QUERY +PREHOOK: Input: default@exim_employee +PREHOOK: Input: default@exim_employee@emp_country=us +#### A masked pattern was here #### +POSTHOOK: query: SELECT * FROM exim_employee +POSTHOOK: type: QUERY +POSTHOOK: Input: default@exim_employee +POSTHOOK: Input: default@exim_employee@emp_country=us +#### A masked pattern was here #### +1 us +2 us +3 us +4 us +5 us +6 us +PREHOOK: query: IMPORT TABLE exim_employee PARTITION (emp_country='cz') +#### A masked pattern was here #### +PREHOOK: type: IMPORT +#### A masked pattern was here #### +PREHOOK: Input: ### test.blobstore.path ###/import_addpartition_local_to_blobstore/import/exim_employee +PREHOOK: Output: default@exim_employee +POSTHOOK: query: IMPORT TABLE exim_employee PARTITION (emp_country='cz') +#### A masked pattern was here #### +POSTHOOK: type: IMPORT +#### A masked pattern was here #### +POSTHOOK: Input: ### test.blobstore.path ###/import_addpartition_local_to_blobstore/import/exim_employee +POSTHOOK: Output: default@exim_employee +POSTHOOK: Output: default@exim_employee@emp_country=cz +PREHOOK: query: DESCRIBE EXTENDED exim_employee +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@exim_employee +POSTHOOK: query: DESCRIBE EXTENDED exim_employee +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@exim_employee +emp_id int employee id +emp_country string two char iso code + +# Partition Information +# col_name data_type comment + +emp_country string two char iso code + +#### A masked pattern was here #### +PREHOOK: query: SELECT * FROM exim_employee +PREHOOK: type: QUERY +PREHOOK: Input: default@exim_employee +PREHOOK: Input: default@exim_employee@emp_country=cz +PREHOOK: Input: default@exim_employee@emp_country=us +#### A masked pattern was here #### +POSTHOOK: query: SELECT * FROM exim_employee +POSTHOOK: type: QUERY +POSTHOOK: Input: default@exim_employee +POSTHOOK: Input: default@exim_employee@emp_country=cz +POSTHOOK: Input: default@exim_employee@emp_country=us +#### A masked pattern was here #### +1 cz +2 cz +3 cz +4 cz +5 cz +6 cz +1 us +2 us +3 us +4 us +5 us +6 us +PREHOOK: query: IMPORT TABLE exim_employee PARTITION (emp_country='in') +#### A masked pattern was here #### +PREHOOK: type: IMPORT +#### A masked pattern was here #### +PREHOOK: Input: ### test.blobstore.path ###/import_addpartition_local_to_blobstore/import/exim_employee +PREHOOK: Output: default@exim_employee +POSTHOOK: query: IMPORT TABLE exim_employee PARTITION (emp_country='in') +#### A masked pattern was here #### +POSTHOOK: type: IMPORT +#### A masked pattern was here #### +POSTHOOK: Input: ### test.blobstore.path ###/import_addpartition_local_to_blobstore/import/exim_employee +POSTHOOK: Output: default@exim_employee +POSTHOOK: Output: default@exim_employee@emp_country=in +PREHOOK: query: DESCRIBE EXTENDED exim_employee +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@exim_employee +POSTHOOK: query: DESCRIBE EXTENDED exim_employee +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@exim_employee +emp_id int employee id +emp_country string two char iso code + +# Partition Information +# col_name data_type comment + +emp_country string two char iso code + +#### A masked pattern was here #### +PREHOOK: query: SELECT * FROM exim_employee +PREHOOK: type: QUERY +PREHOOK: Input: default@exim_employee +PREHOOK: Input: default@exim_employee@emp_country=cz +PREHOOK: Input: default@exim_employee@emp_country=in +PREHOOK: Input: default@exim_employee@emp_country=us +#### A masked pattern was here #### +POSTHOOK: query: SELECT * FROM exim_employee +POSTHOOK: type: QUERY +POSTHOOK: Input: default@exim_employee +POSTHOOK: Input: default@exim_employee@emp_country=cz +POSTHOOK: Input: default@exim_employee@emp_country=in +POSTHOOK: Input: default@exim_employee@emp_country=us +#### A masked pattern was here #### +1 cz +2 cz +3 cz +4 cz +5 cz +6 cz +1 in +2 in +3 in +4 in +5 in +6 in +1 us +2 us +3 us +4 us +5 us +6 us http://git-wip-us.apache.org/repos/asf/hive/blob/187eb760/itests/hive-blobstore/src/test/results/clientpositive/import_blobstore_to_blobstore.q.out ---------------------------------------------------------------------- diff --git a/itests/hive-blobstore/src/test/results/clientpositive/import_blobstore_to_blobstore.q.out b/itests/hive-blobstore/src/test/results/clientpositive/import_blobstore_to_blobstore.q.out new file mode 100644 index 0000000..b15a22f --- /dev/null +++ b/itests/hive-blobstore/src/test/results/clientpositive/import_blobstore_to_blobstore.q.out @@ -0,0 +1,161 @@ +PREHOOK: query: DROP TABLE exim_employee +PREHOOK: type: DROPTABLE +POSTHOOK: query: DROP TABLE exim_employee +POSTHOOK: type: DROPTABLE +PREHOOK: query: CREATE TABLE exim_employee (emp_id int COMMENT "employee id") +COMMENT "employee table" +PARTITIONED BY (emp_country string COMMENT "two char iso code") +STORED AS TEXTFILE +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@exim_employee +POSTHOOK: query: CREATE TABLE exim_employee (emp_id int COMMENT "employee id") +COMMENT "employee table" +PARTITIONED BY (emp_country string COMMENT "two char iso code") +STORED AS TEXTFILE +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@exim_employee +PREHOOK: query: LOAD DATA LOCAL INPATH "../../data/files/test.dat" +INTO TABLE exim_employee PARTITION (emp_country="in") +PREHOOK: type: LOAD +#### A masked pattern was here #### +PREHOOK: Output: default@exim_employee +POSTHOOK: query: LOAD DATA LOCAL INPATH "../../data/files/test.dat" +INTO TABLE exim_employee PARTITION (emp_country="in") +POSTHOOK: type: LOAD +#### A masked pattern was here #### +POSTHOOK: Output: default@exim_employee +POSTHOOK: Output: default@exim_employee@emp_country=in +PREHOOK: query: LOAD DATA LOCAL INPATH "../../data/files/test.dat" +INTO TABLE exim_employee PARTITION (emp_country="us") +PREHOOK: type: LOAD +#### A masked pattern was here #### +PREHOOK: Output: default@exim_employee +POSTHOOK: query: LOAD DATA LOCAL INPATH "../../data/files/test.dat" +INTO TABLE exim_employee PARTITION (emp_country="us") +POSTHOOK: type: LOAD +#### A masked pattern was here #### +POSTHOOK: Output: default@exim_employee +POSTHOOK: Output: default@exim_employee@emp_country=us +PREHOOK: query: LOAD DATA LOCAL INPATH "../../data/files/test.dat" +INTO TABLE exim_employee PARTITION (emp_country="cz") +PREHOOK: type: LOAD +#### A masked pattern was here #### +PREHOOK: Output: default@exim_employee +POSTHOOK: query: LOAD DATA LOCAL INPATH "../../data/files/test.dat" +INTO TABLE exim_employee PARTITION (emp_country="cz") +POSTHOOK: type: LOAD +#### A masked pattern was here #### +POSTHOOK: Output: default@exim_employee +POSTHOOK: Output: default@exim_employee@emp_country=cz +PREHOOK: query: DESCRIBE EXTENDED exim_employee +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@exim_employee +POSTHOOK: query: DESCRIBE EXTENDED exim_employee +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@exim_employee +emp_id int employee id +emp_country string two char iso code + +# Partition Information +# col_name data_type comment + +emp_country string two char iso code + +#### A masked pattern was here #### +PREHOOK: query: SELECT * FROM exim_employee +PREHOOK: type: QUERY +PREHOOK: Input: default@exim_employee +PREHOOK: Input: default@exim_employee@emp_country=cz +PREHOOK: Input: default@exim_employee@emp_country=in +PREHOOK: Input: default@exim_employee@emp_country=us +#### A masked pattern was here #### +POSTHOOK: query: SELECT * FROM exim_employee +POSTHOOK: type: QUERY +POSTHOOK: Input: default@exim_employee +POSTHOOK: Input: default@exim_employee@emp_country=cz +POSTHOOK: Input: default@exim_employee@emp_country=in +POSTHOOK: Input: default@exim_employee@emp_country=us +#### A masked pattern was here #### +1 cz +2 cz +3 cz +4 cz +5 cz +6 cz +1 in +2 in +3 in +4 in +5 in +6 in +1 us +2 us +3 us +4 us +5 us +6 us +PREHOOK: query: EXPORT TABLE exim_employee PARTITION (emp_country='us') +TO '### test.blobstore.path ###/import_blobstore_to_blobstore/export/exim_employee' +PREHOOK: type: EXPORT +PREHOOK: Input: default@exim_employee@emp_country=us +PREHOOK: Output: ### test.blobstore.path ###/import_blobstore_to_blobstore/export/exim_employee +POSTHOOK: query: EXPORT TABLE exim_employee PARTITION (emp_country='us') +TO '### test.blobstore.path ###/import_blobstore_to_blobstore/export/exim_employee' +POSTHOOK: type: EXPORT +POSTHOOK: Input: default@exim_employee@emp_country=us +POSTHOOK: Output: ### test.blobstore.path ###/import_blobstore_to_blobstore/export/exim_employee +PREHOOK: query: DROP TABLE exim_employee +PREHOOK: type: DROPTABLE +PREHOOK: Input: default@exim_employee +PREHOOK: Output: default@exim_employee +POSTHOOK: query: DROP TABLE exim_employee +POSTHOOK: type: DROPTABLE +POSTHOOK: Input: default@exim_employee +POSTHOOK: Output: default@exim_employee +PREHOOK: query: IMPORT FROM '### test.blobstore.path ###/import_blobstore_to_blobstore/export/exim_employee' +#### A masked pattern was here #### +PREHOOK: type: IMPORT +PREHOOK: Input: ### test.blobstore.path ###/import_blobstore_to_blobstore/export/exim_employee +PREHOOK: Input: ### test.blobstore.path ###/import_blobstore_to_blobstore/import/exim_employee +PREHOOK: Output: database:default +POSTHOOK: query: IMPORT FROM '### test.blobstore.path ###/import_blobstore_to_blobstore/export/exim_employee' +#### A masked pattern was here #### +POSTHOOK: type: IMPORT +POSTHOOK: Input: ### test.blobstore.path ###/import_blobstore_to_blobstore/export/exim_employee +POSTHOOK: Input: ### test.blobstore.path ###/import_blobstore_to_blobstore/import/exim_employee +POSTHOOK: Output: database:default +POSTHOOK: Output: default@exim_employee +POSTHOOK: Output: default@exim_employee@emp_country=us +PREHOOK: query: DESCRIBE EXTENDED exim_employee +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@exim_employee +POSTHOOK: query: DESCRIBE EXTENDED exim_employee +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@exim_employee +emp_id int employee id +emp_country string two char iso code + +# Partition Information +# col_name data_type comment + +emp_country string two char iso code + +#### A masked pattern was here #### +PREHOOK: query: SELECT * FROM exim_employee +PREHOOK: type: QUERY +PREHOOK: Input: default@exim_employee +PREHOOK: Input: default@exim_employee@emp_country=us +#### A masked pattern was here #### +POSTHOOK: query: SELECT * FROM exim_employee +POSTHOOK: type: QUERY +POSTHOOK: Input: default@exim_employee +POSTHOOK: Input: default@exim_employee@emp_country=us +#### A masked pattern was here #### +1 us +2 us +3 us +4 us +5 us +6 us http://git-wip-us.apache.org/repos/asf/hive/blob/187eb760/itests/hive-blobstore/src/test/results/clientpositive/import_blobstore_to_blobstore_nonpart.q.out ---------------------------------------------------------------------- diff --git a/itests/hive-blobstore/src/test/results/clientpositive/import_blobstore_to_blobstore_nonpart.q.out b/itests/hive-blobstore/src/test/results/clientpositive/import_blobstore_to_blobstore_nonpart.q.out new file mode 100644 index 0000000..d92b6c1 --- /dev/null +++ b/itests/hive-blobstore/src/test/results/clientpositive/import_blobstore_to_blobstore_nonpart.q.out @@ -0,0 +1,103 @@ +PREHOOK: query: DROP TABLE exim_employee +PREHOOK: type: DROPTABLE +POSTHOOK: query: DROP TABLE exim_employee +POSTHOOK: type: DROPTABLE +PREHOOK: query: CREATE TABLE exim_employee (emp_id int COMMENT "employee id") +COMMENT "employee table" +STORED AS TEXTFILE +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@exim_employee +POSTHOOK: query: CREATE TABLE exim_employee (emp_id int COMMENT "employee id") +COMMENT "employee table" +STORED AS TEXTFILE +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@exim_employee +PREHOOK: query: LOAD DATA LOCAL INPATH "../../data/files/test.dat" +INTO TABLE exim_employee +PREHOOK: type: LOAD +#### A masked pattern was here #### +PREHOOK: Output: default@exim_employee +POSTHOOK: query: LOAD DATA LOCAL INPATH "../../data/files/test.dat" +INTO TABLE exim_employee +POSTHOOK: type: LOAD +#### A masked pattern was here #### +POSTHOOK: Output: default@exim_employee +PREHOOK: query: DESCRIBE EXTENDED exim_employee +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@exim_employee +POSTHOOK: query: DESCRIBE EXTENDED exim_employee +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@exim_employee +emp_id int employee id + +#### A masked pattern was here #### +PREHOOK: query: SELECT * FROM exim_employee +PREHOOK: type: QUERY +PREHOOK: Input: default@exim_employee +#### A masked pattern was here #### +POSTHOOK: query: SELECT * FROM exim_employee +POSTHOOK: type: QUERY +POSTHOOK: Input: default@exim_employee +#### A masked pattern was here #### +1 +2 +3 +4 +5 +6 +PREHOOK: query: EXPORT TABLE exim_employee +TO '### test.blobstore.path ###/import_blobstore_to_blobstore_nonpart/export/exim_employee' +PREHOOK: type: EXPORT +PREHOOK: Input: default@exim_employee +PREHOOK: Output: ### test.blobstore.path ###/import_blobstore_to_blobstore_nonpart/export/exim_employee +POSTHOOK: query: EXPORT TABLE exim_employee +TO '### test.blobstore.path ###/import_blobstore_to_blobstore_nonpart/export/exim_employee' +POSTHOOK: type: EXPORT +POSTHOOK: Input: default@exim_employee +POSTHOOK: Output: ### test.blobstore.path ###/import_blobstore_to_blobstore_nonpart/export/exim_employee +PREHOOK: query: DROP TABLE exim_employee +PREHOOK: type: DROPTABLE +PREHOOK: Input: default@exim_employee +PREHOOK: Output: default@exim_employee +POSTHOOK: query: DROP TABLE exim_employee +POSTHOOK: type: DROPTABLE +POSTHOOK: Input: default@exim_employee +POSTHOOK: Output: default@exim_employee +PREHOOK: query: IMPORT FROM '### test.blobstore.path ###/import_blobstore_to_blobstore_nonpart/export/exim_employee' +#### A masked pattern was here #### +PREHOOK: type: IMPORT +PREHOOK: Input: ### test.blobstore.path ###/import_blobstore_to_blobstore_nonpart/export/exim_employee +PREHOOK: Input: ### test.blobstore.path ###/import_blobstore_to_blobstore_nonpart/import/exim_employee +PREHOOK: Output: database:default +POSTHOOK: query: IMPORT FROM '### test.blobstore.path ###/import_blobstore_to_blobstore_nonpart/export/exim_employee' +#### A masked pattern was here #### +POSTHOOK: type: IMPORT +POSTHOOK: Input: ### test.blobstore.path ###/import_blobstore_to_blobstore_nonpart/export/exim_employee +POSTHOOK: Input: ### test.blobstore.path ###/import_blobstore_to_blobstore_nonpart/import/exim_employee +POSTHOOK: Output: database:default +POSTHOOK: Output: default@exim_employee +PREHOOK: query: DESCRIBE EXTENDED exim_employee +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@exim_employee +POSTHOOK: query: DESCRIBE EXTENDED exim_employee +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@exim_employee +emp_id int employee id + +#### A masked pattern was here #### +PREHOOK: query: SELECT * FROM exim_employee +PREHOOK: type: QUERY +PREHOOK: Input: default@exim_employee +#### A masked pattern was here #### +POSTHOOK: query: SELECT * FROM exim_employee +POSTHOOK: type: QUERY +POSTHOOK: Input: default@exim_employee +#### A masked pattern was here #### +1 +2 +3 +4 +5 +6 http://git-wip-us.apache.org/repos/asf/hive/blob/187eb760/itests/hive-blobstore/src/test/results/clientpositive/import_blobstore_to_local.q.out ---------------------------------------------------------------------- diff --git a/itests/hive-blobstore/src/test/results/clientpositive/import_blobstore_to_local.q.out b/itests/hive-blobstore/src/test/results/clientpositive/import_blobstore_to_local.q.out new file mode 100644 index 0000000..4d2eeb0 --- /dev/null +++ b/itests/hive-blobstore/src/test/results/clientpositive/import_blobstore_to_local.q.out @@ -0,0 +1,161 @@ +PREHOOK: query: DROP TABLE exim_employee +PREHOOK: type: DROPTABLE +POSTHOOK: query: DROP TABLE exim_employee +POSTHOOK: type: DROPTABLE +PREHOOK: query: CREATE TABLE exim_employee (emp_id int COMMENT "employee id") +COMMENT "employee table" +PARTITIONED BY (emp_country string COMMENT "two char iso code") +STORED AS TEXTFILE +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@exim_employee +POSTHOOK: query: CREATE TABLE exim_employee (emp_id int COMMENT "employee id") +COMMENT "employee table" +PARTITIONED BY (emp_country string COMMENT "two char iso code") +STORED AS TEXTFILE +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@exim_employee +PREHOOK: query: LOAD DATA LOCAL INPATH "../../data/files/test.dat" +INTO TABLE exim_employee PARTITION (emp_country="in") +PREHOOK: type: LOAD +#### A masked pattern was here #### +PREHOOK: Output: default@exim_employee +POSTHOOK: query: LOAD DATA LOCAL INPATH "../../data/files/test.dat" +INTO TABLE exim_employee PARTITION (emp_country="in") +POSTHOOK: type: LOAD +#### A masked pattern was here #### +POSTHOOK: Output: default@exim_employee +POSTHOOK: Output: default@exim_employee@emp_country=in +PREHOOK: query: LOAD DATA LOCAL INPATH "../../data/files/test.dat" +INTO TABLE exim_employee PARTITION (emp_country="us") +PREHOOK: type: LOAD +#### A masked pattern was here #### +PREHOOK: Output: default@exim_employee +POSTHOOK: query: LOAD DATA LOCAL INPATH "../../data/files/test.dat" +INTO TABLE exim_employee PARTITION (emp_country="us") +POSTHOOK: type: LOAD +#### A masked pattern was here #### +POSTHOOK: Output: default@exim_employee +POSTHOOK: Output: default@exim_employee@emp_country=us +PREHOOK: query: LOAD DATA LOCAL INPATH "../../data/files/test.dat" +INTO TABLE exim_employee PARTITION (emp_country="cz") +PREHOOK: type: LOAD +#### A masked pattern was here #### +PREHOOK: Output: default@exim_employee +POSTHOOK: query: LOAD DATA LOCAL INPATH "../../data/files/test.dat" +INTO TABLE exim_employee PARTITION (emp_country="cz") +POSTHOOK: type: LOAD +#### A masked pattern was here #### +POSTHOOK: Output: default@exim_employee +POSTHOOK: Output: default@exim_employee@emp_country=cz +PREHOOK: query: DESCRIBE EXTENDED exim_employee +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@exim_employee +POSTHOOK: query: DESCRIBE EXTENDED exim_employee +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@exim_employee +emp_id int employee id +emp_country string two char iso code + +# Partition Information +# col_name data_type comment + +emp_country string two char iso code + +#### A masked pattern was here #### +PREHOOK: query: SELECT * FROM exim_employee +PREHOOK: type: QUERY +PREHOOK: Input: default@exim_employee +PREHOOK: Input: default@exim_employee@emp_country=cz +PREHOOK: Input: default@exim_employee@emp_country=in +PREHOOK: Input: default@exim_employee@emp_country=us +#### A masked pattern was here #### +POSTHOOK: query: SELECT * FROM exim_employee +POSTHOOK: type: QUERY +POSTHOOK: Input: default@exim_employee +POSTHOOK: Input: default@exim_employee@emp_country=cz +POSTHOOK: Input: default@exim_employee@emp_country=in +POSTHOOK: Input: default@exim_employee@emp_country=us +#### A masked pattern was here #### +1 cz +2 cz +3 cz +4 cz +5 cz +6 cz +1 in +2 in +3 in +4 in +5 in +6 in +1 us +2 us +3 us +4 us +5 us +6 us +PREHOOK: query: EXPORT TABLE exim_employee PARTITION (emp_country='us') +TO '### test.blobstore.path ###/import_blobstore_to_local/export/exim_employee' +PREHOOK: type: EXPORT +PREHOOK: Input: default@exim_employee@emp_country=us +PREHOOK: Output: ### test.blobstore.path ###/import_blobstore_to_local/export/exim_employee +POSTHOOK: query: EXPORT TABLE exim_employee PARTITION (emp_country='us') +TO '### test.blobstore.path ###/import_blobstore_to_local/export/exim_employee' +POSTHOOK: type: EXPORT +POSTHOOK: Input: default@exim_employee@emp_country=us +POSTHOOK: Output: ### test.blobstore.path ###/import_blobstore_to_local/export/exim_employee +PREHOOK: query: DROP TABLE exim_employee +PREHOOK: type: DROPTABLE +PREHOOK: Input: default@exim_employee +PREHOOK: Output: default@exim_employee +POSTHOOK: query: DROP TABLE exim_employee +POSTHOOK: type: DROPTABLE +POSTHOOK: Input: default@exim_employee +POSTHOOK: Output: default@exim_employee +PREHOOK: query: IMPORT FROM '### test.blobstore.path ###/import_blobstore_to_local/export/exim_employee' +#### A masked pattern was here #### +PREHOOK: type: IMPORT +#### A masked pattern was here #### +PREHOOK: Input: ### test.blobstore.path ###/import_blobstore_to_local/export/exim_employee +PREHOOK: Output: database:default +POSTHOOK: query: IMPORT FROM '### test.blobstore.path ###/import_blobstore_to_local/export/exim_employee' +#### A masked pattern was here #### +POSTHOOK: type: IMPORT +#### A masked pattern was here #### +POSTHOOK: Input: ### test.blobstore.path ###/import_blobstore_to_local/export/exim_employee +POSTHOOK: Output: database:default +POSTHOOK: Output: default@exim_employee +POSTHOOK: Output: default@exim_employee@emp_country=us +PREHOOK: query: DESCRIBE EXTENDED exim_employee +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@exim_employee +POSTHOOK: query: DESCRIBE EXTENDED exim_employee +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@exim_employee +emp_id int employee id +emp_country string two char iso code + +# Partition Information +# col_name data_type comment + +emp_country string two char iso code + +#### A masked pattern was here #### +PREHOOK: query: SELECT * FROM exim_employee +PREHOOK: type: QUERY +PREHOOK: Input: default@exim_employee +PREHOOK: Input: default@exim_employee@emp_country=us +#### A masked pattern was here #### +POSTHOOK: query: SELECT * FROM exim_employee +POSTHOOK: type: QUERY +POSTHOOK: Input: default@exim_employee +POSTHOOK: Input: default@exim_employee@emp_country=us +#### A masked pattern was here #### +1 us +2 us +3 us +4 us +5 us +6 us http://git-wip-us.apache.org/repos/asf/hive/blob/187eb760/itests/hive-blobstore/src/test/results/clientpositive/import_blobstore_to_warehouse.q.out ---------------------------------------------------------------------- diff --git a/itests/hive-blobstore/src/test/results/clientpositive/import_blobstore_to_warehouse.q.out b/itests/hive-blobstore/src/test/results/clientpositive/import_blobstore_to_warehouse.q.out new file mode 100644 index 0000000..764c86d --- /dev/null +++ b/itests/hive-blobstore/src/test/results/clientpositive/import_blobstore_to_warehouse.q.out @@ -0,0 +1,157 @@ +PREHOOK: query: DROP TABLE exim_employee +PREHOOK: type: DROPTABLE +POSTHOOK: query: DROP TABLE exim_employee +POSTHOOK: type: DROPTABLE +PREHOOK: query: CREATE TABLE exim_employee (emp_id int COMMENT "employee id") +COMMENT "employee table" +PARTITIONED BY (emp_country string COMMENT "two char iso code") +STORED AS TEXTFILE +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@exim_employee +POSTHOOK: query: CREATE TABLE exim_employee (emp_id int COMMENT "employee id") +COMMENT "employee table" +PARTITIONED BY (emp_country string COMMENT "two char iso code") +STORED AS TEXTFILE +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@exim_employee +PREHOOK: query: LOAD DATA LOCAL INPATH "../../data/files/test.dat" +INTO TABLE exim_employee PARTITION (emp_country="in") +PREHOOK: type: LOAD +#### A masked pattern was here #### +PREHOOK: Output: default@exim_employee +POSTHOOK: query: LOAD DATA LOCAL INPATH "../../data/files/test.dat" +INTO TABLE exim_employee PARTITION (emp_country="in") +POSTHOOK: type: LOAD +#### A masked pattern was here #### +POSTHOOK: Output: default@exim_employee +POSTHOOK: Output: default@exim_employee@emp_country=in +PREHOOK: query: LOAD DATA LOCAL INPATH "../../data/files/test.dat" +INTO TABLE exim_employee PARTITION (emp_country="us") +PREHOOK: type: LOAD +#### A masked pattern was here #### +PREHOOK: Output: default@exim_employee +POSTHOOK: query: LOAD DATA LOCAL INPATH "../../data/files/test.dat" +INTO TABLE exim_employee PARTITION (emp_country="us") +POSTHOOK: type: LOAD +#### A masked pattern was here #### +POSTHOOK: Output: default@exim_employee +POSTHOOK: Output: default@exim_employee@emp_country=us +PREHOOK: query: LOAD DATA LOCAL INPATH "../../data/files/test.dat" +INTO TABLE exim_employee PARTITION (emp_country="cz") +PREHOOK: type: LOAD +#### A masked pattern was here #### +PREHOOK: Output: default@exim_employee +POSTHOOK: query: LOAD DATA LOCAL INPATH "../../data/files/test.dat" +INTO TABLE exim_employee PARTITION (emp_country="cz") +POSTHOOK: type: LOAD +#### A masked pattern was here #### +POSTHOOK: Output: default@exim_employee +POSTHOOK: Output: default@exim_employee@emp_country=cz +PREHOOK: query: DESCRIBE EXTENDED exim_employee +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@exim_employee +POSTHOOK: query: DESCRIBE EXTENDED exim_employee +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@exim_employee +emp_id int employee id +emp_country string two char iso code + +# Partition Information +# col_name data_type comment + +emp_country string two char iso code + +#### A masked pattern was here #### +PREHOOK: query: SELECT * FROM exim_employee +PREHOOK: type: QUERY +PREHOOK: Input: default@exim_employee +PREHOOK: Input: default@exim_employee@emp_country=cz +PREHOOK: Input: default@exim_employee@emp_country=in +PREHOOK: Input: default@exim_employee@emp_country=us +#### A masked pattern was here #### +POSTHOOK: query: SELECT * FROM exim_employee +POSTHOOK: type: QUERY +POSTHOOK: Input: default@exim_employee +POSTHOOK: Input: default@exim_employee@emp_country=cz +POSTHOOK: Input: default@exim_employee@emp_country=in +POSTHOOK: Input: default@exim_employee@emp_country=us +#### A masked pattern was here #### +1 cz +2 cz +3 cz +4 cz +5 cz +6 cz +1 in +2 in +3 in +4 in +5 in +6 in +1 us +2 us +3 us +4 us +5 us +6 us +PREHOOK: query: EXPORT TABLE exim_employee PARTITION (emp_country='us') +TO '### test.blobstore.path ###/import_blobstore_to_warehouse/export/exim_employee' +PREHOOK: type: EXPORT +PREHOOK: Input: default@exim_employee@emp_country=us +PREHOOK: Output: ### test.blobstore.path ###/import_blobstore_to_warehouse/export/exim_employee +POSTHOOK: query: EXPORT TABLE exim_employee PARTITION (emp_country='us') +TO '### test.blobstore.path ###/import_blobstore_to_warehouse/export/exim_employee' +POSTHOOK: type: EXPORT +POSTHOOK: Input: default@exim_employee@emp_country=us +POSTHOOK: Output: ### test.blobstore.path ###/import_blobstore_to_warehouse/export/exim_employee +PREHOOK: query: DROP TABLE exim_employee +PREHOOK: type: DROPTABLE +PREHOOK: Input: default@exim_employee +PREHOOK: Output: default@exim_employee +POSTHOOK: query: DROP TABLE exim_employee +POSTHOOK: type: DROPTABLE +POSTHOOK: Input: default@exim_employee +POSTHOOK: Output: default@exim_employee +PREHOOK: query: IMPORT FROM '### test.blobstore.path ###/import_blobstore_to_warehouse/export/exim_employee' +PREHOOK: type: IMPORT +PREHOOK: Input: ### test.blobstore.path ###/import_blobstore_to_warehouse/export/exim_employee +PREHOOK: Output: database:default +POSTHOOK: query: IMPORT FROM '### test.blobstore.path ###/import_blobstore_to_warehouse/export/exim_employee' +POSTHOOK: type: IMPORT +POSTHOOK: Input: ### test.blobstore.path ###/import_blobstore_to_warehouse/export/exim_employee +POSTHOOK: Output: database:default +POSTHOOK: Output: default@exim_employee +POSTHOOK: Output: default@exim_employee@emp_country=us +PREHOOK: query: DESCRIBE EXTENDED exim_employee +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@exim_employee +POSTHOOK: query: DESCRIBE EXTENDED exim_employee +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@exim_employee +emp_id int employee id +emp_country string two char iso code + +# Partition Information +# col_name data_type comment + +emp_country string two char iso code + +#### A masked pattern was here #### +PREHOOK: query: SELECT * FROM exim_employee +PREHOOK: type: QUERY +PREHOOK: Input: default@exim_employee +PREHOOK: Input: default@exim_employee@emp_country=us +#### A masked pattern was here #### +POSTHOOK: query: SELECT * FROM exim_employee +POSTHOOK: type: QUERY +POSTHOOK: Input: default@exim_employee +POSTHOOK: Input: default@exim_employee@emp_country=us +#### A masked pattern was here #### +1 us +2 us +3 us +4 us +5 us +6 us http://git-wip-us.apache.org/repos/asf/hive/blob/187eb760/itests/hive-blobstore/src/test/results/clientpositive/import_blobstore_to_warehouse_nonpart.q.out ---------------------------------------------------------------------- diff --git a/itests/hive-blobstore/src/test/results/clientpositive/import_blobstore_to_warehouse_nonpart.q.out b/itests/hive-blobstore/src/test/results/clientpositive/import_blobstore_to_warehouse_nonpart.q.out new file mode 100644 index 0000000..9d0b059 --- /dev/null +++ b/itests/hive-blobstore/src/test/results/clientpositive/import_blobstore_to_warehouse_nonpart.q.out @@ -0,0 +1,99 @@ +PREHOOK: query: DROP TABLE exim_employee +PREHOOK: type: DROPTABLE +POSTHOOK: query: DROP TABLE exim_employee +POSTHOOK: type: DROPTABLE +PREHOOK: query: CREATE TABLE exim_employee (emp_id int COMMENT "employee id") +COMMENT "employee table" +STORED AS TEXTFILE +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@exim_employee +POSTHOOK: query: CREATE TABLE exim_employee (emp_id int COMMENT "employee id") +COMMENT "employee table" +STORED AS TEXTFILE +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@exim_employee +PREHOOK: query: LOAD DATA LOCAL INPATH "../../data/files/test.dat" +INTO TABLE exim_employee +PREHOOK: type: LOAD +#### A masked pattern was here #### +PREHOOK: Output: default@exim_employee +POSTHOOK: query: LOAD DATA LOCAL INPATH "../../data/files/test.dat" +INTO TABLE exim_employee +POSTHOOK: type: LOAD +#### A masked pattern was here #### +POSTHOOK: Output: default@exim_employee +PREHOOK: query: DESCRIBE EXTENDED exim_employee +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@exim_employee +POSTHOOK: query: DESCRIBE EXTENDED exim_employee +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@exim_employee +emp_id int employee id + +#### A masked pattern was here #### +PREHOOK: query: SELECT * FROM exim_employee +PREHOOK: type: QUERY +PREHOOK: Input: default@exim_employee +#### A masked pattern was here #### +POSTHOOK: query: SELECT * FROM exim_employee +POSTHOOK: type: QUERY +POSTHOOK: Input: default@exim_employee +#### A masked pattern was here #### +1 +2 +3 +4 +5 +6 +PREHOOK: query: EXPORT TABLE exim_employee +TO '### test.blobstore.path ###/import_blobstore_to_warehouse_nonpart/export/exim_employee' +PREHOOK: type: EXPORT +PREHOOK: Input: default@exim_employee +PREHOOK: Output: ### test.blobstore.path ###/import_blobstore_to_warehouse_nonpart/export/exim_employee +POSTHOOK: query: EXPORT TABLE exim_employee +TO '### test.blobstore.path ###/import_blobstore_to_warehouse_nonpart/export/exim_employee' +POSTHOOK: type: EXPORT +POSTHOOK: Input: default@exim_employee +POSTHOOK: Output: ### test.blobstore.path ###/import_blobstore_to_warehouse_nonpart/export/exim_employee +PREHOOK: query: DROP TABLE exim_employee +PREHOOK: type: DROPTABLE +PREHOOK: Input: default@exim_employee +PREHOOK: Output: default@exim_employee +POSTHOOK: query: DROP TABLE exim_employee +POSTHOOK: type: DROPTABLE +POSTHOOK: Input: default@exim_employee +POSTHOOK: Output: default@exim_employee +PREHOOK: query: IMPORT FROM '### test.blobstore.path ###/import_blobstore_to_warehouse_nonpart/export/exim_employee' +PREHOOK: type: IMPORT +PREHOOK: Input: ### test.blobstore.path ###/import_blobstore_to_warehouse_nonpart/export/exim_employee +PREHOOK: Output: database:default +POSTHOOK: query: IMPORT FROM '### test.blobstore.path ###/import_blobstore_to_warehouse_nonpart/export/exim_employee' +POSTHOOK: type: IMPORT +POSTHOOK: Input: ### test.blobstore.path ###/import_blobstore_to_warehouse_nonpart/export/exim_employee +POSTHOOK: Output: database:default +POSTHOOK: Output: default@exim_employee +PREHOOK: query: DESCRIBE EXTENDED exim_employee +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@exim_employee +POSTHOOK: query: DESCRIBE EXTENDED exim_employee +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@exim_employee +emp_id int employee id + +#### A masked pattern was here #### +PREHOOK: query: SELECT * FROM exim_employee +PREHOOK: type: QUERY +PREHOOK: Input: default@exim_employee +#### A masked pattern was here #### +POSTHOOK: query: SELECT * FROM exim_employee +POSTHOOK: type: QUERY +POSTHOOK: Input: default@exim_employee +#### A masked pattern was here #### +1 +2 +3 +4 +5 +6 http://git-wip-us.apache.org/repos/asf/hive/blob/187eb760/itests/hive-blobstore/src/test/results/clientpositive/import_local_to_blobstore.q.out ---------------------------------------------------------------------- diff --git a/itests/hive-blobstore/src/test/results/clientpositive/import_local_to_blobstore.q.out b/itests/hive-blobstore/src/test/results/clientpositive/import_local_to_blobstore.q.out new file mode 100644 index 0000000..56343bb --- /dev/null +++ b/itests/hive-blobstore/src/test/results/clientpositive/import_local_to_blobstore.q.out @@ -0,0 +1,159 @@ +PREHOOK: query: DROP TABLE exim_employee +PREHOOK: type: DROPTABLE +POSTHOOK: query: DROP TABLE exim_employee +POSTHOOK: type: DROPTABLE +PREHOOK: query: CREATE TABLE exim_employee (emp_id int COMMENT "employee id") +COMMENT "employee table" +PARTITIONED BY (emp_country string COMMENT "two char iso code") +STORED AS TEXTFILE +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@exim_employee +POSTHOOK: query: CREATE TABLE exim_employee (emp_id int COMMENT "employee id") +COMMENT "employee table" +PARTITIONED BY (emp_country string COMMENT "two char iso code") +STORED AS TEXTFILE +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@exim_employee +PREHOOK: query: LOAD DATA LOCAL INPATH "../../data/files/test.dat" +INTO TABLE exim_employee PARTITION (emp_country="in") +PREHOOK: type: LOAD +#### A masked pattern was here #### +PREHOOK: Output: default@exim_employee +POSTHOOK: query: LOAD DATA LOCAL INPATH "../../data/files/test.dat" +INTO TABLE exim_employee PARTITION (emp_country="in") +POSTHOOK: type: LOAD +#### A masked pattern was here #### +POSTHOOK: Output: default@exim_employee +POSTHOOK: Output: default@exim_employee@emp_country=in +PREHOOK: query: LOAD DATA LOCAL INPATH "../../data/files/test.dat" +INTO TABLE exim_employee PARTITION (emp_country="us") +PREHOOK: type: LOAD +#### A masked pattern was here #### +PREHOOK: Output: default@exim_employee +POSTHOOK: query: LOAD DATA LOCAL INPATH "../../data/files/test.dat" +INTO TABLE exim_employee PARTITION (emp_country="us") +POSTHOOK: type: LOAD +#### A masked pattern was here #### +POSTHOOK: Output: default@exim_employee +POSTHOOK: Output: default@exim_employee@emp_country=us +PREHOOK: query: LOAD DATA LOCAL INPATH "../../data/files/test.dat" +INTO TABLE exim_employee PARTITION (emp_country="cz") +PREHOOK: type: LOAD +#### A masked pattern was here #### +PREHOOK: Output: default@exim_employee +POSTHOOK: query: LOAD DATA LOCAL INPATH "../../data/files/test.dat" +INTO TABLE exim_employee PARTITION (emp_country="cz") +POSTHOOK: type: LOAD +#### A masked pattern was here #### +POSTHOOK: Output: default@exim_employee +POSTHOOK: Output: default@exim_employee@emp_country=cz +PREHOOK: query: DESCRIBE EXTENDED exim_employee +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@exim_employee +POSTHOOK: query: DESCRIBE EXTENDED exim_employee +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@exim_employee +emp_id int employee id +emp_country string two char iso code + +# Partition Information +# col_name data_type comment + +emp_country string two char iso code + +#### A masked pattern was here #### +PREHOOK: query: SELECT * FROM exim_employee +PREHOOK: type: QUERY +PREHOOK: Input: default@exim_employee +PREHOOK: Input: default@exim_employee@emp_country=cz +PREHOOK: Input: default@exim_employee@emp_country=in +PREHOOK: Input: default@exim_employee@emp_country=us +#### A masked pattern was here #### +POSTHOOK: query: SELECT * FROM exim_employee +POSTHOOK: type: QUERY +POSTHOOK: Input: default@exim_employee +POSTHOOK: Input: default@exim_employee@emp_country=cz +POSTHOOK: Input: default@exim_employee@emp_country=in +POSTHOOK: Input: default@exim_employee@emp_country=us +#### A masked pattern was here #### +1 cz +2 cz +3 cz +4 cz +5 cz +6 cz +1 in +2 in +3 in +4 in +5 in +6 in +1 us +2 us +3 us +4 us +5 us +6 us +PREHOOK: query: EXPORT TABLE exim_employee PARTITION (emp_country='us') +#### A masked pattern was here #### +PREHOOK: type: EXPORT +PREHOOK: Input: default@exim_employee@emp_country=us +#### A masked pattern was here #### +POSTHOOK: query: EXPORT TABLE exim_employee PARTITION (emp_country='us') +#### A masked pattern was here #### +POSTHOOK: type: EXPORT +POSTHOOK: Input: default@exim_employee@emp_country=us +#### A masked pattern was here #### +PREHOOK: query: DROP TABLE exim_employee +PREHOOK: type: DROPTABLE +PREHOOK: Input: default@exim_employee +PREHOOK: Output: default@exim_employee +POSTHOOK: query: DROP TABLE exim_employee +POSTHOOK: type: DROPTABLE +POSTHOOK: Input: default@exim_employee +POSTHOOK: Output: default@exim_employee +#### A masked pattern was here #### +PREHOOK: type: IMPORT +#### A masked pattern was here #### +PREHOOK: Input: ### test.blobstore.path ###/import_local_to_blobstore/import/exim_employee +PREHOOK: Output: database:default +#### A masked pattern was here #### +POSTHOOK: type: IMPORT +#### A masked pattern was here #### +POSTHOOK: Input: ### test.blobstore.path ###/import_local_to_blobstore/import/exim_employee +POSTHOOK: Output: database:default +POSTHOOK: Output: default@exim_employee +POSTHOOK: Output: default@exim_employee@emp_country=us +PREHOOK: query: DESCRIBE EXTENDED exim_employee +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@exim_employee +POSTHOOK: query: DESCRIBE EXTENDED exim_employee +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@exim_employee +emp_id int employee id +emp_country string two char iso code + +# Partition Information +# col_name data_type comment + +emp_country string two char iso code + +#### A masked pattern was here #### +PREHOOK: query: SELECT * FROM exim_employee +PREHOOK: type: QUERY +PREHOOK: Input: default@exim_employee +PREHOOK: Input: default@exim_employee@emp_country=us +#### A masked pattern was here #### +POSTHOOK: query: SELECT * FROM exim_employee +POSTHOOK: type: QUERY +POSTHOOK: Input: default@exim_employee +POSTHOOK: Input: default@exim_employee@emp_country=us +#### A masked pattern was here #### +1 us +2 us +3 us +4 us +5 us +6 us http://git-wip-us.apache.org/repos/asf/hive/blob/187eb760/itests/hive-blobstore/src/test/results/clientpositive/insert_blobstore_to_blobstore.q.out ---------------------------------------------------------------------- diff --git a/itests/hive-blobstore/src/test/results/clientpositive/insert_blobstore_to_blobstore.q.out b/itests/hive-blobstore/src/test/results/clientpositive/insert_blobstore_to_blobstore.q.out new file mode 100644 index 0000000..4651899 --- /dev/null +++ b/itests/hive-blobstore/src/test/results/clientpositive/insert_blobstore_to_blobstore.q.out @@ -0,0 +1,110 @@ +PREHOOK: query: DROP TABLE blobstore_source +PREHOOK: type: DROPTABLE +POSTHOOK: query: DROP TABLE blobstore_source +POSTHOOK: type: DROPTABLE +PREHOOK: query: CREATE TABLE blobstore_source ( + a string, + b string, + c double) +ROW FORMAT DELIMITED +FIELDS TERMINATED BY ' ' +COLLECTION ITEMS TERMINATED BY '\t' +LINES TERMINATED BY '\n' +#### A masked pattern was here #### +PREHOOK: type: CREATETABLE +PREHOOK: Input: ### test.blobstore.path ###/insert_blobstore_to_blobstore/blobstore_source +PREHOOK: Output: database:default +PREHOOK: Output: default@blobstore_source +POSTHOOK: query: CREATE TABLE blobstore_source ( + a string, + b string, + c double) +ROW FORMAT DELIMITED +FIELDS TERMINATED BY ' ' +COLLECTION ITEMS TERMINATED BY '\t' +LINES TERMINATED BY '\n' +#### A masked pattern was here #### +POSTHOOK: type: CREATETABLE +POSTHOOK: Input: ### test.blobstore.path ###/insert_blobstore_to_blobstore/blobstore_source +POSTHOOK: Output: database:default +POSTHOOK: Output: default@blobstore_source +PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/3col_data.txt' INTO TABLE blobstore_source +PREHOOK: type: LOAD +#### A masked pattern was here #### +PREHOOK: Output: default@blobstore_source +POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/3col_data.txt' INTO TABLE blobstore_source +POSTHOOK: type: LOAD +#### A masked pattern was here #### +POSTHOOK: Output: default@blobstore_source +PREHOOK: query: DROP TABLE blobstore_table +PREHOOK: type: DROPTABLE +POSTHOOK: query: DROP TABLE blobstore_table +POSTHOOK: type: DROPTABLE +PREHOOK: query: CREATE TABLE blobstore_table LIKE blobstore_source +#### A masked pattern was here #### +PREHOOK: type: CREATETABLE +PREHOOK: Input: ### test.blobstore.path ###/insert_blobstore_to_blobstore/blobstore_table +PREHOOK: Output: database:default +PREHOOK: Output: default@blobstore_table +POSTHOOK: query: CREATE TABLE blobstore_table LIKE blobstore_source +#### A masked pattern was here #### +POSTHOOK: type: CREATETABLE +POSTHOOK: Input: ### test.blobstore.path ###/insert_blobstore_to_blobstore/blobstore_table +POSTHOOK: Output: database:default +POSTHOOK: Output: default@blobstore_table +PREHOOK: query: INSERT OVERWRITE TABLE blobstore_table SELECT * FROM blobstore_source +PREHOOK: type: QUERY +PREHOOK: Input: default@blobstore_source +PREHOOK: Output: default@blobstore_table +POSTHOOK: query: INSERT OVERWRITE TABLE blobstore_table SELECT * FROM blobstore_source +POSTHOOK: type: QUERY +POSTHOOK: Input: default@blobstore_source +POSTHOOK: Output: default@blobstore_table +PREHOOK: query: SELECT COUNT(*) FROM blobstore_table +PREHOOK: type: QUERY +PREHOOK: Input: default@blobstore_table +#### A masked pattern was here #### +POSTHOOK: query: SELECT COUNT(*) FROM blobstore_table +POSTHOOK: type: QUERY +POSTHOOK: Input: default@blobstore_table +#### A masked pattern was here #### +7 +PREHOOK: query: INSERT INTO TABLE blobstore_table SELECT * FROM blobstore_source +PREHOOK: type: QUERY +PREHOOK: Input: default@blobstore_source +PREHOOK: Output: default@blobstore_table +POSTHOOK: query: INSERT INTO TABLE blobstore_table SELECT * FROM blobstore_source +POSTHOOK: type: QUERY +POSTHOOK: Input: default@blobstore_source +POSTHOOK: Output: default@blobstore_table +PREHOOK: query: SELECT COUNT(*) FROM blobstore_table +PREHOOK: type: QUERY +PREHOOK: Input: default@blobstore_table +#### A masked pattern was here #### +POSTHOOK: query: SELECT COUNT(*) FROM blobstore_table +POSTHOOK: type: QUERY +POSTHOOK: Input: default@blobstore_table +#### A masked pattern was here #### +14 +PREHOOK: query: SELECT * FROM blobstore_table +PREHOOK: type: QUERY +PREHOOK: Input: default@blobstore_table +#### A masked pattern was here #### +POSTHOOK: query: SELECT * FROM blobstore_table +POSTHOOK: type: QUERY +POSTHOOK: Input: default@blobstore_table +#### A masked pattern was here #### +1 abc 10.5 +2 def 11.5 +3 ajss 90.23232 +4 djns 89.02002 +5 random 2.99 +6 data 3.002 +7 ne 71.9084 +1 abc 10.5 +2 def 11.5 +3 ajss 90.23232 +4 djns 89.02002 +5 random 2.99 +6 data 3.002 +7 ne 71.9084 http://git-wip-us.apache.org/repos/asf/hive/blob/187eb760/itests/hive-blobstore/src/test/results/clientpositive/insert_empty_into_blobstore.q.out ---------------------------------------------------------------------- diff --git a/itests/hive-blobstore/src/test/results/clientpositive/insert_empty_into_blobstore.q.out b/itests/hive-blobstore/src/test/results/clientpositive/insert_empty_into_blobstore.q.out new file mode 100644 index 0000000..8e5e096 --- /dev/null +++ b/itests/hive-blobstore/src/test/results/clientpositive/insert_empty_into_blobstore.q.out @@ -0,0 +1,155 @@ +PREHOOK: query: DROP TABLE empty +PREHOOK: type: DROPTABLE +POSTHOOK: query: DROP TABLE empty +POSTHOOK: type: DROPTABLE +PREHOOK: query: DROP TABLE blobstore_dynamic_partitioning +PREHOOK: type: DROPTABLE +POSTHOOK: query: DROP TABLE blobstore_dynamic_partitioning +POSTHOOK: type: DROPTABLE +PREHOOK: query: DROP TABLE blobstore_list_bucketing +PREHOOK: type: DROPTABLE +POSTHOOK: query: DROP TABLE blobstore_list_bucketing +POSTHOOK: type: DROPTABLE +PREHOOK: query: CREATE TABLE empty ( + id int, + name string, + dept string, + pt string, + dt string, + hr string) +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@empty +POSTHOOK: query: CREATE TABLE empty ( + id int, + name string, + dept string, + pt string, + dt string, + hr string) +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@empty +PREHOOK: query: CREATE TABLE blobstore_dynamic_partitioning ( + id int, + name string, + dept string) +PARTITIONED BY ( + pt string, + dt string, + hr string) +#### A masked pattern was here #### +PREHOOK: type: CREATETABLE +PREHOOK: Input: ### test.blobstore.path ###/insert_empty_into_blobstore/blobstore_dynamic_partitioning +PREHOOK: Output: database:default +PREHOOK: Output: default@blobstore_dynamic_partitioning +POSTHOOK: query: CREATE TABLE blobstore_dynamic_partitioning ( + id int, + name string, + dept string) +PARTITIONED BY ( + pt string, + dt string, + hr string) +#### A masked pattern was here #### +POSTHOOK: type: CREATETABLE +POSTHOOK: Input: ### test.blobstore.path ###/insert_empty_into_blobstore/blobstore_dynamic_partitioning +POSTHOOK: Output: database:default +POSTHOOK: Output: default@blobstore_dynamic_partitioning +PREHOOK: query: INSERT INTO TABLE blobstore_dynamic_partitioning PARTITION (pt='a', dt, hr) SELECT id, name, dept, dt, hr FROM empty +PREHOOK: type: QUERY +PREHOOK: Input: default@empty +PREHOOK: Output: default@blobstore_dynamic_partitioning@pt=a +POSTHOOK: query: INSERT INTO TABLE blobstore_dynamic_partitioning PARTITION (pt='a', dt, hr) SELECT id, name, dept, dt, hr FROM empty +POSTHOOK: type: QUERY +POSTHOOK: Input: default@empty +PREHOOK: query: SELECT COUNT(*) FROM blobstore_dynamic_partitioning +PREHOOK: type: QUERY +PREHOOK: Input: default@blobstore_dynamic_partitioning +#### A masked pattern was here #### +POSTHOOK: query: SELECT COUNT(*) FROM blobstore_dynamic_partitioning +POSTHOOK: type: QUERY +POSTHOOK: Input: default@blobstore_dynamic_partitioning +#### A masked pattern was here #### +0 +PREHOOK: query: CREATE TABLE blobstore_list_bucketing ( + id int, + name string, + dept string) +PARTITIONED BY ( + pt string, + dt string, + hr string) +SKEWED BY (id) ON ('1', '2', '3') STORED AS DIRECTORIES +#### A masked pattern was here #### +PREHOOK: type: CREATETABLE +PREHOOK: Input: ### test.blobstore.path ###/insert_empty_into_blobstore/blobstore_list_bucketing +PREHOOK: Output: database:default +PREHOOK: Output: default@blobstore_list_bucketing +POSTHOOK: query: CREATE TABLE blobstore_list_bucketing ( + id int, + name string, + dept string) +PARTITIONED BY ( + pt string, + dt string, + hr string) +SKEWED BY (id) ON ('1', '2', '3') STORED AS DIRECTORIES +#### A masked pattern was here #### +POSTHOOK: type: CREATETABLE +POSTHOOK: Input: ### test.blobstore.path ###/insert_empty_into_blobstore/blobstore_list_bucketing +POSTHOOK: Output: database:default +POSTHOOK: Output: default@blobstore_list_bucketing +PREHOOK: query: INSERT INTO TABLE blobstore_list_bucketing PARTITION (pt='a', dt='a', hr='a') SELECT id, name, dept FROM empty +PREHOOK: type: QUERY +PREHOOK: Input: default@empty +PREHOOK: Output: default@blobstore_list_bucketing@pt=a/dt=a/hr=a +POSTHOOK: query: INSERT INTO TABLE blobstore_list_bucketing PARTITION (pt='a', dt='a', hr='a') SELECT id, name, dept FROM empty +POSTHOOK: type: QUERY +POSTHOOK: Input: default@empty +POSTHOOK: Output: default@blobstore_list_bucketing@pt=a/dt=a/hr=a +PREHOOK: query: SELECT COUNT(*) FROM blobstore_list_bucketing +PREHOOK: type: QUERY +PREHOOK: Input: default@blobstore_list_bucketing +#### A masked pattern was here #### +POSTHOOK: query: SELECT COUNT(*) FROM blobstore_list_bucketing +POSTHOOK: type: QUERY +POSTHOOK: Input: default@blobstore_list_bucketing +#### A masked pattern was here #### +0 +PREHOOK: query: INSERT INTO TABLE blobstore_dynamic_partitioning PARTITION (pt='b', dt, hr) SELECT id, name, dept, dt, hr FROM empty +PREHOOK: type: QUERY +PREHOOK: Input: default@empty +PREHOOK: Output: default@blobstore_dynamic_partitioning@pt=b +POSTHOOK: query: INSERT INTO TABLE blobstore_dynamic_partitioning PARTITION (pt='b', dt, hr) SELECT id, name, dept, dt, hr FROM empty +POSTHOOK: type: QUERY +POSTHOOK: Input: default@empty +PREHOOK: query: SELECT COUNT(*) FROM blobstore_dynamic_partitioning +PREHOOK: type: QUERY +PREHOOK: Input: default@blobstore_dynamic_partitioning +#### A masked pattern was here #### +POSTHOOK: query: SELECT COUNT(*) FROM blobstore_dynamic_partitioning +POSTHOOK: type: QUERY +POSTHOOK: Input: default@blobstore_dynamic_partitioning +#### A masked pattern was here #### +0 +PREHOOK: query: INSERT INTO TABLE blobstore_list_bucketing PARTITION (pt='b', dt='b', hr='b') SELECT id, name, dept FROM empty +PREHOOK: type: QUERY +PREHOOK: Input: default@empty +PREHOOK: Output: default@blobstore_list_bucketing@pt=b/dt=b/hr=b +POSTHOOK: query: INSERT INTO TABLE blobstore_list_bucketing PARTITION (pt='b', dt='b', hr='b') SELECT id, name, dept FROM empty +POSTHOOK: type: QUERY +POSTHOOK: Input: default@empty +POSTHOOK: Output: default@blobstore_list_bucketing@pt=b/dt=b/hr=b +POSTHOOK: Lineage: blobstore_list_bucketing PARTITION(pt=b,dt=b,hr=b).dept SIMPLE [(empty)empty.FieldSchema(name:dept, type:string, comment:null), ] +POSTHOOK: Lineage: blobstore_list_bucketing PARTITION(pt=b,dt=b,hr=b).id SIMPLE [(empty)empty.FieldSchema(name:id, type:int, comment:null), ] +POSTHOOK: Lineage: blobstore_list_bucketing PARTITION(pt=b,dt=b,hr=b).name SIMPLE [(empty)empty.FieldSchema(name:name, type:string, comment:null), ] +PREHOOK: query: SELECT COUNT(*) FROM blobstore_list_bucketing +PREHOOK: type: QUERY +PREHOOK: Input: default@blobstore_list_bucketing +#### A masked pattern was here #### +POSTHOOK: query: SELECT COUNT(*) FROM blobstore_list_bucketing +POSTHOOK: type: QUERY +POSTHOOK: Input: default@blobstore_list_bucketing +#### A masked pattern was here #### +0 http://git-wip-us.apache.org/repos/asf/hive/blob/187eb760/itests/hive-blobstore/src/test/results/clientpositive/insert_into_table.q.out ---------------------------------------------------------------------- diff --git a/itests/hive-blobstore/src/test/results/clientpositive/insert_into_table.q.out b/itests/hive-blobstore/src/test/results/clientpositive/insert_into_table.q.out index 4ed53e5..663a572 100644 --- a/itests/hive-blobstore/src/test/results/clientpositive/insert_into_table.q.out +++ b/itests/hive-blobstore/src/test/results/clientpositive/insert_into_table.q.out @@ -71,6 +71,7 @@ STAGE PLANS: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat properties: + COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 column.name.delimiter , columns id @@ -80,6 +81,8 @@ STAGE PLANS: location ### test.blobstore.path ###/table1 name default.table1 numFiles 2 + numRows 2 + rawDataSize 2 serialization.ddl struct table1 { i32 id} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe @@ -142,6 +145,7 @@ STAGE PLANS: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat properties: + COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 column.name.delimiter , columns id @@ -151,6 +155,8 @@ STAGE PLANS: location ### test.blobstore.path ###/table1 name default.table1 numFiles 2 + numRows 2 + rawDataSize 2 serialization.ddl struct table1 { i32 id} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe @@ -177,6 +183,7 @@ STAGE PLANS: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat properties: + COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 column.name.delimiter , columns id @@ -186,6 +193,8 @@ STAGE PLANS: location ### test.blobstore.path ###/table1 name default.table1 numFiles 2 + numRows 2 + rawDataSize 2 serialization.ddl struct table1 { i32 id} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe @@ -205,6 +214,7 @@ STAGE PLANS: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat properties: + COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 column.name.delimiter , columns id @@ -214,6 +224,8 @@ STAGE PLANS: location ### test.blobstore.path ###/table1 name default.table1 numFiles 2 + numRows 2 + rawDataSize 2 serialization.ddl struct table1 { i32 id} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe @@ -224,6 +236,7 @@ STAGE PLANS: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat properties: + COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 column.name.delimiter , columns id @@ -233,6 +246,8 @@ STAGE PLANS: location ### test.blobstore.path ###/table1 name default.table1 numFiles 2 + numRows 2 + rawDataSize 2 serialization.ddl struct table1 { i32 id} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe @@ -253,6 +268,7 @@ STAGE PLANS: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat properties: + COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 column.name.delimiter , columns id @@ -262,6 +278,8 @@ STAGE PLANS: location ### test.blobstore.path ###/table1 name default.table1 numFiles 2 + numRows 2 + rawDataSize 2 serialization.ddl struct table1 { i32 id} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe @@ -284,6 +302,7 @@ STAGE PLANS: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat properties: + COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 column.name.delimiter , columns id @@ -293,6 +312,8 @@ STAGE PLANS: location ### test.blobstore.path ###/table1 name default.table1 numFiles 2 + numRows 2 + rawDataSize 2 serialization.ddl struct table1 { i32 id} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe @@ -312,6 +333,7 @@ STAGE PLANS: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat properties: + COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 column.name.delimiter , columns id @@ -321,6 +343,8 @@ STAGE PLANS: location ### test.blobstore.path ###/table1 name default.table1 numFiles 2 + numRows 2 + rawDataSize 2 serialization.ddl struct table1 { i32 id} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe @@ -331,6 +355,7 @@ STAGE PLANS: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat properties: + COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 column.name.delimiter , columns id @@ -340,6 +365,8 @@ STAGE PLANS: location ### test.blobstore.path ###/table1 name default.table1 numFiles 2 + numRows 2 + rawDataSize 2 serialization.ddl struct table1 { i32 id} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
