Querying Data in Unified Analytics
Unified Analytics basics
Setting up an Impala Virtual Warehouse
Setting up a Hive Virtual Warehouse
Running a query
Granting permissions to run SQL queries
Using DDL statements
Escaping an invalid identifier
Client access to Unified Analytics
Connecting a JDBC client
Connecting an Impala shell client
Using the Impala shell client
Materialized views
Creating and using a materialized view
Creating the tables and view
Verifying the query rewrite
Query rewrite example
Managing query rewrites
Using optimizations from a subquery
Dropping a materialized view
Showing materialized views
Describing a materialized view
Periodically rebuilding a materialized view
Incremental rebuilds
Purposely using a stale materialized view
Creating and using a partitioned materialized view
Materialized view commands
ALTER MATERIALIZED VIEW REBUILD
ALTER MATERIALIZED VIEW REWRITE
CREATE MATERIALIZED VIEW
DESCRIBE EXTENDED and DESCRIBE FORMATTED
DROP MATERIALIZED VIEW
SHOW MATERIALIZED VIEWS
Materialized view recommendations introduction
Speeding up queries using BI mode
Get the JDBC driver
Connect to Unified Analytics with a BI tool
Enable BI mode to rewrite queries automatically
Using roll ups and grouping sets
Using set operations
Using anti joins
Creating a table from Parquet data
Querying correlated data
Subquery restrictions
Comparing tables using ANY/SOME/ALL
Handling ETL jobs
Inserting data into a table
Updating data in a table
Merging data in tables
Deleting data from a table