Search found 1759 matches

by JimKnicely
Sun Sep 24, 2017 3:21 pm
Forum: General
Topic: Delete Vectors
Replies: 1
Views: 20

Re: Delete Vectors

Hi Monica, Nice to meet you too! There will be 1 delete vector for each projection... Example: dbadmin=> select count(*) from test2; count -------- 100000 (1 row) dbadmin=> select count(distinct projection_basename) from projections where anchor_table_name = 'test2'; count ------- 2 (1 row) dbadmin=...
by JimKnicely
Fri Sep 15, 2017 5:00 pm
Forum: Vertica Links
Topic: Under the Hood of Vertica: Machine Learning and Streaming Data Analytics
Replies: 0
Views: 47

Under the Hood of Vertica: Machine Learning and Streaming Data Analytics

Take a deep dive into Vertica’s integration with Apache Spark, an in-memory data processing engine.

See: https://www.brighttalk.com/webcast/8913 ... -analytics
by JimKnicely
Thu Sep 14, 2017 2:35 pm
Forum: Vertica Links
Topic: Vertica Presentation at the db tech showcase Tokyo 2017
Replies: 0
Views: 32

Vertica Presentation at the db tech showcase Tokyo 2017

On September 5th, Kanako Obayashi from the Vertica Best Practices team presented at the db tech showcase Tokyo 2017, one of the largest database events in Japan. Kanako’s presentation was about Vertica advanced analytics, including machine learning and geospatial analysis. More than 50 people attend...
by JimKnicely
Tue Sep 05, 2017 1:16 pm
Forum: dbVisualizer
Topic: i want to delete the duplicate rows in s table based on few columns, with out using temp table
Replies: 1
Views: 95

Re: i want to delete the duplicate rows in s table based on few columns, with out using temp table

Hi, Here is one way: dbadmin=> select * from test; c1 | c2 | c3 | c4 ----+----+----+-------- 1 | 1 | 1 | TEST1 1 | 1 | 1 | TEST2 1 | 1 | 2 | TEST3 1 | 1 | 2 | TEST5 1 | 1 | 3 | TEST10 (5 rows) dbadmin=> delete from test where hash(c1, c2, c3, c4) not in (select hash(c1, c2, c3, c4) from test limit 1...
by JimKnicely
Thu Aug 10, 2017 2:41 pm
Forum: Vertica Links
Topic: AIM lists top 7 reasons HPE Vertica 8 is a good fit for every organization
Replies: 0
Views: 128

AIM lists top 7 reasons HPE Vertica 8 is a good fit for every organization

Analytics India Magazine, recently listed the top 7 reasons that make HPE Vertica 8 a good fit for every organization. Delving into why HPE Vertica 8 is the best fit for businesses to create an analytics-driven enterprise, we couldn't agree more!

Read about it here:
https://t.co/ATNojWVbvQ
by JimKnicely
Thu Aug 10, 2017 2:32 pm
Forum: Vertica Links
Topic: What’s New in Vertica 8.1.1: Backup to Amazon S3 - Blog Post
Replies: 0
Views: 80

What’s New in Vertica 8.1.1: Backup to Amazon S3 - Blog Post

Posted on Thursday, August 3rd, 2017 at 1:32 pm. Written by James As more businesses move their infrastructure from on-premises solutions to cloud-based and hybrid environments, Vertica has kept pace. In version 8.1.1, Vertica introduced support for backup and restore to and from Amazon’s Simple Sta...
by JimKnicely
Thu Aug 10, 2017 2:30 pm
Forum: Vertica Links
Topic: Geospatial Analysis on Shapefile of Longitude and Latitude Data Using Vertica: Hurricane Bonnie - Blog Post
Replies: 0
Views: 101

Geospatial Analysis on Shapefile of Longitude and Latitude Data Using Vertica: Hurricane Bonnie - Blog Post

Posted on Monday, August 7th, 2017 at 1:51 pm. This blog post was authored by Ginger Ni . Like any natural disaster, hurricanes can leave behind extensive damage to life and property. The question asked by NGOs, government agencies, and insurance companies is, “How can we predict the locations where...

Go to advanced search