CSV

Parquet

JSON
Row_Number

ORC Read Rank

AVRO
Ranking Dense_rank

ODBC
Persent_Rank

JDBC
Ntill
Math Functions
Parquet
Lag

CSV
Laed

AVRO
Value First_Value
Write
ORC
Last_value

Delta
Nth_Value

JSON
AVG
DataFrame
Max
RDD Data Stuctures
Aggreate Min
Dataset
Sum
Numeric types
Count
String Type
WHERE CLAUSE
Binary type
GROUP BY CLAUSE
Boolean Type
Clause
HAVING CLAUSE
Interval types
ORDER BY CLAUSE
DayTimeIntervalType Data Types
Day-Time Interval Type ALL

FloatType AND

LongType IN

DecimalType Not

Datetype OR

StructField Logical Operators Between

StructType Exists
Complex types
ArrayType Like
Operators
MapType is null

groupBy Any

aggregateByKey Some

aggregate Bitwise Operators

join Arithmetic Operators

repartition
Comparison Operators
distinct
Compound Operators
reduceByKey

ASCII
Cartesian

Char
intersection

CharIndex
sortBy/orderBy Wide Transformation

Concat
dropDuplicatates

Concat_ws
groupBy

Format
pivot

Left
cube/rollup

Len
approxQuantile

Lower
cogroup/cogroupwith

Ltrim
subtract

Nchar
zipWithUniqueID
String Functions
Patindex
cogroup

Replace
map

Replicate
mapPartition

Reverse
Flatmap

Right
filter

Rtrim
union

Space
mapvalues

Stuff
glom Narrow Transformation

Substring
flatmapvalues

Trim
select

Upper
withcolumn

withColumnRenamed Current_Timestamp

limit DateAdd

mapPartitionsWithIndex DatedIff
Python Spark SQL Spark
Collect DateFromParts

first Operations Datename

take Day
Window Functions
reduce Getdate

saveAsTeztFile Getutcdatae

show Isdate

top Month

countByValue SysDatetime

fold Year

aggregate
Inline Scalar Functions
foreach
Scalar Functions
Multi-Statement Scalar Functions
getNumPartitions User Defined Functions
Table-Valued Functions
TreeAggregate
System Functions
treeReduce
Union
forEachPartitions
Union All
collectAsMap
Intersect
takeSample
Except
Sum Actions
Correlated
count() Sub Queries
Non-correlated
max
Recursive Queries CTE
min Other Functions
dynmic Table
CountApprox
OPENJSON
Histogram
JSON Support JSON_QUERY
mean
JSON_VALUE
variance
Temporal Tables
stdev
Error Handling
sample
Pivot
variance

TEMPORARY
countApproxDistinct
Views
GLOBAL TEMPORARY
topandas

save NOT NULL Constraint:

saveastable Primary

saveasParquetFile Foreign Kry

Constraints
SaveAsasequenceFile Check

SaveasobjectFile Unique

select Default

explode
Caching
alias
Partitioning
when index
Broadcasting
otherwise
Column Pruning
isin
Create
like Quries
Alter
startwith/endswith
DDL Drop
substring
Rename
Between
Truncate
na.fill
Insert
na.drop Missing & Replace SQL Sub Language
Update
na.replace BML
Delete
dtypes
Merge
show
Grant
head DQL
Revoke
first
DQL Select
take
Inspect Data
Collection Functions
describe

Numeric_functions
count

Character_function
distinct

Data_mining_function
printSchema
Single row function:
Datetime_functions
explain

Conversion_function
Count

Collection_function
sum

XML_function
min GroupBy

max

avg