For detailed information about “Dynamic Partitions” please click here. In this lesson, we’ll see how to create the dynamic partition. Consider the below data for
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.
Static Partitions in Hive
For detailed information about “Static Partitions” please click here. In this lesson, we’ll see how to create the static partition. Consider the below data for
Partitioning in Apache Hive
Data in Apache Hive is classified as Table, Partition, or Bucket. Hadoop is often designed to handle massive datasets, thus tables will contain massive amounts
Apache Hive – New Columns in Output
In Apache Hive, in addition to choosing existing columns from a table, it is possible to generate new columns in the query output depending on
Get Hive Username & Password
The parameters and basic settings are often stored in the config files of most programs. Parameters or settings might be user credentials, user preferences, or
Connecting Hive with BEELINE
This post will explain how to connect to Beeline as well as how to connect Hive from Beeline. Simply type “beeline” into the terminal window
Big Data & SQL 