Raymond Raymond / Spark & PySpark

Install Big Data Tools (Spark, Zeppelin, Hadoop) in Windows for Learning and Practice

event 2018-02-25 visibility 5,160 comment 2 insights toc
insights Stats
toc Table of contents

Are you a Windows/.NET developer and willing to learn big data concepts and tools in your Windows?

If yes, you can follow the links below to install them in your PC. The installations are usually easier to do in Linux/UNIX but they are not difficult to implement in Windows either since they are based on Java.

Installation guides

All the following documents are based on Windows 10. The steps should be the same in other Windows environments though some of the screenshots may be different.

Install Zeppelin 0.7.3 in Windows

Install Hadoop 3.0.0 in Windows (Single Node)

Install Spark 2.2.1 in Windows

Install Apache Sqoop in Windows

Configure Hadoop 3.1.0 in a Multi Node Cluster

Apache Hive 3.0.0 Installation on Windows 10 Step by Step Guide

Learning tutorials

Use Hadoop File System Task in SSIS to Write File into HDFS
Invoke Hadoop WebHDFS APIs in .NET Core

Write and Read Parquet Files in Spark/Scala

Write and Read Parquet Files in HDFS through Spark/Scala

Convert String to Date in Spark (Scala)

Read Text File from Hadoop in Zeppelin through Spark Context

Connecting Apache Zeppelin to your SQL Server

Load Data into HDFS from SQL Server via Sqoop

Default Ports Used by Hadoop Services (HDFS, MapReduce, YARN)

Connect to SQL Server in Spark (PySpark)

Implement SCD Type 2 Full Merge via Spark Data Frames

Password Security Solution for Sqoop

PySpark: Convert JSON String Column to Array of Object (StructType) in Data Frame

Spark - Save DataFrame to Hive Table

Copy Files from Hadoop HDFS to Local

Data Partitioning in Spark (PySpark) In-depth Walkthrough

Data Partitioning Functions in Spark (PySpark) Deep Dive

Read Data from Hive in Spark 1.x and 2.x

Get the Current Spark Context Settings/Configurations

PySpark - Fix PermissionError: [WinError 5] Access is denied

Configure a SQL Server Database as Remote Hive Metastore

Connect to Hive via HiveServer2 JDBC Driver

I will be constantly updating my blog with tutorials. Feel free to subscribe this blog (RSS).

More from Kontext
comment Comments
Raymond Raymond #212 access_time 6 years ago more_vert

Yes, you can load your text file into hdfs via CLI, WebHDFS api or any other tools/programming that supports this. You can then do transformations using tools like Apache Beam, Spark or notebooks (Zeppeline or Jupyter), etc.These tools also can then write into sql server database through ODBC/JDBC or native SQL Server drivers.


person Rajesh access_time 6 years ago

Can we load date from text file to HDFS and do calculations/corrections and load the data to SQL SERVER DB table

hide_source Anonymous #68 access_time 6 years ago more_vert

Can we load date from text file to HDFS and do calculations/corrections and load the data to SQL SERVER DB table

Please log in or register to comment.

account_circle Log in person_add Register

Log in with external accounts