When it comes to verifying the table information, Hive offers two choices for checking its specifics. One is “Extended,” and the other is “Formatted.” Both
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.
Get The Tables List In an external File – Hive
This blog will show you how to retrieve the names of all the tables in the selected database into an external file. To get a
Generate Create Table Statement In Hive
Most RDBMSs include the possibility to build scripts to create objects like as tables, Views, and so on. Hive too has a function that displays
Usage of OVERWRITE in Apache Hive
OVERWRITE is used to replace any existing data in a table or partition with new rows before inserting or loading them. This indicates that OVERWRITE
Loading Multiple FIles in Hive
Loading data from many flat files into an RDBMS is a challenging operation. But in Hive, it won’t take long since Apache Hive is designed
Sub-Queries in Hive – SemanticException [Error 10249]
Hive is supporting “Sub-Queries” functionality since version 0.13, as previously described in “Sub-Queries in Apache Hive.” We also discussed how the query syntax is similar
Big Data & SQL 