Vertica Tips, Lessons and Examples

Moderator: NorbertKrupa

New Topic

71 topics

Topics

Replies

Views

Last post

Hide vsql password

Last post by JimKnicely « Fri Oct 16, 2015 6:45 pm
Replies: 1
by ajay.kapur » Thu Oct 15, 2015 5:31 pm

1 Replies

54715 Views

Last post by JimKnicely
Fri Oct 16, 2015 6:45 pm
Row-Column transpose pivotted on one column

Last post by Abhijat Chowdhary « Wed May 20, 2015 10:53 am

by Abhijat Chowdhary » Wed May 20, 2015 10:53 am

0 Replies

16523 Views

Last post by Abhijat Chowdhary
Wed May 20, 2015 10:53 am
The LONG VARCHAR data type

Last post by padme « Thu Apr 23, 2015 6:27 am
Replies: 2
by JimKnicely » Thu Jan 09, 2014 8:27 pm

2 Replies

20923 Views

Last post by padme
Thu Apr 23, 2015 6:27 am
Vertica AWR Type Module

Last post by JimKnicely « Tue Jan 27, 2015 2:55 pm
Replies: 1
by Aastha » Sun Jan 25, 2015 6:39 pm

1 Replies

13550 Views

Last post by JimKnicely
Tue Jan 27, 2015 2:55 pm
\z meta-command in vsql

Last post by JimKnicely « Mon Apr 28, 2014 4:07 pm

by JimKnicely » Mon Apr 28, 2014 4:07 pm

0 Replies

12584 Views

Last post by JimKnicely
Mon Apr 28, 2014 4:07 pm
Reviewing EE profiling data when you didn't enable profiling

Last post by NorbertKrupa « Fri Mar 21, 2014 11:38 pm
Replies: 3
by scutter » Fri Mar 21, 2014 8:58 pm

3 Replies

18979 Views

Last post by NorbertKrupa
Fri Mar 21, 2014 11:38 pm
Estimating Size of a table

Last post by JimKnicely « Mon Jan 27, 2014 8:08 pm
Replies: 6
by nnani » Fri Sep 20, 2013 8:09 am

6 Replies

28212 Views

Last post by JimKnicely
Mon Jan 27, 2014 8:08 pm
Export query result from Vertica to R

Last post by sdorich « Thu Jan 09, 2014 8:33 pm

by sdorich » Thu Jan 09, 2014 8:33 pm

0 Replies

12440 Views

Last post by sdorich
Thu Jan 09, 2014 8:33 pm
Other Vertica Example Database

Last post by nnani « Tue Oct 22, 2013 9:46 am
Replies: 4
by mrian » Wed Oct 16, 2013 11:47 am

4 Replies

19760 Views

Last post by nnani
Tue Oct 22, 2013 9:46 am
Each session has its own sequence cache on each Vertica node

Last post by JimKnicely « Wed Oct 16, 2013 3:50 pm

by JimKnicely » Wed Oct 16, 2013 3:50 pm

0 Replies

12501 Views

Last post by JimKnicely
Wed Oct 16, 2013 3:50 pm
Converting Columns to Rows

Last post by id10t « Fri Oct 04, 2013 2:55 pm
Replies: 1
by JimKnicely » Fri Feb 15, 2013 5:42 pm

1 Replies

22768 Views

Last post by id10t
Fri Oct 04, 2013 2:55 pm
Accurate Projection Row Count

Last post by JimKnicely « Wed Sep 18, 2013 7:12 pm
Replies: 5
by JimKnicely » Tue Sep 17, 2013 5:49 pm

5 Replies

21016 Views

Last post by JimKnicely
Wed Sep 18, 2013 7:12 pm
External Proc to Allow Non-Owning Users to Truncate Tables

Last post by nnani « Wed Sep 11, 2013 9:35 am
Replies: 1
by JimKnicely » Tue Sep 10, 2013 7:50 pm

1 Replies

17858 Views

Last post by nnani
Wed Sep 11, 2013 9:35 am
Partition Swapping

Last post by billykopecki « Thu Jun 13, 2013 1:34 pm
Replies: 2
by doug_harmon » Wed Jun 12, 2013 10:41 pm

2 Replies

21780 Views

Last post by billykopecki
Thu Jun 13, 2013 1:34 pm
No Super projection found !!!

Last post by scutter « Thu May 30, 2013 1:59 am
Replies: 1
by abeeshdreams » Wed May 29, 2013 7:08 am

1 Replies

14645 Views

Last post by scutter
Thu May 30, 2013 1:59 am
USER Storage Location Types

Last post by JimKnicely « Wed Apr 17, 2013 5:00 pm

by JimKnicely » Wed Apr 17, 2013 5:00 pm

0 Replies

13111 Views

Last post by JimKnicely
Wed Apr 17, 2013 5:00 pm
Multi-Record Insert Statement

Last post by JimKnicely « Tue Apr 16, 2013 9:06 pm

by JimKnicely » Tue Apr 16, 2013 9:06 pm

0 Replies

17172 Views

Last post by JimKnicely
Tue Apr 16, 2013 9:06 pm
Combining Top and Bottom Limits

Last post by JimKnicely « Mon Apr 15, 2013 6:07 pm

by JimKnicely » Mon Apr 15, 2013 6:07 pm

0 Replies

14310 Views

Last post by JimKnicely
Mon Apr 15, 2013 6:07 pm
Storage Policies in Vertica 6.1 and Beyond

Last post by zvika « Sat Apr 13, 2013 1:40 pm
Replies: 1
by JimKnicely » Fri Apr 12, 2013 12:15 pm

1 Replies

17473 Views

Last post by zvika
Sat Apr 13, 2013 1:40 pm
Simulating DML Operations on External Tables

Last post by JimKnicely « Wed Apr 10, 2013 1:09 pm

by JimKnicely » Wed Apr 10, 2013 1:09 pm

0 Replies

13990 Views

Last post by JimKnicely
Wed Apr 10, 2013 1:09 pm
Rotating Column Data Using Analytics

Last post by JimKnicely « Mon Apr 08, 2013 4:05 pm

by JimKnicely » Mon Apr 08, 2013 4:05 pm

0 Replies

13686 Views

Last post by JimKnicely
Mon Apr 08, 2013 4:05 pm
Vertica 6.1 supports INTERSECT, MINUS and EXCEPT

Last post by JimKnicely « Mon Apr 08, 2013 2:29 pm
Replies: 4
by JimKnicely » Wed Dec 12, 2012 4:45 pm

4 Replies

22890 Views

Last post by JimKnicely
Mon Apr 08, 2013 2:29 pm
Converting to a Julian Date and Back Again!

Last post by JimKnicely « Fri Mar 22, 2013 4:27 pm

by JimKnicely » Fri Mar 22, 2013 4:27 pm

0 Replies

15700 Views

Last post by JimKnicely
Fri Mar 22, 2013 4:27 pm
CONCAT and NULL

Last post by JimKnicely « Tue Mar 19, 2013 4:06 pm

by JimKnicely » Tue Mar 19, 2013 4:06 pm

0 Replies

15187 Views

Last post by JimKnicely
Tue Mar 19, 2013 4:06 pm
Generate a Random String

Last post by JimKnicely « Sat Mar 16, 2013 5:51 pm
Replies: 1
by JimKnicely » Fri Mar 15, 2013 8:43 pm

1 Replies

16828 Views

Last post by JimKnicely
Sat Mar 16, 2013 5:51 pm

New Topic

71 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