Using Apache Hive
Apache Hive 3 tables
Hive table locations
Refer to a table using dot notation
Understanding CREATE TABLE behavior
Creating a CRUD transactional table
Creating an insert-only transactional table
Creating an S3-based external table
Dropping an external table along with data
Converting a managed non-transactional table to external
Accessing StorageHandler and other external tables
Creating secure external tables
Check for required Ranger features in Data Hub
Enable authorization of StorageHandler-based tables in Data Hub
Examples of creating secure external tables
Using constraints
Determining the table type
Apache Hive 3 ACID transactions
Apache Hive query basics
Querying the information_schema database
Inserting data into a table
Updating data in a table
Merging data in tables
Deleting data from a table
Using a subquery
Subquery restrictions
Use wildcards with SHOW DATABASES
Aggregating and grouping data
Querying correlated data
Using common table expressions
Use a CTE in a query
Comparing tables using ANY/SOME/ALL
Escaping an invalid identifier
CHAR data type support
ORC vs Parquet formats
Creating a default directory for managed tables
Configuring a table location outside the warehouse root directory
Generating surrogate keys
Partitions and performance
Creating partitions dynamically
Partition refresh and configuration
Automating partition discovery and repair
Managing partition retention time
Repairing partitions manually using MSCK repair
Query scheduling
Enabling scheduled queries
Periodically rebuilding a materialized view
Getting scheduled query information and monitor the query
Materialized views
Creating and using a materialized view
Creating the tables and view
Verifing use of a query rewrite
Using optimizations from a subquery
Dropping a materialized view
Showing materialized views
Describing a materialized view
Managing query rewrites
Purposely using a stale materialized view
Creating and using a partitioned materialized view
HPL/SQL stored procedures in Data Hub
Setting up a Hive client
Creating a function
Using the cursor to return record sets
Stored procedure examples
Using functions
Reloading, viewing, and filtering functions
Create a user-defined function
Setting up the development environment
Creating the UDF class
Building the project and upload the JAR
Registering the UDF
Calling the UDF in a query