Using Apache Hive
Apache Hive 3 tables
Refer to a table using dot notation
Creating a CRUD transactional table
Creating an insert-only transactional table
Converting a managed non-transactional table to external
External tables based on a non-default schema
Using your schema in MariaDB
Using your schema in MS SQL
Using your schema in Oracle
Using your schema in PostgreSQL
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
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
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
Stored procedure examples