create table test_inner_table (key string)
LOAD DATA LOCAL INPATH ‘filepath’ INTO TABLE test_inner_table
select * from test_inner_table select count(*),得到test_inner_table
drop table test_inner_table
<强> 强> <强> 强>
<强> 强> <强> 强>
create table test_partition_table (key 字符串),partitioned by (dtstring)
LOAD DATA INPATH “filepath”, INTO table test_partition_tablepartition (dt=' 2006 ')
select *得到test_partition_table select count(*),得到test_partition_table
,drop table test_partition_table
<强> 强> <强> 强>
<强> 强> <强> 强>
create external table test_external_table (key 字符串)
LOAD DATA INPATH “filepath”, INTO table test_inner_table
select *得到test_external_table select count(*),得到test_external_table
drop table test_external_table
<强> 强> <强> 强>
<强> 强> <强> 强>
create table test_bucket_table (key 字符串) ,,,,clustered by (关键)into 20,桶
LOAD DATA INPATH “filepath”, into TABLE test_bucket_table
select *得到test_bucket_table set hive.enforce.bucketing =,真的,
<强> 强> <强> 强>
create view test_view as select *,得到测试
<强> 强> <强> 强>
& lt; property> ,,,,,,& lt; name> hive.hwi.war.file ,,,,,,& lt; value> lib/hive-hwi-0.8.1.war null蜂巢入门到剖析(四)