Certainly. Vertica relies on keeping all nodes consistent. If a node can’t remain consistent (such as COMMITing a transaction), then it will take itself out of the cluster.
—Sharon
Search found 302 matches
- Mon Aug 10, 2015 4:59 pm
- Forum: New to Vertica Database Administration
- Topic: ROSSALColumnAccess position not found Error!
- Replies: 4
- Views: 9761
- Mon Aug 10, 2015 2:29 pm
- Forum: New to Vertica Database Administration
- Topic: ROSSALColumnAccess position not found Error!
- Replies: 4
- Views: 9761
Re: ROSSALColumnAccess position not found Error!
That’s vertica trying to find a particular “position” (row number) in a ROS and not finding it. Sounds like something got corrupted. Does the log file tell you which projection is corrupted?
—Sharon
—Sharon
- Wed Aug 05, 2015 8:51 pm
- Forum: Vertica Performance Tuning
- Topic: Help with LIMIT performance?
- Replies: 2
- Views: 16655
Re: Help with LIMIT performance?
It’s going to depend greatly on what sort of query you are executing. Each node will limit the data that it sends back to the initiator to a single row as quickly as it can. But if the query needs to do lots of work before it can apply the LIMIT 1 then you need to wait. For example a large GROUP BY ...
- Fri Jul 24, 2015 1:32 pm
- Forum: New to Vertica SQL
- Topic: Help with Code
- Replies: 16
- Views: 31766
Re: Help with Code
C’mon folks, let’s be a little bit more supportive. Not everyone has vast experience with more complex SQL. Everyone needs to start somewhere.
If you don’t have something constructive to say, then please don’t say anything.
—Sharon
If you don’t have something constructive to say, then please don’t say anything.
—Sharon
- Thu Jul 23, 2015 1:07 pm
- Forum: ADO.NET
- Topic: CREATE TEMP TABLE transaction auto commit issue
- Replies: 7
- Views: 34272
Re: CREATE TEMP TABLE transaction auto commit issue
You can use COPY .. NO COMMIT to defer the commit.
—Sharon
—Sharon
- Tue May 26, 2015 12:50 am
- Forum: Vertica SQL
- Topic: Joins, group by, etc with Flex?
- Replies: 3
- Views: 7708
Re: Joins, group by, etc with Flex?
Joins and Group Bys can be executed on virtual flex table columns as well - they need not be materialized.Yes, as long as those columns involved with JOIN's and GROUP BY's are materialized on the Flex table.
—Sharon
- Sun May 17, 2015 9:41 pm
- Forum: New to Vertica
- Topic: How Delete Works in vertica
- Replies: 2
- Views: 8689
Re: How Delete Works in vertica
Well, let’s clarify this a bit. When you delete data, a “delete vector” is created for the deleted rows. DELETE may use the WOS for the delete vector. If there are many rows being deleted, the delete vector may spill to ROS just as a load does. Or if you use the /*+direct*/ hint on the DELETE, then ...