excel Archives - BIG DATA PROGRAMMERS

Create Delta table from Excel File in Databricks

Tagged: Azure, databricks, Delta Table, excel, spark scala

Requirement In this post, we will perform a task to read an Excel file, process the data, and store the data in a Delta Table in Databricks. Sample Data We will take the below sample data for this exercise: empno ename designation manager hire_date sal deptno location 9369 SMITH CLERKRead More →

Export hive table to excel

Tagged: big data, excel, export, file, hive

Requirement You have one hive table named as infostore which is present in bdp schema. It is needed to get the data into Excel file. Solution. Let’s say the location where output file should present is /root/local_bdp/posts/export-hive-data-into-file Step 1: Create Output directory mkdir /root/local_bdp/posts/export-hive-data-into-file/output Step 2: Go to hive CLIRead More →