Skip to main content

Command Palette

Search for a command to run...

Hive Tables

Updated
1 min read
S

I am a data engineer who is responsible for designing, building, maintaining, and testing the infrastructure and systems that are used to store, process, and analyze data. I work closely with data scientists and analysts to ensure that the data pipelines and systems are able to support the data needs of an organization.

I have a strong background in computer science and software engineering, and skilled in programming languages such as Python, Java, and SQL also familiar with database systems and big data technologies like Hadoop, Spark, and NoSQL databases.

Some of my key responsibilities as a data engineer:

Designing and building data pipelines to extract, transform, and load data from various sources Setting up and maintaining data storage and processing systems, including data warehouses and data lakes Collaborating with data scientists and analysts to understand their data needs and ensure that the data infrastructure can support their requirements Performing data quality checks and troubleshooting any issues that arise Implementing security and privacy measures to protect sensitive data

There are two type of Tables available in Hive Data warehouse.

1. Internal Table

  • All the meta definition are maintained by Hive
  • Actual Data resides on Hive Data warehouse.

Steps to load: We can directly load data to table

image.png

2. External Table

  • All the meta definition are maintained by Hive
  • Actual Data resides on HDFS.

image.png

More from this blog

Sivaraman Arumugam

27 posts

I will share my thoughts and notes about my studies