Hcatalog in HIVE

0 votes
What is the use if Hcatalog in HIVE? I know it works as a storage management layer for Hadoop. But I don't know how exactly it works?
Help Needed.
Aug 30, 2018 in Database by Ashish
• 2,630 points
162 views

1 answer to this question.

0 votes
HCatalog supports reading and writing files in any format for which a Hive SerDe (serializer-deserializer) can be written. By default, HCatalog supports RCFile, CSV, JSON, and SequenceFile formats. To use a custom format, you must provide the InputFormat, OutputFormat, and SerDe.

HCatalog is built on top of the Hive metastore and incorporates components from the Hive DDL. HCatalog provides read and write interfaces for Pig and MapReduce and uses Hive’s command line interface for issuing data definition and metadata exploration commands.

It also presents a REST interface to allow external tools access to Hive DDL (Data Definition Language) operations, such as “create table” and “describe table”.

HCatalog presents a relational view of data. Data is stored in tables and these tables can be placed into databases. Tables can also be partitioned on one or more keys. For a given value of a key (or set of keys) there will be one partition that contains all rows with that value (or set of values).

Hope this helps.
answered Aug 30, 2018 by kurt_cobain
• 9,260 points

Related Questions In Database

0 votes
1 answer

Logging Levels in Cassandra

ALL: All levels including custom levels TRACE: Designates finer-grained informational ...READ MORE

answered Jun 28, 2018 in Database by shams
• 3,580 points
37 views
0 votes
2 answers

Durable Writes in Cassandra

When Cassandra write: 1. memtable (in memory) 2. commit ...READ MORE

answered Nov 25, 2018 in Database by Amit
• 180 points
1,336 views
0 votes
1 answer

Standalone Mode in Hbase

It is a default mode of HBase. ...READ MORE

answered Jul 11, 2018 in Database by kurt_cobain
• 9,260 points
642 views
0 votes
1 answer

Connection in Hbase

Following code is used to open a ...READ MORE

answered Jul 11, 2018 in Database by Data_Nerd
• 2,360 points
54 views
0 votes
3 answers

What is Hive? Is Hive a database?

Hive is a data Warehouse infrastructure/system built ...READ MORE

answered Jul 1 in Big Data Hadoop by Ved Gupta
6,389 views
0 votes
1 answer

Hadoop on cassandra database

Regarding your question - there is a ...READ MORE

answered Mar 26, 2018 in Big Data Hadoop by nitinrawat895
• 10,690 points
61 views
0 votes
1 answer
0 votes
1 answer

What is a importance of Hive ODBC Connector

The Cloudera ODBC Driver for Hive enables ...READ MORE

answered Apr 10, 2018 in Big Data Hadoop by kurt_cobain
• 9,260 points
103 views
0 votes
1 answer

Buckets in HIVE

There are two main reasons for performing bucketing ...READ MORE

answered Aug 30, 2018 in Database by kurt_cobain
• 9,260 points
76 views
0 votes
1 answer

Database Repair Options in Cassandra

Anti Entropy: Anti-entropy Repair is a process of ...READ MORE

answered Jun 28, 2018 in Database by kurt_cobain
• 9,260 points
158 views