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
Using the recommender in local mode
Setting up a mini HiveServer
Getting wi script help
Running Recommender examples
Running the Hello world example
Running the exclude aggregations example
Running the level of detail examples
Running the JSON output example
Running the multiple query input example
Running the repetitive queries example
Cleaning up materialized views
Analyzing JSON records
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
Query 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