Vertica Data Load

Moderator: NorbertKrupa

New Topic

80 topics

Topics

Replies

Views

Last post

Loading data via COPY to a table without ksafty.

Last post by fane89 « Thu Aug 03, 2017 10:16 am
Replies: 4
by fane89 » Tue Jul 25, 2017 9:38 am

4 Replies

80089 Views

Last post by fane89
Thu Aug 03, 2017 10:16 am
Parse Json from Vertica VARCHAR column

Last post by Harshitha « Thu Jun 29, 2017 7:44 pm
Replies: 3
by _pj_ » Wed Mar 29, 2017 1:33 pm

3 Replies

32020 Views

Last post by Harshitha
Thu Jun 29, 2017 7:44 pm
Exporting Vertica tables to S3

Last post by JimKnicely « Sat Mar 04, 2017 4:05 am
Replies: 3
by Beg1nner » Fri Feb 24, 2017 3:24 pm

3 Replies

27676 Views

Last post by JimKnicely
Sat Mar 04, 2017 4:05 am
Loading sorted data in vertica

Last post by JimKnicely « Wed Sep 21, 2016 4:23 pm
Replies: 1
by dhaneshp » Sat Jul 16, 2016 6:56 pm

1 Replies

21901 Views

Last post by JimKnicely
Wed Sep 21, 2016 4:23 pm
Copying column which has both , and "

Last post by NorbertKrupa « Mon May 23, 2016 3:05 am
Replies: 6
by Beg1nner » Thu Aug 13, 2015 9:38 pm

6 Replies

34248 Views

Last post by NorbertKrupa
Mon May 23, 2016 3:05 am
Loading 7-zip compressed files

Last post by NorbertKrupa « Mon May 23, 2016 3:02 am
Replies: 3
by Josh » Mon Nov 17, 2014 1:56 pm

3 Replies

24048 Views

Last post by NorbertKrupa
Mon May 23, 2016 3:02 am
Changing datetime pattern in Vertica COPY

Last post by JimKnicely « Mon Mar 21, 2016 8:48 pm
Replies: 1
by Beg1nner » Mon Mar 21, 2016 7:34 pm

1 Replies

20622 Views

Last post by JimKnicely
Mon Mar 21, 2016 8:48 pm
Enabled Primary Key not reinforced in 7.2

Last post by JimKnicely « Mon Feb 29, 2016 4:22 pm
Replies: 3
by EmmanuelB » Wed Dec 09, 2015 11:34 am

3 Replies

27212 Views

Last post by JimKnicely
Mon Feb 29, 2016 4:22 pm
COPY command NULL option question...

Last post by bud « Sat Jan 09, 2016 8:45 pm
Replies: 2
by bud » Mon Jan 04, 2016 6:59 pm

2 Replies

24886 Views

Last post by bud
Sat Jan 09, 2016 8:45 pm
negative partition_key in partitions table?

Last post by NorbertKrupa « Wed Dec 23, 2015 4:30 am
Replies: 1
by kalensk » Wed Dec 23, 2015 3:01 am

1 Replies

19995 Views

Last post by NorbertKrupa
Wed Dec 23, 2015 4:30 am
Loading data ending with \

Last post by JimKnicely « Wed Sep 23, 2015 4:51 pm
Replies: 1
by Beg1nner » Tue Sep 22, 2015 7:28 pm

1 Replies

23859 Views

Last post by JimKnicely
Wed Sep 23, 2015 4:51 pm
COPY vs. LCOPY

Last post by NorbertKrupa « Wed Jun 17, 2015 4:17 am
Replies: 2
by Josh » Tue Mar 27, 2012 7:38 pm

2 Replies

24169 Views

Last post by NorbertKrupa
Wed Jun 17, 2015 4:17 am
Can Vertica Flex handle a 3000 column table with 300 char column names?

Last post by NorbertKrupa « Tue May 26, 2015 6:28 pm
Replies: 2
by maizer » Thu May 21, 2015 9:11 pm

