The Apache Hive CAST function is a type conversion function that converts data types from one to another. It can convert a string to an
Category: Apache Hive
Apache Hive Database Size
We might need to know the database size for a variety of reasons, such as capacity planning, storage allocations, and so on. The following methods
Number of Tables in Hive Database
In previous postings, I demonstrated how to retrieve metadata from the INFORMATION SCHEMA table in MySQL. It’s now time to check Apache Hive for the
Create Table With Delimiter and SELECT – Apache Hive
The following example shows how to create a table in Apache Hive with different delimiters, and with and without default location, a text file format
Can permanent and temporary tables with the same name coexist?
Temporary tables in SQL Server are prefixed with “#” and table variables with “@,” thus they can have the same name as permanent tables and
Definitions of Big Data, Hadoop and Ecosystem Components
Commonly used terms in Hadoop / Big Data are described in this post. VMWare: A hypervisor is installed on the physical server using VMware server
Big Data & SQL 