It is still difficult to move existing data warehouse jobs to #Hadoop, but helpful tools are emerging. A Hadoop tool known as #ClouderaNavigator Optimizer is one.
Offloading work from a high-cost data warehouse is sometimes seen as a first target for Hadoop commodity clusters. Moving over extract-transform-and-load (ETL), querying, and reporting jobs doesn't dramatically change the way business is done, but it can potentially curb data warehouse growth and costs.
But, even several years into the Hadoop era, migrating jobs to the distributed platform is not necessarily easy. Being able to figure out which jobs can move over without troublesome amounts of developer effort can help data managers concentrate their first efforts on the best pickings.
A Hadoop tool from Cloudera Inc. called Navigator Optimizer looks to help with that. It grew out of the company's 2015 purchase of Xplain.io, a company that sought to bring into Hadoop some database optimization capabilities akin to ones long familiar with SQL. The product went into general availability this summer.
"The tool allows people to start looking at the queries that are running on other platforms and see how they would act in our Hadoop environment," said Peter Wojciechowski, software engineering manager at Conversant, a digital marketing company that churns through large amounts of data to present personalized ads.
http://searchdatamanagement.techtarget.com/feature/Hadoop-tool-finds-low-hanging-fruit-for-migrating-data-warehouse-jobs
No comments:
Post a Comment