Is it possible to create multiple table in hive for same data?

devquora
devquora

Posted On: Feb 22, 2018

 

Initially, it looks not possible as I am a regular RDBMS user like other programmers, but then I tried to connect in Hive context. I found it is possible as Hive creates  schema and append on top of an existing data file. One can have multiple schema for one data file, schema would be saved in hive’s metastore and data will not be parsed read or serialized to disk in given schema. When s/he will try to retrieve data schema will be used. Lets say if my file have 5 column (Id, Name, Class, Section, Course) we can have multiple schema by choosing any number of column

    Related Questions

    Please Login or Register to leave a response.

    Related Questions

    Hadoop Interview Questions

    What does HDFS mean?

    The HDFS is one of the storage systems of the Hadoop structure. It is a circulated file structure that can helpfully ke..

    Hadoop Interview Questions

    What are the key features of HDFS?

    Various key features of HDFS are as follows: HDFS is a profoundly versatile and reliable storage system for big data st..

    Hadoop Interview Questions

    What is check pointing in Hadoop?

    Check pointing is a fundamental part of keeping up and holding on file system metadata in HDFS. It’s urgent for profi..