Hi, Try increase the moveout interval parameter, so that your moveout process starts at defined intervals according to you. Are you trying to load data frequently? ( frequency less then 5 mins ) How are you checking the moveout process is running. Try this SQL to check select * from system_sessions ...

Thanks skwa :) The last part of your reply answered my doubt. So there are three bugs 1. user_functions should have only user defined function, currently having all new function released with Vertica 7 2. procedure_type column should be function_type column description for this column in documents -...

Thanks a lot skwa

I already knew that ApproxCountDistinct is not a user defined function, but was surprised to see it in user_functions table.

also, Does the same bug apply for stored Procedure thing

Thanks

Hello All, Is there a way we can say which function is a user_defined(created by user) function in user_functions table. Currently I am seeing many functions in my user_functions system table Example ApproxCountDistinctLong Also, I can see procedure type as Stored Procedure....are these nothing but ...

Hi norbertk, Purging in vertica is a heavy operation, which can affect the read operations on database Pro's 1. Release database space being held by Delete vectors in database 2. Saves the queries from reading delete vectors while scanning data since there are no delete vectors existing after purge ...

Hello all, after trying the ODBC loader package and no success at it while installation, I m turning towards Vertica UDL. Before going to it, I just wanted to get a few things cleared 1. Can I use Vertica UDL to stream data from SQL server into Vertica directly using ODBC ? 2. Can a Vertica UDL be a...

Hello All, I need to setup connection between Vertica and SQL server. Trying to use ODBC loader package When trying to compile, I am getting this error make installmkdir -p build g++ -I /opt/vertica/sdk/include -I /opt/vertica/sdk/examples/HelperLibraries -fPIC -shared -Wall -g -o build/ODBCLoader.s...