Because of the many built-in functions provided by Apache Hive, the job made it easy for analysts, developers and programmers in most instances. Instead of
Category: Apache Hive
Find the position of a substring in a string – Apache Hive
INSTR function in Apache Hive helps in finding the position of a substring in a string. It returns only the first first occurrence of the
Reserved Keywords as Columns in Apache Hive
Since the use of reserved keywords for user-defined objects such as tables, columns, etc. is not good practice, However, if there is a situation where
Process and analyze JSON documents – Apache Hive
A JSON file is a file in the JavaScript Object Notation (JSON) format that stores simple data structures and objects, which is a standard format
Concatenating Rows in Apache Hive
The CONCAT_WS function in Apache Hive incorporates two or more strings into a single string with the specified delimiter. Example: SELECT fname, lname, CONCAT_WS(‘ ‘,
Accessing Part of the Date – Apache Hive
The most critical and significant column is always the date/time in the data. A date/time dimension provides all the information you need for a given
Big Data & SQL 