进入beeline客户端
beeline -u jdbc:hive2://hadoop102:10000 -n atguigu
行数据按照tab划分
row format delimited fields terminated by ‘\t’
导入数据进入
load data local inpath ‘/opt/module/hive/datas/test.txt’ into table test;
创建student表,并导入数据
create table if not exists student(
id int, name string
)
row format delimited fields terminated by ‘\t’;
load data local inpath ‘/opt/module/hive/datas/student.txt’ into table student;
查看详细表结构
desc formatted student;
修改表的属性参数(内部表改为外部表)
alter table student set tblproperties(‘EXTERNAL’=‘TRUE’);
反过来
alter table student set tblproperties(‘EXTERNAL’=‘FALSE’);
重命名表
ALTER TABLE table_name RENAME TO new_table_name