Top "Hiveql" questions

Variant of SQL used in the Apache Hive data warehouse infrastructure.

Hive's unix_timestamp and from_unixtime functions

I am under the impression that unix_timestamp and from_unixtime Hive functions are 'reverse' of each other. When I …

hive hiveql
hive Expression Not In Group By Key

I create a table in HIVE. It has the following columns: id bigint, rank bigint, date string I want to …

group-by hive hiveql
Hive - LIKE Operator

I can not figure out how I deal with that problem: This is my Data: Table1: Table2: BRAND PRODUCT SOLD …

hadoop hive hiveql sql-like
how to write case and group by in hive query

This is my hive table: course dept subject status btech cse java pass btech cse hadoop fail btech cse cg …

hadoop hive hiveql
How to list all hive databases being in use or created so far?

Similar to SHOW TABLES command, do we have any such command to list all databases created so far?

hadoop hive hiveql
Combine many tables in Hive using UNION ALL?

I'm trying to append one variable from several tables together (aka row-bind, concatenate) to make one longer table with a …

sql hive hiveql
Hive dynamic partitioning

I'm trying to create a partitioned table using dynamic partitioning, but i'm facing an issue. I'm running Hive 0.12 on Hortonworks …

hadoop hive hiveql
How to copy all hive table from one Database to other Database

I have default db in hive table which contains 80 tables . I have created one more database and I want to …

hive hiveql impala
Map type variable in hive

I am having trouble trying to define map type in hive. According to Hive Manual there definitely is a map …

hive hiveql
Date comparison in Hive

I'm working with Hive and I have a table structured as follows: CREATE TABLE t1 ( id INT, created TIMESTAMP, some_…

hive timestamp hiveql ddl