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

70994 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

21447 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

26366 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

18029 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

16416 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

25523 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

35664 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

16424 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

25530 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

16308 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

28329 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

26608 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

23073 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

29188 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

19196 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

16953 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

21674 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

19437 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

23032 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

18498 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

17974 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

30108 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

20210 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

20430 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

22213 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