建表插入
create table ods_sail2(
id bigInt,
num int,
sail_pirce decimal(6,2),
discount DECIMAL(2,1),
employee_id BIGINT,
sail_date date
)
row format delimited fields terminated by ','
stored as orc
load data local inpath 'file:///root/testData/ods_sail.txt' into table ods_sail2;
查询报错
使用select
insert into table ods_sail2 select * from ods_sail;
查询
查看建表语句
show create table ods_sail2