Search found 302 matches

by scutter
Mon Aug 10, 2015 4:59 pm
Forum: New to Vertica Database Administration
Topic: ROSSALColumnAccess position not found Error!
Replies: 4
Views: 9698

Re: ROSSALColumnAccess position not found Error!

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
by scutter
Mon Aug 10, 2015 2:29 pm
Forum: New to Vertica Database Administration
Topic: ROSSALColumnAccess position not found Error!
Replies: 4
Views: 9698

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
by scutter
Wed Aug 05, 2015 8:51 pm
Forum: Vertica Performance Tuning
Topic: Help with LIMIT performance?
Replies: 2
Views: 16411

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 ...
by scutter
Fri Jul 24, 2015 1:32 pm
Forum: New to Vertica SQL
Topic: Help with Code
Replies: 16
Views: 31350

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
by scutter
Thu Jul 23, 2015 1:07 pm
Forum: ADO.NET
Topic: CREATE TEMP TABLE transaction auto commit issue
Replies: 7
Views: 33894

Re: CREATE TEMP TABLE transaction auto commit issue

You can use COPY .. NO COMMIT to defer the commit.

—Sharon
by scutter
Tue May 26, 2015 12:50 am
Forum: Vertica SQL
Topic: Joins, group by, etc with Flex?
Replies: 3
Views: 7673

Re: Joins, group by, etc with Flex?

Yes, as long as those columns involved with JOIN's and GROUP BY's are materialized on the Flex table.
Joins and Group Bys can be executed on virtual flex table columns as well - they need not be materialized.

—Sharon
by scutter
Sun May 17, 2015 9:41 pm
Forum: New to Vertica
Topic: How Delete Works in vertica
Replies: 2
Views: 8639

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 ...

Go to advanced search