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

71035 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

21467 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

26401 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

18061 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

16435 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

25568 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

35719 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

16444 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

25576 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

16328 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

28349 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

26653 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

23098 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

29217 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

19224 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

16971 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

21689 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

19458 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

23055 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

18514 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

17993 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

30143 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

20227 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

20451 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

22233 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