Home >> Big Data Hadoop >> HIve External Table in Big Data Hadoop

HIve External Table in Big Data Hadoop

Create external table external_table(name string,age int, address string,zip int)row format delimited fields terminated by ','stored as textfile location '/test/abc';

Create external table external_table(name string,age int)row format delimited fields terminated by ','stored as parquet location '/test/abc';

Use external table if data is being used outside of Hive.

The data files are read and processed by an existing program that doesn't lock the files. Data needs to remain in the underlying location even after a DROP.

 

 

Post Your Comment

Next Questions
Hive DDL
Hive CLI Options
Hive shell commands
Hive Logging & Resources
Hive Types Of Joins
Hive Joins
Hive Joins cont
Hive Built-in Operators
Hive Data Types
Hive Built-in Functions
Hive Explode
Hive SORT BY vs ORDER By
HIve DISTRIBUTE BY vs CLUSTER BY
Hive HUE Editor
Hive vs Impala
Hive Data & Schema
Hive Partitioning
Hive Bucketing
Hive File Format
Hive Engine
Hive Vectorization
Hive User Defined Function
Hive How to Write a User Defined Function
Hive User Defined Aggregate Functions
Hive Performance Tuning

Copyright ©2022 coderraj.com. All Rights Reserved.