Skip to content Skip to sidebar Skip to footer
Showing posts with the label Hive

Collect Set By Group?

I am working with Hive data pulled into a Python Jupyter notebook using a Hive wrapper written in P… Read more Collect Set By Group?

Spark 2.2 Thrift Server Error On Dataframe Numberformatexception When Query Hive Table

I have Hortonworks HDP 2.6.3 running Spark2 (v2.2). My test case is very simple: Create a Hive tab… Read more Spark 2.2 Thrift Server Error On Dataframe Numberformatexception When Query Hive Table

How To Select Columns Using Dynamic Select Query Using Window Function

I have sample input dataframe as below, but the value (clm starting with m) columns can be n number… Read more How To Select Columns Using Dynamic Select Query Using Window Function

Reading And Writing From Hive Tables With Spark After Aggregation

We have a hive warehouse, and wanted to use spark for various tasks (mainly classification). At tim… Read more Reading And Writing From Hive Tables With Spark After Aggregation

Hive Client For Python 3.x

is it possible to connect to hadoop and run hive queries using Python 3.x? I am using Python 3.4.1.… Read more Hive Client For Python 3.x

Compare Two Partitions Of Table In Hive

I need to compare data changes in two partitions of table in Hive. Specifically, I have two partiti… Read more Compare Two Partitions Of Table In Hive

How To Find The Pathing Flow And Rank Them Using Pig Or Hive?

Below is the example for my use case. Solution 1: You can reference this question where an OP was… Read more How To Find The Pathing Flow And Rank Them Using Pig Or Hive?

Compare Two Partitions Of Table In Hive

I need to compare data changes in two partitions of table in Hive. Specifically, I have two partiti… Read more Compare Two Partitions Of Table In Hive