Top "Hiveql" questions

This is my table: pid high medium low 1 10 8 6 2 20 16 12 3 10 6 4 I want store this data in another table in Hive with the …

Suppose my table looks something like: Col1 Col2 Col3.....Col20 Col21 Now I want to select all but Col21. I …

I have to change the partition column name (not partition spec), I looked for the commands in hive wiki and …

I want to select all columns in a table except StudentAddress and hence I wrote following query: select `(StudentAddress)?+.+` from …

could anyone let me know how to fix missing replicas? ============================================================================ Total size: 3447348383 B Total dirs: 120 Total files: 98 Total blocks (validated): 133 (…

I'm new to hive and could use some tips. I'm trying to export query results from hive as a csv. …

select * from Table_name limit 5; select col1_name,col2_name from table_name limit 5; When i run the first query …

How can I achieve the same functionality as SQL's "offset" in Hive? SELECT * from table LIMIT 20 OFFSET 30 Thanks!

I want to get summary data of the first quartile for a table in Hive. Below is a query to …

My question is rather simple, but somehow I cannot find a clear answer by reading the documentation. I have Spark2 …