HintsToday

Hints and Answers for Everything

  • Home
    • SPARK Dataframe- Complete Tutorial
    • How PySpark processes your pipeline – data size, partition count, shuffle impact, memory usage, time estimates, and executor configuration
  • Tutorials
    • SQL
      • SQL Tutorial for Interviews- Types of SQL /Spark SQL commands- DDL, DML, TCL, CRUD in SQL
    • Pyspark
      • PySpark Coding Practice Questions
      • Pyspark Architecture Fundas Course
      • Dataframe Programming
      • Spark SQL
      • Pyspark Execution
      • Optimization in Pyspark
    • Interview Prep
      • Apache Spark RDDs: Comprehensive Tutorial
      • Pyspark Wholesome Tutorial- Links to refer, PDfs
      • Step-by-Step Roadmap tailored for Data Engineer target stack (SQL, PySpark, Python, AWS S3, Hadoop, Bitbucket)
      • PySpark Debugging & Introspection Toolkit
      • Coding Questions in Spark SQL, Pyspark, and Python
      • Personal DSA tutor- mastering data structures and algorithms
    • Databricks
    • Bigdata Fundamentals
    • AI & ML
    • Python
    • SAS
  • Forums
    • Azure DataBricks Interview Questions
    • Pyspark Interview Questions
    • Python Core Programming
    • About us

Log in

recent posts

  • Memory Management in PySpark- CPU Cores, executors, executor memory
  • Memory Management in PySpark- Scenario 1, 2
  • Develop and maintain CI/CD pipelines using GitHub for automated deployment, version control
  • Complete guide to building and managing data workflows in Azure Data Factory (ADF)
  • Complete guide to architecting and implementing data governance using Unity Catalog on Databricks

about

  • Twitter
  • Facebook
  • Instagram

Category: SQL

  • Pivot & unpivot in Spark SQL – How to translate SAS Proc Transpose to Spark SQL

    October 2, 2024

    PIVOT Clause in Spark sql or Mysql or Oracle Pl sql or Hive QL The PIVOT clause is a powerful tool in SQL that allows you to rotate rows into columns, making it easier to analyze and report data. Here’s how to use the PIVOT clause in Spark SQL, MySQL, Oracle PL/SQL, and Hive QL:…

  • Mysql or Pyspark SQL query- The placement of subqueries

    August 2, 2024

  • Temporary Functions in PL/Sql Vs Spark Sql

    June 26, 2024

  • Window functions in Oracle Pl/Sql and Hive explained and compared with examples

    June 6, 2024

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

    June 6, 2024

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

    June 5, 2024

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

    June 2, 2024

  • Database Structures,managing Databases, Schemas, Tablespaces

    April 15, 2024

  • SQL Data Types(Numeric, String & Date)- Default Values- PL/SQL, Hive

    April 15, 2024

  • What is SQL, Data Database, DBMS , RDBMS, SQL Commands Categories

    April 15, 2024

Previous Page
1 2 3
Next Page

Designed with WordPress