Is it possible to insert multiple rows into a Vertica database table with a single SQL command?
I'm looking for something like this.
CREATE LOCAL TEMPORARY TABLE "iris" ("Sepal.Length" DOUBLE PRECISION, "Sepal.Width" DOUBLE PRECISION, "Petal.Length" DOUBLE PRECISION, "Petal.Width" DOUBLE PRECISION, "Species" VARCHAR) INSERT INTO "iris" VALUES (5.1, 3.5, 1.4, 0.2, 'setosa'), (4.9, 3.0, 1.4, 0.2, 'setosa'), (4.7, 3.2, 1.3, 0.2, 'setosa)
This produces an error. The documentation states "You must insert one complete tuple at a time." Does this mean that I need one INSERT INTO SQL statement for each row of data?
When comparing storage usage on 4 nodes in our cluster, I noticed that a lot of size is occupied by backups (namely in Objects \backups\Objects location). I used vbr -t -remove -c backup.ini to remove old archived backups (we keep 4) , but the size of the Objects did not go down at all.
Next, I ran two commands:
vbr -t quick-repair -c configfile.ini
vbr -t collect-garbage -c configfile.ini --report-file=path/filename
Some old objects seemed to be deleted. but they only accounted for about 60GB of space. Since I deleted 2 archive backups, I expected the size of the Objects to go down 50%, but it didn't. The size of backups folder decreased from 830 to 760 GB only.
What it takes to fully remove all backups? Does backup\Objects holds some other files needed by Vertica?
1) Will Terrace routing work same as its in EON also.
2) since EON separated compute and storage, how terrace routing to going to help us in performance
3) If we impletented Terrace Routing , the same architecture we will be carrying while implementing to EON?
4) if we implemented EON do we need to additional implement Terrace routing?
Please respond as soon as possible
I am using count(1) over() recordCount to get the total number of records returned by the query and this appends along with the result. My query is something like this
select count(1) over() recordCount ,a.column1 ,b.column2 from table_1 a left join table_2 b on a.column_1 = b.column_1
With this clause place in a query the execution time is ~31 secs
But when i remove this clause, the execution time is ~5 secs.
Is there any alternative way to get the count of number of records returned by a query.
Something like the ROWCOUNT function in Oracle.
We have a 3 node Verica cluster. I want to start backup from one node to an external storage how do I know that no other backup is taking place at the same time on another node. I assume we can look for running vbr process on all three nodes, but is there a better way?