Top "Hiveql" questions

HiveQL UNION ALL

I have table_A: id var1 var2 1 a b 2 c d Table_B: id var1 var2 3 e f 4 g h …

hadoop union hive hiveql

Comparing two tables for equality in HIVE

I have two tables, table1 and table2. Each with the same columns: key, c1, c2, c3 I want to check …

sql join hive left-join hiveql

Hive - Converting a string to bigint

Suppose I have a string like '00321' and I want to convert it into a BIGINT in Hive, how …

hive hiveql data-conversion

Hive doesn't support in, exists. How do I write the following query?

I have two tables A and B that both have a column id. I wish to obtain ids from A …

hadoop hive hiveql

Delete a database with tables in Hive

I have a database in hive which has around 100 tables. I would like to delete the whole database in a …

database hive hiveql

Transferring hive table from one database to another

I need to move a hive table from one database to another. How can I do that?

hive hiveql

Difference between `load data inpath ` and `location` in hive?

At my firm, I see these two commands used frequently, and I'd like to be aware of the differences, because …

sql hadoop hive hdfs hiveql

HIVE - INSERT OVERWRITE vs DROP TABLE + CREATE TABLE + INSERT INTO

I'm doing some automatic script of few queries in hive and we found that we need time to time clear …

hive hiveql create-table

Looping using Hiveql

I'm trying to merge 2 datasets, say A and B. The dataset A has a variable "Flag" which takes 2 values. Rather …

hive hiveql

No partition predicate found for Alias even when the partition predicate in present in the query

I have a table pos.pos_inv in hdfs which is partitioned by yyyymm. Below is the query: select DATE_…

hadoop hive cloudera hiveql hue