Apache Hive is one of the most popular SQL framework in Hadoop ecosystem.
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 which we perform on any TIMESTAMP or DATE or TIME data type. Now the question is how to find out the difference or subtract two timestamp ? Hive Timestamp Difference […]
How to Subtract TIMESTAMP-DATE-TIME in HIVE Read More »
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). Typical TIMESTAMP data type has DATE part which is YEAR/MONTH/DAY and TIME part which is HOUR/MINUTE/SECOND/NanoSecond. We can represent these components as : TIMESTAMP : 2017-11-29 14:53:50.724 S.No Part Format
Handle Date and Timestamp in HIVE like a pro – Everything you must know Read More »
Once you have access to HIVE , the first thing you would like to do is Create a Database and Create few tables in it. Before we start with the SQL commands, it is good to know how HIVE stores the data. Since in HDFS everything is FILE based so HIVE stores all the information
Create your first Table in HIVE and load data into it. Read More »
Have you encountered this error while working on HIVE tables with clusters and buckets ? This is one of the most common error we face in HIVE while doing transactions on tables. Since transactions in HIVE is still not as mature as compared to RDBMS if we try to run some DML on a Target
Bucketized tables do not support INSERT INTO Read More »