Tag: hiveql

Order of the tables in a JOIN

In spark-sql I have a query that uses several tables (both large & small) in Joins. My question is – does the order of these tables matter with respect to query performance ? For e.g. select …

Two different table counts insert into Hive Table

hadoop hive hiveql sql

i need to insert data into hive table from two different table counts. example, let assume i have a table sample having fields counter1 and counter2 now i have another two tables test1 and test2. i …

Split column in hive

apache-spark-sql hadoop hive hiveql sql

I am new to Hive and Hadoop framework. I am trying to write a hive query to split the column delimited by a pipe ‘|’ character. Then I want to group up the 2 adjacent values and separate them into …

Hive: Cant perform union query with limit

hive hive-query hiveql sql union

I am trying to run a union all query in hive but i get I also tried but i got what am i doing wrong ? Answer Use select from subquery:

SQL Query to Select Min and Max Values For Each Day Over a Period

hive hiveql sql

I would like to select all the rows that contain either min or max datetime values for each equipment_id, for every day included in the period. The code below selects the min and max datetime values …

Divide each value of a column by the total count of records in a table

hive hive-query hiveql sql

A query that is capable of dividing each value of a column by the total number of records in the table I tried the following query I see an error and not able to execute the query. for example total records is 5 so (1/5)*100 = 20 Answer use analytic count(*) over():