The Big Data Virtual Chapter provides a community for SQL Server professionals to learn about the use of Microsoft SQL Server software with Hadoop and related technologies.

Microsoft is making significant investments to create the next gen ‘Big Data’ Platform. The goal of the Big Data Virtual Chapter is provide a PASS community for Microsoft SQL Server professionals to learn about the use of Microsoft SQL Server software with Hadoop and related technologies. Join us to share experiences, problems and solutions, as well as learn new skills for building large-scale Hadoop-based systems using the Microsoft platform.

Paco Gonzalez -- Big Data Virtual Chapter Leader bigdata@sqlpass.org

Follow us on twitter: @PASSBigDataVC

Watch our you tube channel for previous recordings: http://www.youtube.com/channel/UCkOKmMW_LEsACOqE8C1RWdw

 

Next Meeting: Tue, Mar 18 2014

SQOOP - Taking relational data to Hadoop and back again

Language: English
Event Type: Online
Online Meeting URL: https://attendee.gotowebinar.com/register/6755077640845514498
RSVPURL: https://attendee.gotowebinar.com/register/6755077640845514498

SQOOP or SQL to Hadoop is a tool in the Hadoop ecosystem that lets you take your "SQL" data and put it into Hadoop or vice versa.  The use cases are numerous.  You can have Hadoop perform the heavy lifting using Map Reduce and then use SQOOP to take the results and put them in "SQL".  You can have Hadoop act as your Data Warehouse and use SQOOP to do your daily loads from your relational DB into Hadoop.

SQOOP is a command line tool but don't let that put you off.  On a recent customer engagement we used SQOOP to load Hadoop and it performed very well.

This session will look at SQOOP and the plethora of options available to you on the command line.  If you want to learn about SQOOP then this is the session for you.

Allan is the joint owner of Copper Blue Consulting Ltd (http://www.copper-blue.com/).  Copper Blue Consulting focus on getting the right data to the right people at the right time and in the right format.  We are passionate about data integrity and suitability.  We have worked all over the world in a variety of industries.and on projects both large and small.  Allan focusses on data and process integration using tools such as SSIS, SQOOP, Pig, ZeroMQ and RabbitMQ.

When

iCal
UTC : Tue, Mar 18 2014 18:00 - 19:00
Event Time : Tue, Mar 18 2014 14:00 - 15:00 Eastern Daylight Time
Your Local Time: Tue, Mar 18 2014 18:00 - 19:00

Where

http://bigdata.sqlpass.org/
Live Meeting. The URL will display the day of the event

Direction: None

Featured Presentation

SQOOP - Taking relational data to Hadoop and back again

Speaker: Allan Mitchell, Principal Consultant Copper Blue Consulting

Summary: SQOOP or SQL to Hadoop is a tool in the Hadoop ecosystem that lets you take your "SQL" data and put it into Hadoop or vice versa. The use cases are numerous. You can have Hadoop perform the heavy lifting using Map Reduce and then use SQOOP to take the results and put them in "SQL". You can have Hadoop act as your Data Warehouse and use SQOOP to do your daily loads from your relational DB into Hadoop. SQOOP is a command line tool but don't let that put you off. On a recent customer engagement we used SQOOP to load Hadoop and it performed very well. This session will look at SQOOP and the plethora of options available to you on the command line. If you want to learn about SQOOP then this is the session for you.

About Allan: Allan Mitchell is a SQL Server MVP and runs Copper Blue Consulting with Jen Stirrup. He has worked all over the world helping customers integrate their data and processes. He has implemented large Hadoop installations as well as event stream processing solutions.

Attachments