RAVI K YADAV

FIFA 2022

Qatar is hosting FIFA 2022. The host nation faced certain controversies which became insignificant when players like of Messi, Neymar, Ronaldo, Mbappe and others arrived in the middle of the field. This cup could be the last time many of these giants will represent their nation. Many people travelled to Qatar to see their stars…
UNNEST in BigQuery

BigQuery is a scalable and highly efficient data warehouse solution. As we move more and more existing databases into BigQuery with existing structure, some data types are little difficult to query and manipulate, such as “struct” data type. For example, we may get a data row that may look like this. In order to query…
Not Tomorrow but Today

There are many articles/blogs/books/videos to provide motivation and a sense of urgency to get up and do something. Here are some of the notes from one such blog Avoid these excuses: I am too tired. I don’t have the time. I am not capable. Someone else will do it. It’s too late now. Now is…
Numpy and dependencies hell.

Data mining or machine learning in general has greatly benefited from the development of Numpy library. Many years back when I was moving my tech stack from R to Python, numpy and pandas packages helped me master data mining in Python. Almost every data mining and machine learning package rely heavily on these two packages.…
India and US: Two largest democracies converge

Today PM. Modi of India and President Trump of USA came together in Houston to speak in front of one of the largest gathering of people from India. There are very few such moments a person (or the generation) can have in it’s lifetime, that defines many many years of international relationships. After the independence…
matplotlib and cycler dependency.

Anaconda is growing in popularity for managing python packages and versions across different environments. Anaconda version (from different packagers) comes with some prepackaged libraries. Sometimes, they libraries may have install order dependencies. One such dependency I have noticed is in matplotlib and cycler packages. I recently installed an anaconda package. Every time I tried to…
Scala and Spark compatibility issues

One of the major issue I have noticed working around with Spark and Scala is dependency between two packages. Scala developers are upgrading Scala little faster than folks at Apache Spark can absorb. At the time of writing, Scala 2.12.8 is already out, but Spark’s latest release 2.4.0 is still stuck at Scala 2.11.X. I…
Openness of internet

Internet was made popular by the notion of freedom, ease and speed. Ability to share information with anyone, by a click on button with a system located at any point of the world. Everyone knew the power of this new technology, and many feared the challenges that will come with this new technology. Internet has…
Is Saudi consulate safe?

Recently a well known (at least in Saudi Arabia) Saudi journalist was assassinated and secretly disposed from national consulate of Saudi Arabia in Turkey. Initially the Saudi government denied any knowledge and involvement in this brutality. After two weeks of constant pressure from USA and hard evidences from Turkey, government released statement that it was…
Germany survives the day.

What an amazing world cup we are having so far! People are changing their favorites each day. None of the soccer behemoths are standing up to their reputation. The so-called underdogs are emerging with-in each group. One of the nerve-wracking matches was played today between Germany and Sweden. German fans were expecting an easy win,…
FIFA World Cup 2018

Russia is hosting FIFA world cup this year. The hospitality of the nation may help change its image across the world. It may help increase the tourism as well. No wonder countries are willing to go to any extent to host FIFA world cup. No matter who is the host, the games will be nerve…
Android Studio upgrade and Google authentication

After few months, I downloaded my android application from GitHub to add some new features to that. I upgraded the SDK version and other dependencies. Strangely the google authentication using Firebase stopped working. Initially i thought the error was with version upgrades. One thing was not compatible with another libraries, or so. Fixed “Google Play…
Install sbt on openSUSE Tumbleweed

Steps: Open yast2 and add sbt repo: https://bintray.com/sbt/rpm/rpm. Search for sbt in yast tool. Install the selected software. Unless there was an error, you are set. Check sbt installation by typing commands in terminal: sbt –version or sbt about If you get successful results, then you are set. Else follow the error prompts to fix the issue.…
Start with Pentaho Kettle

Quick steps to start using Pentaho Kettle Data Integration tool (Community Edition). Pentaho Community 6.0 uses Java 1.7. Make sure Java 1.7 is installed on machine before starting working with this tool. Steps to start: Download the community edition data integration tool. Extract and move it to a specific folder. It works like eclipse. Download…
Database backup in mysql using terminal