2 Replies

23742 Views

Last post by NorbertKrupa
Tue May 26, 2015 6:28 pm
Loading data from S3 bucket into Vertica DB

Last post by Vertica_grm « Wed May 06, 2015 9:38 pm
Replies: 2
by Vertica_grm » Tue May 05, 2015 9:46 pm

2 Replies

22257 Views

Last post by Vertica_grm
Wed May 06, 2015 9:38 pm
Loading UCS – 2 Little Endian to Vertica

Last post by NorbertKrupa « Thu Apr 23, 2015 4:09 am
Replies: 1
by Vertica_grm » Wed Apr 22, 2015 9:14 pm

1 Replies

17935 Views

Last post by NorbertKrupa
Thu Apr 23, 2015 4:09 am
Copy .tsv file into a table.

Last post by Vertica_grm « Wed Apr 22, 2015 3:30 pm
Replies: 6
by Vertica_grm » Tue Apr 21, 2015 8:41 pm

6 Replies

37179 Views

Last post by Vertica_grm
Wed Apr 22, 2015 3:30 pm
Data in WOS

Last post by NorbertKrupa « Tue Mar 10, 2015 6:44 pm
Replies: 6
by vigneshn » Sat Mar 07, 2015 3:08 pm

6 Replies

29963 Views

Last post by NorbertKrupa
Tue Mar 10, 2015 6:44 pm
What Happens when using Direct Option in Copy , Insert, Update Command

Last post by JimKnicely « Sun Mar 08, 2015 5:08 pm
Replies: 1
by vigneshn » Sat Mar 07, 2015 3:02 pm

1 Replies

18342 Views

Last post by JimKnicely
Sun Mar 08, 2015 5:08 pm
Copy Rejected Data

Last post by Benjamin_e « Mon Dec 01, 2014 4:04 pm
Replies: 17
by ClevelandSteve » Fri Jun 20, 2014 2:53 pm
1

2

3
17 Replies

70646 Views

Last post by Benjamin_e
Mon Dec 01, 2014 4:04 pm
Can I tune a COPY statement that uses the AUTO option?

Last post by Brett « Mon Dec 01, 2014 3:35 am

by Brett » Mon Dec 01, 2014 3:35 am

0 Replies

16465 Views

Last post by Brett
Mon Dec 01, 2014 3:35 am
2.2 GB of inserts.sql How to insert them.

Last post by Benjamin_e « Wed Nov 26, 2014 7:06 am
Replies: 3
by Benjamin_e » Tue Nov 25, 2014 11:46 pm

3 Replies

24258 Views

Last post by Benjamin_e
Wed Nov 26, 2014 7:06 am
How to ignore '\N' in some fields from csv file?

Last post by Benjamin_e « Mon Nov 24, 2014 9:43 am
Replies: 3
by Benjamin_e » Sun Nov 23, 2014 4:30 pm

3 Replies

24973 Views

Last post by Benjamin_e
Mon Nov 24, 2014 9:43 am
LOAD_STREAMS table sorted = unsorted ?

Last post by scutter « Wed Sep 24, 2014 2:53 pm
Replies: 6
by Julie » Mon Sep 22, 2014 6:58 pm

6 Replies

31167 Views

Last post by scutter
Wed Sep 24, 2014 2:53 pm
Need to use DEFAULT keyword in data file for COPY command

Last post by NorbertKrupa « Fri Aug 22, 2014 5:20 pm
Replies: 4
by beth » Thu Aug 21, 2014 7:56 pm

4 Replies

26997 Views

Last post by NorbertKrupa
Fri Aug 22, 2014 5:20 pm
Text DataType in Vertica

Last post by NorbertKrupa « Tue Jul 29, 2014 4:09 am
Replies: 1
by ayush068 » Mon Jul 28, 2014 8:09 pm

1 Replies

21401 Views

Last post by NorbertKrupa
Tue Jul 29, 2014 4:09 am

New Topic

80 topics

Return to Board Index

Forum permissions

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum