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

63967 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

20528 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

25447 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

17285 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

15867 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

24715 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

34109 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

15829 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

24542 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

15753 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

27667 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

25755 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

22087 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

27919 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

18375 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

16406 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

20869 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

18856 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

22353 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

17922 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

17375 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

28551 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

19643 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

18652 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

21199 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