Using Apache Hive
Apache Hive 3 tables
Hive table locations
Create a CRUD transactional table
Create an insert-only transactional table
Create an S3-based external table
Drop an external table along with data
Using constraints
Determine the table type
Hive 3 ACID transactions
Using materialized views
Create and use a materialized view
Use a materialized view in a subquery
Drop a materialized view
Show materialized views
Describe a materialized view
Manage query rewrites
Create and use a partitioned materialized view
Apache Hive query basics
Query the information_schema database
Insert data into an ACID table
Update data in a table
Merge data in tables
Delete data from a table
Create a temporary table
Configure temporary table storage
Use a subquery
Subquery restrictions
Aggregate and group data
Query correlated data
Using common table expressions
Use a CTE in a query
Escape an illegal identifier
CHAR data type support
ORC vs Parquet in CDP
Partitions introduction
Create partitions dynamically
Manage partitions
Automate partition discovery and repair
Repair partitions manually using MSCK repair
Manage partition retention time
Generate surrogate keys
Using JdbcStorageHandler to query RDBMS
Using functions
Reload, view, and filter functions
Create a user-defined function
Set up the development environment
Create the UDF class
Build the project and upload the JAR
Register the UDF
Call the UDF in a query