Using Apache Hive
Apache Hive 3 tables
Hive table locations
Refer to a table using dot notation
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
Generating surrogate keys
Partitions and performance
Creating partitions dynamically
Partition refresh and configuration
Automating partition discovery and repair
Repairing partitions manually using MSCK repair
Managing partition retention time
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
CDW stored procedures
Setting up a CDW client
Creating a function
Using the cursor to return record sets
HPL/SQL 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