PageRenderTime 25ms CodeModel.GetById 17ms app.highlight 3ms RepoModel.GetById 1ms app.codeStats 1ms

/tags/release-0.0.0-rc0/hive/external/hbase-handler/src/test/results/hbase_joins.q.out

#
text | 267 lines | 265 code | 2 blank | 0 comment | 0 complexity | 81ccf602d7c05c94763eafffe5e66e93 MD5 | raw file
  1PREHOOK: query: DROP TABLE users
  2PREHOOK: type: DROPTABLE
  3POSTHOOK: query: DROP TABLE users
  4POSTHOOK: type: DROPTABLE
  5PREHOOK: query: DROP TABLE states
  6PREHOOK: type: DROPTABLE
  7POSTHOOK: query: DROP TABLE states
  8POSTHOOK: type: DROPTABLE
  9PREHOOK: query: DROP TABLE countries
 10PREHOOK: type: DROPTABLE
 11POSTHOOK: query: DROP TABLE countries
 12POSTHOOK: type: DROPTABLE
 13PREHOOK: query: DROP TABLE users_level
 14PREHOOK: type: DROPTABLE
 15POSTHOOK: query: DROP TABLE users_level
 16POSTHOOK: type: DROPTABLE
 17PREHOOK: query: -- From HIVE-1257
 18
 19CREATE TABLE users(key string, state string, country string, country_id int)
 20STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
 21WITH SERDEPROPERTIES (
 22"hbase.columns.mapping" = "info:state,info:country,info:country_id"
 23)
 24PREHOOK: type: CREATETABLE
 25POSTHOOK: query: -- From HIVE-1257
 26
 27CREATE TABLE users(key string, state string, country string, country_id int)
 28STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
 29WITH SERDEPROPERTIES (
 30"hbase.columns.mapping" = "info:state,info:country,info:country_id"
 31)
 32POSTHOOK: type: CREATETABLE
 33POSTHOOK: Output: default@users
 34PREHOOK: query: CREATE TABLE states(key string, name string)
 35STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
 36WITH SERDEPROPERTIES (
 37"hbase.columns.mapping" = "state:name"
 38)
 39PREHOOK: type: CREATETABLE
 40POSTHOOK: query: CREATE TABLE states(key string, name string)
 41STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
 42WITH SERDEPROPERTIES (
 43"hbase.columns.mapping" = "state:name"
 44)
 45POSTHOOK: type: CREATETABLE
 46POSTHOOK: Output: default@states
 47PREHOOK: query: CREATE TABLE countries(key string, name string, country string, country_id int)
 48STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
 49WITH SERDEPROPERTIES (
 50"hbase.columns.mapping" = "info:name,info:country,info:country_id"
 51)
 52PREHOOK: type: CREATETABLE
 53POSTHOOK: query: CREATE TABLE countries(key string, name string, country string, country_id int)
 54STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
 55WITH SERDEPROPERTIES (
 56"hbase.columns.mapping" = "info:name,info:country,info:country_id"
 57)
 58POSTHOOK: type: CREATETABLE
 59POSTHOOK: Output: default@countries
 60PREHOOK: query: INSERT OVERWRITE TABLE users SELECT 'user1', 'IA', 'USA', 0
 61FROM src WHERE key=100
 62PREHOOK: type: QUERY
 63PREHOOK: Input: default@src
 64PREHOOK: Output: default@users
 65POSTHOOK: query: INSERT OVERWRITE TABLE users SELECT 'user1', 'IA', 'USA', 0
 66FROM src WHERE key=100
 67POSTHOOK: type: QUERY
 68POSTHOOK: Input: default@src
 69POSTHOOK: Output: default@users
 70PREHOOK: query: INSERT OVERWRITE TABLE states SELECT 'IA', 'Iowa'
 71FROM src WHERE key=100
 72PREHOOK: type: QUERY
 73PREHOOK: Input: default@src
 74PREHOOK: Output: default@states
 75POSTHOOK: query: INSERT OVERWRITE TABLE states SELECT 'IA', 'Iowa'
 76FROM src WHERE key=100
 77POSTHOOK: type: QUERY
 78POSTHOOK: Input: default@src
 79POSTHOOK: Output: default@states
 80PREHOOK: query: INSERT OVERWRITE TABLE countries SELECT 'USA', 'United States', 'USA', 1
 81FROM src WHERE key=100
 82PREHOOK: type: QUERY
 83PREHOOK: Input: default@src
 84PREHOOK: Output: default@countries
 85POSTHOOK: query: INSERT OVERWRITE TABLE countries SELECT 'USA', 'United States', 'USA', 1
 86FROM src WHERE key=100
 87POSTHOOK: type: QUERY
 88POSTHOOK: Input: default@src
 89POSTHOOK: Output: default@countries
 90PREHOOK: query: SELECT u.key, u.country, c.name, c.key FROM users u JOIN countries c 
 91ON (u.country = c.key)
 92PREHOOK: type: QUERY
 93PREHOOK: Input: default@countries
 94PREHOOK: Input: default@users
 95PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-01-10_14-19-29_136_2919119166696342265/-mr-10000
 96POSTHOOK: query: SELECT u.key, u.country, c.name, c.key FROM users u JOIN countries c 
 97ON (u.country = c.key)
 98POSTHOOK: type: QUERY
 99POSTHOOK: Input: default@countries
