Adding Soon...
One can check https://www.tutorialspoint.com/hive/index.htm
It has explained the basic functions in hive in a precise manner which you can cover in no time & start working on Hive.
You might have seen above link, & may have got a good quick overview of Hive. You can check further below URLs -
https://www.guru99.com/hive-partitions-buckets-example.html
data-flair.training/blogs/hive-features-and-limitations/
===============================================================================================
In Hive, unlike Oracle, empty Strings are not treated as NULL. If you are having such requirement then you need to look more on Google for this.
And you can achieve this by using serialization.null.format property in your table create statement or you can alter this property for existing table, like shown below -
create table hello(
id INT,
middle String,
last String)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ','
TBLPROPERTIES('serialization.null,format'='');
or you can alter the existing table -
hive> alter table hello set tblproperties ('serialization.null.format'='');
It has explained the basic functions in hive in a precise manner which you can cover in no time & start working on Hive.
You might have seen above link, & may have got a good quick overview of Hive. You can check further below URLs -
https://www.guru99.com/hive-partitions-buckets-example.html
data-flair.training/blogs/hive-features-and-limitations/
===============================================================================================
In Hive, unlike Oracle, empty Strings are not treated as NULL. If you are having such requirement then you need to look more on Google for this.
And you can achieve this by using serialization.null.format property in your table create statement or you can alter this property for existing table, like shown below -
create table hello(
id INT,
middle String,
last String)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ','
TBLPROPERTIES('serialization.null,format'='');
or you can alter the existing table -
hive> alter table hello set tblproperties ('serialization.null.format'='');