Hive的数据模型_内部表
- 与数据库中的Table在概念上是类似。
- 每一个Table在Hive中都有一个相应的目录存储数据。
- 所有的Table数据(不包括External Table)都保存在这个目录中。
create table t1 (tid int, tname string, age int); create table t2 (tid int, tname string, age int) location ‘/mytable/hive/t2‘ create table t3 (tid int, tname string, age int) row format delimited fields terminated by ‘,‘; create table t4 as select * from t1;
hdfs dfs -cat /usr/hive/warehouse/tablename/000000_0
alter table t1 add columns(english int); desc t1;
if open the recycle bin function of hdfs . we can see the file has not been deleted, but move from one dir to another dir, we can restore it.
drop table t1;
原文：http://www.cnblogs.com/liupuLearning/p/6322471.html