I have a requirement to select * from all columns from a hive struct. Hive create table script is here below Create Table script Select * from the table displays each struct as a column select ...

Hi does Hive support distinct on multiple columns. like select distinct(a, b, c, d) from table. If not is there a way to achieve this?

As a developer, I've created HBase table for our project by importing data from existing MySQL table using sqoop job. The problem is our data analyst team are familiar with MySQL syntax, implies th...

Hi i'm new to Hive and I want to insert the current timestamp into my table along with a row of data. Here is an example of my team table : team_id int fname string lname string time timestamp ...

I am new for Apache Hive. While working on external table partition, if I add new partition directly to HDFS, the new partition is not added after running MSCK REPAIR table. Below are the codes I t...

I am looking for something in hive like Select * from table 1 where dt > (Select max(dt) from table2) Obviously hive doesn't support sub queries in where clause and also, even if I use join...