forked from apache/hive
-
Notifications
You must be signed in to change notification settings - Fork 0
/
metadata_only.q.out
163 lines (160 loc) · 6.71 KB
/
metadata_only.q.out
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
PREHOOK: query: create table test1 (id int, val string) partitioned by (val2 string) STORED AS ORC TBLPROPERTIES ('transactional'='true')
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@test1
POSTHOOK: query: create table test1 (id int, val string) partitioned by (val2 string) STORED AS ORC TBLPROPERTIES ('transactional'='true')
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@test1
PREHOOK: query: describe formatted test1
PREHOOK: type: DESCTABLE
PREHOOK: Input: default@test1
POSTHOOK: query: describe formatted test1
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@test1
# col_name data_type comment
id int
val string
# Partition Information
# col_name data_type comment
val2 string
# Detailed Table Information
Database: default
#### A masked pattern was here ####
Retention: 0
#### A masked pattern was here ####
Table Type: MANAGED_TABLE
Table Parameters:
COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"}
bucketing_version 2
numFiles 0
numPartitions 0
numRows 0
rawDataSize 0
totalSize 0
transactional true
transactional_properties default
#### 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: []
PREHOOK: query: alter table test1 add partition (val2='foo')
PREHOOK: type: ALTERTABLE_ADDPARTS
PREHOOK: Output: default@test1
POSTHOOK: query: alter table test1 add partition (val2='foo')
POSTHOOK: type: ALTERTABLE_ADDPARTS
POSTHOOK: Output: default@test1
POSTHOOK: Output: default@test1@val2=foo
PREHOOK: query: alter table test1 add partition (val2='bar')
PREHOOK: type: ALTERTABLE_ADDPARTS
PREHOOK: Output: default@test1
POSTHOOK: query: alter table test1 add partition (val2='bar')
POSTHOOK: type: ALTERTABLE_ADDPARTS
POSTHOOK: Output: default@test1
POSTHOOK: Output: default@test1@val2=bar
PREHOOK: query: insert into test1 partition (val2='foo') values (1, 'abc')
PREHOOK: type: QUERY
PREHOOK: Input: _dummy_database@_dummy_table
PREHOOK: Output: default@test1@val2=foo
POSTHOOK: query: insert into test1 partition (val2='foo') values (1, 'abc')
POSTHOOK: type: QUERY
POSTHOOK: Input: _dummy_database@_dummy_table
POSTHOOK: Output: default@test1@val2=foo
POSTHOOK: Lineage: test1 PARTITION(val2=foo).id SCRIPT []
POSTHOOK: Lineage: test1 PARTITION(val2=foo).val SCRIPT []
PREHOOK: query: select distinct val2, current_timestamp from test1
PREHOOK: type: QUERY
PREHOOK: Input: default@test1
PREHOOK: Input: default@test1@val2=bar
PREHOOK: Input: default@test1@val2=foo
PREHOOK: Output: hdfs://### HDFS PATH ###
POSTHOOK: query: select distinct val2, current_timestamp from test1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@test1
POSTHOOK: Input: default@test1@val2=bar
POSTHOOK: Input: default@test1@val2=foo
POSTHOOK: Output: hdfs://### HDFS PATH ###
foo 2020-06-17 02:42:31.342
PREHOOK: query: insert into test1 partition (val2='bar') values (1, 'def')
PREHOOK: type: QUERY
PREHOOK: Input: _dummy_database@_dummy_table
PREHOOK: Output: default@test1@val2=bar
POSTHOOK: query: insert into test1 partition (val2='bar') values (1, 'def')
POSTHOOK: type: QUERY
POSTHOOK: Input: _dummy_database@_dummy_table
POSTHOOK: Output: default@test1@val2=bar
POSTHOOK: Lineage: test1 PARTITION(val2=bar).id SCRIPT []
POSTHOOK: Lineage: test1 PARTITION(val2=bar).val SCRIPT []
PREHOOK: query: delete from test1 where val2 = 'bar'
PREHOOK: type: QUERY
PREHOOK: Input: default@test1
PREHOOK: Input: default@test1@val2=bar
PREHOOK: Output: default@test1@val2=bar
POSTHOOK: query: delete from test1 where val2 = 'bar'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@test1
POSTHOOK: Input: default@test1@val2=bar
POSTHOOK: Output: default@test1@val2=bar
PREHOOK: query: select '--> hive.optimize.metadataonly=true'
PREHOOK: type: QUERY
PREHOOK: Input: _dummy_database@_dummy_table
PREHOOK: Output: hdfs://### HDFS PATH ###
POSTHOOK: query: select '--> hive.optimize.metadataonly=true'
POSTHOOK: type: QUERY
POSTHOOK: Input: _dummy_database@_dummy_table
POSTHOOK: Output: hdfs://### HDFS PATH ###
--> hive.optimize.metadataonly=true
PREHOOK: query: select distinct val2, current_timestamp from test1
PREHOOK: type: QUERY
PREHOOK: Input: default@test1
PREHOOK: Input: default@test1@val2=bar
PREHOOK: Input: default@test1@val2=foo
PREHOOK: Output: hdfs://### HDFS PATH ###
POSTHOOK: query: select distinct val2, current_timestamp from test1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@test1
POSTHOOK: Input: default@test1@val2=bar
POSTHOOK: Input: default@test1@val2=foo
POSTHOOK: Output: hdfs://### HDFS PATH ###
bar 2020-06-17 02:42:38.171
foo 2020-06-17 02:42:38.171
PREHOOK: query: select '--> hive.optimize.metadataonly=false'
PREHOOK: type: QUERY
PREHOOK: Input: _dummy_database@_dummy_table
PREHOOK: Output: hdfs://### HDFS PATH ###
POSTHOOK: query: select '--> hive.optimize.metadataonly=false'
POSTHOOK: type: QUERY
POSTHOOK: Input: _dummy_database@_dummy_table
POSTHOOK: Output: hdfs://### HDFS PATH ###
--> hive.optimize.metadataonly=false
PREHOOK: query: select distinct val2, current_timestamp from test1
PREHOOK: type: QUERY
PREHOOK: Input: default@test1
PREHOOK: Input: default@test1@val2=bar
PREHOOK: Input: default@test1@val2=foo
PREHOOK: Output: hdfs://### HDFS PATH ###
POSTHOOK: query: select distinct val2, current_timestamp from test1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@test1
POSTHOOK: Input: default@test1@val2=bar
POSTHOOK: Input: default@test1@val2=foo
POSTHOOK: Output: hdfs://### HDFS PATH ###
foo 2020-06-17 02:42:38.838
PREHOOK: query: select current_timestamp, * from test1
PREHOOK: type: QUERY
PREHOOK: Input: default@test1
PREHOOK: Input: default@test1@val2=bar
PREHOOK: Input: default@test1@val2=foo
PREHOOK: Output: hdfs://### HDFS PATH ###
POSTHOOK: query: select current_timestamp, * from test1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@test1
POSTHOOK: Input: default@test1@val2=bar
POSTHOOK: Input: default@test1@val2=foo
POSTHOOK: Output: hdfs://### HDFS PATH ###
2020-06-17 02:42:40.158 1 abc foo