Search found 302 matches
- Thu Sep 04, 2014 2:44 am
- Forum: Vertica Database Administration
- Topic: sessions vs vs_sessions
- Replies: 2
- Views: 6501
Re: sessions vs vs_sessions
Thanks norbert !!!!
- Thu Sep 04, 2014 2:30 am
- Forum: Vertica SQL
- Topic: ORDERED Hint
- Replies: 6
- Views: 11207
Re: ORDERED Hint
Thanks sharon !!!!
- Wed Sep 03, 2014 12:10 pm
- Forum: Vertica Database Administration
- Topic: sessions vs vs_sessions
- Replies: 2
- Views: 6501
sessions vs vs_sessions
Hello All,
Came across this system table vs_sessions and was confused as to what does this table show.
The session tables show the sessions information, but it seems this table is different from sessions table.
This table does not belong to v_internal or v_monitor or v_catalog schema.
Thanks
Came across this system table vs_sessions and was confused as to what does this table show.
The session tables show the sessions information, but it seems this table is different from sessions table.
This table does not belong to v_internal or v_monitor or v_catalog schema.
Thanks
- Thu Aug 28, 2014 8:58 am
- Forum: Vertica Database Administration
- Topic: NewEEThread vs Plannedconcurrency
- Replies: 4
- Views: 8870
NewEEThread vs Plannedconcurrency
while going through Vertica configuration parameters table, I found these two parameters 1. NewEEThread : Number of threads the EE will attempt to use for processing (per plan) 2. SortWorkerThreads : Controls the number of Sort worker threads; 0 disables background threads According to description ,...
- Thu Aug 28, 2014 7:28 am
- Forum: Announcements, Events and Activities
- Topic: Pictures from the conference!
- Replies: 16
- Views: 52024
Re: Pictures from the conference!
Good to see Vertica Forum members together.
Superlike
Superlike
- Thu Aug 28, 2014 7:09 am
- Forum: Vertica Database Administration
- Topic: DROP COLUMN doesn't work if there is data in the table
- Replies: 7
- Views: 19762
Re: DROP COLUMN doesn't work if there is data in the table
Hi Jim,
Continuing on this topic.
Is there any column showing the order by clause of the tables.
Projections's order by clause can be checked with Projection_columns, but I could not find any tables showing tables order by clause
Thanks
Continuing on this topic.
Is there any column showing the order by clause of the tables.
Projections's order by clause can be checked with Projection_columns, but I could not find any tables showing tables order by clause
Thanks
- Thu Jul 24, 2014 6:14 am
- Forum: New to Vertica Database Administration
- Topic: Copying the Database to Another Cluster
- Replies: 3
- Views: 8128
Re: Copying the Database to Another Cluster
Agreed with Skwa,
Lets not call it a limitation, it is part of smart design of product's Backup and Restore feature.
And for the workaround , Vertica gives this feature / tool to export your data from one cluster to another, using Export to Vertica options.
Hope this helps
Lets not call it a limitation, it is part of smart design of product's Backup and Restore feature.
And for the workaround , Vertica gives this feature / tool to export your data from one cluster to another, using Export to Vertica options.
Hope this helps