javahadoophivehcatalog

Read table from Hive without map reduce


How to read from Hive without map reduce? I am trying to read a column from a table created on Hive, but I don't want the overhead that exist from map reduce. Basicaly I want to retrive the values from a table created on Hive without overhead and get them the fastest way possible.


Solution

  • Instead of MapReduce, you can use Tez or Spark as you execution engine in Hive.

    See hive.execution.engine in Hive Configuration Properties.

    There are also quite a few SQL engines compatible with the hive metadata e.g Presto, Spark SQL, Impala.