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.

Try in SPARQL Jump to: Surface forms Statements Referenced by

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.

DataGrip supportsLanguage HiveQL
this entity surface form: Apache Hive SQL dialect