Search found 54 matches
- 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 '...
- 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?
- 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
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
- 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?
- 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!
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!
- 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!
Is it possible to install Vertica on a ARM distribution of Debian Linux?
Thanks!
- 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.
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.