Skip to main content
Question

JVM while holding global locks

  • Feb 12, 2019 3:13 AM UTC
  • 4 replies
  • 20 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
  • Feb 12, 2019 1:16 PM UTC

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
  • Feb 12, 2019 7:55 PM UTC

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
  • Feb 19, 2019 5:50 AM UTC
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
  • Feb 20, 2019 5:45 PM UTC

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?