In Part 1 of the series, we covered in detail how the PQ_DISTRIBUTE can change the data distribution method across parallel query workers and the importance of avoiding BUFFERED hash joins. Through the remaining parts of the series, I showed…

Recently I spent some time trying to migrate root partition to another FS type in an OVM environment. The target was to migrate root partition from btrfs to ext4. Here is a short outline of how it was done. 1….

Co-Author: Rafael Alvarez When you look up the word idempotence in wikipedia you get the following definition: Idempotence is the property of certain operations in mathematics and computer science whereby they can be applied multiple times without changing the result beyond the…

I recently joined Chris Presley for his podcast, Cloudscape, to talk about what’s happening in the world of cloud-related matters. My focus was to share the most recent events surrounding Amazon Web Services (AWS). Topics of discussion included: Registration is…

I’ve written previously about “Oracle Live SQL”, a free service from Oracle where you can try your coding skills and learn using its vast code library. Today I want to mention one of its other features which may not be…

Machine learning algorithms help to identify hidden insights in data without needing explicit, complicated programmes. Machine learning uses algorithms which learn from previous data to help produce reliable and repeatable decisions. It’s important to know the iterative aspect of machine learning, as…

I recently joined Chris Presley for his podcast, Cloudscape, to talk about what’s happening in the world of cloud-related matters. I shared the most recent events surrounding Microsoft Azure. Topics of discussion included: Business Critical service tier in Azure SQL…

Welcome back to the Cloudscape Podcast! In this month’s edition, we are joined by Greg Baker who will discuss the latest from Amazon and Kartick Sekar who will discuss the latest from Google. Warner Chaves will have his own Microsoft…

Some clients have asked us to change the number of num_tokens as their requirement changes. For example lower number of num_tokens are recommended is using DSE search etc.. The most important thing during this process is that the cluster stays…

Toronto, Canada – Google Cloud Summit Oct 4, 2018,  Pythian, a global IT company that helps businesses leverage disruptive data technologies to better compete, announced today that it has achieved the Machine Learning Partner Specialization in the Google Cloud Partner…