Using Apache Hive
Apache Hive 3 tables
Locating Hive tables and changing the location
Refer to a table using dot notation
Understanding CREATE TABLE behavior
Creating a CRUD transactional table
Creating an insert-only transactional table
Creating, using, and dropping an external table
Creating an Ozone-based external table
Accessing Hive files in Ozone
Recommended Hive configurations when using Ozone
Dropping an external table along with data
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
Creating a temporary table
Configuring temporary table storage
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
Enabling all 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 proceduresHPL/SQL stored procedures
Setting up a CDW client
Setting up a Hive client
Creating a function
Using the cursor to return record sets
Stored procedure examples
Using JdbcStorageHandler to query RDBMS
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