Search found 54 matches

by fsalvelt
Tue Oct 08, 2013 8:10 pm
Forum: New to Vertica SQL
Topic: Missing data using "between" with dates
Replies: 4
Views: 13818

Missing data using "between" with dates

Hello, I am experiencing a problem with a date query using the "between" operator. The following query does not return rows where a_date is on December 31, 2012: select * from a_table where a_date is between '01-DEC-12' and '31-DEC-12'; If I change '31-DEC-12' to '01-JAN-13' I can get the data for '...
by fsalvelt
Mon Sep 02, 2013 11:05 am
Forum: Vertica Backup & Recovery
Topic: How do I clear the DATABASE_BACKUPS table?
Replies: 2
Views: 7266

Re: How do I clear the DATABASE_BACKUPS table?

Thanks, yes I did all of that. Is there a work around to clear the DATABASE_BACKUPS table?
by fsalvelt
Fri Aug 30, 2013 4:02 pm
Forum: Vertica Backup & Recovery
Topic: How do I clear the DATABASE_BACKUPS table?
Replies: 2
Views: 7266

How do I clear the DATABASE_BACKUPS table?

Hi,

Even after I delete all of the backup files from disk, I can't get rid of the backup data that is in the DATABASE_BACKUPS directory. How do I clear this table?

Thanks
by fsalvelt
Thu Jul 11, 2013 4:05 pm
Forum: Vertica Links
Topic: HP ASE – Vertica Big Data Solutions Administrator V1
Replies: 2
Views: 6116

Re: HP ASE – Vertica Big Data Solutions Administrator V1

What are the requirements? Is it just the exam?
by fsalvelt
Mon Jun 24, 2013 2:27 pm
Forum: Vertica and the Operating System
Topic: Eliminating the ssh client timeout
Replies: 1
Views: 17468

Eliminating the ssh client timeout

Hi guys,

I am connecting to my Vertica Linux host via putty in Windows. Is there a way in Linux I can eliminate the inactivity timeout period? Or at least set it to something longer?

Thank you!
by fsalvelt
Tue Apr 30, 2013 3:28 pm
Forum: Vertica Installation
Topic: Can we use ARM Processor Based Hardware?
Replies: 3
Views: 7622

Can we use ARM Processor Based Hardware?

Hey,

Is it possible to install Vertica on a ARM distribution of Debian Linux?

Thanks!
by fsalvelt
Tue Apr 09, 2013 2:06 pm
Forum: Vertica Migration
Topic: Migrating data from sysbase to vertica
Replies: 1
Views: 15324

Re: Migrating data from sysbase to vertica

Hi,

Do you mean Sybase? If so, I don't think you can directly connect Vertica to Sybase. You'll probably have to use the Sybase bcp utility to copy data from your tables to operating system files. Then you can use the Vertica COPY command to load the data into Vertica.

Go to advanced search