As mentioned in the previous post, when the data is temporary or if you want Hive to control the life cycle of the table and
Category: Apache Hive
CDH Compatible Versions – Hive, Impala and HUE
How to get Apache Hive, Apache Impala and Hue version details? This is the question that many learners who use Cloudera’s supplied QuickStart VM are
Convert Delimited Data Into Columns In Hive
The conversion of delimited data into columns in Apache Hive is discussed in this article. If the data is already loaded as a single column
Hive SerDe – RegEx – Example8
Similar to the previous article, the dataset below is also common and a good example to learn regular expressions. Dataset (for copying purpose):82.133.98.11 – –
Hive SerDe – RegEx – Example7
The dataset below is one of the most popular and active dataset on the Internet. Regular expression has been written for this log by a
Hive DateTime Functions – UNIX_TIMESTAMP() and FROM_UNIXTIME()
In this article, we will address the frequently utilized Hive date and time functions that convert the date to BIGINT and from BIGINT to the
Big Data & SQL 