Data Preparation Tools – Technical Brief

Phil Molea, Sr. Information Developer, Vertica
August 20, 2018

Curtis Bennett authored this blog Vertica supports a number of industry standard data preparation tools for use in the data science life-cycle. In addition to the functions described here, Vertica has a wide array of analytic capabilities which can be leveraged for additional data preparations including time-series analytics (with missing value imputation), analytic windowing and...

Master Blog Series: Getting Started with Vertica

Soniya Shah, Information Developer
August 20, 2018

This post was authored by Soniya Shah. Are you a new Vertica user? If so, you're probably wondering where to start. We're here to help you on your big data analytics journey, from understanding Vertica terminology to making the most of your resources. If you find yourself asking questions like What does the Tuple Mover...

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...

Subscribe For Email Updates

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

Sign-up

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!
Vertica and Python logos stacked

vertica-python Becomes Vertica’s First Officially Supported Open Source Database Client

Phil Molea, Sr. Information Developer, Vertica
August 14, 2018

Tom Wall authored this post. We are very excited to announce that vertica-python, the open source python database client for Vertica created by Uber Technologies Inc., will officially become a supported database client for Vertica! This is a great milestone for Vertica and our community of users and developers. Not only do we expect to...

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...

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
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...

Displaying the Current Schema

James Knicely, Vertica Field Chief Technologist
August 8, 2018

Each user session has a search path of schemas. Vertica uses this search path to find tables and user-defined functions (UDFs) that are unqualified by their schema name. You can use the CURRENT_SCHEMA function to display the name of the current schema (i.e., the first “valid” schema in the user’s search path). dbadmin=> SHOW search_path;...

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...
Database Server Room

Generate Random Integers, Including Negative Numbers

Sarah Lemaire, Manager, Vertica Documentation
August 6, 2018

Jim Knicely authored this tip. The RANDOMINT(n) function returns one of the n integers from 0 through n – 1. Those are all positive integers. What if I want to include negative integers? That’s easy with a simple multiplication. dbadmin=> SELECT DECODE(randomint(2), 1, 1, -1) * randomint(11) "Random INT from -10 to 10"; Random INT...

Summarize a Table’s Projections: Quick Tip

Sarah Lemaire, Manager, Vertica Documentation
August 2, 2018

Jim Knicely authored this tip. Use the built-in Vertica function GET_TABLE_PROJECTIONS to quickly summarize the details of all of the projections of a Vertica table. dbadmin=> \t Showing only tuples. dbadmin=> SELECT get_table_projections('public.jim'); Current system K is 1. # of Nodes: 3. Table public.jim has 3 projections. Projection Name: [Segmented] [Seg Cols] [# of Buddies]...