HiveQL
E705291
HiveQL is a SQL-like query language designed for managing and analyzing large datasets stored in Apache Hive’s data warehouse system on Hadoop.
All labels observed (2)
| Label | Occurrences |
|---|---|
| Apache Hive SQL dialect | 1 |
| HiveQL canonical | 1 |
Statements (61)
| Predicate | Object |
|---|---|
| instanceOf |
data warehouse query language
ⓘ
domain-specific language ⓘ query language ⓘ |
| basedOn | SQL NERFINISHED ⓘ |
| compiledTo |
Apache Spark jobs
ⓘ
Apache Tez jobs ⓘ MapReduce jobs ⓘ |
| designedFor |
Apache Hive
NERFINISHED
ⓘ
Hadoop ecosystem ⓘ |
| developedBy | Apache Software Foundation NERFINISHED ⓘ |
| domain |
big data analytics
ⓘ
data engineering ⓘ |
| hasAlternativeName |
HQL
NERFINISHED
ⓘ
Hive Query Language NERFINISHED ⓘ |
| hasFeature |
SQL-like syntax
ⓘ
extensibility via UDFs ⓘ support for SerDes ⓘ support for buckets ⓘ support for complex data types ⓘ support for partitions ⓘ |
| runsOn |
Apache Hive metastore
NERFINISHED
ⓘ
Hadoop Distributed File System NERFINISHED ⓘ |
| supportsComplexType |
ARRAY
ⓘ
MAP ⓘ STRUCT ⓘ UNIONTYPE ⓘ |
| supportsDataType |
BIGINT
ⓘ
BOOLEAN ⓘ DATE ⓘ DECIMAL ⓘ DOUBLE ⓘ FLOAT ⓘ INT ⓘ STRING ⓘ TIMESTAMP ⓘ |
| supportsOperation |
DELETE
ⓘ
GROUP BY ⓘ INSERT ⓘ JOIN ⓘ LIMIT ⓘ ORDER BY ⓘ SELECT ⓘ UPDATE ⓘ bucketing ⓘ external tables ⓘ partition management ⓘ schema-on-read ⓘ subqueries ⓘ table creation ⓘ user-defined functions ⓘ views ⓘ |
| targetUser |
data analysts
ⓘ
data engineers ⓘ |
| usedFor |
ETL processing
ⓘ
ad hoc querying ⓘ batch analytics ⓘ data warehousing ⓘ |
| usedWith |
Apache Hive CLI
NERFINISHED
ⓘ
Beeline NERFINISHED ⓘ JDBC clients ⓘ ODBC clients ⓘ |
Referenced by (2)
Full triples — surface form annotated when it differs from this entity's canonical label.
this entity surface form:
Apache Hive SQL dialect