When we create an external table in Hive, we typically specify its location rather than the actual file. Hive reads data from the specified location,
Tag: Apache Hive Internal and External Tables
Loading Multiple FIles in Hive
Loading data from many flat files into an RDBMS is a challenging operation. But in Hive, it won’t take long since Apache Hive is designed
Change Location of Managed Table in Hive
Internal tables are similar to regular database tables in that data may be stored and queried on them. When the data is either temporary or
External Tables in Apache Hive
When the data isn’t transient and you don’t want Hive to manage the table’s and data’s life cycle, you’ll consider creating external tables, as discussed
Can We Create An External Table Using CTAS?
Can we create an external table using CTAS? The answer is NO. (Read till the end) As per the Hive’s documentation, CTAS has these restrictions:
Hive Internal Tables Using CTAS
In addition to previous implementations of the creation of internal tables (a.k.a. managed tables), another approach for creating internal tables is using the CTAS (create-table-as-select)
Big Data & SQL 