Hi All,
I encountered such error when I tried to run a UDF in my query.
It is a TransformFunction written in C++.
It simply reads a Tweet JSON string as input and then extract some attribute values from it.
The query I run is something like this:
SELECT user_id, hashtag, created_at, text
FROM (SELECT twitter(json) over(partition by hash(json))
FROM tweetjson) as foo;
I am running vertica 6.1.3 in a 16-node cluster, each node has 4 CPU cores and 32GB RAM.
The UDF "twitter" works well when the table tweetjson is small, e.g., 16GB.
However, when the table size was 500GB, the query failed, and returned the following message:
java.sql.SQLException: [Vertica][VJDBC](3399) ERROR: Failure in UDx RPC call InvokeProcessPartition(): UDx side process has exited abnormally
at com.vertica.util.ServerErrorData.buildException(Unknown Source)
at com.vertica.dataengine.VResultSet.fetchChunk(Unknown Source)
at com.vertica.dataengine.VResultSet.initialize(Unknown Source)
at com.vertica.dataengine.VQueryExecutor.readExecuteResponse(Unknown Source)
I didn't change any default resource configuration. Was it the reason that the UDF was out of memory?
Where can I find the log that contains more detailed error message?
Thanks,
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.