I usually prefer MySQL workbench to take backups and restore them. But sometimes circumstances bring forward a machine that doesn’t contain workbench. Use command line utility in that case. These backups/dumps are nothing but SQL statements. mysqldump -u[username] -p [database_name]>[filename].sql To restore a backup. mysql -u[username] -p [database_name] <[file_name].sql If database name is not known then log into MySQL and…
What is “Host” key in Ubuntu

Right cntr key on your keyboard is default host key on ubuntu systems. Problem: After updating ubuntu on oracle virtualbox, my menu bar stopped displaying. solution: After annoyingly trying to search it in virtualbox settings and image settings, I finally found the solution. Press Host+c key and your will see the menu bar. Never realized…
Some helpful tips for Ruby on rails setup on fedora 21

1) Install RVM \curl -sSL https://get.rvm.io | bash -s stable 2) Install ruby dependencies and ruby older version. rvm install 1.8.7 rvm use 1.8.7 –default if use doesn’t work, then get reload rvm and try again. rvm get stable rvm use 2.0.0 –default 3) Go this url and install mysql http://dev.mysql.com/doc/mysql-repo-excerpt/5.6/en/linux-installation-yum-repo.html mysql configuration : $…
HttpHandlers!! What are they?

There are many features in asp.net that are left unused, much because, developers don’t know when to use them. Such a feature is HttpHandlers. When a request is made to IIS for an asp.net resource, like, .aspx, .ascx, etc, the asp.net worker process internally creates an instance of right HttpHandler for the request and effectively…
Access Output parameter in DAL in DNN

To keep the story short and simple. In DNN, sqldataprovider class, you can write a function like this. public override bool CreateItem(string itemname) { SqlParameter[] parameter = new SqlParameter[2]; parameter[0] = new SqlParameter(“@itemname”, itemname); parameter[1] = new SqlParameter(“@isadded”, SqlDbType.Bit); parameter[1].Direction = ParameterDirection.Output; SqlHelper.ExecuteNonQuery(ConnectionString, CommandType.StoredProcedure, NamePrefix + “sp_insertitem”, parameter); if…
MVC Design Pattern in Web Applications

Any modern-day website consist of a User Interface(UI), and a business logic that modifies data before sending to UI and modifies it again after receiving request from UI. There are many issues that come while designing websites with complex functionalities. But one important one is “How to modularized the UI functionality so that individual parts…
FIFA 2010 Final Spain v/s Netherlands

All Spain lovers it’s time for enjoy. Finally Spain did justice to ill-tempered players from Dutch-land. Orange was squeezed by the Spanish bulls. From Dutch side 8 players got yellow card and finally one got red (they play fast but they play bad). Spanish players were replying to Dutch in similar Fashion. Frustration among Spain…
FIFA 2010 Updates.

Am i dreaming? Is it really true? I cannot trust what I saw, finally its official, “FRANCE” is out of this world cup. Though Frank Ribery and Malouda tried to keep french dreams alive, but their partners were in no mood to stay in South Africa for more. It was expected of the french performance.…
FIFA-Mexico V/S France (Dream comes true)

A packed stadium is an ideal place for Mexican wave. More fascinating if the team playing comes out to be Mexico. The anxiety increases if they play against France. This happened today in Africa where Mexico fought a battle against mighty France. Trust me, they fought well and finally emerged as winners too. French team…
Fifa 2010 RSA v/s Uruguay

Whole Africa is celebrating, they can see all their stars in action. It’s a big event for all African nations, specially South Africa (RSA). Local support for home team is enormous. People cheer them up, every time they run towards opponent’s goal. But the poor performance by RSA team was not worth the efforts supporters…
FIFA-Brazil v/s North Korea (Fairest Game I ever watched)

Football season is on. Everybody is walking, talking and living football. Yesterday night Brazil played against North Korea (or Korea DPR). I was cheering for Brazil, off-course yes they have Kaka, and probably one of the best attack. But it was a pleasure to watch Koreans playing football. How often do you see players falling…
Whose Life is This?

This is one of the most common question that every person have to face at least once in his life. Who owns the life they are living. Long time back millions of sperms started their journey to reach the unfertilized egg inside fallopian tubes. Finally after swimming hard and faster than competitors, one was successful…
“Ticket to Mumbai”

“One ticket to Mumbai!! Please one Ticket to Mumbai!!”, I was shouting with all my strength but the person sitting at the counter could barely hear it. “Train will come after 5 hours, take the change”, Shouted the man. I tried hard but couldn’t count the money he returned. “I have to sleep, I have…