Author: brock Date: Wed Feb 4 21:55:58 2015 New Revision: 1657414 URL: http://svn.apache.org/r1657414 Log: HIVE-8949 - Test for PARQUET-26 (Ryan Blue via Brock)
Added: hive/trunk/data/files/StringMapOfOptionalIntArray.parquet (with props) hive/trunk/ql/src/test/queries/clientpositive/parquet_map_of_arrays_of_ints.q hive/trunk/ql/src/test/results/clientpositive/parquet_map_of_arrays_of_ints.q.out Added: hive/trunk/data/files/StringMapOfOptionalIntArray.parquet URL: http://svn.apache.org/viewvc/hive/trunk/data/files/StringMapOfOptionalIntArray.parquet?rev=1657414&view=auto ============================================================================== Binary file - no diff available. Propchange: hive/trunk/data/files/StringMapOfOptionalIntArray.parquet ------------------------------------------------------------------------------ svn:mime-type = application/octet-stream Added: hive/trunk/ql/src/test/queries/clientpositive/parquet_map_of_arrays_of_ints.q URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/parquet_map_of_arrays_of_ints.q?rev=1657414&view=auto ============================================================================== --- hive/trunk/ql/src/test/queries/clientpositive/parquet_map_of_arrays_of_ints.q (added) +++ hive/trunk/ql/src/test/queries/clientpositive/parquet_map_of_arrays_of_ints.q Wed Feb 4 21:55:58 2015 @@ -0,0 +1,16 @@ +-- this test reads and writes a parquet file with a map of arrays of ints +-- validates PARQUET-26 is fixed + +CREATE TABLE parquet_map_of_arrays_of_ints ( + examples MAP<STRING, ARRAY<INT>> +) STORED AS PARQUET; + +LOAD DATA LOCAL INPATH '../../data/files/StringMapOfOptionalIntArray.parquet' +OVERWRITE INTO TABLE parquet_map_of_arrays_of_ints; + +CREATE TABLE parquet_map_of_arrays_of_ints_copy STORED AS PARQUET AS SELECT * FROM parquet_map_of_arrays_of_ints; + +SELECT * FROM parquet_map_of_arrays_of_ints_copy; + +DROP TABLE parquet_map_of_arrays_of_ints; +DROP TABLE parquet_map_of_arrays_of_ints_copy; Added: hive/trunk/ql/src/test/results/clientpositive/parquet_map_of_arrays_of_ints.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/parquet_map_of_arrays_of_ints.q.out?rev=1657414&view=auto ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/parquet_map_of_arrays_of_ints.q.out (added) +++ hive/trunk/ql/src/test/results/clientpositive/parquet_map_of_arrays_of_ints.q.out Wed Feb 4 21:55:58 2015 @@ -0,0 +1,63 @@ +PREHOOK: query: -- this test reads and writes a parquet file with a map of arrays of ints +-- validates PARQUET-26 is fixed + +CREATE TABLE parquet_map_of_arrays_of_ints ( + examples MAP<STRING, ARRAY<INT>> +) STORED AS PARQUET +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@parquet_map_of_arrays_of_ints +POSTHOOK: query: -- this test reads and writes a parquet file with a map of arrays of ints +-- validates PARQUET-26 is fixed + +CREATE TABLE parquet_map_of_arrays_of_ints ( + examples MAP<STRING, ARRAY<INT>> +) STORED AS PARQUET +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@parquet_map_of_arrays_of_ints +PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/StringMapOfOptionalIntArray.parquet' +OVERWRITE INTO TABLE parquet_map_of_arrays_of_ints +PREHOOK: type: LOAD +#### A masked pattern was here #### +PREHOOK: Output: default@parquet_map_of_arrays_of_ints +POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/StringMapOfOptionalIntArray.parquet' +OVERWRITE INTO TABLE parquet_map_of_arrays_of_ints +POSTHOOK: type: LOAD +#### A masked pattern was here #### +POSTHOOK: Output: default@parquet_map_of_arrays_of_ints +PREHOOK: query: CREATE TABLE parquet_map_of_arrays_of_ints_copy STORED AS PARQUET AS SELECT * FROM parquet_map_of_arrays_of_ints +PREHOOK: type: CREATETABLE_AS_SELECT +PREHOOK: Input: default@parquet_map_of_arrays_of_ints +PREHOOK: Output: database:default +PREHOOK: Output: default@parquet_map_of_arrays_of_ints_copy +POSTHOOK: query: CREATE TABLE parquet_map_of_arrays_of_ints_copy STORED AS PARQUET AS SELECT * FROM parquet_map_of_arrays_of_ints +POSTHOOK: type: CREATETABLE_AS_SELECT +POSTHOOK: Input: default@parquet_map_of_arrays_of_ints +POSTHOOK: Output: database:default +POSTHOOK: Output: default@parquet_map_of_arrays_of_ints_copy +PREHOOK: query: SELECT * FROM parquet_map_of_arrays_of_ints_copy +PREHOOK: type: QUERY +PREHOOK: Input: default@parquet_map_of_arrays_of_ints_copy +#### A masked pattern was here #### +POSTHOOK: query: SELECT * FROM parquet_map_of_arrays_of_ints_copy +POSTHOOK: type: QUERY +POSTHOOK: Input: default@parquet_map_of_arrays_of_ints_copy +#### A masked pattern was here #### +{"low":[34,35,null],"high":[340,360]} +PREHOOK: query: DROP TABLE parquet_map_of_arrays_of_ints +PREHOOK: type: DROPTABLE +PREHOOK: Input: default@parquet_map_of_arrays_of_ints +PREHOOK: Output: default@parquet_map_of_arrays_of_ints +POSTHOOK: query: DROP TABLE parquet_map_of_arrays_of_ints +POSTHOOK: type: DROPTABLE +POSTHOOK: Input: default@parquet_map_of_arrays_of_ints +POSTHOOK: Output: default@parquet_map_of_arrays_of_ints +PREHOOK: query: DROP TABLE parquet_map_of_arrays_of_ints_copy +PREHOOK: type: DROPTABLE +PREHOOK: Input: default@parquet_map_of_arrays_of_ints_copy +PREHOOK: Output: default@parquet_map_of_arrays_of_ints_copy +POSTHOOK: query: DROP TABLE parquet_map_of_arrays_of_ints_copy +POSTHOOK: type: DROPTABLE +POSTHOOK: Input: default@parquet_map_of_arrays_of_ints_copy +POSTHOOK: Output: default@parquet_map_of_arrays_of_ints_copy