Top "Hive" questions

hive Expression Not In Group By Key

I create a table in HIVE. It has the following columns: id bigint, rank bigint, date string I want to …

group-by hive hiveql

SparkSQL - Read parquet file directly

I am migrating from Impala to SparkSQL, using the following code to read a table: my_data = sqlContext.read.parquet(…

scala apache-spark hive apache-spark-sql hdfs

Alter hive table add or drop column

I have orc table in hive I want to drop column from this table ALTER TABLE table_name drop col_…

hadoop hive

Hive - LIKE Operator

I can not figure out how I deal with that problem: This is my Data: Table1: Table2: BRAND PRODUCT SOLD …

hadoop hive hiveql sql-like

how to write case and group by in hive query

This is my hive table: course dept subject status btech cse java pass btech cse hadoop fail btech cse cg …

hadoop hive hiveql

Loading Data from a .txt file to Table Stored as ORC in Hive

I have a data file which is in .txt format. I am using the file to load data into Hive …

hadoop hive

Connect from Java to Hive using JDBC

I'm trying to connect from Java to Hive server 1. I found a question time ago in this forum but it …

java hadoop jdbc hive

When creating an external table in hive can I point the location to specific files in a directory?

I have defined a table as such: create external table PageViews (Userid string, Page_View string) partitioned by (ds string) …

hive external

Hive: writing column headers to local file?

Hive documentation lacking again: I'd like to write the results of a query to a local file as well as …

syntax hive

How To Remove non-alpha numeric, or non-numeric characters with Hive REGEXP_EXTRACT() Function

I've been trying to figure out how to remove multiple non-alphanumeric or non-numeric characters, or return only the numeric characters …

regex hadoop hive etl