Search found 732 matches

by id10t
Sat Jul 25, 2015 4:59 pm
Forum: New to Vertica SQL
Topic: Help with Code
Replies: 16
Views: 31305

Re: Help with Code

Hi! C’mon folks, let’s be a little bit more supportive. Not everyone has vast experience with more complex SQL. Everyone needs to start somewhere. Sharon, your critics is acceptable. BTW: your solution is awesome. people who live in glass houses shouldn't throw stones one shouldn't criticize others ...
by id10t
Sat Jul 25, 2015 2:41 pm
Forum: Vertica SQL
Topic: Joining and Grouping 2 column set
Replies: 7
Views: 14050

Re: Joining and Grouping 2 column set

Hi! Where is your solution? No challenges here, you always can solve it with "brute force". 1. select all distinct values (you can do it) daniel=> select distinct first as place from t daniel-> union daniel-> select distinct second as place from t; place ------- A B C D (4 rows) 2. count occurrence ...
by id10t
Thu Jul 23, 2015 8:49 pm
Forum: New to Vertica SQL
Topic: Help with Code
Replies: 16
Views: 31305

Re: Help with Code

Hi! IMO: Once I see it how it's done, I'll be able to do myself next time. Worst comment you can give. This comment means: I can do my work with templates only and if there are no templates(tutorials) so I can NOT do it by myself . You are not able to do work without external help, you are not able ...
by id10t
Thu Jul 23, 2015 9:16 am
Forum: New to Vertica
Topic: Vertica performance tuning techniques
Replies: 1
Views: 5542

Re: Vertica performance tuning techniques

Hi! How could i create projections using DBD. Please let me know the detailed steps on this. Surprise 1: Vertica has documentation. Surprise 2: Internet is full in such kind of info For what people writes documentation? <=> Why we should to repost/rewrite/reblog it? Why we should waste out time twic...
by id10t
Wed Jul 22, 2015 8:12 pm
Forum: Vertica SQL Functions
Topic: Convert Hex to decimal on table column in vertica
Replies: 1
Views: 15377

Re: Convert Hex to decimal on table column in vertica

Hi! Can you suggest the best way to achieve this? Can you explain meaning of "best way"? What is it? I don't know. Is it Performance/runtime? Or implementation time? Or complexity? Or price(for proprietary solution)? If you can not define your problem, so you do not understand it. What is your limit...
by id10t
Sat Jul 18, 2015 10:23 pm
Forum: Vertica Installation
Topic: Installing Patches
Replies: 6
Views: 23566

Re: Installing Patches

... to figure out Linux flavour type in terminal: python -c "import platform; print ' '.join(platform.dist())" Snippet determines the name of the Linux OS distribution name. Supported distributions: SuSE debian fedora redhat centos mandrake mandriva rocks slackware yellowdog gentoo UnitedLinux turbo...
by id10t
Fri Jul 17, 2015 4:35 pm
Forum: Vertica Installation
Topic: Installing Patches
Replies: 6
Views: 23566

Re: Installing Patches

Hi! Version XXX.YYY.ZZZ means: XXX - release version YYY - major fix/patch ZZZ - minor fix/patch It is always advised & better to follow recommended upgrade path which is 6.0.zzz >>> 6.1.zzz >>> 6.2.zzz >>> 6.3.zzz >>> ... >>> 7.0.zzz >>> 7.1.zzz >>> 7.2.zzz i.e. upgrade version of major fix to the ...

Go to advanced search