Hive

• August 26, 2024

  What is Hive?

  Hive a Data warehouse infra Hive is an open-source data warehouse infrastructure built on top of Hadoop for providing data summarization, query, and analysis. It allows users to query and manage large datasets residing in distributed storage using a SQL-like language called HiveQL. Here’s an overview of Hive: Features of Hive: Components of Hive: Use…

• June 6, 2024

  Common Table Expressions (CTEs) in Oracle Pl/Sql / Hive / Spark SQL explained and Compared

  Common Table Expressions (CTEs) are a useful feature in SQL for simplifying complex queries and improving readability. Both Oracle PL/SQL and Apache Hive support CTEs, although there may be slight differences in their syntax and usage. Common Table Expressions in Oracle PL/SQL In Oracle, CTEs are defined using the WITH clause. They are used to…

• June 5, 2024

  String/Character Manipulation functions in Oracle PL/SQL, Apache Hive

  Function Name Description Example Usage Result CONCAT Concatenates two strings. SELECT CONCAT(‘Oracle’, ‘PL/SQL’) FROM dual; OraclePL/SQL ` ` (Concatenation) Concatenates two strings. LENGTH Returns the length of a string. SELECT LENGTH(‘Oracle’); 6 LOWER Converts all characters in a string to lowercase. SELECT LOWER(‘ORACLE’); oracle UPPER Converts all characters in a string to uppercase. SELECT UPPER(‘oracle’);…

• June 2, 2024

  Date and Time manipulation in Oracle SQL, Apache Hive QL, Mysql

  Date and Time manipulation in Oracle SQL In Oracle SQL, date and time manipulation is essential for many database operations, ranging from basic date arithmetic to complex formatting and extraction. Here’s a guide covering various common operations you might need. 1. Basic Date Arithmetic Adding/Subtracting Days: Adding/Subtracting Months: Adding/Subtracting Years: 2. Extracting Components from Date…