Tag: SQL

Feed: Cloudera Engineering Blog » Hadoop. Author: Christophe Bisciglia. For the last few months, we’ve been working with the TVA to help them manage hundreds of TB of data from America’s power grids. As the Obama administration investigates ways to improve our energy infrastructure, the TVA is doing everything they can to keep up with the volumes of data generated by the “smart grid.” But as you know, storing that data is only half the battle. In this guest blog post, the TVA’s Josh Patterson goes into detail about how Hadoop enables them to conduct deeper analysis over larger data ... Read More

Feed: Cloudera Engineering Blog » Hadoop. Author: Aaron Kimball. In addition to providing you with a dependable release of Hadoop that is easy to configure, at Cloudera we also focus on developing tools to extend Hadoop’s usability, and make Hadoop a more central component of your data infrastructure. In this vein, we’re proud to announce the availability of Sqoop, a tool designed to easily import information from SQL databases into your Hadoop cluster. Sqoop (“SQL-to-Hadoop”) is a straightforward command-line tool with the following capabilities: Imports individual tables or entire databases to files in HDFS Generates Java classes to allow you ... Read More

Feed: Cloudera Engineering Blog » Hadoop. Author: Tom White. This piece is based on the talk “Practical MapReduce” that I gave at Hadoop User Group UK on April 14. 1. Use an appropriate MapReduce language There are many languages and frameworks that sit on top of MapReduce, so it’s worth thinking up-front which one to use for a particular problem. There is no one-size-fits-all language; each has different strengths and weaknesses. Java: Good for: speed; control; binary data; working with existing Java or MapReduce libraries. Pipes: Good for: working with existing C++ libraries. Streaming: Good for: writing MapReduce programs in ... Read More

Feed: Cloudera Engineering Blog » Hadoop. Author: Christophe Bisciglia. There’s been a lot of buzz about Apache Hadoop lately. Just the other day, some of our friends at Yahoo! reclaimed the terasort record from Google using Hadoop, and the folks at Facebook let on that they ingest 15 terabytes a day into their 2.5 petabyte Hadoop-powered data warehouse. But many people still find themselves wondering just how all this works, and what it means to them. We get a lot of common questions while working with customers, speaking at conferences, and teaching new users about Hadoop. If you, or folks ... Read More

Feed: IBM Big Data & Analytics Hub - All Content. Author: cindy-russell. It seems that we’re reaching the point where the Internet of Things (IoT) is moving from the domain of enthusiastic early-adopters to the more challenging, more profitable territory of mainstream enterprise technology.In particular, companies in industries that depend on the attention and loyalty of large numbers of consumers – retail and air travel, for example –have already woken up to the possibilities. If you can recognize an individual customer’s mobile device as they move through an airport or walk past your store, you can potentially take action to improve that ... Read More

Feed: Percona Database Performance Blog. Author: Kenny Gryp. Kenny Gryp and Ramesh Sivaraman  | June 23, 2017 |  Posted In: Group Replication, High-availability, InnoDB, Percona XtraDB Cluster PREVIOUS POST Thank you for attending the Wednesday, June 21, 2017 high availability webinar titled Percona XtraDB Cluster, Galera Cluster, MySQL Group Replication. In this blog, I will provide answers to the Q & A for that webinar. You can find the slides and a recording of the webinar here. Is there a minimum MySQL server version for Group Replication? MySQL Group Replication is GA since MySQL Community 5.7.17. This is the lowest version that you ... Read More

Feed: What's New. The Quick Start builds an AWS-validated architecture that includes:• An Amazon Redshift data warehouse, which is an enterprise-class relational database query and management system. • Tableau Server for business intelligence (BI) and data visualization capabilities, and a sample Tableau Server dashboard that demonstrates how to connect to multiple data sources in AWS.• A sample dataset that's loaded to an Amazon Redshift cluster to support efficient creation of aggregates at large data scale, and an associated SQL worker instance. You can also choose to load your own dataset.• Amazon Relational Database Service (Amazon RDS) with PostgreSQL, to provide ... Read More

Feed: Planet DB2 Author: DB2Night Replays Follow @Roger_E_Sanders Follow @jrockwood Special Guests: Roger Sanders and Jessica Rockwood, IBM Breaking Db2 (LUW) News from the IBM Canada Lab 100% of our audience learned something! Shocker! "DB2 for LUW" is now just "Db2". Mainframe folks will still have to type out "Db2 for z/OS". Some IBM products, or solution offerings, have been renamed. What's new? Well, V11.1.2.2 is new, and there are plenty of goodies and enhancements in it. There's a new DSM release. There are new (free) editions of Db2. A PDF is available for reference, but make sure you download ... Read More

Feed: Cloudera Engineering Blog » Hadoop. Author: Aaron Kimball. Editor’s note (added Nov. 9. 2013): Valuable data in an organization is often stored in relational database systems. To access that data, you could use external APIs as detailed in this blog post below, or you could use Apache Sqoop, an open source tool (packaged inside CDH) that allows users to import data from a relational database into Apache Hadoop for further processing. Sqoop can also export those results back to the database for consumption by other clients. Apache Hadoop’s strength is that it enables ad-hoc analysis of unstructured or semi-structured data. Relational databases, by contrast, ... Read More

Feed: What's New. Amazon Athena is now available in the Asia Pacific (Singapore) and Asia Pacific (Tokyo) regions. Amazon Athena is an interactive query service that makes it easy to analyze data in Amazon S3 using standard SQL. Athena is serverless, so there is no infrastructure to manage, and you pay only for the queries that you run. With the latest release customers can now use Amazon Athena in the following regions: US East (Northern Virginia), US East (Ohio), US West (Oregon), Europe (Ireland), Asia Pacific (Singapore), and Asia Pacific (Tokyo). To learn more, please visit the Amazon Athena page ... Read More