Hive Tables DDL

  • Scott Shaw
  • Andreas François Vermeulen
  • Ankur Gupta
  • David Kjerrumgaard


By now, you know that Hive was created as a means to query the unstructured world of Hadoop without writing complex MapReduce programs. It gives users the ability to write simple queries using the expressiveness of SQL, the language that so many are already familiar with. Hive query language (HiveQL or HQL) is based on ANSI standard SQL, and hence is very easy to understand for anyone familiar with SQL. A user can log in to the Hive command-line interface and start querying the data on HDFS.


Data Type Relational Database Small File Internal Table Partition Column 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Copyright information

© Scott Shaw, Andreas Francois Vermeulen, Ankur Gupta, David Kjerrumgaard 2016

Authors and Affiliations

  • Scott Shaw
    • 1
  • Andreas François Vermeulen
    • 2
  • Ankur Gupta
    • 3
  • David Kjerrumgaard
    • 4
  1. 1.Saint LouisUSA
  2. 2.West Kilbride North AyrshireUK
  3. 3.UxbridgeUK
  4. 4.HendersonUSA

Personalised recommendations