1、准备一个hive分区表数据
temp.tmp_adm_label
2、登录Oracle客户端
1)查询方式1:
select '1331r1_13' as test_str from dual ;
select
(case when instr(test_str,'_')>0 then substr(test_str,'1',instr(test_str,'_')-1 )el
1、准备一个hive分区表数据
temp.tmp_adm_label
2、登录Oracle客户端
1)查询方式1:
select '1331r1_13' as test_str from dual ;
select
(case when instr(test_str,'_')>0 then substr(test_str,'1',instr(test_str,'_')-1 )el