drop table if exists `dev.astron_spark_test`;
CREATE TABLE `dev.astron_spark_test`
( id string, age string, sex int, weight double
)row format delimited fields terminated by '\t'
select count(1) from dev.astron_spark_test
select * from dev.astron_spark_test
后台load数据
load data local inpath ‘spark_test.txt’ overwrite into table dev.astron_spark_test
;