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
|