Vertica

Archive for the ‘Uncategorized’ Category

Connecting HP Vertica 7.x to Tableau Desktop 8.2

Connecting HP Vertica to Tableau Desktop from Vertica Systems on Vimeo.
Have you ever wanted to visualize your HP Vertica Analytics Platform with graphs, tables, maps, or other formats? The Tableau Desktop by Tableau Software visualization tool lets you do just that in a couple steps. Use the Tableau Desktop HP Vertica specific ODBC driver connector to access your data from HP Vertica and create different views for visual analysis. Watch this video to learn how to connect HP Vertica to Tableau Desktop using both the HP Vertica specific ODBC driver connector and the generic connector.

What’s New in Dragline (7.1.0): Resource Pool Routing

Resource Pool Routing from Vertica Systems on Vimeo.

HP Vertica 7.1.x introduces new features that allow you to dynamically reroute queries to secondary resource pools.

Use the new CASCADE TO parameter when creating or altering a resource pool to indicate a secondary resource pool to which queries can cascade and execute when they exceed the RUNTIMECAP of the pool on which they started running. This way, if a query exceeds its initial pool’s RUNTIMECAP, it can cascade to a designated secondary pool with a larger RUNTIMECAP instead of causing an error.

Because grant privileges are not considered on secondary pools, you can use this functionality to designate secondary resource pools where user queries can cascade to without giving users explicit permission to run queries on that pool.

Check out this video to learn more about dynamically rerouting queries.
For more information, see the documentation.

All Aboard the Modern Data Architecture Roadshow!

Following fresh on the heels of HP and HortonWorks’ partnership, HP is sponsoring the upcoming #Hadoop and the Modern Data Architecture roadshow. We are proud to be Gold sponsors of the event in Tyson’s Corner, VA on September 23rd, 2014. The day long workshop will focus on gaining insight into the business value derived from Hadoop, understanding the technical role of Hadoop within your data center, and looking at the future of Hadoop as presented by the builders and architects of the platform.

Our HP team at the event will focus on HAVEn, our big data analytics solution, and we’re sending some of our top experts from Vertica and Autonomy to answer any questions you might have. Vertica is HP’s next generation analytics platform and is focused on handling structured data. The HP Vertica engine is helping data analysts all over the world perform ad hoc queries in record time. With HAVEn, this is paired with HP Autonomy, which handles the unstructured data and analysis portion of your big data needs.

HAVEn pic

  • Hadoop/HDFS: Catalogue massive volumes of distributed data.
  • Autonomy IDOL: Process and index all information.
  • Vertica: Analyze at extreme scale in real-time.
  • Enterprise Security: Collect & unify machine data.
  • nApps: Powering HP Software + your apps.

Come by to the conference tomorrow to learn all about how HP HAVEn and Hortonworks work together to meet your Big Data needs. Get more information here.

We look forward to seeing you there!

That Giant Sucking Sound is Your Big Data Science Project

shutterstock_144005719

Vertica recently hosted its second annual Big Data Conference in Boston, Massachusetts. It was very well attended with over eight hundred folks, and about two hundred companies represented. We at Vertica love these events for a few reasons – first because our customers tend to be our best spokespeople because it’s such a sound product, but also because it’s a chance for us to learn from them.

In one of the sessions, the presenter asked the audience how many of them had Hadoop installed today. Almost all the hands went up. This wasn’t too surprising given that the session was on Hadoop and Vertica integration. Then the presenter asked how many of those folks had actually paid for Hadoop. Most of the hands went down. Then the presenter asked how many of those folks felt that they were getting business value out of their investment. Only two or three hands stayed up. This was eye-opening for us at HP, and it was surprising to the audience as well. Everyone seemed to think they were doing something wrong with Hadoop that was causing them to miss out on the value.

