Requirement In this post, we are going to learn to create a delta table from the dataframe at an external path in Databricks. This scenario comes when we consume data from any file, source database table, etc., at last, we used to have the data in the dataframe. We canRead More →
Requirement You have comma separated file and you want to create an external table in the hive on top of it (need to load CSV file in hive), then follow the below steps. Solution Step 1: Sample CSV File Create a sample CSV file named as sample_1.csv. You can downloadRead More →
Requirement Suppose we have data in Hive table. We want the same data into HBase table. So, our requirement is to migrate the data from Hive to HBase table. Components Involved Hive – Source table HBase – Target Table Solution We cannot load data directly into HBase table from theRead More →
Requirement You have marks of all the students of a class with roll number in CSV file. It is needed to calculate the percentage of marks of students in the hive. Given: Download the sample CSV file which have 7 columns, 1st column is Roll no and other 6 columnsRead More →
