The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

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;

Answers

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

    Jim_Knicely
    于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
Emoji
Image
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.