Tag: hive

Hive: How to clear the contents of Hive CLI

Command You’re most likely familiar with the clear command to clear the contents of Unix /Linux shells. You can use a slightly modified version of this command to clear the contents of the Hive CLI. Keyboard Shortcut Alternatively, the following keyboard shortcut can be used to clear the contents of the Hive CLI.

Hive: How to display column names in SELECT statement output

If you’re executing any SELECT statement on Hive cli, only the rows are displayed. The column names are not displayed by default. To show the column headers, print.header property needs to be set to true. This can be done with the following statement. By default, the output of SELECT statement will not have any column […]

Find the version of Apache Hive from Command Line Interface (CLI)

The version of Apache Hive can be retrieved from Command Line. You don’t have to navigate through the configuration files or browse through the User Interface. There are two commands that can be used from Command Line to obtain the version of Apache Hive. COMMAND #1 This command follows the popular convention used by other […]

Apache Sqoop: Import data from RDBMS to HDFS in ORC Format

Apache Sqoop import tool offers capability to import data from RDBMS (MySQL, Oracle, SQLServer, etc) table to HDFS. Sqoop import provides native support to store data in text file as well as binary format such as Avro and Parquet. There’s no native support to import in ORC format. However, it’s still possible to import in […]

Cloudera CCA Spark and Hadoop Developer (CCA175) Certification – Preparation Guide

Cloudera’s CCA Spark and Hadoop Developer (CCA175) exam validates the candidate’s ability to employ various Big Data tools such as Hadoop, Spark, Hive, Impala, Sqoop, Flume, Kafka, etc to solve hands-on problems. I passed CCA175 certification exam on May 13, 2019 and wanted to share my experience. This article has everything you should know about […]

Scroll to Top