HIVE DATA TYPE

siddar — Fri, 06 Sep 2019 08:14:24 GMT

hi, what data type should we use for general home address in hive???

Re: HIVE DATA TYPE

yukti — Fri, 06 Sep 2019 10:18:42 GMT

CREATE TABLE IF NOT EXISTS mydb.employees ( name STRING COMMENT 'Employee name', salary FLOAT COMMENT 'Employee salary', subordinates ARRAY<STRING> COMMENT 'Names of subordinates', deductions MAP<STRING, FLOAT> COMMENT 'Keys are deductions names, values are percentages', address STRUCT<street:STRING, city:STRING, state:STRING, zip:INT> COMMENT 'Home address') COMMENT 'Description of the table' TBLPROPERTIES ('creator'='me', 'created_at'='2012-01-02 10:00:00', ...) LOCATION '/user/hive/warehouse/mydb.db/employees';

you can use struct as given in example.

question HIVE DATA TYPE in Support Questions

HIVE DATA TYPE

Re: HIVE DATA TYPE