Hibiki Serizawa comments

Results 6 comments of


                                            Hibiki Serizawa

ODBCLoader() : ERROR 3399: Failure in UDx RPC call InvokeSetupUDL(): timed out in receiving a UDx message

@RomainLeclair Please increase the value of **UDxFencedBlockTimeout** configuration parameter. The default value is 60 which means 60sec. `ALTER DATABASE DEFAULT SET UDxFencedBlockTimeout = ;`

ODBCLoader() : ERROR 3399: Failure in UDx RPC call InvokeSetupUDL(): timed out in receiving a UDx message

@RomainLeclair Can you provide detailed information to break down the issue and reproduce it? 1. Log messages in UDxFencedProcesses.log and vertica.log related to this transaction. 2. Any error happened on...

compatlib_function - ConnectBy supports VARCHAR inputs

[Test Data] ``` => CREATE TABLE company (id INT, supervisor_id INT, name VARCHAR(20)); => INSERT INTO company VALUES (1, null, 'Patrick'); => INSERT INTO company VALUES (2, 1, 'Jim'); =>...

compatlib_function - ConnectBy supports VARCHAR inputs

@dmankins Thank you for your valuable feedback! Yes, the data conversion from int to string will be a performance concern. I removed the conversion using the template. Can you review...

compatlib_function - ConnectBy supports only an integer input. It does not work when the parent-child relationship is established as a STRING / VARCHAR.

Confirmed connect_by_path accepts only INTEGER values for parent ID and child ID. If it was run with the following data, the error happened. ``` => CREATE TABLE company (id VARCHAR,...

Strings Package Error "ROLLBACK 3399"

I tried to compile String package and install it in Vertica 10.1.1-5 on Ubuntu 16. It was successful. OS version: ``` $ lsb_release -a No LSB modules are available. Distributor...