When To Use External Table And Internal Table In Hive

When To Use External Table And Internal Table In Hive

We can create table in hive in two different approaches,one approach is hive external table and another approach is hive managed table.In this post we explained the detailed information about Hive create table and real time examples of hive create tables. Here is the two types of hive table . i) Hive External Table ii) […]

Hive Permanent UDF Function Hive Add Jar Permanently

Hive Permanent UDF Function Hive Add Jar Permanently

In Our Hive we almost worked on Hive tables and analytic work by using some built in transformations in our hive ecosystem,But all the time hive built in transformations will not support for our requirement,at that time we have write our own user defined function in hive also called as UDFs in hive . In Hive we […]

Difference Between Partitioning and Bucketing in hive

difference-between-partitioning-and-bucketing-in-hive

In my previous posts we already discussed about Hive Partitioning  concepts and Hive buckets concepts very clearly and also we deeply involved in differences between static partition and dynamic partition in hive concepts also now this is the time to known about main Difference Between Partitioning and Bucketing in hive . Hive Partition Hive Partitioning dividing the large […]

Static partition vs dynamic partition in hive differences

Static partition vs dynamic partition in hive

In our Last post we discussed about Introduction to Hive Partition In that post we clearly discussed the main difference between SQL partition and Hive Partition and the main advantages with Hive Partitions also.In Hive Partition concept there is two different type of partitions one is Static Partition and another one is Dynamic Partition.Here we will […]

Hive UDF Example In Java Upper Case And Lower Case

hive-udf-example-in-java-upper-case-and-lower-case

In this Hive UDF program i wrote an udf for converting a string from Lower case to upper case and upper case to lower case based on condition which string lenght is grater than 5. Below is the code for converting strings from Upper to lower and lower to upper . Also Read How to […]