Top "Hiveql" questions

hive 0.13 msck repair table only lists partitions not in metastore

I'm trying to use Hive(0.13) msck repair table command to recover partitions and it only lists the partitions not added …

hive hiveql hadoop2

How to specify column list in hive insert into query

I have just installed and configured Apache Hive version 1.1.0. Then I have created a table by quering this query: create …

hadoop hive hiveql

metastore_db created wherever I run Hive

Folder metastore_db is created in any directory where I run Hive query. Is there any way to have only …

hive hiveql

What is the replacement of NULLIF in Hive?

I would like to know what is the replacement of NULLIF in Hive? I am using COALESCE but its not …

sql hive hiveql hadoop2

How do you insert data into complex data type "Struct" in Hive

I'm completely new to Hive and Stack Overflow. I'm trying to create a table with complex data type "STRUCT" and …

hadoop struct hive hiveql complextype

Hive: Is it possible to rename an existing hive database?

There seems to be a similar requirement at: https://issues.apache.org/jira/browse/HIVE-4847 However, when I tried the …

hadoop hive hiveql

Wrong result for count(*) in hive table

I have created a table in HIVE CREATE TABLE IF NOT EXISTS daily_firstseen_analysis ( firstSeen STRING, category STRING, circle …

hadoop hive hiveql

Hive: More clean way to SELECT AS and GROUP BY

I try to write Hive Sql like that SELECT count(1), substr(date, 1, 4) as year FROM *** GROUP BY year But Hive …

hadoop hive hiveql

Hive Union Group By Error

In the following query, I am trying to count up the distinct, and total occurences of the column "primary" and …

hadoop hive hiveql

How to access the last element in an array ?

In my hive table, the session field is a string in format like: ip-sessionID-userID or area-sessionID-userID There's 3 or 4 fields separated …

arrays hive hiveql