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'
```
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'
```

浙公网安备 33010602011771号