We may want to subtract two timestamps in order to find out the difference between occurrence of two events. This is a very common operation… Read More »How to Subtract TIMESTAMP-DATE-TIME in HIVE
Hive supports traditional UNIX timestamp data type with nanosecond upto 9 decimal precision (in Teradata it is till 6 decimal precision for timestamp data type).… Read More »Handle Date and Timestamp in HIVE like a pro – Everything you must know
Once you have access to HIVE , the first thing you would like to do is Create a Database and Create few tables in it.… Read More »Create your first Table in HIVE and load data into it.
Have you encountered this error while working on HIVE tables with clusters and buckets ? This is one of the most common error we face… Read More »Bucketized tables do not support INSERT INTO
Hadoop is a very popular framework for data storage and data processing. So it suffice two main purposes: Distributed Data Storage using HDFS ( Hadoop… Read More »Hadoop & Hive – Introduction for Beginners