One on One with Davin Potts: 4. How You Can Help With Your Favorite Open Source Project Without Being an Expert

At the recent Data Day Texas event, I sat down with Davin Potts and had a long conversation about a wide variety of subjects. I divided the conversation into multiple chunks by subject, and have been posting them one chunk at a time. In the first post, we discussed the wide variety of programming languages and […]

One on One with Davin Potts: 3. Exciting News for Upcoming Python Release 3.8

At the recent Data Day Texas event, I sat down with Davin Potts and had a long conversation about a wide variety of subjects. I divided the conversation into multiple chunks by subject, and have been posting them one chunk at a time. In the first post, we discussed the wide variety of programming languages […]

A Perfect Match – Matrimony.com and Vertica

If you have ever sought a romantic match in India, chances are you have visited Matrimony.com. According to the Times of India, 92% of singles in India seek love on matrimony sites. Matrimony.com’s flagship brand, BharatMatrimony, alone has more than 4,000 associates serving more than three million active members. But, how does Matrimony.com connect singles […]

Open Source Software is Free, Like a Puppy

Open source software has a long and inspiring history. In the very early days of software itself, academic collaboration was the norm. But in the late 70’s and early 80’s, manufacturers increasingly copyrighted their technologies, protected their source code, and required licensed use of software. The era of commercial software was born. Freedom! Richard Stallman […]

Revoke Access to Multiple System Tables from Multiple Users with a New Role

Vertica provides an API (application programming interface) for monitoring various features and functions within a database in the form of system tables. These tables provide a robust, stable set of views that let you monitor information about your system’s resources, background processes, workload, and performance, allowing you to more efficiently profile, diagnose, and view historical […]

Revoke Access From Just One System Table

Vertica provides an API (application programming interface) for monitoring various features and functions within a database in the form of system tables. These tables provide a robust, stable set of views that let you monitor information about your system’s resources, background processes, workload, and performance, allowing you to more efficiently profile, diagnose, and view historical […]

Create a SQL Function to Calculate the nth Root of a Number

Vertica has a built-in function to calculate the arithmetic square root a number called SQRT and another built-in function to calculate the arithmetic cube root of a number called CBRT. Example: dbadmin=> SELECT sqrt(9); sqrt —— 3 (1 row) dbadmin=> SELECT cbrt(27); cbrt —— 3 (1 row) But what if I need a function to […]

Single Sign-On for Support: New Login for Passport Users

As part of the Micro Focus ongoing IT transformation, we have consolidated single sign-on systems to improve your experience of interacting with Micro Focus. All Passport users need to create a new account. To maintain your current access rights, you need to register with the same e-mail address you used with passport. If you use […]

One on One with Davin Potts: 2. Advantages of KNIME and Letting Databases Do What Databases Do Best

At the recent Data Day Texas event, I sat down with Davin Potts and had a long conversation about a wide variety of subjects. I divided the conversation into multiple chunks by subject, and will post them up one subject at a time. In the first post, we discussed the wide variety of programming languages […]

Generate a Murmur Hash

Murmur (Murmerhash) is a modern non-cryptographic hash function that has a low collision rate and high performance. It is suitable for general hash-based lookups, but not suitable for cryptographic use cases. Vertica has a built-in function called HASH. Example: dbadmin=> SELECT murmurhash(‘VERTICA MURMUR Hash!’); murmurhash ——————— 6154089896006532138 (1 row) dbadmin=> SELECT murmurhash(‘The quick brown fox […]