1 Reply Latest reply on May 18, 2020 1:27 AM by user186817

    Function [INFASQLExecute] failed in adapter [/informatica/IPC104/plugins/dynamic/hiveruntime/libhive.so] with error code [-1].

    Dmitriy Vasilev New Member

      Good afternoon.

       

      We have Informatica BDM 10.401

       

       

      Error occurs when executing CTE from source from HIVE connector custom sql query:

       

      with a (select "1" as s from shema.table)

      select s

      from a

       

      Function [INFASQLExecute] failed in adapter [/informatica/IPC104/plugins/dynamic/hiveruntime/libhive.so] with error code [-1].

      Function [INFASQLGetDiagRecW] failed in adapter [/informatica/IPC104/plugins/dynamic/hiveruntime/libhive.so] with error code [100].

      Function [INFASQLGetDiagRecW] failed in adapter [/informatica/IPC104/plugins/dynamic/hiveruntime/libhive.so] with error code [100].].

      at com.informatica.dtm.executor.edtm.EdtmExecutor.createAndExeJdtm(EdtmExecutor.java:492)

      at com.informatica.dtm.executor.edtm.EdtmExecutor.run(EdtmExecutor.java:293)

      at com.informatica.platform.ldtm.executor.ExecutionEngine$SubmittedRunnable.run(ExecutionEngine.java:593)

      at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)

      at java.util.concurrent.FutureTask.run(FutureTask.java:266)

      at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)

      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

      at java.lang.Thread.run(Thread.java:748)

       

       

      A week ago, on version 10.201, we didn 't have this problem

       

       

       

      query  working

       

      select s

      from (select "1" as s from shema.table)  a