Running SQL Queries
Overview
SQL tables in CDP
SQL table locations
Creating a CRUD transactional table in Hive
Creating an insert-only transactional table
Creating an external table
Dropping an external table and data
Partitioned tables
Creating and loading a managed, partitioned table
Creating an Impala external partitioned table
Creating a Hive external partitioned table
Repairing Hive or Impala partitions
Using your schema in PostgreSQL
Determining the table type
Using database.table in queries
Inserting data into a table
Updating data in a table
Deleting data from a table
Using a subquery
Aggregating and grouping data