I’m trying to recreate an excel pivot table in hive by selecting two variables based on a condition and then sum over the grouping variable.

We have a centralized RDBMS that backs the metastore, is it possible to set up multiple metastore instances behind a load balancer (all accessing the same RDBMS server)? Are the metastore instances stateful or need to know about other instances to avoid race conditions?

if we have a HIVE query where I have applied “where” clause two filters

I have a field: Username.
the ouput is lastname,firstname (No extra space after the comma)

I want to query all tables/columns metadata in hive. The way this is done in other databases like mssql, postgresql is to query information_schema views, but i don’t see anything like that in hive.
Can someone confirm is information_schema doesn’t exists in hive. If it doesn’t exists what would be a way to query metadata ??

I have a table with 5 columns: date – date of temperature measurement, process_id – identifier of the process for which the temperature is measured, batch_id – identifier of the upload batch, code – upload code, value – temperature value for the process.

I encountered an issue while using the latest version of Hive, 4.0.0. I am not sure if this is a bug. The details are as follows: I am using Hadoop version 3.3.6 and have set up a fully distributed cluster. The Hive version is 4.0.0, with one master server and one client. Currently, I am connecting to Hive via the Beeline client. When executing a join in Hive, I encountered the following error:

I have a below table which has 5 columns. The column CLASS have data with empty arrays.

C:Usershp>cd C:hivebin