Improving Performance and Memory Acquisitions for Vertica Queries

Soniya Shah, Information Developer
March 29, 2018

This blog post was authored by Shrirang Kamat. The following design considerations will help you improve the performance and memory of your Vertica queries. When creating table definitions, you should carefully choose the size of the lookup column based on your data. Properly sizing your column based on your data will help to improve performance....

Vertica Quick Tip: Summary of Cluster State

Soniya Shah, Information Developer
March 29, 2018

This blog post was authored by Jim Knicely. The GET_CLUSTER_STATE_SUMMARY function can be used to quickly view the current status of your Vertica cluster. All nodes are up: One node is down: dbadmin=> SELECT get_cluster_state_summary(); get_cluster_state_summary --------------------------------------------------------------------------------------------------------------------------- Cluster State: test2 UNKNOWN: 1 of 4 (v_test2_node0004) UP: 3 of 4 (v_test2_node0001, v_test2_node0002, v_test2_node0003) (1 row) Have...

Vertica Quick Tip: What’s the Maximum Column Size?

Soniya Shah, Information Developer
March 28, 2018

This blog post was authored by Jim Knicely. There exists a maximum number of characters that can be stored in columns having a data type of VARCHAR or LONG VARCHAR. In case you’ve forgotten those maximum values for the version of Vertica you are using, there are two handy functions that provide this information. To...

Subscribe For Email Updates

Sign-up and select Vertica in your preferences to receive our monthly Vertica newsletter.

Sign-up

Commercial passenger plane with Vertica painted on the tail

Blog Post Series: Using Vertica to Track Commercial Aircraft in near Real-Time – Part 6

Mark Whalley, Manager, Vertica Education
March 27, 2018

Part 6: Extract, Transform and Load ADS-B messages into Kafka I have discussed in previous blog posts the continuous stream of messages from aircraft transponders, captured and decoded using the DUMP1090 application, which we are planning on feeding into a series of Kafka topics, prior to loading into their corresponding tables in a Vertica database....
Three 3D arrows, different colors pointing in different directions

Vertica Quick Tip: Case Insensitive Session Queries

Soniya Shah, Information Developer
March 27, 2018

This blog post was authored by Jim Knicely. By default Vertica is case sensitive when it comes to comparing strings. You can change this behavior by setting the session locale to LEN_S1. Note that you will see a pretty hefty performance hit when using the LEN_S1 locale. A better option would be to store your...

Vertica Quick Tip: Automatically Close an Idle Session

Soniya Shah, Information Developer
March 26, 2018

This blog post was authored by Jim Knicely. The IDLESESSIONTIMEOUT parameter can be used to close a session that has been idle for a period of time. An idle session is one that has no queries running. dbadmin=> \c - jim You are now connected as user "jim". dbadmin=> SELECT current_session(); current_session ------------------------------- v_test2_node0001-3667:0x2a19e (1...

Explore Popular Topics

SQL
DBadmin
Advanced Analytics
machine learning
Best Practices
Cloud
VSQL
Eon Mode
Analytics
Partner Integrations
Vertica
Open Source
AWS
IoT
Time series
Data Gals

What is it like being a girl in a room of many boys?

Soniya Shah, Information Developer
March 26, 2018

This blog post was authored by Crystal Farley (North). I volunteered to be the Chairperson for the virtual chapter of DataGals because I think connecting women across the world is a great way to continue to #PushforProgress. Why not bridge the gap and create a community where we encourage diversity and inclusion of everyone that...
Programmer

How Cisco and Vertica empower high performance analytics for the most demanding workloads

Soniya Shah, Information Developer
March 22, 2018

This blog post was authored by Steve Sarsfield. Hadoop and HDFS is capable of storing massive volumes of data, but performing analytics on Hadoop can be challenging. Despite the apparent low-cost cost of Hadoop, it is best suited for data lake and data science solutions, where the number of concurrent analytical users is low. In...

Vertica Quick Tip: EXPLAIN Plan in JSON Format

Soniya Shah, Information Developer
March 22, 2018

This blog post was authored by Jim Knicely. The EXPLAIN command returns the optimizer's query plan for executing a specified query. ------------------------------ QUERY PLAN DESCRIPTION: ------------------------------ EXPLAIN SELECT the_date FROM big_date_table WHERE the_date_as_date BETWEEN '09-19-2017' AND '09-19-2018'; Access Path: +-STORAGE ACCESS for big_date_table [Cost: 5M, Rows: 25M] (PATH ID: 1) | Projection: public.big_date_table_super | Materialize:...

Projection Delete Concerns

Soniya Shah, Information Developer
March 21, 2018

This blog post was authored by Curtis Bennett. Deletes in Vertica are a complicated topic. I’ve had many people say to me that they’d heard that one should never do deletes in Vertica, or that deletes in Vertica are slow. Nothing could be further from the truth. But like anything in a database, they should...

Vertica Quick Tip: On the Fly Date Dimension

Soniya Shah, Information Developer
March 21, 2018

This blog post was authored by Jim Knicely. The Vertica TIMESERIES Clause is an important component of time series analytics computation. It performs gap filling and interpolation (GFI) to generate time slices missing from the input records. I like to use it to create a dynamic date dimension for my data warehouse. Have Fun!

Vertica Quick Tip: Enable \timing from the vsql Command Line

Soniya Shah, Information Developer
March 20, 2018

This blog post was authored by Jim Knicely. The vsql \timing meta-command reports, in milliseconds, the length of time each SQL statement runs. dbadmin=> SELECT COUNT(*) FROM big_varchar_table WHERE pk BETWEEN 1000000 AND 2000000; COUNT --------- 1000001 (1 row) Time: First fetch (1 row): 179.609 ms. All rows formatted: 179.691 ms You can also enable...