Search found 20 matches
- Tue Feb 28, 2017 4:57 pm
- Forum: Vertica Data Load
- Topic: Exporting Vertica tables to S3
- Replies: 3
- Views: 18538
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?
- Fri Feb 24, 2017 3:24 pm
- Forum: Vertica Data Load
- Topic: Exporting Vertica tables to S3
- Replies: 3
- Views: 18538
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?
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?
- Sat Nov 12, 2016 7:49 pm
- Forum: New to Vertica
- Topic: commas and % in the dataset
- Replies: 1
- Views: 17853
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%
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%
- Tue May 17, 2016 5:41 pm
- Forum: Vertica Data Load
- Topic: Copying column which has both , and "
- Replies: 6
- Views: 26384
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.
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.
- Mon Mar 21, 2016 7:34 pm
- Forum: Vertica Data Load
- Topic: Changing datetime pattern in Vertica COPY
- Replies: 1
- Views: 15552
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
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
- Mon Feb 08, 2016 7:48 pm
- Forum: Vertica Database Administration
- Topic: Query_requests table
- Replies: 3
- Views: 16947
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...
- Thu Feb 04, 2016 9:40 pm
- Forum: Vertica Database Administration
- Topic: Query_requests table
- Replies: 3
- Views: 16947
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...