Product
- Product Overview
  
  Product Overview
  
  Vertica delivers unified analytics and machine learning at unprecedented speed, scale, and value.
  
  Learn More
- Product
  - Vertica Accelerator,
    Vertica-as-a-Service
    - Vertica SaaS offering
    - Built on and delivers all the functionality of the Vertica Unified Analytics Platform
    - Automated administration and runs in your own AWS account
- second column
  - Vertica Unified Analytics Platform,
    Customer-Managed Software
    - Bring Your Own License (BYOL) analytics software
    - Runs on-premises, hybrid, multi clouds, and containerized
    - Advanced analytics, in database ML, and data lake query engine
- Product Resource
  
  Vertica Announces Vertica 12 for Future-Proof Analytics
  
  Latest version of analytics database enables more deployment flexibility, advanced analytics, and enhanced machine learning
Industries
- Solutions Overview
  
  Featured Use Case:
  Customer Behavior Analytics
  
  Customer centricity is a mission critical initiative across industries. Unify customer data, deliver personalized, omni-channel experiences, and grow and retain your customer base.
  
  Learn More
- Industries
- Industries
- Industries Resource
  
  Harness the Internet of Things (IoT)
  
  IoT data is expected to grow exponentially across industries. Learn how to leverage sensor data at massive scale for business and customer value.
  
  Read On
Support & Services
- Support Resource
  
  Support & Services
  
  Access subscription-based pricing: New customers eligible for a 50% discount.
  
  Act now
- Support Links
- Documentation
- Downloads
Partners
- Partners Overview
  
  Partners
  
  Tight integration with and support from leading technology and solution providers.
  
  Learn More
- Partners
- col 2
  - 3rd Party Technology Partner Integration
  - Quickstarts
- Partners Resource
  
  Vertica Inside – Embedded Analytics at Scale
  
  Seize the huge growth opportunity for OEM software developers
Resources
- Resource Library
  
  Resources
  
  Explore our Thought Leadership library, including the most recent articles, webcasts and reports, with expert insights.
  
  Browse Resources
- Resource Library
  - Blog
  - Case Studies
  - Demos
  - eBooks
  - Infographics
  - Videos
- Webcasts
- What is…analytics and database technology topics
About
- About Vertica
  
  About Vertica
  
  Built for Fast. Built for Freedom.
  
  Learn More
- col 2
  - Careers
  - Contact us
- About Vertica
  - News & Recognition
  - Events
- About Resource
  
  Stay Informed
  
  Sign-up to receive our monthly newsletter.
  
  Subscribe
  
  Latest newsletter
Try Vertica
My Account

Accept the EULA When Installing Vertica

After installing Vertica, you have to ACCEPT the EULA the first time you start admintools on any Vertica node. To avoid having to do that, you can accept the EULA during the install using the –accept-eula or –Y option!

Example:

/opt/vertica/sbin/install_vertica -s 172.16.XX.XXX,172.16.61.XXX,172.16.XX.XXX-T -r vertica-9.2.0-6.x86_64.RHEL6.rpm --license CE --accept-eula

Helpful Links: https://www.vertica.com/docs/latest/HTML/Content/Authoring/InstallationGuide/InstallingVertica/InstallVerticaScript.htm https://www.vertica.com/docs/latest/HTML/Content/Authoring/InstallationGuide/InstallingVertica/InstallingVerticaSilently.htm

Have fun!

About the Author

James Knicely
Vertica Field Chief Technologist

I've had the privilege of working with many database technologies in my career. But after being introduced to Vertica in May of 2011 as a client, I was hooked on the new technology after witnessing a query run in milliseconds that had previously ran for hours on the legacy database we had in place. It was then that I knew I wanted to eventually join the Vertica team, and 4 years later I did! I am currently a Vertica evangelist and am ready to help you get on board! Please feel free to reach out to me with any questions you have about Vertica and make sure to follow my Vertica Quick Tips!

Read More Posts From James
Connect With James on

Quick Tip on a blue enter key on a keyboard

Setting Session Authorization to Troubleshoot

Sruthi Anumula, Senior Database Support Engineer
September 29, 2023

There are possible scenarios in which a dbadmin would want to run queries as another user to troubleshoot or test. You can use SET SESSION AUTHORIZATION to impersonate another user and run queries. Let's understand this with an example. Here we create a user named test, resource pool named userpool, and make this a default...

UNNEST vs EXPLODE Functions

Sruthi Anumula, Senior Database Support Engineer
September 19, 2023

Vertica provides two functions, UNNEST and EXPLODE to expand arrays into one or more rows. These functions offer the same functionality with subtle differences in syntax and output. Let's understand with a simple example. We have 3 array columns in the table. Let us expand 1 array column for a particular order key. Explode provides...

Checklist for Inconsistent Execution Time of Same Query in Eon Mode

Sruthi Anumula, Senior Database Support Engineer
September 6, 2023

In Eon Mode, when a query is executed and if the ROS containers associated to the tables in the query are not present in depot, it will fetch results from the communal storage bucket. In the next immediate run, the query should provide results to the user from the files present in the depot. However,...

Quick Tip on a blue enter key on a keyboard

Using Fallthrough Authentication

Sruthi Anumula, Senior Database Support Engineer
July 21, 2023

Prior to Vertica 12.0.x, if a user failed to log in with a some authentication method, they could not attempt to log in again with some other method. For example, if a user used failed to log in with hash authentication, they could not attempt to log in with LDAP in the same connection attempt....