PageRenderTime 4ms CodeModel.GetById 1ms app.highlight 1ms RepoModel.GetById 1ms app.codeStats 0ms

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

#
text | 14 lines | 6 code | 8 blank | 0 comment | 0 complexity | 698e28e4fd46eae657df1564cd181e46 MD5 | raw file
 1show partitions srcpart;
 2
 3
 4
 5create table if not exists nzhang_part7 like srcpart;
 6describe extended nzhang_part7;
 7
 8
 9insert overwrite table nzhang_part7 partition (ds='2010-03-03', hr='12') select key, value from srcpart where ds = '2008-04-08' and hr = '12';
10
11show partitions nzhang_part7;
12
13select * from nzhang_part7 where ds is not null and hr is not null;
14