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

48359 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

18262 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

15391 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

15586 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

20762 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

16369 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

13405 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

17369 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

16334 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

13691 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

16142 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

16630 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

14409 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

14626 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

12152 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

23992 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

20122 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

12202 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

46581 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

10884 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

15178 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

15799 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

19272 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

17337 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

15012 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