For detailed information about ORC file format, click here. ORC provides the best Hive performance overall. In addition, to specifying the storage format, you can
Category: Apache Hive
Optimized Row Columnar (ORC) File Format
The Optimized Row Columnar (ORC) file format is the most powerful way for improved performance and storage saving, of all file formats. It provides the
Conditional Statements in Apache Hive
The use of conditional statements is very frequent when it comes to data interpretation. Often data manipulation, too, relies on conditional statements. Operators such as
A Common Mistake In Defining File Format In Hive
Often the written code is parsed, often an error is not returned from the table generated with file formats, however it is obvious that even
Is Complex Data Really Complex To Handle?
Let’s split the title-question into two. What is the complex data and how complex it is to handle. First, let’s see what complex data is.
Executing HiveQL Script from CLI in different modes
The purpose of this article is to explore interactive and non-interactive modes of execution of the SQL file to retrieve records from the Hive metastore
Big Data & SQL 