Search found 732 matches
- Sat Jul 25, 2015 4:59 pm
- Forum: New to Vertica SQL
- Topic: Help with Code
- Replies: 16
- Views: 31330
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 ...
- Sat Jul 25, 2015 2:41 pm
- Forum: Vertica SQL
- Topic: Joining and Grouping 2 column set
- Replies: 7
- Views: 14052
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 ...
- Thu Jul 23, 2015 8:49 pm
- Forum: New to Vertica SQL
- Topic: Help with Code
- Replies: 16
- Views: 31330
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 ...
- Thu Jul 23, 2015 9:16 am
- Forum: New to Vertica
- Topic: Vertica performance tuning techniques
- Replies: 1
- Views: 5545
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...
- Wed Jul 22, 2015 8:12 pm
- Forum: Vertica SQL Functions
- Topic: Convert Hex to decimal on table column in vertica
- Replies: 1
- Views: 15387
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...
- Sat Jul 18, 2015 10:23 pm
- Forum: Vertica Installation
- Topic: Installing Patches
- Replies: 6
- Views: 23575
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...
- Fri Jul 17, 2015 4:35 pm
- Forum: Vertica Installation
- Topic: Installing Patches
- Replies: 6
- Views: 23575
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 ...