Skip to main content
Question

JVM while holding global locks

  • February 12, 2019
  • 4 replies
  • 16 views

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;

4 replies

Jim_Knicely
Forum|alt.badge.img+2
  • Participating Frequently
  • February 12, 2019

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
Forum|alt.badge.img+1
  • Participating Frequently
  • February 12, 2019

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
  • Author
  • New Participant
  • February 19, 2019
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
Forum|alt.badge.img+1
  • Participating Frequently
  • February 20, 2019

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?