Search found 20 matches

by Beg1nner
Tue Feb 28, 2017 4:57 pm
Forum: Vertica Data Load
Topic: Exporting Vertica tables to S3
Replies: 3
Views: 6758

Re: Exporting Vertica tables to S3

Yes I did check them out. But we are on Vertica 7.2.1. Other than upgrading and using awslib, is there any better way?
by Beg1nner
Fri Feb 24, 2017 3:24 pm
Forum: Vertica Data Load
Topic: Exporting Vertica tables to S3
Replies: 3
Views: 6758

Exporting Vertica tables to S3

Hi all,

We are using vertica 7.2.1 and we have 50 odd tables in a schema (total data size ~5 TB). What is the best approach you would suggest to move this data into S3?
by Beg1nner
Sat Nov 12, 2016 7:49 pm
Forum: New to Vertica
Topic: commas and % in the dataset
Replies: 1
Views: 6192

commas and % in the dataset

Hi Team,

I have a dataset which contains below items. I have used integer and numeric. But Vertica is rejecting data. What is best option to store such values as integers/float and not varchar?

1,234
54.1%
by Beg1nner
Tue May 17, 2016 5:41 pm
Forum: Vertica Data Load
Topic: Copying column which has both , and "
Replies: 6
Views: 9568

Re: Copying column which has both , and "

How About this?

csv file.

55682,"Bolts, Studs Click",2,Timer
55682,"Bolts”” Studs Click",2,Timer

Enclosed by ‘”’ in copy command, rejects the second row. Removing the Enclosed by ‘”’ in the copy command, rejects the first.
by Beg1nner
Mon Mar 21, 2016 7:34 pm
Forum: Vertica Data Load
Topic: Changing datetime pattern in Vertica COPY
Replies: 1
Views: 6856

Changing datetime pattern in Vertica COPY

My source data has dates in the following manner

YYYYMMDD-HH:MM:SS

In my vertica database, I have created my column as datetime and the load is getting rejected. How should i convert the datetime on the manner accepted by vertica?

YYYY/MM/DD HH:MM:SS
by Beg1nner
Mon Feb 08, 2016 7:48 pm
Forum: Vertica Database Administration
Topic: Query_requests table
Replies: 3
Views: 9241

Re: Query_requests table

Thanks! that was really helpful. I have one follow up question. Is there a limit to the value we can enter in the 'interval' parameter when we are setting time specific limit? If I want table to store 1 year of data could I just enter the below? SELECT SET_DATA_COLLECTOR_TIME_POLICY('OptimizerEvents...
by Beg1nner
Thu Feb 04, 2016 9:40 pm
Forum: Vertica Database Administration
Topic: Query_requests table
Replies: 3
Views: 9241

Query_requests table

We were in the process of monitoring all the queries our users run in our platform. I found vertica logs these in query_requests table. I have some questions on the same. 1> Is there a limit to the amount of data/ how far back that Vertica keeps logs of queries in query_requests table? If yes, can w...

Go to advanced search