Hive and Hue/Beeswax Frequently Asked Questions
(Doc ID 1498351.1)
Last updated on NOVEMBER 30, 2022
Applies to:
Big Data Appliance Integrated Software - Version 1.1.0 and laterLinux 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? |
| Does Cloudera Distribution for Hadoop (CDH) support automatic compaction for 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? |
| 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 |