In Hive, when we are creating the table in AVRO format, will the records be populated into the table?
Because, when I run the below query, the table is being created. But, the I couldn’t find any data/records in that table.
create table departments
stored as avro
tblproperties (‘avro.schema.url’ = ‘hdfs://nn01.itversity.com/user/sbalaji2105/avsc/department.avsc’);
For your reference I am attaching the screenshots:
AVSC File Location:
Hive Table Creation: