Vertica Blog
Sarah Lemaire smiling

Sarah Lemaire

Manager, Vertica Documentation

Connect With Sarah on

Modern Database Analytics

Single Sign-On for Support: New Login for Passport Users

Sarah Lemaire, Manager, Vertica Documentation
February 27, 2019

As part of the Micro Focus ongoing IT transformation, we have consolidated single sign-on systems to improve your experience of interacting with Micro Focus. All Passport users need to create a new account. To maintain your current access rights, you need to register with the same e-mail address you used with passport. If you use...
Modern Database Analytics

Vertica is Coming to Harvard: Friday, October 12, 2018!

Sarah Lemaire, Manager, Vertica Documentation
October 10, 2018

Vertica is looking for outstanding software engineers and QA engineers. We are hiring full-time employees and summer 2019 interns in our Cambridge, MA and Pittsburgh, PA offices. You’ll have the opportunity to add your innovative ideas to our flagship product, massively scalable database that is used for many of the most challenging Big Data workloads....

Vertica is Coming to Brandeis on October 10!

Sarah Lemaire, Manager, Vertica Documentation
September 16, 2018

Vertica is looking for outstanding software engineers, QA engineers, and technical writers. We are hiring full-time employees and summer 2019 interns in our Cambridge, MA and Pittsburgh, PA offices. You’ll have the opportunity to add your innovative ideas to our flagship product, massively scalable database that is used for many of the most challenging Big...
Modern Database Analytics

Vertica is Coming to Pittsburgh on September 20!

Sarah Lemaire, Manager, Vertica Documentation
September 16, 2018

Vertica is looking for outstanding software engineers, QA engineers, and technical writers. We are hiring full-time employees and summer 2019 interns in our Cambridge, MA and Pittsburgh, PA offices. You’ll have the opportunity to add your innovative ideas to our flagship product, massively scalable database that is used for many of the most challenging Big...
Programmer

Vertica is Coming to UMass-Amherst on September 27!

Sarah Lemaire, Manager, Vertica Documentation
September 16, 2018

Vertica is looking for outstanding software engineers, QA engineers, and technical writers. We are hiring full-time employees and summer 2019 interns in our Cambridge, MA and Pittsburgh, PA offices. You’ll have the opportunity to add your innovative ideas to our flagship product, massively scalable database that is used for many of the most challenging Big...

Vertica is Coming to Brown on September 25!

Sarah Lemaire, Manager, Vertica Documentation
September 16, 2018

Vertica is looking for outstanding software engineers, QA engineers, and technical writers. We are hiring full-time employees and summer 2019 interns in our Cambridge, MA and Pittsburgh, PA offices. You’ll have the opportunity to add your innovative ideas to our flagship product, massively scalable database that is used for many of the most challenging Big...

Converting CHAR and VARCHAR to BINARY or VARBINARY

Sarah Lemaire, Manager, Vertica Documentation
August 16, 2018

Jim Knicely authored this tip. As of Vertica 9.1.1, explicit coercion (casting) from CHAR and VARCHAR data types to either BINARY or VARBINARY data types is supported! Prior to Vertica 9.1.1: dbadmin=> INSERT INTO test_coercion SELECT 'Convert me!'; OUTPUT -------- 1 (1 row) dbadmin=> SELECT c1::VARBINARY FROM test_coercion; ERROR 2366: Cannot cast type varchar to...

Getting Help with Command-Line Tools

Sarah Lemaire, Manager, Vertica Documentation
August 15, 2018

Jim Knicely authored this post. Vertica comes with some nifty command-line tools like vsql, admintools, and vbr. If you need assistance using any of these, you can run them with the –-help parameter to view the options available for each tool. Have fun!

Cascading Schema Ownership

Sarah Lemaire, Manager, Vertica Documentation
August 13, 2018

Jim Knicely authored this tip.</br? Yesterday’s quick tip revealed that as of Vertica 9.1.1, you can transfer the ownership of a schema to another user. But what about the underlying schema objects (i.e., TABLES, VIEWS, etc.)?</br? By default, the ALTER SCHEMA…OWNER TO command does not affect ownership of objects in the target schema or the...
Modern Database Analytics

Change the Owner of a Schema

Sarah Lemaire, Manager, Vertica Documentation
August 13, 2018

Jim Knicely authored this tip. As of Vertica 9.1.1, you can now transfer the ownership of a schema to another user! dbadmin=> CREATE USER etl_user; CREATE USER dbadmin=> ALTER SCHEMA my_etl_schema OWNER TO etl_user; ALTER SCHEMA dbadmin=> SELECT schema_name, schema_owner FROM schemata WHERE schema_name = 'my_etl_schema'; schema_name | schema_owner ---------------+-------------- my_etl_schema | etl_user (1 row)...
Programmer

Find the Number of Days Passed and Remaining in the Relative Year

Sarah Lemaire, Manager, Vertica Documentation
August 9, 2018

Jim Knicely authored this post. Although there aren’t any specific functions that will return the number of days that have passed and that are remaining in a given year, you can combine a few of Vertica’s built-in date functions to find these numbers. You can encapsulate the date logic above into several user-defined functions that...

Referencing Multiple Related LONG VARCHAR Columns

Sarah Lemaire, Manager, Vertica Documentation
August 7, 2018

Jim Knicely authored this post. Table columns having the LONG VARCHAR data type can store up to 32,000,000 octets. Since there is a table row limit size of 32,768,000 bytes, how do I reference more than one related LONG VARCHAR, each having the maximum length? Simple. Use more than one table! dbadmin=> CREATE TABLE test1...