Top "Hiveql" questions

Skip first line of csv while loading in hive table

Hello Friends, I created table in hive with help of following command - CREATE TABLE db.test ( fname STRING, lname …

hadoop hive hiveql

How can I convert array to string in hive sql?

I want to convert an array to string in hive. I want to collect_set array values to convert to …

arrays string hive concatenation hiveql

Can we load Parquet file into Hive directly?

I know we can load parquet file using Spark SQL and using Impala but wondering if we can do the …

hadoop hive apache-spark-sql hiveql parquet

Hive: Sum over a specified group (HiveQL)

I have a table: key product_code cost 1 UK 20 1 US 10 1 EU 5 2 UK 3 2 EU 6 I would like to find the sum …

hadoop hive hiveql hortonworks-data-platform

Hiveql - RIGHT() LEFT() Function

Is there a function in Hiveql that is equivalent to Right() or Left() fuction form TSQL? For example, RIGHT(col1,10) …

string hive hiveql

Is LIMIT clause in HIVE really random?

The documentation of HIVE notes that LIMIT clause returns rows chosen at random. I have been running a SELECT table …

sql hive hiveql shark-sql

Apache Hive How to round off to 2 decimal places?

Actually I'm looking for more details about the sum function in Apache Hive. Until now, I understood that I can …

hadoop hiveql

Hive Explode / Lateral View multiple arrays

I have a hive table with the following schema: COOKIE | PRODUCT_ID | CAT_ID | QTY 1234123 [1,2,3] [r,t,null] [2,1,null] How …

hive explode hiveql

How to calculate median in Hive

I have a hive table, name age sal A 45 1222 B 50 4555 c 44 8888 D 78 1222 E 12 7888 F 23 4555 I want to calculate median of …

hive hiveql

Both left and right aliases encountered in Hive JOIN; without any inequality clause

I am using following query: Select S.MDSE_ITEM_I, S.CO_LOC_I, MAX(S.SLS_D) as MAX_…

sql hive hiveql