Category: Hive

Interview Questions of Hive

August 12, 2016 by Arti Khedkar

Filed under Hadoop, Hive

Last modified August 12, 2016

Interview Questions of Hive What is Hive? Where is Hive best suitable? What are the different types of tables available in HIve? Is Hive suitable to be used for OLTP systems? Why? Can a table be renamed in Hive? Can we change the data type of a column in a hive table? What are the different types of tables available in Hive? Is Hive suitable …

Implementing basic SQL Update statement in Hive

June 27, 2016 by S4

Filed under Hadoop, Hive

Last modified June 27, 2016

Implementing basic SQL Update statement in Hive Hive is not meant for point to point queries and hence sql update functionality would be least required in hive that should be the reason hive doesn’t have update functionality for rows or rather individual columns in a row. There would be cases you find a much more suitable use case in hive, but the same can’t be …

Joins with plain Map Reduce or Multiple Inputs

June 27, 2016 by S4

Filed under Hadoop, Hive

Last modified June 27, 2016

Joins with plain Map Reduce or Multiple Inputs Being a map reduce developer I’d never recommend to write joins of data sets using custom map reduce code. You have very intelligent and powerful tools handy in hadoop like hive and pig that can easily join huge data sets with the choice of join like inner, outer etc. But if such a scenario arises where you …

Optimizing Joins in hive Sorting Java Heap issues with hive joins

June 27, 2016 by S4

Filed under Hadoop, Hive

Last modified June 27, 2016

Optimizing Joins in hive/Sorting Java Heap issues with hive joins Optimizing Joins in hive/Sorting Java Heap issues with hive joins, In hadoop we tent to use hive extensively since it is SQL like language and easier in framing our jobs with stored structured data. (Even Pig is great but still needs a little time to get comfortable with Pig Latin). But as beginners we often …