In Hive, Managed tables / Internal table are Hive owned tables and the tables data…
Category: article
How to do Force serialization in AWS Redshift table by locking all tables?
You can force serialization by locking all tables in each session. The LOCK command blocks operations that would result in…
Serializable isolation violation on table in Redshift : ERROR: 1023 : Resolved solution
When you run concurrent Amazon Redshift operations in different sessions, there is a probability of getting “ERROR: 1023 DETAIL: Serializable…
How to concatenate multiple columns in a Spark dataframe
concat_ws : With concat_ws () function you can concatenates multiple input string columns together into a single string column, using…
PySpark-How to create and RDD from a List and from AWS S3
In this article you will learn , what an RDD is ? How can we create an RDD from a…
How to run dataframe as Spark SQL – PySpark
If you have a situation that you can easily get the result using SQL/ SQL already existing , then you…
How to get all combination of columns using PySpark? What is Cube in Spark ?
A cube is a multi-dimensional generalization of a two- or three-dimensional spreadsheet. Cube is a shorthand for multidimensional dataset, given…
How to convert xls to csv ? I can see first header column got shifted to next column- Solved
The requirement is to convert and xls to csv using python. Initially we used pandas , pandas.read_excel to read an…
How can I get all the hive tables and its external location,partitions etc ?
There may be some situations where you may need to give all the hive tables created and its location and…
Hive – Where can I get the hive metastore details (Credentials,Host,Server etc)
In General we don’t deal directly with Hive metastore . But there are some situation that we may need to…
Hive – What are the metastore tables in Hive ?
Metastore is the central repository of Apache Hive metadata. It stores metadata for Hive tables AUX_TABLE BUCKETING_COLS CDS COLUMNS_V2 COMPACTION_QUEUE…