100POSTHOOK: Input: default@users
101POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-01-10_14-19-29_136_2919119166696342265/-mr-10000
102user1	USA	United States	USA
103PREHOOK: query: SELECT u.key, u.country, c.name, c.key FROM users u JOIN countries c
104ON (u.country = c.country)
105PREHOOK: type: QUERY
106PREHOOK: Input: default@countries
107PREHOOK: Input: default@users
108PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-01-10_14-19-38_418_1418937364423533875/-mr-10000
109POSTHOOK: query: SELECT u.key, u.country, c.name, c.key FROM users u JOIN countries c
110ON (u.country = c.country)
111POSTHOOK: type: QUERY
112POSTHOOK: Input: default@countries
113POSTHOOK: Input: default@users
114POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-01-10_14-19-38_418_1418937364423533875/-mr-10000
115user1	USA	United States	USA
116PREHOOK: query: SELECT u.key, u.country, c.name, c.key FROM users u JOIN countries c 
117ON (u.country_id = c.country_id)
118PREHOOK: type: QUERY
119PREHOOK: Input: default@countries
120PREHOOK: Input: default@users
121PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-01-10_14-19-47_279_1891102438076444084/-mr-10000
122POSTHOOK: query: SELECT u.key, u.country, c.name, c.key FROM users u JOIN countries c 
123ON (u.country_id = c.country_id)
124POSTHOOK: type: QUERY
125POSTHOOK: Input: default@countries
126POSTHOOK: Input: default@users
127POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-01-10_14-19-47_279_1891102438076444084/-mr-10000
128PREHOOK: query: SELECT u.key, u.state, s.name FROM users u JOIN states s 
129ON (u.state = s.key)
130PREHOOK: type: QUERY
131PREHOOK: Input: default@states
132PREHOOK: Input: default@users
133PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-01-10_14-19-54_306_2919915084551749896/-mr-10000
134POSTHOOK: query: SELECT u.key, u.state, s.name FROM users u JOIN states s 
135ON (u.state = s.key)
136POSTHOOK: type: QUERY
137POSTHOOK: Input: default@states
138POSTHOOK: Input: default@users
139POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-01-10_14-19-54_306_2919915084551749896/-mr-10000
140user1	IA	Iowa
141PREHOOK: query: SELECT u.key, u.country, c.name, c.key FROM users u JOIN countries c 
142ON (u.country = c.key)
143PREHOOK: type: QUERY
144PREHOOK: Input: default@countries
145PREHOOK: Input: default@users
146PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-01-10_14-20-03_810_1067780128697572780/-mr-10000
147POSTHOOK: query: SELECT u.key, u.country, c.name, c.key FROM users u JOIN countries c 
148ON (u.country = c.key)
149POSTHOOK: type: QUERY
150POSTHOOK: Input: default@countries
151POSTHOOK: Input: default@users
152POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-01-10_14-20-03_810_1067780128697572780/-mr-10000
153user1	USA	United States	USA
154PREHOOK: query: SELECT u.key, u.country, c.name, c.key FROM users u JOIN countries c
155ON (u.country = c.country)
156PREHOOK: type: QUERY
157PREHOOK: Input: default@countries
158PREHOOK: Input: default@users
159PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-01-10_14-20-14_736_8923692779050900406/-mr-10000
160POSTHOOK: query: SELECT u.key, u.country, c.name, c.key FROM users u JOIN countries c
161ON (u.country = c.country)
162POSTHOOK: type: QUERY
163POSTHOOK: Input: default@countries
164POSTHOOK: Input: default@users
165POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-01-10_14-20-14_736_8923692779050900406/-mr-10000
166user1	USA	United States	USA
167PREHOOK: query: SELECT u.key, u.country, c.name, c.key FROM users u JOIN countries c 
168ON (u.country_id = c.country_id)
169PREHOOK: type: QUERY
170PREHOOK: Input: default@countries
171PREHOOK: Input: default@users
172PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-01-10_14-20-22_235_696090037944243521/-mr-10000
173POSTHOOK: query: SELECT u.key, u.country, c.name, c.key FROM users u JOIN countries c 
174ON (u.country_id = c.country_id)
175POSTHOOK: type: QUERY
176POSTHOOK: Input: default@countries
177POSTHOOK: Input: default@users
178POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-01-10_14-20-22_235_696090037944243521/-mr-10000
179PREHOOK: query: SELECT u.key, u.state, s.name FROM users u JOIN states s 
180ON (u.state = s.key)
181PREHOOK: type: QUERY
182PREHOOK: Input: default@states
183PREHOOK: Input: default@users
184PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-01-10_14-20-28_951_5386570432365997648/-mr-10000
185POSTHOOK: query: SELECT u.key, u.state, s.name FROM users u JOIN states s 
186ON (u.state = s.key)
187POSTHOOK: type: QUERY
188POSTHOOK: Input: default@states
189POSTHOOK: Input: default@users
190POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-01-10_14-20-28_951_5386570432365997648/-mr-10000
191user1	IA	Iowa
192PREHOOK: query: DROP TABLE users
193PREHOOK: type: DROPTABLE
194PREHOOK: Input: default@users
195PREHOOK: Output: default@users
196POSTHOOK: query: DROP TABLE users
197POSTHOOK: type: DROPTABLE
198POSTHOOK: Input: default@users
199POSTHOOK: Output: default@users
200PREHOOK: query: DROP TABLE states
201PREHOOK: type: DROPTABLE
202PREHOOK: Input: default@states
203PREHOOK: Output: default@states
204POSTHOOK: query: DROP TABLE states
205POSTHOOK: type: DROPTABLE
206POSTHOOK: Input: default@states
207POSTHOOK: Output: default@states
208PREHOOK: query: DROP TABLE countries
209PREHOOK: type: DROPTABLE
210PREHOOK: Input: default@countries
211PREHOOK: Output: default@countries
212POSTHOOK: query: DROP TABLE countries
213POSTHOOK: type: DROPTABLE
214POSTHOOK: Input: default@countries
215POSTHOOK: Output: default@countries
216PREHOOK: query: CREATE TABLE users(key int, userid int, username string, created int) 
217STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
218WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,f:userid,f:nickname,f:created")
219PREHOOK: type: CREATETABLE
220POSTHOOK: query: CREATE TABLE users(key int, userid int, username string, created int) 
221STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
222WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,f:userid,f:nickname,f:created")
223POSTHOOK: type: CREATETABLE
224POSTHOOK: Output: default@users
225PREHOOK: query: CREATE TABLE users_level(key int, userid int, level int)
226STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
227WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,f:userid,f:level")
228PREHOOK: type: CREATETABLE
229POSTHOOK: query: CREATE TABLE users_level(key int, userid int, level int)
230STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
231WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,f:userid,f:level")
232POSTHOOK: type: CREATETABLE
233POSTHOOK: Output: default@users_level
234PREHOOK: query: -- HIVE-1903:  the problem fixed here showed up even without any data,
235-- so no need to load any to test it
236SELECT year(from_unixtime(users.created)) AS year, level, count(users.userid) AS num 
237 FROM users JOIN users_level ON (users.userid = users_level.userid) 
238 GROUP BY year(from_unixtime(users.created)), level
239PREHOOK: type: QUERY
240PREHOOK: Input: default@users
241PREHOOK: Input: default@users_level
242PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-01-10_14-20-47_957_2665969936395506719/-mr-10000
243POSTHOOK: query: -- HIVE-1903:  the problem fixed here showed up even without any data,
244-- so no need to load any to test it
245SELECT year(from_unixtime(users.created)) AS year, level, count(users.userid) AS num 
246 FROM users JOIN users_level ON (users.userid = users_level.userid) 
247 GROUP BY year(from_unixtime(users.created)), level
248POSTHOOK: type: QUERY
249POSTHOOK: Input: default@users
250POSTHOOK: Input: default@users_level
251POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-01-10_14-20-47_957_2665969936395506719/-mr-10000
252PREHOOK: query: DROP TABLE users
253PREHOOK: type: DROPTABLE
254PREHOOK: Input: default@users
255PREHOOK: Output: default@users
256POSTHOOK: query: DROP TABLE users
257POSTHOOK: type: DROPTABLE
258POSTHOOK: Input: default@users
259POSTHOOK: Output: default@users
260PREHOOK: query: DROP TABLE users_level
261PREHOOK: type: DROPTABLE
262PREHOOK: Input: default@users_level
263PREHOOK: Output: default@users_level
264POSTHOOK: query: DROP TABLE users_level
265POSTHOOK: type: DROPTABLE
266POSTHOOK: Input: default@users_level
267POSTHOOK: Output: default@users_level