In this post, I am going to explain how to partition the dataset using two columns.   Suppose, I have below dataset to track the users that are using my website.   userId to… Read More

In this post, I am going to explain an example that cover following data types in Hive.   a.   Array b.   Map c.    Struct   Array: Represent an… Read More

For all the examples, I am going to use below table definition.CREATE TABLE employee (id INT,name STRING,hobbies ARRAYSTRING>,technology_experience MAPSTRING,STRING>,gender_age STRUCTS… Read More

Syntaxcreate table {new_table} like {existing_table}  Step 1: Create table emp which stores employees information. CREATE TABLE emp (id INT,name STRING,hobbies ARRA… Read More

Introduction to Hive insert into As with all other databases, the HIVE, a sequential database, also expects data to be inserted. In the case of HIVE, this insert process can be performed in… Read More

Introduction to Hive Table In the hive, the tables are consisting of columns and rows and store the related data in the table format within the same database. The table is storing the recor… Read More

Introduction to Dynamic Partitioning in Hive Partitioning is an important concept in Hive that partitions the table based on data by a set of rules and patterns. Dynamic partition is a sing… Read More

前言 本文以离线数据仓库为背景，重点介绍因传输链$… Read More

Working in GNU/Linux terminal often includes the processing of outgoing text. One of the most common tools that is used for this is the cut command. It cuts out some text information (file o… Read More

Note from September 4, 2019: We’ve updated this blog post, initially published on January 26, 2016. Major changes include: support of Amazon Linux 2, no longer having to compile Squi… Read More

Introduction to Sqoop Commands It stands for ‘SQL to Hadoop’ and Hadoop to SQL and an open source tool. It is an application com connectivity tool that transfers bulk data betwe… Read More

Using SELECT INTO, we can save the output of a select command into a file.Instead of displaying the output on the screenmysql> SELECT * INTO OUTFILE '/tmp/employee.txt' FROM employee;We c… Read More

Converting excel data to mysql database is very important in those days because so many companies wants maintain their old/current excel data into mysql database so that they can access from… Read More

1.The Java interpreter is used for the execution of the source code.TrueFalseAns: a.2) On successful compilation a file with the class extension is created.a) Trueb) FalseAns: a.3) The Java… Read More