You are absolutely correct.
The application pool uses previously spawned connections to run a job which creates a temporary table. When a node has been bounced after the session has been started, it won't let that session create a temp table.
Do you know the reasoning behind this behavior?
Rob.
Search found 13 matches
- Tue Jan 28, 2014 9:50 am
- Forum: Vertica Database Administration
- Topic: Cannot modify temporary table error
- Replies: 2
- Views: 7715
- Wed Jan 22, 2014 9:01 am
- Forum: Vertica Database Administration
- Topic: Cannot modify temporary table error
- Replies: 2
- Views: 7715
Cannot modify temporary table error
Hi, Has anyone seen this before? I am trying to create a temporary table as follows: create LOCAL TEMP table recent_stock_items ON COMMIT PRESERVE ROWS AS select distinct s.public_reference, s.advertiser_id, s.stock_item_last_updated, s.stock_item_id,s.revision_number, s.version_number from stock_it...
- Wed Feb 06, 2013 11:53 am
- Forum: Vertica Database Administration
- Topic: Simulate Heavy Load
- Replies: 1
- Views: 4894
Simulate Heavy Load
Hi,
Does anyone have any tools or scripts that can simulate heavy load across a Vertica database/cluster?
I'm trying to set up a training session but want to show people what heavy load looks like.
Cheers
Rob.
Does anyone have any tools or scripts that can simulate heavy load across a Vertica database/cluster?
I'm trying to set up a training session but want to show people what heavy load looks like.
Cheers
Rob.
- Fri Sep 14, 2012 10:22 am
- Forum: Vertica Performance Tuning
- Topic: Database Designer
- Replies: 5
- Views: 10876
Database Designer
Can any user run the database desginer or can it only be the dba superuser account?
Rob.
Rob.
- Wed Sep 12, 2012 4:31 pm
- Forum: Vertica Backup & Recovery
- Topic: Backup to standby cluster
- Replies: 2
- Views: 20034
Backup to standby cluster
Hi, I have successfully performed a backup locally on my live cluster by creating a snapshot and subsequent incrementals and this works fine. I now want to back up the same database to a standby cluster in my secondary data centre so I have created this ini file : -----------------------------------...
- Wed Aug 01, 2012 9:21 am
- Forum: Vertica Database Administration
- Topic: Read Only User
- Replies: 3
- Views: 13345
Re: Read Only User
Thanks Jim,
That's great.
Is there not a way to grant the select option to a role and then grant that role to the users?
That's great.
Is there not a way to grant the select option to a role and then grant that role to the users?
- Thu Jul 26, 2012 10:18 am
- Forum: Vertica Database Administration
- Topic: Read Only User
- Replies: 3
- Views: 13345
Read Only User
How do you create a read only user??
I would like to create a user that can select from a schema but not update or delete it.
Thanks
I would like to create a user that can select from a schema but not update or delete it.
Thanks