My Oracle Support Banner

Hive and Hue/Beeswax Frequently Asked Questions (Doc ID 1498351.1)

Last updated on OCTOBER 14, 2019

Applies to:

Big Data Appliance Integrated Software - Version 1.1.0 and later
Linux x86-64

Purpose

 This document provides answers to frequently asked questions about the Hive and Hue Components installed on Oracle Big Data Appliance (BDA).

Questions and Answers

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Questions and Answers
 What is HIVE?
 What is Beeswax?
 Is Hive Shell recommended to use over Beeswax and vice versa?
 What release of Cloudera Manager manages Hive?
 Where does HIVE store Metadata?
 Where does BeesWax store Metadata?
 Does HIVE and Beeswax share Metastore on BDA?
 Where to find mysql user/password for HIVE on BDA?
 Can Hue/Beeswax user select/update tables created in Hive Shell?
 Can Hue/Beeswax user create a table?
 How to setup Authorization in Hive Shell?
 How to setup Authorization in Beeswax?
 Is there access to Hive with the Oracle R Connector for Hadoop? 
 Are complex Hive data types such as arrays, maps and structures suported by Oracle R Connector for Hadoop V2.0? 
 Are AVRO formatted files in Hive tables suported by Oracle R Connector for Hadoop V2.0? 
 Can Hive queries be generated from R language constructs?
 How can horizontal scrolling be enabled in Hue Beeswax?
 How can the Hive examples under /usr/share/doc/hive-*/examples be run?
 Can the Apache Hive Windowing and Analytics functions planned for Hive 0.11 be backported on top of BDA v2.3.1 CDH 4.4?
 In BDA V3.0.*/CDH 5.0.* what are the recommended values for these 3 Hive Java Heap sizes?
 For some hive queries, we got heap size error "org.apache.hadoop.mapred.YarnChild: Error running child : java.lang.OutOfMemoryError: Java heap space" should we increase: ApplicationMaster Java Maximum Heap Size, Map Task Maximum Heap Size, and Reduce Task Maximum Heap Size default value on the BDA of 787.69 MB?
 Is there a skipTrash option when a user drops a table in Hive similar to hdfs?
 What would be the best way to set up a data mart in impala/hive when using large partitioned tables?
 In the case above will querying a a view with: create view table_view as select * from table; behave exactly the same as selecting directly from the table?
 Is ORC format or ACID supported for hive updates in the current or upcoming versions?
 If we want to use Hive using ORC is it supported, we have a use case to update the dimension data?
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.