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

Pyhive, Sqlalchemy Can Not Connect To Hadoop Sandbox

I have installed, pip install thrift pip install PyHive pip install thrift-sasl and since pip ins… Read more Pyhive, Sqlalchemy Can Not Connect To Hadoop Sandbox

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

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

How To Export All Hive Databases And Their Tables To A Csv Or Txt Fiile

I am trying to output all tables in a database to an csv or text file. I can output all the databas… Read more How To Export All Hive Databases And Their Tables To A Csv Or Txt Fiile

Python Variable Passed As Hive Query

I am trying to create a python script that will ask the user for input. This input will be stored … Read more Python Variable Passed As Hive Query

Remove Empty Line Printed From Hive Query Output Using Python

i am performing a hive query and storing the output in a tsv file in the local FS. I am running a f… Read more Remove Empty Line Printed From Hive Query Output Using Python

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