This post will show you how to check the table’s creation date in Apache Hive. SQL developers will look for such information in system tables
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.
Using Avro Schema URL in Apache Hive
Please visit my previous article for an introduction and detailed information regarding Apache Avro and its use in Apache Hive. This is a follow-up to
SQL Server – Altering IDENTITY Values
When a new record is added to a table, SQL Server generates a unique number using the IDENTITY keyword. This is the primary key field
Using Apache Avro in Apache Hive
Avro is a serialization system developed by Apache. It is a row-based storage format. Avro contains the data definition as well as the data in
Starting Hosts and Roles in Cloudera VM
Long ago, while I was running Cloudera VM 5.10.0.0, I thought to download the most recent version (of that time) to see what modifications or
Alternative to “UNION” in Apache Hive
The UNION operator is one of the most often used SQL operators. This function combines the results of two or more SELECT queries and returns
Big Data & SQL 