<p>There are two type of Tables available in Hive Data warehouse.</p>
<h1 id="heading-1-internal-table">1. Internal Table</h1>
<ul>
<li>All the meta definition are maintained by Hive</li>
<li>Actual Data resides on Hive Data warehouse.</li>
</ul>
<p>Steps to load:
We can directly load data to table </p>
<p><img src="https://cdn.hashnode.com/res/hashnode/image/upload/v1665502283712/YRaqGCD-x.png" alt="image.png" /></p>
<h1 id="heading-2-external-table">2. External Table</h1>
<ul>
<li>All the meta definition are maintained by Hive</li>
<li>Actual Data resides on HDFS.</li>
</ul>
<p><img src="https://cdn.hashnode.com/res/hashnode/image/upload/v1665502394959/yIOqBFL0Q.png" alt="image.png" /></p>


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](https://cdn.hashnode.com/res/hashnode/image/upload/v1665502283712/YRaqGCD-x.png align="left")

# 2. External Table
- All the meta definition are maintained by Hive
- Actual Data resides on HDFS.

![image.png](https://cdn.hashnode.com/res/hashnode/image/upload/v1665502394959/yIOqBFL0Q.png align="left")


SIVARAMAN A's blog

SIVARAMAN A's blog

Hive Tables

1. Internal Table

2. External Table