The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

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 - Select Field - Administrator
    edited February 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;

  • SruthiASruthiA Vertica Employee 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?

  • 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 Vertica Employee 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