Search found 106 matches

by Josh
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?
by Josh
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 --...
by Josh
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
by Josh
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!
by Josh
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.
by Josh
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 ...

Go to advanced search