spark,select 剔除某个字段的写法

例如需要剔除dtime字段

set spark.sql.parser.quotedRegexColumnNames=true;   
set spark.sql.hive.convertMetastoreOrc=false;
```
insert overwrite table lg_aws_db01.table1 partition (dtime = '20230403')
select `(dtime)?+.+` from lg_aws_db01.table1
where dtime = '20230402'
```
posted @ 2023-04-24 11:59  RAmenLCH  阅读(339)  评论(0)    收藏  举报