1、 创建表(内部表)
1.1 默认方式创建表
create table t5(id int,value string);
create external table t7(id int,value string)
row format delimited
fields terminated by '\t'
location 'hdfs://nameservice/user/18810635769/external/impala';
1.1 默认方式创建表
create table t5(id int,value string);
1.2 查询表结构
desc formatted t5;
默认存储位置: hdfs://nameservice/user/hive/warehouse/shenfuli.db/t5
类型: MANAGED_TABLE
2、 指定存储方式
2.1 执行存储方式
2.1 执行存储方式
create table t6(id int ,name string)
row format delimited
fields terminated by '\t'
stored as textfile;
2.2 查看表结构
row format delimited
fields terminated by '\t'
stored as textfile;
2.2 查看表结构
存储位置: hdfs://nameservice/user/hive/warehouse/shenfuli.db/t6
2.3 插入数据
类型: MANAGED_TABLE
通过Hive批量导入文件方式方式:
load data local inpath ‘/root/user.txt’ into table t6;
load data local inpath ‘/root/user.txt’ into table t6;
进入Impala,通过refresh t6刷新当前数据
3、创建外部表
3.1 默认方式创建表:
create external table t7(id int,value string)
row format delimited
fields terminated by '\t'
location 'hdfs://nameservice/user/18810635769/external/impala';
存储位置:hdfs://nameservice/user/18810635769/external/impala
表类型: EXTERNAL_TABLE
3.2 指定存储方式
表类型: EXTERNAL_TABLE
3.2 指定存储方式
create external table t9(id int,value string)
row format delimited
fields terminated by '\t'
row format delimited
fields terminated by '\t'
stored as textfile
location 'hdfs://nameservice/user/18810635769/external/impala';
location 'hdfs://nameservice/user/18810635769/external/impala';
通过Hive批量导入文件方式方式:
load data local inpath ‘/root/user.txt’ into table t10;
进入Impala,通过refresh t6刷新当前数据