Hive

SQL-like interface

Hive

Hive offers the possibility to use Hadoop through a SQL-like interface

Hive and Impala use the same SQL syntax HiveQL

Field delimitter

  • Default field delimitter Ctr+A (0x01)
  • It can be changed when creating a table
    
                ROW FORMAT DELIMITED
                FIELDS TERMINATED BY ':'