create database if not EXISTS spark_integrition
use spark_integrition
create EXTERNAL table student
(
name string,
age int,
gpa string
)
row format delimited
fields terminated by '\t'
lines terminated by '\n'
stored as textfile
location '/dataset/hive'
load data inpath '/dataset/studenttab10k' overwrite into table student
Hive创建表
最新推荐文章于 2023-03-08 15:38:43 发布