The Vertica Forum is getting a makeover! The site will be undergoing maintenance from Tuesday 8/13 to Friday 8/16. We appreciate your patience and cooperation during this time.

JVM while holding global locks

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_KnicelyJim_Knicely Administrator
    edited February 12

    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;

  • SruthiASruthiA Employee

    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?

  • via Email
    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?

    于2019年2月12日周二 下午9:16写道:
  • SruthiASruthiA Employee

    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?

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.