HiveQL

GPTKB entity

Statements (87)
Predicate Object
gptkbp:instanceOf query language
gptkbp:designedFor data warehousing
gptkbp:hasFeature Union
subqueries
limit
join
from
materialized views
user-defined functions
views
group by
vectorized query execution
bucketing
table partitioning
sort by
windowing functions
external tables
joins
select
set operations
complex data types
ACID transactions (since Hive 0.14)
CTAS (Create Table As Select)
alter table
analyze
analyze table
cluster by
compute statistics
cost-based optimizer
create database
create function
create index
create view
describe table
distribute by
drop database
drop function
drop index
drop table
drop view
dynamic partitioning
except
explain
explain analyze
explain cost
explain dependency
explain extended
explain formatted
explain logical
explain physical
explain plan
explain plan for
explain vectorization
having
insert into
insert overwrite
intersect
lateral view
map and array data types
metadata storage in metastore
multi-table inserts
order by
schema on read
serde (serialization/deserialization) support
show databases
show partitions
show tables
static partitioning
struct data type
support for ORC, Parquet, Avro file formats
support for text, sequence, RCFile formats
table sampling
truncate table
union data type
where
https://www.w3.org/2000/01/rdf-schema#label HiveQL
gptkbp:influencedBy SQL
gptkbp:runsOn gptkb:Hadoop
gptkbp:supports gptkb:Spark
gptkb:Tez
gptkb:MapReduce
gptkb:data_manipulation_language
data definition language
data query language
gptkbp:usedBy gptkb:Apache_Hive
gptkbp:bfsParent gptkb:Hive
gptkbp:bfsLayer 5