Repository: hive
Updated Branches:
  refs/heads/master 820db608f -> 644932d1e


HIVE-19146 : Delete dangling q.out - addendum


Project: http://git-wip-us.apache.org/repos/asf/hive/repo
Commit: http://git-wip-us.apache.org/repos/asf/hive/commit/644932d1
Tree: http://git-wip-us.apache.org/repos/asf/hive/tree/644932d1
Diff: http://git-wip-us.apache.org/repos/asf/hive/diff/644932d1

Branch: refs/heads/master
Commit: 644932d1e97f31bb10ed7928a6fc902e574fda27
Parents: 820db60
Author: Ashutosh Chauhan <hashut...@apache.org>
Authored: Tue Apr 10 07:50:10 2018 -0700
Committer: Ashutosh Chauhan <hashut...@apache.org>
Committed: Tue Apr 10 07:50:10 2018 -0700

----------------------------------------------------------------------
 ...insert_overwrite_local_directory_1_bug.q.out |  71 ----
 .../materialized_view_describe.q.out            | 366 -------------------
 .../clientpositive/materialized_view_drop.q.out |  39 --
 3 files changed, 476 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/hive/blob/644932d1/ql/src/test/results/clientpositive/insert_overwrite_local_directory_1_bug.q.out
----------------------------------------------------------------------
diff --git 
a/ql/src/test/results/clientpositive/insert_overwrite_local_directory_1_bug.q.out
 
b/ql/src/test/results/clientpositive/insert_overwrite_local_directory_1_bug.q.out
deleted file mode 100644
index 502404d..0000000
--- 
a/ql/src/test/results/clientpositive/insert_overwrite_local_directory_1_bug.q.out
+++ /dev/null
@@ -1,71 +0,0 @@
-PREHOOK: query: create table map_table (foo STRING , bar MAP<STRING, STRING>)
-ROW FORMAT DELIMITED
-FIELDS TERMINATED BY '\t'
-COLLECTION ITEMS TERMINATED BY ','
-MAP KEYS TERMINATED BY ':'
-STORED AS TEXTFILE
-PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:default
-PREHOOK: Output: default@map_table
-POSTHOOK: query: create table map_table (foo STRING , bar MAP<STRING, STRING>)
-ROW FORMAT DELIMITED
-FIELDS TERMINATED BY '\t'
-COLLECTION ITEMS TERMINATED BY ','
-MAP KEYS TERMINATED BY ':'
-STORED AS TEXTFILE
-POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@map_table
-PREHOOK: query: load data local inpath "../../data/files/map_table.txt" 
overwrite into table map_table
-PREHOOK: type: LOAD
-#### A masked pattern was here ####
-PREHOOK: Output: default@map_table
-POSTHOOK: query: load data local inpath "../../data/files/map_table.txt" 
overwrite into table map_table
-POSTHOOK: type: LOAD
-#### A masked pattern was here ####
-POSTHOOK: Output: default@map_table
-PREHOOK: query: explain
-select * from map_table
-PREHOOK: type: QUERY
-POSTHOOK: query: explain
-select * from map_table
-POSTHOOK: type: QUERY
-STAGE DEPENDENCIES:
-  Stage-1 is a root stage
-  Stage-0 depends on stages: Stage-1
-
-STAGE PLANS:
-  Stage: Stage-1
-    Map Reduce
-      Map Operator Tree:
-          TableScan
-            alias: map_table
-            Statistics: Num rows: 1 Data size: 520 Basic stats: COMPLETE 
Column stats: NONE
-            Select Operator
-              expressions: foo (type: string), bar (type: map<string,string>)
-              outputColumnNames: _col0, _col1
-              Statistics: Num rows: 1 Data size: 520 Basic stats: COMPLETE 
Column stats: NONE
-              File Output Operator
-                compressed: false
-                Statistics: Num rows: 1 Data size: 520 Basic stats: COMPLETE 
Column stats: NONE
-                table:
-                    input format: 
org.apache.hadoop.mapred.SequenceFileInputFormat
-                    output format: 
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                    serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-
-  Stage: Stage-0
-    Fetch Operator
-      limit: -1
-      Processor Tree:
-        ListSink
-
-PREHOOK: query: select * from map_table
-PREHOOK: type: QUERY
-PREHOOK: Input: default@map_table
-#### A masked pattern was here ####
-POSTHOOK: query: select * from map_table
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@map_table
-#### A masked pattern was here ####
-foo1   {"k1":"v1","k2":"v2","k3":"v3"}
-foo2   {"k21":"v21","k22":"v22","k31":"v31"}

