hive-blobstore/src/test/results/clientpositive/rcfile_format_nonpart.q.out

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 ###/rcfile_format_nonpart/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 ###/rcfile_format_nonpart/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 rcfile_table
PREHOOK: type: DROPTABLE
POSTHOOK: query: DROP TABLE rcfile_table
POSTHOOK: type: DROPTABLE
PREHOOK: query: CREATE TABLE rcfile_table (a INT, b STRING, value DOUBLE) STORED AS RCFILE
#### A masked pattern was here ####
PREHOOK: type: CREATETABLE
PREHOOK: Input: ### test.blobstore.path ###/rcfile_format_nonpart/rcfile_table
PREHOOK: Output: database:default
PREHOOK: Output: default@rcfile_table
POSTHOOK: query: CREATE TABLE rcfile_table (a INT, b STRING, value DOUBLE) STORED AS RCFILE
#### A masked pattern was here ####
POSTHOOK: type: CREATETABLE
POSTHOOK: Input: ### test.blobstore.path ###/rcfile_format_nonpart/rcfile_table
POSTHOOK: Output: database:default
POSTHOOK: Output: default@rcfile_table
PREHOOK: query: INSERT OVERWRITE TABLE rcfile_table
SELECT * FROM blobstore_source
PREHOOK: type: QUERY
PREHOOK: Input: default@blobstore_source
PREHOOK: Output: default@rcfile_table
POSTHOOK: query: INSERT OVERWRITE TABLE rcfile_table
SELECT * FROM blobstore_source
POSTHOOK: type: QUERY
POSTHOOK: Input: default@blobstore_source
POSTHOOK: Output: default@rcfile_table
PREHOOK: query: SELECT * FROM rcfile_table
PREHOOK: type: QUERY
PREHOOK: Input: default@rcfile_table
#### A masked pattern was here ####
POSTHOOK: query: SELECT * FROM rcfile_table
POSTHOOK: type: QUERY
POSTHOOK: Input: default@rcfile_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
PREHOOK: query: SELECT a FROM rcfile_table GROUP BY a
PREHOOK: type: QUERY
PREHOOK: Input: default@rcfile_table
#### A masked pattern was here ####
POSTHOOK: query: SELECT a FROM rcfile_table GROUP BY a
POSTHOOK: type: QUERY
POSTHOOK: Input: default@rcfile_table
#### A masked pattern was here ####
1
2
3
4
5
6
7
PREHOOK: query: SELECT b FROM rcfile_table GROUP BY b
PREHOOK: type: QUERY
PREHOOK: Input: default@rcfile_table
#### A masked pattern was here ####
POSTHOOK: query: SELECT b FROM rcfile_table GROUP BY b
POSTHOOK: type: QUERY
POSTHOOK: Input: default@rcfile_table
#### A masked pattern was here ####
abc
ajss
data
def
djns
ne
random
PREHOOK: query: SELECT VALUE FROM rcfile_table GROUP BY VALUE
PREHOOK: type: QUERY
PREHOOK: Input: default@rcfile_table
#### A masked pattern was here ####
POSTHOOK: query: SELECT VALUE FROM rcfile_table GROUP BY VALUE
POSTHOOK: type: QUERY
POSTHOOK: Input: default@rcfile_table
#### A masked pattern was here ####
2.99
3.002
10.5
11.5
71.9084
89.02002
90.23232
PREHOOK: query: INSERT INTO TABLE rcfile_table
SELECT * FROM blobstore_source
PREHOOK: type: QUERY
PREHOOK: Input: default@blobstore_source
PREHOOK: Output: default@rcfile_table
POSTHOOK: query: INSERT INTO TABLE rcfile_table
SELECT * FROM blobstore_source
POSTHOOK: type: QUERY
POSTHOOK: Input: default@blobstore_source
POSTHOOK: Output: default@rcfile_table
PREHOOK: query: SELECT * FROM rcfile_table
PREHOOK: type: QUERY
PREHOOK: Input: default@rcfile_table
#### A masked pattern was here ####
POSTHOOK: query: SELECT * FROM rcfile_table
POSTHOOK: type: QUERY
POSTHOOK: Input: default@rcfile_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
PREHOOK: query: SELECT a FROM rcfile_table GROUP BY a
PREHOOK: type: QUERY
PREHOOK: Input: default@rcfile_table
#### A masked pattern was here ####
POSTHOOK: query: SELECT a FROM rcfile_table GROUP BY a
POSTHOOK: type: QUERY
POSTHOOK: Input: default@rcfile_table
#### A masked pattern was here ####
1
2
3
4
5
6
7
PREHOOK: query: SELECT b FROM rcfile_table GROUP BY b
PREHOOK: type: QUERY
PREHOOK: Input: default@rcfile_table
#### A masked pattern was here ####
POSTHOOK: query: SELECT b FROM rcfile_table GROUP BY b
POSTHOOK: type: QUERY
POSTHOOK: Input: default@rcfile_table
#### A masked pattern was here ####
abc
ajss
data
def
djns
ne
random
PREHOOK: query: SELECT value FROM rcfile_table GROUP BY value
PREHOOK: type: QUERY
PREHOOK: Input: default@rcfile_table
#### A masked pattern was here ####
POSTHOOK: query: SELECT value FROM rcfile_table GROUP BY value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@rcfile_table
#### A masked pattern was here ####
2.99
3.002
10.5
11.5
71.9084
89.02002
90.23232