Search found 1758 matches

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: 43

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: 30

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: 93

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...
by JimKnicely
Thu Aug 10, 2017 2:28 pm
Forum: Vertica Links
Topic: View Privileges - Blog Post
Replies: 0
Views: 75

View Privileges - Blog Post

Posted on Tuesday, August 8th, 2017 at 12:38 pm. Written by Soniya This set of examples shows the privileges a user needs for various operations related to views, including creating and querying. A view is a virtual table based on the result set of a SQL statement, also called a SQL query. To select...

Go to advanced search