http://git-wip-us.apache.org/repos/asf/hive/blob/644932d1/ql/src/test/results/clientpositive/materialized_view_describe.q.out
----------------------------------------------------------------------
diff --git 
a/ql/src/test/results/clientpositive/materialized_view_describe.q.out 
b/ql/src/test/results/clientpositive/materialized_view_describe.q.out
deleted file mode 100644
index efd60d4..0000000
--- a/ql/src/test/results/clientpositive/materialized_view_describe.q.out
+++ /dev/null
@@ -1,366 +0,0 @@
-PREHOOK: query: create table cmv_basetable (a int, b varchar(256), c 
decimal(10,2))
-PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:default
-PREHOOK: Output: default@cmv_basetable
-POSTHOOK: query: create table cmv_basetable (a int, b varchar(256), c 
decimal(10,2))
-POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@cmv_basetable
-PREHOOK: query: insert into cmv_basetable values (1, 'alfred', 10.30),(2, 
'bob', 3.14),(2, 'bonnie', 172342.2),(3, 'calvin', 978.76),(3, 'charlie', 9.8)
-PREHOOK: type: QUERY
-PREHOOK: Input: _dummy_database@_dummy_table
-PREHOOK: Output: default@cmv_basetable
-POSTHOOK: query: insert into cmv_basetable values (1, 'alfred', 10.30),(2, 
'bob', 3.14),(2, 'bonnie', 172342.2),(3, 'calvin', 978.76),(3, 'charlie', 9.8)
-POSTHOOK: type: QUERY
-POSTHOOK: Input: _dummy_database@_dummy_table
-POSTHOOK: Output: default@cmv_basetable
-POSTHOOK: Lineage: cmv_basetable.a SCRIPT []
-POSTHOOK: Lineage: cmv_basetable.b SCRIPT []
-POSTHOOK: Lineage: cmv_basetable.c SCRIPT []
-PREHOOK: query: create materialized view cmv_mat_view
-comment 'this is the first view'
-tblproperties ('key'='foo') as select a, c from cmv_basetable
-PREHOOK: type: CREATE_MATERIALIZED_VIEW
-PREHOOK: Input: default@cmv_basetable
-PREHOOK: Output: database:default
-PREHOOK: Output: default@cmv_mat_view
-POSTHOOK: query: create materialized view cmv_mat_view
-comment 'this is the first view'
-tblproperties ('key'='foo') as select a, c from cmv_basetable
-POSTHOOK: type: CREATE_MATERIALIZED_VIEW
-POSTHOOK: Input: default@cmv_basetable
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@cmv_mat_view
-PREHOOK: query: describe cmv_mat_view
-PREHOOK: type: DESCTABLE
-PREHOOK: Input: default@cmv_mat_view
-POSTHOOK: query: describe cmv_mat_view
-POSTHOOK: type: DESCTABLE
-POSTHOOK: Input: default@cmv_mat_view
-a                      int                                         
-c                      decimal(10,2)                               
-PREHOOK: query: describe extended cmv_mat_view
-PREHOOK: type: DESCTABLE
-PREHOOK: Input: default@cmv_mat_view
-POSTHOOK: query: describe extended cmv_mat_view
-POSTHOOK: type: DESCTABLE
-POSTHOOK: Input: default@cmv_mat_view
-a                      int                                         
-c                      decimal(10,2)                               
-                
-#### A masked pattern was here ####
-PREHOOK: query: describe formatted cmv_mat_view
-PREHOOK: type: DESCTABLE
-PREHOOK: Input: default@cmv_mat_view
-POSTHOOK: query: describe formatted cmv_mat_view
-POSTHOOK: type: DESCTABLE
-POSTHOOK: Input: default@cmv_mat_view
-# col_name             data_type               comment             
-a                      int                                         
-c                      decimal(10,2)                               
-                
-# Detailed Table Information            
-Database:              default                  
-#### A masked pattern was here ####
-Retention:             0                        
-#### A masked pattern was here ####
-Table Type:            MATERIALIZED_VIEW        
-Table Parameters:               
-       COLUMN_STATS_ACCURATE   {\"BASIC_STATS\":\"true\"}
-       comment                 this is the first view
-       key                     foo                 
-       numFiles                1                   
-       numRows                 5                   
-       rawDataSize             580                 
-       totalSize               346                 
-#### A masked pattern was here ####
-                
-# Storage Information           
-SerDe Library:         org.apache.hadoop.hive.ql.io.orc.OrcSerde        
-InputFormat:           org.apache.hadoop.hive.ql.io.orc.OrcInputFormat  
-OutputFormat:          org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat        
 
-Compressed:            No                       
-Num Buckets:           -1                       
-Bucket Columns:        []                       
-Sort Columns:          []                       
-                
-# View Information              
-View Original Text:    select a, c from cmv_basetable   
-View Expanded Text:    select `cmv_basetable`.`a`, `cmv_basetable`.`c` from 
`default`.`cmv_basetable`   
-View Rewrite Enabled:  No                       
-PREHOOK: query: show tblproperties cmv_mat_view
-PREHOOK: type: SHOW_TBLPROPERTIES
-POSTHOOK: query: show tblproperties cmv_mat_view
-POSTHOOK: type: SHOW_TBLPROPERTIES
-COLUMN_STATS_ACCURATE  {"BASIC_STATS":"true"}
-comment        this is the first view
-key    foo
-numFiles       1
-numRows        5
-rawDataSize    580
-totalSize      346
-#### A masked pattern was here ####
-PREHOOK: query: select a, c from cmv_mat_view
-PREHOOK: type: QUERY
-PREHOOK: Input: default@cmv_mat_view
-#### A masked pattern was here ####
-POSTHOOK: query: select a, c from cmv_mat_view
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@cmv_mat_view
-#### A masked pattern was here ####
-1      10.30
-2      3.14
-2      172342.20
-3      978.76
-3      9.80
-PREHOOK: query: drop materialized view cmv_mat_view
-PREHOOK: type: DROP_MATERIALIZED_VIEW
-PREHOOK: Input: default@cmv_mat_view
-PREHOOK: Output: default@cmv_mat_view
-POSTHOOK: query: drop materialized view cmv_mat_view
-POSTHOOK: type: DROP_MATERIALIZED_VIEW
-POSTHOOK: Input: default@cmv_mat_view
-POSTHOOK: Output: default@cmv_mat_view
-PREHOOK: query: create materialized view cmv_mat_view2
-comment 'this is the second view'
-stored as textfile
-tblproperties ('key'='alice','key2'='bob') as select a from cmv_basetable
-PREHOOK: type: CREATE_MATERIALIZED_VIEW
-PREHOOK: Input: default@cmv_basetable
-PREHOOK: Output: database:default
-PREHOOK: Output: default@cmv_mat_view2
-POSTHOOK: query: create materialized view cmv_mat_view2
-comment 'this is the second view'
-stored as textfile
-tblproperties ('key'='alice','key2'='bob') as select a from cmv_basetable
-POSTHOOK: type: CREATE_MATERIALIZED_VIEW
-POSTHOOK: Input: default@cmv_basetable
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@cmv_mat_view2
-PREHOOK: query: describe formatted cmv_mat_view2
-PREHOOK: type: DESCTABLE
-PREHOOK: Input: default@cmv_mat_view2
-POSTHOOK: query: describe formatted cmv_mat_view2
-POSTHOOK: type: DESCTABLE
-POSTHOOK: Input: default@cmv_mat_view2
-# col_name             data_type               comment             
-a                      int                                         
-                
-# Detailed Table Information            
-Database:              default                  
-#### A masked pattern was here ####
-Retention:             0                        
-#### A masked pattern was here ####
-Table Type:            MATERIALIZED_VIEW        
-Table Parameters:               
-       COLUMN_STATS_ACCURATE   {\"BASIC_STATS\":\"true\"}
-       comment                 this is the second view
-       key                     alice               
-       key2                    bob                 
-       numFiles                1                   
-       numRows                 5                   
-       rawDataSize             5                   
-       totalSize               10                  
-#### A masked pattern was here ####
-                
-# Storage Information           
-SerDe Library:         org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe      
 
-InputFormat:           org.apache.hadoop.mapred.TextInputFormat         
-OutputFormat:          
org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat       
-Compressed:            No                       
-Num Buckets:           -1                       
-Bucket Columns:        []                       
-Sort Columns:          []                       
-                
-# View Information              
-View Original Text:    select a from cmv_basetable      
-View Expanded Text:    select `cmv_basetable`.`a` from 
`default`.`cmv_basetable`        
-View Rewrite Enabled:  No                       
-PREHOOK: query: select a from cmv_mat_view2
-PREHOOK: type: QUERY
-PREHOOK: Input: default@cmv_mat_view2
-#### A masked pattern was here ####
-POSTHOOK: query: select a from cmv_mat_view2
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@cmv_mat_view2
-#### A masked pattern was here ####
-1
-2
-2
-3
-3
-PREHOOK: query: drop materialized view cmv_mat_view2
-PREHOOK: type: DROP_MATERIALIZED_VIEW
-PREHOOK: Input: default@cmv_mat_view2
-PREHOOK: Output: default@cmv_mat_view2
-POSTHOOK: query: drop materialized view cmv_mat_view2
-POSTHOOK: type: DROP_MATERIALIZED_VIEW
-POSTHOOK: Input: default@cmv_mat_view2
-POSTHOOK: Output: default@cmv_mat_view2
-PREHOOK: query: create materialized view cmv_mat_view3
-comment 'this is the third view'
-row format
-  delimited fields terminated by '\t'
-as select * from cmv_basetable
-PREHOOK: type: CREATE_MATERIALIZED_VIEW
-PREHOOK: Input: default@cmv_basetable
-PREHOOK: Output: database:default
-PREHOOK: Output: default@cmv_mat_view3
-POSTHOOK: query: create materialized view cmv_mat_view3
-comment 'this is the third view'
-row format
-  delimited fields terminated by '\t'
-as select * from cmv_basetable
-POSTHOOK: type: CREATE_MATERIALIZED_VIEW
-POSTHOOK: Input: default@cmv_basetable
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@cmv_mat_view3
-PREHOOK: query: describe formatted cmv_mat_view3
-PREHOOK: type: DESCTABLE
-PREHOOK: Input: default@cmv_mat_view3
-POSTHOOK: query: describe formatted cmv_mat_view3
-POSTHOOK: type: DESCTABLE
-POSTHOOK: Input: default@cmv_mat_view3
-# col_name             data_type               comment             
-a                      int                                         
-b                      varchar(256)                                
-c                      decimal(10,2)                               
-                
-# Detailed Table Information            
-Database:              default                  
-#### A masked pattern was here ####
-Retention:             0                        
-#### A masked pattern was here ####
-Table Type:            MATERIALIZED_VIEW        
-Table Parameters:               
-       COLUMN_STATS_ACCURATE   {\"BASIC_STATS\":\"true\"}
-       comment                 this is the third view
-       numFiles                1                   
-       numRows                 5                   
-       rawDataSize             1025                
-       totalSize               497                 
-#### A masked pattern was here ####
-                
-# Storage Information           
-SerDe Library:         org.apache.hadoop.hive.ql.io.orc.OrcSerde        
-InputFormat:           org.apache.hadoop.hive.ql.io.orc.OrcInputFormat  
-OutputFormat:          org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat        
 
-Compressed:            No                       
-Num Buckets:           -1                       
-Bucket Columns:        []                       
-Sort Columns:          []                       
-                
-# View Information              
-View Original Text:    select * from cmv_basetable      
-View Expanded Text:    select `cmv_basetable`.`a`, `cmv_basetable`.`b`, 
`cmv_basetable`.`c` from `default`.`cmv_basetable`      
-View Rewrite Enabled:  No                       
-PREHOOK: query: select a, b, c from cmv_mat_view3
-PREHOOK: type: QUERY
-PREHOOK: Input: default@cmv_mat_view3
-#### A masked pattern was here ####
-POSTHOOK: query: select a, b, c from cmv_mat_view3
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@cmv_mat_view3
-#### A masked pattern was here ####
-1      alfred  10.30
-2      bob     3.14
-2      bonnie  172342.20
-3      calvin  978.76
-3      charlie 9.80
-PREHOOK: query: select distinct a from cmv_mat_view3
-PREHOOK: type: QUERY
-PREHOOK: Input: default@cmv_mat_view3
-#### A masked pattern was here ####
-POSTHOOK: query: select distinct a from cmv_mat_view3
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@cmv_mat_view3
-#### A masked pattern was here ####
-1
-2
-3
-PREHOOK: query: drop materialized view cmv_mat_view3
-PREHOOK: type: DROP_MATERIALIZED_VIEW
-PREHOOK: Input: default@cmv_mat_view3
-PREHOOK: Output: default@cmv_mat_view3
-POSTHOOK: query: drop materialized view cmv_mat_view3
-POSTHOOK: type: DROP_MATERIALIZED_VIEW
-POSTHOOK: Input: default@cmv_mat_view3
-POSTHOOK: Output: default@cmv_mat_view3
-PREHOOK: query: create materialized view cmv_mat_view4
-comment 'this is the last view'
-stored as textfile
-#### A masked pattern was here ####
-as select a from cmv_basetable
-PREHOOK: type: CREATE_MATERIALIZED_VIEW
-PREHOOK: Input: default@cmv_basetable
-#### A masked pattern was here ####
-PREHOOK: Output: database:default
-PREHOOK: Output: default@cmv_mat_view4
-POSTHOOK: query: create materialized view cmv_mat_view4
-comment 'this is the last view'
-stored as textfile
-#### A masked pattern was here ####
-as select a from cmv_basetable
-POSTHOOK: type: CREATE_MATERIALIZED_VIEW
-POSTHOOK: Input: default@cmv_basetable
-#### A masked pattern was here ####
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@cmv_mat_view4
-PREHOOK: query: describe formatted cmv_mat_view4
-PREHOOK: type: DESCTABLE
-PREHOOK: Input: default@cmv_mat_view4
-POSTHOOK: query: describe formatted cmv_mat_view4
-POSTHOOK: type: DESCTABLE
-POSTHOOK: Input: default@cmv_mat_view4
-# col_name             data_type               comment             
-a                      int                                         
-                
-# Detailed Table Information            
-Database:              default                  
-#### A masked pattern was here ####
-Retention:             0                        
-#### A masked pattern was here ####
-Table Type:            MATERIALIZED_VIEW        
-Table Parameters:               
-       COLUMN_STATS_ACCURATE   {\"BASIC_STATS\":\"true\"}
-       comment                 this is the last view
-       numFiles                1                   
-       numRows                 5                   
-       rawDataSize             5                   
-       totalSize               10                  
-#### A masked pattern was here ####
-                
-# Storage Information           
-SerDe Library:         org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe      
 
-InputFormat:           org.apache.hadoop.mapred.TextInputFormat         
-OutputFormat:          
org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat       
-Compressed:            No                       
-Num Buckets:           -1                       
-Bucket Columns:        []                       
-Sort Columns:          []                       
-                
-# View Information              
-View Original Text:    select a from cmv_basetable      
-View Expanded Text:    select `cmv_basetable`.`a` from 
`default`.`cmv_basetable`        
-View Rewrite Enabled:  No                       
-PREHOOK: query: select a from cmv_mat_view4
-PREHOOK: type: QUERY
-PREHOOK: Input: default@cmv_mat_view4
-#### A masked pattern was here ####
-POSTHOOK: query: select a from cmv_mat_view4
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@cmv_mat_view4
-#### A masked pattern was here ####
-1
-2
-2
-3
-3
-PREHOOK: query: drop materialized view cmv_mat_view4
-PREHOOK: type: DROP_MATERIALIZED_VIEW
-PREHOOK: Input: default@cmv_mat_view4
-PREHOOK: Output: default@cmv_mat_view4
-POSTHOOK: query: drop materialized view cmv_mat_view4
-POSTHOOK: type: DROP_MATERIALIZED_VIEW
-POSTHOOK: Input: default@cmv_mat_view4
-POSTHOOK: Output: default@cmv_mat_view4

http://git-wip-us.apache.org/repos/asf/hive/blob/644932d1/ql/src/test/results/clientpositive/materialized_view_drop.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/materialized_view_drop.q.out 
b/ql/src/test/results/clientpositive/materialized_view_drop.q.out
deleted file mode 100644
index ceb34f7..0000000
--- a/ql/src/test/results/clientpositive/materialized_view_drop.q.out
+++ /dev/null
@@ -1,39 +0,0 @@
-PREHOOK: query: create materialized view dmv_mat_view as select cint, cstring1 
from alltypesorc where cint < 0
-PREHOOK: type: CREATE_MATERIALIZED_VIEW
-PREHOOK: Input: default@alltypesorc
-PREHOOK: Output: database:default
-PREHOOK: Output: default@dmv_mat_view
-POSTHOOK: query: create materialized view dmv_mat_view as select cint, 
cstring1 from alltypesorc where cint < 0
-POSTHOOK: type: CREATE_MATERIALIZED_VIEW
-POSTHOOK: Input: default@alltypesorc
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@dmv_mat_view
-PREHOOK: query: show table extended like dmv_mat_view
-PREHOOK: type: SHOW_TABLESTATUS
-POSTHOOK: query: show table extended like dmv_mat_view
-POSTHOOK: type: SHOW_TABLESTATUS
-tableName:dmv_mat_view
-#### A masked pattern was here ####
-inputformat:org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
-outputformat:org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
-columns:struct columns { i32 cint, string cstring1}
-partitioned:false
-partitionColumns:
-totalNumberFiles:1
-totalFileSize:47120
-maxFileSize:47120
-minFileSize:47120
-#### A masked pattern was here ####
-
-PREHOOK: query: drop materialized view dmv_mat_view
-PREHOOK: type: DROP_MATERIALIZED_VIEW
-PREHOOK: Input: default@dmv_mat_view
-PREHOOK: Output: default@dmv_mat_view
-POSTHOOK: query: drop materialized view dmv_mat_view
-POSTHOOK: type: DROP_MATERIALIZED_VIEW
-POSTHOOK: Input: default@dmv_mat_view
-POSTHOOK: Output: default@dmv_mat_view
-PREHOOK: query: show table extended like dmv_mat_view
-PREHOOK: type: SHOW_TABLESTATUS
-POSTHOOK: query: show table extended like dmv_mat_view
-POSTHOOK: type: SHOW_TABLESTATUS

Reply via email to