Data Lake for Enterprises

Data visualization with HIVE tables

Now let us visualize the loaded data by creating Hive tables over the binary Avro data by executing the following Hive table scripts (using Hive Query Editor):

1. Create a customer Hive table by executing the following script:

CREATE EXTERNAL TABLE customerROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.avro.AvroSerDe'STORED AS INPUTFORMAT 'org.apache.hadoop.hive.ql.io.avro.AvroContainerInputFormat'OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.avro.AvroContainerOutputFormat'LOCATION '/datalake/raw/customer'TBLPROPERTIES (  'avro.schema.literal'='{"namespace": "example.avro",    "type": "record",    "name": "Customer",    "fields": [       {"name": "id", "type": "int"},       {"name": "first_name",  "type": "string"}, {"name": "last_name", ...