Featured columns/forums
Code snippets for various programming languages/frameworks.
Tutorials and informations about Teradata.
About the releases of Kontext Project.
local_offer .net core local_offer entity-framework
SQLite is a self-contained and embedded SQL database engine. In .NET Core, Entity Framework Core provides APIs to work with SQLite. This page provides sample code to create a SQLite database using package Microsoft.EntityFrameworkCore.Sqlite . Create sample project ...
local_offer hadoop local_offer yarn local_offer hdfs
This page summarizes the steps to install Hadoop 3.0.0 in your Windows environment. Reference page: https://wiki.apache.org/hadoop/Hadoop2OnWindows ...
local_offer hadoop local_offer linux local_offer WSL
In my previous post , I showed how to configure a single node Hadoop instance on Windows 10. The steps are not too difficult to follow if you have Java programming backgr...
local_offer hadoop local_offer hive
If you have been following my website, you would know I’ve published a number of articles about installing big data tools/framewo...
local_offer python local_offer spark local_offer pyspark
In Spark, SparkContext.parallelize function can be used to convert Python list to RDD and then RDD can be converted to DataFrame object. The following sample code is based on Spark 2.x. In this page, I am going to show you how to convert the following list to a data frame: data = [(...
local_offer python local_offer spark local_offer pyspark
Data partitioning is critical to data processing performance especially for large volume of data processing in Spark. Partitions in Spark won’t span across nodes though one node can contains more than one partitions. When processing, Spark assigns one task for each partition and each worker threa...
local_offer asp.net core local_offer identity core 2
The identity system in ASP.NET has evolved over time. If you are using ASP.NET Core, you probably found User property is an instance of ClaimsPrincipal in Controller or Razor views. Thus to retrieve the information, you need to utilize the claims.
local_offer python local_offer spark
This post shows how to derive new column in a Spark data frame from a JSON array string column. I am running the code in Spark 2.2.1 though it is compatible with Spark 1.6.0 (with less JSON SQL functions). Prerequisites Refer to the following post to install Spark in Windows. ...
local_offer angular local_offer lite-log
Problem When you follow Angular CLI installation guide in Windows, you may encounter the following error: ng is not recognized as an internal or external command The resolutions are available in the following link: ...
local_offer power-bi local_offer google-analytics
Power BI is my favourite BI and visualization tool as it is very simple yet powerful. It doesn’t only support traditional data sources like databases, CSV, JSON, XML and etc., but also supports emerging sources that are available in HDFS, Spark, R, Salesforce, Google Analytics and cloud platforms...
Kontext release v0.6.4
Kontext v0.6.4 is now released with a few changes. Changes Standalone pages Administrators can now add standalone pages. These pages are not linked...
Kontext release v0.6.3
Kontext v0.6.3 is now released with a few changes. Changes User profile enhancements User created latest columns are now also added to user profile page. ...
local_offer pyspark local_offer spark-2-x local_offer spark
Sometime it is necessary to pass environment variables to Spark executors. To pass environment variable to executors, use setExecutorEnv function of SparkConf class. Code snippet In the following code snippet, an environment variable name ENV_NAME is set up with value ...
Save DataFrame as CSV File in Spark
local_offer pyspark local_offer spark local_offer spark-2-x
Spark provides rich APIs to save data frames to many different formats of files such as CSV, Parquet, Orc, Avro, etc. CSV is commonly used in data application though nowadays binary formats are getting momentum. In this article, I am going to show you how to save Spark data frame as CSV file in b...
Kontext release v0.6.2
There are a number of small improvements and enhancements to Kontext in release v0.6.2. Changes The following are the main changes in this release: In site navbar for column site and articles pages, the author of column are added to feature the owner and column. ...
local_offer devops local_offer Azure
It might be useful to push artifact or build variables to your Azure websites environment variables in Release pipelines.
At the moment, tags are managed by the site administrators and there are already a number of tags created. Refer to the following link for more details: Existing tags If you think there is other tags we need to add, please let us ...
Kontext release v0.6.1
Kontext v0.6.1 is now released. New features Azure blob storage as file storage All the user uploaded images are now stored in Azure blob storage. Eac...
Kontext v0.6.1 System Architecture
local_offer kontext local_offer Azure
From release v0.6.1, Kontext platform is server-less and cloud native with horizontal scalabilities.
Kontext Pre-release v0.6.0
local_offer kontext local_offer Azure
Kontext website is now upgraded to ASP.NET Core 3.0 with many new features.