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?
Search found 527 matches
- Tue Mar 08, 2016 11:23 pm
- Forum: General
- Topic: Average Record Length
- Replies: 2
- Views: 6537
- 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: 10321
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...
- Sat Mar 05, 2016 6:15 pm
- Forum: Vertica SQL on Hadoop
- Topic: Vertica UDx's and SQL on Hadoop?
- Replies: 1
- Views: 45314
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.
- Fri Mar 04, 2016 1:42 pm
- Forum: General
- Topic: HPE Big Data Presales Technical Consultant (Job Posting)
- Replies: 2
- Views: 6219
Re: HPE Big Data Presales Technical Consultant (Job Posting)
Will you take me back?
- Tue Mar 01, 2016 10:30 pm
- Forum: Vertica Certification
- Topic: HP2-N36 Certification Dump
- Replies: 4
- Views: 26913
Re: HP2-N36 Certification Dump
Do you always have other people do work for you? Why not study it and earn it?
- Fri Feb 26, 2016 4:56 pm
- Forum: Vertica SQL
- Topic: Mass quering from SQL files (or DB)
- Replies: 3
- Views: 17392
Re: Mass quering from SQL files (or DB)
How about creating cascading resource pools? You can cascade slow running queries into slower resource pools.
- Thu Feb 25, 2016 4:08 pm
- Forum: Vertica Certification
- Topic: HP2-N36 Certification Dump
- Replies: 4
- Views: 26913
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...