There was a time when we talked about Apache Hive limits, and the list went on and on, but that’s no longer the case. Apache
Author: SHAFI SHAIK
Hi, this is Shafi Shaik, Microsoft Solutions Specialist in Data platform as well as in Data Management & Analytics. I am a certified associate in Oracle SQL*Plus and extensively trained in MongoDB Administration. My current role is Database administration with hands-on expertise in almost all relational databases namely Microsoft SQL Server, MySQL, Oracle SQL*Plus, PostGreSQL & Teradata. I'm also specialized in database development, warehousing, traditional data analysis and Big Data analysis.
OFFLINE – Offline The Table in Hive
There’s a functionality in Apache Hive that allows you to take the table offline. We won’t be able to query the table because of it.
Apache Hive vs Apache Impala
The following is a comprehensive list of the differences between Apache Hive and Apache Impala. There were many differences, but the majority of them are
NO_DROP – Disable Dropping The Table in Hive
There’s always the possibility of dropping the table by accident. In most RDBMSs, we restore a table and its data if we have a backup
Apache Impala Mathematical Functions
The mathematical functions in Apache Impala come in handy during data analysis, especially when it comes to revenue or monetary calculations. These math functions are
Apache Impala Built-in Functions
It’s a comprehensive collection of Apache Impala’s built-in functions. Most of the functions in this list are described in full in this blog, so you
Big Data & SQL 