From the course: Analyzing Big Data with Hive
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Types of data manipulation functions - Hive Tutorial
From the course: Analyzing Big Data with Hive
Types of data manipulation functions
- [Instructor] Here let's look at Hive functions we can use to manipulate our data. Now, Hive functions are built-in or extensions to the HiveQL language that allow for manipulation of data. In previous clips we've already used one of these with the CSV custom processor. There are four different types of Hive functions I want to touch on. The first one are string functions, so they deal with text-based data, and this is a type of data you'll see a lot, it often is categorical in nature, and there are a lot of different things you're going to want to know about it when you want to work with that data. The next are mathematical functions, and there are the basic math operators, you know, plus, minus, divide, all that kind of stuff, but there's also other functions that you can use to do things like find the absolute value of something, or find the square root of something, so any of the more advanced mathematical functions are possible as well. Now, dates are special. In every data…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.