Search found 58 matches

by beth
Thu Feb 04, 2016 4:06 pm
Forum: Vertica Installation
Topic: No-Install option to just check prerequisites?
Replies: 2
Views: 17790

No-Install option to just check prerequisites?

Hi all,

Is there an option for the install_vertica.sh script that we can use that will not install Vertica, just test the pre-requisites?

Thanks!
by beth
Mon Dec 07, 2015 1:21 am
Forum: New to Vertica Database Administration
Topic: LGE vs Last Epoch?
Replies: 1
Views: 17760

LGE vs Last Epoch?

Hi all,

Can someone explain the difference between the "LGE (Last Good Epoch)" and the "Last Epoch"?

Thank you!
by beth
Sat Nov 14, 2015 4:58 pm
Forum: New to Vertica Database Administration
Topic: Does Partition Pruning Work?
Replies: 1
Views: 18223

Does Partition Pruning Work?

Hi guys, The documentation says the following about Partition Pruning : When a query predicate includes one or more columns in the partitioning clause, queries look only at relevant ROS containers. Does anyone know if this actually works? If it does how can I tell? I do not see anything about "Parti...
by beth
Sat Nov 14, 2015 4:34 pm
Forum: New to Vertica Database Administration
Topic: Partitions and ROS Containers
Replies: 3
Views: 24315

Re: Partitions and ROS Containers

Thank you Jim and Sharon! Your posts are very, very helpful!!!
by beth
Fri Nov 13, 2015 4:47 pm
Forum: New to Vertica Database Administration
Topic: Partitions and ROS Containers
Replies: 3
Views: 24315

Partitions and ROS Containers

Hi all, From the admin guide I read this: Partitions and ROS Containers 1. Data is automatically split into partitions during load / refresh / recovery operations. 2. The Tuple Mover maintains physical separation of partitions. 3. Each ROS container contains data for a single partition, though there...
by beth
Thu Oct 29, 2015 3:22 pm
Forum: New to Vertica Database Administration
Topic: ANALYZE_EXTERNAL_ROW_COUNT - Where's the counts?
Replies: 3
Views: 8503

ANALYZE_EXTERNAL_ROW_COUNT - Where's the counts?

Good morning,

The ANALYZE_EXTERNAL_ROW_COUNT calculates the exact number of rows in an external table.

Where does it store these row counts?
'
by beth
Sun Oct 25, 2015 9:15 am
Forum: General
Topic: Excavator availability?
Replies: 8
Views: 20261

Re: Excavator availability?

Don't be scary Harry! Hah! That rhymes. I'll be at the next BDC. My boss said he'll pay for it next year. Unfortunately I couldn't make the last one do to budgeting issues. I probably shouldn't say that... But Excavator is out, so Yay!!! :mrgreen:

Go to advanced search