{"id":3986,"date":"2017-09-08T11:38:29","date_gmt":"2017-09-08T11:38:29","guid":{"rendered":"http:\/\/data-flair.training\/blogs\/?p=3986"},"modified":"2017-09-08T11:38:29","modified_gmt":"2017-09-08T11:38:29","slug":"hive-data-types","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/hive-data-types\/","title":{"rendered":"Hive Data Types – Primitive and Complex Data Types in Hive"},"content":{"rendered":"

Hive Data Types are the most fundamental thing you must know before working with Hive Queries.<\/strong><\/p>\n

In our previous blog, we have discussed the\u00a0Hive Architecture<\/strong> in detail. Now in this blog, we are going to cover Apache Hive Data Types with examples.<\/p>\n

Data Types in Hive specifies the column type in Hive tables. The article describes the two categories of Hive Data types that are primitive data type<\/strong> and complex data type<\/strong> along with their example.<\/p>\n

Let us now start with the Hive Data Types.<\/p>\n

Hive Data Types<\/h2>\n

\"Hive<\/a><\/p>\n

Data Types in Hive specifies the column\/field type in the Hive table. It specifies the type of values that can be inserted into the specified column.<\/p>\n

Let’s have a brief look at the Hive data types.<\/p>\n

Primitive Type<\/strong><\/p>\n

    \n
  1. Numeric<\/li>\n
  2. Date\/time<\/li>\n
  3. String<\/li>\n
  4. Miscellaneous<\/li>\n<\/ol>\n

    Complex Type<\/strong><\/p>\n

      \n
    1. Array<\/li>\n
    2. Map<\/li>\n
    3. Struct<\/li>\n
    4. Union<\/li>\n<\/ol>\n

      Let us first start with the Primitive Data Type.<\/p>\n

      Hive Primitive Data Type<\/h3>\n

       <\/p>\n

      \"primitive<\/a><\/p>\n

      1. [ps2id id=’Numeric’ target=”\/]Numeric Type<\/h4>\n

      The Numeric data type in Hive is categorized into<\/p>\n