Search found 106 matches
- Mon Nov 17, 2014 1:56 pm
- Forum: Vertica Data Load
- Topic: Loading 7-zip compressed files
- Replies: 3
- Views: 17866
Loading 7-zip compressed files
Does anyone know if Vertica can load 7-zip compressed files with the COPY command?
- Fri Nov 07, 2014 7:54 pm
- Forum: New to Vertica Database Administration
- Topic: Referencing a global temp with same name as local temp table
- Replies: 2
- Views: 6411
Re: Referencing a global temp with same name as local temp t
Great explanation, Jim! Thanks for your help
- Tue Nov 04, 2014 4:39 pm
- Forum: New to Vertica Database Administration
- Topic: Referencing a global temp with same name as local temp table
- Replies: 2
- Views: 6411
Referencing a global temp with same name as local temp table
Hello, If I create a global and local temp with the same name, when I query the table name I get the local temp table. dbadmin=> create global temp table temp_table (g_a int); CREATE TABLE dbadmin=> create local temp table temp_table (l_a int); CREATE TABLE dbadmin=> select * from temp_table; l_a --...
- Wed Oct 01, 2014 12:47 pm
- Forum: New to Vertica Database Administration
- Topic: What is the smallest data type for a flag indicator?
- Replies: 3
- Views: 7360
What is the smallest data type for a flag indicator?
Hi all,
Which data type in Vertica is best for a flag type value (i.e. on or off/true or false/yes or no) in a table? I was thinking Boolean.
Thank you
Which data type in Vertica is best for a flag type value (i.e. on or off/true or false/yes or no) in a table? I was thinking Boolean.
Thank you
- Thu Sep 04, 2014 11:28 am
- Forum: Vertica Backup & Recovery
- Topic: How do I verify backups are ok?
- Replies: 1
- Views: 13644
How do I verify backups are ok?
Hi all,
Is there a command I can run to verify that my backups are okay? I run incremental backups nightly and want to make sure I'll be able to restore from them!
Thanks!
Is there a command I can run to verify that my backups are okay? I run incremental backups nightly and want to make sure I'll be able to restore from them!
Thanks!
- Fri Aug 08, 2014 1:41 pm
- Forum: New to Vertica Database Administration
- Topic: Once a file is written to disk, it is never written to again
- Replies: 2
- Views: 7264
Once a file is written to disk, it is never written to again
Hello,
Can someone explain to me what is meant by the statement "Once a file is written to disk, it is never written to again" in regard to ROS files? So are the files there forever?
I confused by this.
Can someone explain to me what is meant by the statement "Once a file is written to disk, it is never written to again" in regard to ROS files? So are the files there forever?
I confused by this.
- Tue Jul 08, 2014 1:38 pm
- Forum: New to Vertica
- Topic: Using SEQUENCE or IDENTITY as table column auto increment
- Replies: 1
- Views: 5709
Using SEQUENCE or IDENTITY as table column auto increment
I am curious about what others feel is the best solution for an auto incrementing column in a table. Is it better to use an identity or a sequence? Sequence: dbadmin=> create sequence my_seq; CREATE SEQUENCE dbadmin=> create table test (t int not null default my_seq.nextval, t1 varchar(10)); CREATE ...