Tuesday 26 July 2016

difference between table in a single sql query

IF you have tables A and B, both with column C, here are the records, which are present in table A but not in B:
SELECT A.*
FROM A
    LEFT JOIN B ON (A.C = B.C)
WHERE B.C IS NULL
To get all the differences with a single query, a full join must be used, like this:
SELECT A.*, B.*
FROM A
    FULL JOIN B ON (A.C = B.C)
WHERE A.C IS NULL OR B.C IS NULL
What you need to know in this case is, that when a record can be found in A, but not in B, than the columns which come from B will be NULL, and similarly for those, which are present in B and not in A, the columns from A will be null.

how to delete duplicate records in sql in single query


create table Employee (id int, name varchar(50))

insert into Employee values (1,'raja')

insert into Employee values (2,'raja')

insert into Employee values (3,'krishna')

insert into Employee values (4,'krishna')

insert into Employee values (5,'ramana')

insert into Employee values (6,'prakash')

delete
from table T1, table T2
where T1.dupField = T2.dupField
and T1.uniqueField > T2.uniqueField

delete
from Employee T1, table T2
where T1.name = T2.name
and employee_id.id > T2.employee_id

Friday 8 July 2016

Executor.execute() vs ExecutorService.submit()

1) Both submit() and execute() methods are used to submit a task to Executor framework for asynchronous execution.

2) Both submit() and execute() can accept a Runnable task.

3) You can access submit() and execute() from the ExecutorService interface because it also extends the Executor interface which declares the execute() method.

Apart from the fact that submit() method can return output and execute() cannot, following are other notable differences between these two key methods of Executor framework of Java 5.

1) The submit() can accept both Runnable and Callable task but execute() can only accept the Runnable task.

2) The submit() method is declared in ExecutorService interface while execute() method is declared in the Executor interface.

3) The return type of submit() method is a Future object but return type of execute() method is void.

Read more: http://javarevisited.blogspot.com/2016/04/difference-between-ExecutorServie-submit-vs-Executor-execute-method-in-Java.html#ixzz4DooQVq5V

Wednesday 29 June 2016

what is zookeeper,role of zookeeper.

There are many confusion about zookeeper,what zookeeper is ?.

What is the role of zookeeper .What zookeeper does.

In Simple term,Zookeeper ensure people or node which are agreed to work together ,should work together.

Wednesday 15 June 2016

Scaling the Read Query Load On MongoDB server



Requirement Overview:We are capturing all activity on Jobs In mongoDB like view ,apply,view source,apply source etc.There is lots of read query fired on real times to get stats about jobs.
We need to scale our read load so that we can serve all read request without any delay.


Approach :There are 2 ways of reducing read load on Primary MongoDB server.
       
  1. Distributing the Data on Multiple Node (Sharding).
            
     2.  Use secondary mongodb node for read query.


By default, an application directs its read operations to the primary member in a replica set.        




Since Our data size is not large ,we have not implemented sharding .But read operation are very high on the same data Set.
Code Snippet:


var collection =dataLoggerDB.collection(currentCollection,{readPreference:'secondaryPreferred'});


Read Preference Options:


Read Preference Mode
Description
Default mode. All operations read from the current replica set primary.
In most situations, operations read from the primary but if it is unavailable, operations read from secondary members.
All operations read from the secondary members of the replica set.
In most situations, operations read from secondary members but if no secondary members are available, operations read from the primary.
Operations read from member of the replica set with the least network latency, irrespective of the member’s type.

Thursday 9 June 2016

basic difference between column oriented DB vs Row Oriented DB


basic difference between column oriented DB vs Row Oriented DB :

 1.Scan Less data as compare to row base data base while doing aggregation etc.
 2.Better compress for column data.

Tuesday 7 June 2016

Promises in AngularJS, Explained as a Cartoon


One morning, a father says to his son: "Go and get the weather forecast, son!"

