JVM while holding global locks

Chen_Sun

When using UDL, sometimes I meet "JVM while holding global locks". Why this happend?

Here is the SQL used:

create flex external table aim_track_20190210() as copy with source OssSource(path='oss://xxxxxxx20190210*') parser fjsonparser(flatten_maps=false, record_terminator=E'\n');

create table aim_track_test4 as select m1 from aim_track_20190210 limit 2000;

Jim_Knicely

Which CREATE TABLE statement generates the error? If it's the second, can you run the SELECT part okay?

select m1 from aim_track_20190210 limit 2000;

SruthiA

Could you please share us with UDL OSSSOURCE JAVA code and share us more information on the issue. Is the CREATE flex external table query erroring out?

Chen_Sun

Thanks for the reply. Running the second statement solved my problem. I
am wondering why this issue happen . Is there a better solution without
running extra statement?

Jim_Knicely
于2019年2月12日周二 下午9:16写道：

SruthiA

Chen, you meant you ran below statement?

create table aim_track_test4 as select m1 from aim_track_20190210 limit 2000;

was your plan to create external flex table?