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.
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 […]
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 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’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 […]