Grouping using row number function...

Creating external hive table from parquet file which contains json string...

How to pass multiple statements into Spark SQL HiveContext...

Oracle database query tuning...

hive join tables and create 2 different tables...

Apache Hive: FAILED: ParseException line 4:1 character '' not supported here...

Sorting within collect_list() in hive...

How to convert binary value to decimal in hive/impala...

Hive table deduplication across multiple partitions...

Hive select rows where string in column A contains string from column B...

How to pass env variable in hive script?...

Identify the second max value in hive based on condition...

How to get a first and last value for each partition in a column using SQL...

hive convert array<map<string, string>> to string...

how to include 0 results in count with group by in HIVEQL...

How Create a hive external table with parquet format...

How to transform data in Amazon Athena...

Hive: Unsupported SubQuery Expression 'extract_date': Only SubQuery expressions that are top...

hiveQL query select classID, studName from table1 where grade = Max(grade) group by classID, studNam...

How to implement Oracle's "func(...) keep (dense_rank ...)" In Hive...

Difference between Hive internal tables and external tables?...

Do a startsWith in Hive HQL (with substring?)...

Hive Migrate Date Format from Greenplum SQL...

SQL query conversion to Hive supported migration SQL...

How to convert a hive query with regex to oracle...

Obtain corresponding value to max value of another column...

Replace Digits Using SubString and lpad/rpad...

Is there a way to use like operator with an array in HiveQL?...

How to convert this hive query to oracle...

How to select rows with one of two column values can't be null?...