Overview:  DataOps shortens the gap between business questions and reliable answers, enabling real-time decisions instead of delayed reports.Core practices ...

Nowadays, working with data is very important in the decision-making process. A large amount of data is generated daily and needs to be stored efficiently. The database system makes it possible to ...

The null or empty string partition value would be translate to __HIVE_DEFAULT_PARTITION__ when writing them out to the filesystem. But it seems that we could not replace those partitions afterwards.

Is your SQL drawing a blank? It’s NULL a surprise! The title of this post is a play on words, but very appropriate. We are going to discuss the inconsistent results, as well as performance ...

If you have requirement to filter records where some columnName is either having value Null or have WhiteSpaces or is Empty, you can use following query: SELECT columnName FROM tableName WHERE ...