Over the next few days, I made a point to track down folks in the audience I knew and get their thoughts on what the issues were. Since most of them were Vertica customers I knew many of them already. I thought it would be helpful to identify the signs indicative of a big data science project – a project where a team has installed something like Hadoop and is experimenting with it in the hope of achieving some new analytic insights, but isn’t on a clear path to deriving value out of it. And some clear themes emerged. And these align with what I and my colleagues in the industry have been observing over the last few years. So, without further ado, here are the top five signs that you may have a big data science project in your enterprise:

    1. The project isn’t tied to business value, but has lots of urgency. Somebody on the leadership team went to a big data presentation and has hit the panic button. As a result, the team rushes ahead and does…something. And maybe splinters into different teams doing different things. We all know how well this will turn out.
    2. The technologies were chosen primarily because they beef up resumes. There’s so much hype around big data and the shortage of people with relevant skills that salaries are inflated. And in the face of a project with high urgency, nobody wants to stand still. So download some software! That open source stuff is great, right? While it’s generally true that multiple technologies can solve the same big data problems, some will fit with the business more readily than others. Maybe they’re easier to deploy. Maybe they don’t require extensive skill retooling for the staff. Maybe the TCO is better. Those are all good things to keep in mind during technology selection. But selecting technology for “resume polishing”? Not so much.
    3. The project is burdened with too much process. Most organizations already have well-defined governance processes in place for technology projects. And, so the reasoning goes, big data is basically just a bunch more of the same data and same old reporting & analysis. So when it’s time to undertake a highly experimental big data analytics project which requires agility and adaptability, rigid process usually results in a risk-averse mindset where failure at any level is seen as a bad thing. For projects like these, failure during the experimentation isn’t just expected, it’s a critical part of innovation.
    4. The “can’t-do” attitude. It’s been a well understood fact of life for decades that IT departments often feel under siege – the business always asks for too much, never knows what it wants, and wants it yesterday. As a result, the prevailing attitude in many IT teams today is to start by saying “no”, and then line up a set of justifications for why radical change is bad.
    5. The decision-making impedance mismatch. Sometimes, organizations need to move fast to develop their insights. Maybe it’s driven by the competition, or maybe it’s driven by a change in leadership. And…then they move slooooowly, and miss the opportunity. Other times, the change represents a big one with impact across the company, and requires extensive buy-in and consensus. And…then it moves at a breakneck pace and causes the organization to develop antibodies and reject the project.

     

    So if your organization has one or more big data projects underway, ask whether it suffers from any of these issues. If so, you may have a big data science project on your hands.

No limits: How Big Data changes competition Data drives the bottom line, and technology is no longer limiting your competitors.

This post is condensed from a full article in the latest issue of Discover Performance, HP Software’s hub for IT thought leadership.

Business technology has always been a world of give and take. The more you ask for, the longer you wait. As technology improves, we compromise less—and in the case of Big Data, we can’t afford to compromise at all.

Today’s Big Data analytics platforms are making it possible for organizations to give the business everything: all the data, from all sources, in all formats, in real time, without limits. It’s a novel idea for most organizations, but it’s in the DNA of young, agile companies. This new breed of business is killing the competition by holding technology to the highest possible standard and putting data at the top of the value pyramid.

To compete, the rest of the market will need to act urgently to change their data ideologies and reject limitations as they store and explore data, and serve analytics insights to the business.

Competing with the new natives
“Leading companies today are changing the user experience while it is happening,” says HP Vertica VP Joy King. King says Twitter, as an example, is using real-time analysis of user demographics and usage trends to deploy new features and UI variations on the fly to limited “cohort” populations. The result is that people who use Twitter differently get a different experience—immediately.

“Compare a company using that approach to a company that’s relying on a report that comes once a week or once a month,” King says. “Who do you think will win?”

To stay on top of the new competitive pace set by the data-native enterprise, join Discover Performance, and get all our Big Data insights in your inbox.

Welcome to the HP Vertica 2014 BDC!

1450057_57_z

Well all, it’s finally here. we’ve come a long way in the past months planning and preparing for this week, and we’re already off to a great start! Yesterday we kicked off the BDC with the Hackathon with datasets provided by Conservation international. Below are the names of the winning teams:

FIRST

Team 6

  • Tomáš Jirotka
  • Pavel Burdanov
  • Nikolay Golov

SECOND

Team 8

  • Phil Ivers
  • Talal Assir
  • Zach Taylor
  • Pedro Pedreira

THIRD

Team 4

  • Norbert Krupa
  • Karel Jakubec
  • Durga Nemani
  • Jun Yin

Next up we had a session of ASE testing and were delighted to find that all 9 of our participants passed the first round! In addition, our Best Practices forum was packed and ended up spilling over into a second room to make space for everyone (a good problem to have!).

IMG_7529

Following all that, we wrapped up the day with a fantastic reception with food and drinks for all.

Check back with us tomorrow for another update!

HP Vertica named “Best Columnar Database”


Winner

“Like the emerging category of in in-memory database technologies, columnar databases are deployed in market segments where speed of data analysis is paramount…”

On August 4th, we were pleased and excited to learn that the HP Vertica Analytics Platform was crowned the winner in this years Database Trends and Aplications readers choice awards for “Best Columnar database.” Here at HP we work tirelessly around the clock to deliver you the fastest, most cutting edge Big Data Platform in the world. This is yet another recognition of our hard work and dedication, and for that we thank you! You can read the whole story here.

We hope to see you at the BDC next week!

Get Started With Vertica Today

Subscribe to Vertica