PageRenderTime 19ms CodeModel.GetById 16ms app.highlight 0ms RepoModel.GetById 2ms app.codeStats 0ms

/tags/release-0.0.0-rc0/hive/external/ql/src/test/queries/clientpositive/union23.q

#
text | 17 lines | 15 code | 2 blank | 0 comment | 0 complexity | 63cd2d40a22bec8914b7c677d3113a8f MD5 | raw file
 1explain
 2select s.key2, s.value2
 3from (
 4  select transform(key, value) using 'cat' as (key2, value2)
 5  from src
 6  union all 
 7  select key as key2, value as value2 from src) s
 8order by s.key2, s.value2;
 9
10select s.key2, s.value2
11from (
12  select transform(key, value) using 'cat' as (key2, value2)
13  from src
14  union all 
15  select key as key2, value as value2 from src) s
16order by s.key2, s.value2;
17