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
HMS table storage
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
Escape table names in dot notation
CHAR data type support
Create partitions dynamically
Repair partitions using MSCK repair
Manage partitions automatically
Automate partition discovery and repair
Manage partition retention time
Generate surrogate keys
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
