The Match() function in QlikView is used to match the value of a string on expression with the data value present in a column. It is similar to the in function that we see in SQL language. It is useful to fetch rows containing specific strings and it also has an extension in form of wildmatch() function.
Let's consider the following data as input file for the examples illustrated below.
As AI/ML engineers, we spend countless hours experimenting with datasets, tuning hyperparameters, and optimizing model…
For nearly 70 years, Dijkstra’s algorithm has been the cornerstone for computing shortest paths in weighted graphs —…
PySpark is one of the most powerful distributed computing tools in the modern data engineering landscape. Among its…
As a Senior Spark Developer and ETL Expert, I often get asked how to harness Apache Spark’s immense processing power…
As a senior data engineer, witnessing the transformation of our discipline is truly exciting. Let’s dive deeper into…
After seeing response to my first writeup on Spark caching, I decided to write article on memory management in spark…
Hello Friends, I am using Spark for Data analysis & reporting since last 5+ years and came across many problems while…
Hello All, In this post I am going to write about few optimizations in hive in terms of Partitioning, I/O and…
Hello All, In this post I will going to cover one small but important concept of SerDe w.r.
What is Apache Tez? If you are an Hadoop developer then you might have heard of executions engines used in Hadoop jobs…