Hadoop User Group (HUG) Ireland packed the house with a great evening on Apache Mesos/Myriad and an overview of Airbnb’s Predictive Model After a restful holiday season, the new year kicked off in style for Hadoop User Group (HUG) Ireland with its opening 2016 event at Synchronoss on January 11th. We heard from Mary Mangru, President of DAMA Ireland about ...
LinkedIn’s new “Rewinder” tool outshines Apache Resource Manager and Job History Server on its Hadoop clusters… SIREn Solutions announces Kibi Another week has passed where the team at Sonra have been impressed with developments in our big data community. LinkedIn is a big data company, which also happens to do other stuff that pays the bills and has faced the ...
Technology and Big Data movers... A week of wonder in review... This week saw a number of exciting ideas and announcements reach the Tech community that signals how it can positively impact the world. Taking a look at some of the highlights, I think we can get excited about the following: Burak Yavuz , Software Engineer at Databricks blogged about ...
Today we will have a look what happens when we place a filter condition into an outer join. We will also have a look at how this compares to placing the filter condition into the WHERE clause. Finally we'll have a look where this could be useful. Let's first create some sample data.
create table customer (
ALTER TABLE customer
add CONSTRAINT pk_customer PRIMARY KEY (cust_id);
create table customer_loc (
ALTER TABLE customer_loc
add CONSTRAINT pk_customer_loc PRIMARY KEY (customer_loc_id);
insert into customer values (1,'Gold');
insert into customer values (2,'Gold');
insert into customer values (3,'Silver');
insert into customer_loc values (1,1,'Dublin');
insert into customer_loc values (2,2,'Paris');
insert into customer_loc values (3,4,'Berlin');
analyze table customer compute statistics;
analyze table customer_loc compute statistics;
Let's run our first outer join ...
I recently needed to convert a comma separated list of values in a table column to a column where each value in the list gets its own row in a table. So first of all let's create such a table. I have limited the number of comma separated values that will be created to 12. View Listing 1 To convert ...