Search found 1778 matches

by JimKnicely
Thu Dec 07, 2017 3:17 pm
Forum: Vertica Links
Topic: Phrase Search with Vertica Text Search
Replies: 0
Views: 97

Phrase Search with Vertica Text Search

Vertica already provides Text Search. Text Search allows you to quickly search the contents of a single CHAR, VARCHAR, LONG VARCHAR, VARBINARY, or LONG VARBINARY field within a table to locate a specific token. Vertica implements that capability using a dedicated Text Index to store all the individ...
by JimKnicely
Thu Dec 07, 2017 3:13 pm
Forum: Vertica Links
Topic: Blog Post Series: Using Vertica to Track Commercial Aircraft in near Real-Time
Replies: 0
Views: 59

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

Awesome 3 Part Blog post by Soniya : Project Overview This post presents an overview of an ongoing series that focuses on using Vertica, Raspberry Pi, and Apache Kafka to track commercial aircraft in near-real time. Part 1: https://my.vertica.com/blog/blog-post-series-using-vertica-track-commercial-...
by JimKnicely
Thu Dec 07, 2017 3:06 pm
Forum: Vertica Links
Topic: Flattened Tables - Vertica Blog Post
Replies: 0
Views: 69

Flattened Tables - Vertica Blog Post

Before release 8.1., Vertica users could denormalize their data by combining all fact and dimension table columns in a single ‘fat’ table. These tables facilitated faster query execution. However, this approach required users to maintain redundant sets of normalized and denormalized data, which inc...
by JimKnicely
Fri Nov 17, 2017 5:18 pm
Forum: New to Vertica Database Development
Topic: Increase wait time out period for locked tables
Replies: 4
Views: 3764

Re: Increase wait time out period for locked tables

You can change the Lock Timeout at the SESSION, NODE and DATABASE levels. Examples: dbadmin=> select parameter_name, current_value, default_value from configuration_parameters where parameter_name = 'LockTimeout'; parameter_name | current_value | default_value ----------------+---------------+------...
by JimKnicely
Thu Nov 16, 2017 3:36 pm
Forum: Vertica Links
Topic: What’s New in Vertica 9.0: Sentry Integration
Replies: 0
Views: 97

What’s New in Vertica 9.0: Sentry Integration

Great blog post authored by Mitchell Tracy and Monica Cellio! Hadoop clusters can use authorization services to determine which users can access what data in Hive and, by extension, HDFS. In Vertica 9.0 we now support one of the most common such services, Apache Sentry. Read more here: https://my.ve...
by JimKnicely
Thu Nov 16, 2017 3:33 pm
Forum: Vertica Links
Topic: Data Pipelines: Vertica and Kafka
Replies: 0
Views: 109

Data Pipelines: Vertica and Kafka

New Blog post authored by Tom Wall and Soniya Shah! At Vertica, we want to make it as easy as possible for your Vertica environment to coexist with other tools and technologies. We know that one size does not fit all. Sometimes you need a customized, end-to-end view of your system. Read more: https:...
by JimKnicely
Thu Nov 02, 2017 2:16 pm
Forum: Vertica Links
Topic: Vertica 9.0 and the Google Cloud Platform
Replies: 0
Views: 94

Vertica 9.0 and the Google Cloud Platform

Awesome blog post authored by Lisa Donaghue... In Vertica 9.0, Management Console (MC) provides tools to provision and manage clusters and databases on an AWS environment. You can get started easily with a guided Cluster Creation wizard on AWS. The new Fast Tasks page introduces new users to a few f...

Go to advanced search