We addressed in the previous post that “Date” is the most significant column that helps to explain patterns, trends and even business. From diagnostic analysis
Formatting number in Apache Hive
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
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(‘ ‘,
Big Data & SQL 