pawel.ciesla – Big Data & ETL

How to resolve: Got permission denied while trying to connect to the Docker daemon socket at…: dial unix /var/run/docker.sock: connect: permission denied

Post author:pawel.ciesla
Post published:12 July 2020
Post category:Articles / Docker
Post comments:0 Comments

After docker installation you can encounter error: Got permission denied while trying to connect to the Docker daemon socket at unix:///var/run/docker.sock: Get http://%2Fvar%2Frun%2Fdocker.sock/v1.40/images/json: dial unix /var/run/docker.sock: connect: permission denied Solution…

Apache Kafka: How to delete data from Kafka topic?

Post author:pawel.ciesla
Post published:15 June 2020
Post category:Apache Kafka / Articles / Big Data
Post comments:0 Comments

When working with Apache Kafka, there may be a situation when we need to delete data from topick, because e.g. during testing junk data was sent, and we have not…

How to install Microsoft Teams on Windows 7 or Windows 10?

Post author:pawel.ciesla
Post published:29 March 2020
Post category:Articles / Tips
Post comments:0 Comments

Recently, Microsoft Teams has been gaining more and more popularity among users. All in all, it is not surprising, because currently on the market it is difficult to find a…

How to install Microsoft Teams on Ubuntu 18.04 (Linux)?

Post author:pawel.ciesla
Post published:29 March 2020
Post category:Articles / Tips
Post comments:0 Comments

Recently, Microsoft Teams has been gaining more and more popularity among users. All in all, it is not surprising, because currently on the market it is difficult to find a…

How to use Lombok @Builder in abstract java class?

Post author:pawel.ciesla
Post published:28 March 2020
Post category:Articles / Tips
Post comments:0 Comments

The answer is - you cannot, but you can use @SuperBuilder annotation instead of @Builder. @SuperBuilder was introduced as experimental feature in lombok v1.18.2.@SuperBuilder's toBuilder feature and limited support for…

How to use Pivot SQL function in Microsoft SQL Server

Post author:pawel.ciesla
Post published:26 March 2020
Post category:Articles / Databases / SQL Server
Post comments:0 Comments

Sometimes you got business requirements to create new view or dashboard and to do this you need to convert rows to columns. You can transpose them on two ways: using…

Apache Spark: Convert DataFrame to DataSet – Scala

Post author:pawel.ciesla
Post published:26 March 2020
Post category:Apache Spark / Articles
Post comments:0 Comments

Many times you might want to have strong typing on your data in Spark. The best to get it is to DataSet insted of DataFrame. In this post I give…

Apache Spark: ReduceByKey vs GroupByKey – differences and comparison

Post author:pawel.ciesla
Post published:26 March 2020
Post category:Apache Spark / Articles
Post comments:0 Comments

In this post I will try to introduce you to the main differences between ReduceByKey and GroupByKey methods and why you should avoid the latter. But why? The answer is…

Oracle Database: How to check if the table has a primary key. Types of constraints

Post author:pawel.ciesla
Post published:24 March 2020
Post category:Articles / Databases / Oracle / SQL Developer
Post comments:0 Comments

A constraint is a rule that you define and its task is to protect the table from clutter that may arise as a result of adding incorrect or incomplete data.…

How to run Microsoft SQL Server database using docker and docker-compose

Post author:pawel.ciesla
Post published:23 March 2020
Post category:Articles / Databases / SQL Server
Post comments:0 Comments

In this post I will show you how you can easily run Microsoft SQL Server Database using docker and docker-compose. Microsoft provides official images in docker hub, so you can…

Subscribe to be up to date