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

72658 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

22106 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

27171 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

18832 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

17338 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

26276 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

36800 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

17294 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

27650 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

16797 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

30284 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

27375 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

23880 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

29833 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

19784 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

17790 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

22214 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

22887 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

23886 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

19026 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

18750 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

30933 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

20748 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

22308 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

22992 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