Search found 527 matches

by NorbertKrupa
Tue Mar 08, 2016 11:23 pm
Forum: General
Topic: Average Record Length
Replies: 2
Views: 6489

Re: Average Record Length

What kind of team do you work on that writes the query for you? Have you tried to write one yourself?

Do you want the average length of each column in each table?
Do you want the average row length of each table?
by NorbertKrupa
Tue Mar 08, 2016 1:37 pm
Forum: General
Topic: Vertica joins on Integer or VARCHAR fields , which one is good for performance ?
Replies: 4
Views: 10248

Re: Vertica joins on Integer or VARCHAR fields , which one is good for performance ?

At the machine level, there are instructions which can perform integer comparisons in one cycle and are usually stored in smaller registers. With strings (or VARCHAR) which can be varying lengths, and characters, you have to compare each character of the string as well as NULLs. Since these characte...
by NorbertKrupa
Sat Mar 05, 2016 6:15 pm
Forum: Vertica SQL on Hadoop
Topic: Vertica UDx's and SQL on Hadoop?
Replies: 1
Views: 44006

Re: Vertica UDx's and SQL on Hadoop?

You should be able to. With SOH you get the Vertica package and just install it on your Hadoop nodes.
by NorbertKrupa
Tue Mar 01, 2016 10:30 pm
Forum: Vertica Certification
Topic: HP2-N36 Certification Dump
Replies: 4
Views: 26150

Re: HP2-N36 Certification Dump

Do you always have other people do work for you? Why not study it and earn it?
by NorbertKrupa
Fri Feb 26, 2016 4:56 pm
Forum: Vertica SQL
Topic: Mass quering from SQL files (or DB)
Replies: 3
Views: 16785

Re: Mass quering from SQL files (or DB)

How about creating cascading resource pools? You can cascade slow running queries into slower resource pools.
by NorbertKrupa
Thu Feb 25, 2016 4:08 pm
Forum: Vertica Certification
Topic: HP2-N36 Certification Dump
Replies: 4
Views: 26150

Re: HP2-N36 Certification Dump

There are prep books available for the exams. Please take a look at the prep guide . Please review the exam policies : HP certification content - including questions, answers and diagrams -- are proprietary, confidential and copyrighted HP materials. Any disclosure of the contents of any HP ExpertOn...

Go to advanced search