Hortonworks Docs
»
»
Also available as:
Using Apache Hive
Apache Hive 3 tables
Create a CRUD transactional table
Create an insert-only transactional table
Create, use, and drop an external table
Drop an external table along with data
Using constraints
Determine the table type
Altering tables from flat to transactional
Alter a table from flat to transactional
Hive 3 ACID transactions
Using materialized views
Create and use a materialized view
Use a materialized view in a subquery
Drop a materialized view
Show materialized views
Describe a materialized view
Manage rewriting of a query
Create a materialized view and store it in Druid
Create and use a partitioned materialized view
Apache Hive queries
Query the information_schema database
Insert data into an ACID table
Update data in a table
Merge data in tables
Delete data from a table
Create a temporary table
Configure temporary table storage
Use a subquery
Subquery restrictions
Aggregate and group data
Query correlated data
Using common table expressions
Use a CTE in a query
Escape an illegal identifier
CHAR data type support
Create partitions dynamically
Repair partitions using MSCK repair
Query a SQL data source using the JdbcStorageHandler
Creating a user-defined function
Set up the development environment
Create the UDF class
Build the project and upload the JAR
Register the UDF
Call the UDF in a query
© 2012-2019, Hortonworks, Inc.
Document licensed under the
Creative Commons Attribution ShareAlike 4.0 License
.
Hortonworks.com
|
Documentation
|
Support
|
Community