Every Sunday morning, a father asks his son to go and find out the weather forecast for the afternoon, by using his super-strong telescope to look across the horizon from the tallest hill by their house. The son promises his dad he will go and get the weather forecast. He creates a promise with his dad at the door when he leaves.
At that point, the dad decides if the weather tomorrow is good, he'll prepare a fishing trip for tomorrow. If it's bad he won't. Also, if the son is unable to get a forecast, he'll stay in as well.
After 30mins or so, the son comes back. Different things happen from week-to-week:

Outcome A) Weather forecast retrieved! Sunshine :-)

The son succeeded in retrieving the weather forecast, clear skies and sunshine! The promise was fulfilled (the son kept his promise) and the dad decided to pack up for the fishing trip for Sunday.


Outcome B) Weather forecast retrieved! Cloudy and rain :-(

The son succeeded in retrieving the weather forecast, but it looked like cloudy and rain. The promise was fulfilled but dad decided to stay in because of the bad weather.

Outcome C) Couldn't get the weather forecast :-/

The son failed to retrieve the forecast, there was a problem; it was way too foggy to see what weather was coming over the hills. The promise the son made when he left was broken - the promise was rejected! The dad decided to stay in, it wasn't worth the risk.




How does this look in code?

The dad is controlling the logic in this situation, and he's dealing with the Son as if he's a service.
We've already stated the logic, the father asks the son to get the weather forecast, and as the son can't tell him immediately, and the father has other things to do while he waits, the son makes a promise he shall return with the weather. When the dad has the forecast, he'll either pack up the boat, or stay inside. The important thing to note here, is the son's trip up the hill shouldn't 'block' the dad from doing anything, so this is why the situation is perfect for the creation of a promise, which can be resolved (fulfilled or rejected) later on.
Using Angular's then() function we can specify what the Dad needs to do in the event of each outcome. The then() function accepts 2 functions as parameters: a function to be executed when the promise is fulfilled, and a function to be executed when the promise is rejected.

Controller: FatherCtrl

The father is controlling the situation here:

        // function somewhere in father-controller.js
        var makePromiseWithSon = function() {
            // This service's function returns a promise, but we'll deal with that shortly
            SonService.getWeather()
                // then() called when son gets back
                .then(function(data) {
                    // promise fulfilled
                    if (data.forecast==='good') {
                        prepareFishingTrip();
                    } else {
                        prepareSundayRoastDinner();
                    }
                }, function(error) {
                    // promise rejected, could log the error with: console.log('error', error);
                    prepareSundayRoastDinner();
                });
        };
    

Service: SonService

The Son is being used as a service, he climbs the hill and tried to see the weather. We'll suppose when the son is looking through his telescope and looking for the approaching weather, it's analogous to using a weather API, in the sense that it's an asynchronous operation, he may get a variable answer, and there may be a problem (say, a 500 response, foggy skies).
The response from the 'Fishing Weather API' will be returned with the promise, if it was fulfilled. It will be in the format: { "forecast": "good" }
    app.factory('SonService', function ($http, $q) {
        return {
            getWeather: function() {
                // the $http API is based on the deferred/promise APIs exposed by the $q service
                // so it returns a promise for us by default
                return $http.get('http://fishing-weather-api.com/sunday/afternoon')
                    .then(function(response) {
                        if (typeof response.data === 'object') {
                            return response.data;
                        } else {
                            // invalid response
                            return $q.reject(response.data);
                        }

                    }, function(response) {
                        // something went wrong
                        return $q.reject(response.data);
                    });
            }
        };
    });
    



Summary

This analogy demonstrates the asynchronous nature of the request the dad makes to his son, for the weather forecast. The dad doesn't want to wait at the door in anticipation when the son leaves, because he has other stuff to do. Instead, he makes a promise at the door, and decides what will happen in either of the 3 scenarios (good weather/bad weather/no forecast). The son immediately gives a promise to his dad when he leaves, and will resolve or reject it on his return.
The son is dealing with an asynchronous service (searching the sky with his telescope/using a weather API) to get data, but all of this is correctly abstracted away from his old man, who doesn't really understand technology!
source
http://andyshora.com/promises-angularjs-explained-as-cartoon.html