I'll try to test your example.
Thanks so much!!
Search found 6 matches
- Thu Apr 24, 2014 2:34 am
- Forum: Vertica Data Load
- Topic: INSERT very slow
- Replies: 6
- Views: 13326
- Tue Apr 22, 2014 6:58 pm
- Forum: Vertica Data Load
- Topic: INSERT very slow
- Replies: 6
- Views: 13326
Re: INSERT very slow
Yes, I'm inserting row by row with individual INSERT statement.
I receive the data from binlog (mysql) and then I insert into vertica, I'm using ODBC / python2.7
Could you help me?
Thanks
I receive the data from binlog (mysql) and then I insert into vertica, I'm using ODBC / python2.7
Could you help me?
Thanks
- Tue Apr 22, 2014 4:15 pm
- Forum: Vertica Data Load
- Topic: INSERT very slow
- Replies: 6
- Views: 13326
INSERT very slow
Hello people.
I'm working in a tool, I'm using mysql binlog to replicate into vertica in real time. I'm using python between mysql / vertica, but the INSERT statement is very slow, there are other way to accelerate the INSERT?
thanks in advance
I'm working in a tool, I'm using mysql binlog to replicate into vertica in real time. I'm using python between mysql / vertica, but the INSERT statement is very slow, there are other way to accelerate the INSERT?
thanks in advance
- Fri Apr 04, 2014 2:26 pm
- Forum: Announcements, Events and Activities
- Topic: Free Vertica T-Shirt
- Replies: 8
- Views: 18509
Re: Free Vertica T-Shirt
yeahhhhh I want the t-shirt
Could you send me to Argentina? I love Vertica
Could you send me to Argentina? I love Vertica
- Mon Mar 18, 2013 4:36 pm
- Forum: Vertica Administration Tools
- Topic: Remove node from cluster
- Replies: 9
- Views: 36014
Re: Remove node from cluster
The cluster is going to keep running with 3 nodes, and its K-Safety is 1. We had 5 nodes. We know that it is not recommended to have a cluster with only 3 nodes, but we need to do it. Our main concern was that when issuing the script "update_vertica -R hostname", it tries to modify the installation ...
- Wed Mar 13, 2013 8:13 pm
- Forum: Vertica Administration Tools
- Topic: Remove node from cluster
- Replies: 9
- Views: 36014
Remove node from cluster
When trying to remove a host from a running cluster (the node was already removed from the database, it is no longer being used), the script seems to try to update the remaining hosts. Is this correct? It tries to setup all directories and permissions again, NTP, password, even if Vertica is already...