Hi!
Is there an autocommit feature at the DB level? Or is this a feature only available with vsql?
Thank you
Search found 49 matches
- Thu Mar 06, 2014 4:51 pm
- Forum: New to Vertica Database Administration
- Topic: Auto Commit at the DB level?
- Replies: 1
- Views: 5298
- Wed Feb 26, 2014 2:07 pm
- Forum: New to Vertica Database Administration
- Topic: DIsplaying Data Types and Sizes of System Tables
- Replies: 1
- Views: 5242
DIsplaying Data Types and Sizes of System Tables
Howdy,
Is there a way that I can see the data types and sizes of the columns in a system table? If I try to export one I get an error:
Is there a way that I can see the data types and sizes of the columns in a system table? If I try to export one I get an error:
Code: Select all
dbadmin=> select export_objects('', 'sessions');
ERROR 2425: Cannot export virtual table sessions
- Wed Feb 19, 2014 1:41 pm
- Forum: New to Vertica Database Administration
- Topic: Get status of a long running insert ...
- Replies: 12
- Views: 26124
Re: Get status of a long running insert ...
Thanks for the great feedback! I am using Vertica 7 by the way... I will try some of the suggestions provided and will post my findings
- Tue Feb 11, 2014 6:12 pm
- Forum: New to Vertica Database Administration
- Topic: Get status of a long running insert ...
- Replies: 12
- Views: 26124
Get status of a long running insert ...
Hi,
Is there a way to find out how many records of a long running insert statements have been inserted? I can't tell if the process is hanging or if its just slow.
Is there a way to find out how many records of a long running insert statements have been inserted? I can't tell if the process is hanging or if its just slow.
- Tue Feb 04, 2014 8:31 pm
- Forum: Vertica Database Administration
- Topic: Are Views being Used?
- Replies: 1
- Views: 4543
Are Views being Used?
Howdy,
Is there some way I can tell if a view is being used? I'd to clean up some views (i.e. drop them) but I don't want to drop any that are be used.
Thanks...
Is there some way I can tell if a view is being used? I'd to clean up some views (i.e. drop them) but I don't want to drop any that are be used.
Thanks...
- Tue Jan 28, 2014 12:30 pm
- Forum: New to Vertica Database Administration
- Topic: How do I copy sequences to a new DB?
- Replies: 1
- Views: 5830
How do I copy sequences to a new DB?
Hi,
How can I copy sequences from one db to another so that they maintain the current values from the original db. If I go the export_objects route, it does not retain the current value of the sequence.
Thank you.
How can I copy sequences from one db to another so that they maintain the current values from the original db. If I go the export_objects route, it does not retain the current value of the sequence.
Thank you.
- Mon Jan 13, 2014 3:00 pm
- Forum: New to Vertica
- Topic: Why run compute_flextable_keys_and_build_view()?
- Replies: 0
- Views: 4075
Why run compute_flextable_keys_and_build_view()?
What does this message mean when I try to select from a flex table I created? dbadmin=> select * from flex_test_view; status ------------------------------------------------------------------------------------------------------------------------------ Please run compute_flextable_keys_and_build_view...