Top "Partitioning" questions

Partitioning is a performance strategy whereby you divide possibly very large groups of data into some number of smaller groups of data.

mysql database automatic partitioning

I have a mysql database table that I want to partition by date, particularly by month & year. However, when …

mysql database performance partitioning
Find Partition Schema Definitions in SQL Server Database

I have access to a database and I need to know the Partition Scheme definitions in the database. i.e. …

sql sql-server partitioning database-partitioning partition
pyspark partitioning data using partitionby

I understand that partitionBy function partitions my data. If I use rdd.partitionBy(100) it will partition my data by key …

python apache-spark pyspark partitioning rdd
What is MYSQL Partitioning?

I have read the documentation (http://dev.mysql.com/doc/refman/5.1/en/partitioning.html), but I would like, in your …

mysql database partitioning
How to get the number of elements in partition?

Is there any way to get the number of elements in a spark RDD partition, given the partition ID? Without …

apache-spark partitioning
Partition data for efficient joining for Spark dataframe/dataset

I need to join many DataFrames together based on some shared key columns. For a key-value RDD, one can specify …

apache-spark apache-spark-sql spark-dataframe partitioning apache-spark-dataset
How to see table partition size in MySQL ( is it even possible? )

I've partitioned my table horizontally and I'd like to see how the rows are currently distributed. Searching the web didn't …

mysql database database-design database-schema partitioning
Dropping multiple partitions in Impala/Hive

1- I'm trying to delete multiple partitions at once, but struggling to do it with either Impala or Hive. I …

sql hive hdfs partitioning impala
how to add columns to existing hive partitioned table?

alter table abc add columns (stats1 map<string,string>, stats2 map<string,string>) i have altered …

hive partitioning hive-partitions hiveddl
Spark SQL saveAsTable is not compatible with Hive when partition is specified

Kind of edge case, when saving parquet table in Spark SQL with partition, #schema definitioin final StructType schema = DataTypes.createStructType(…

hive apache-spark-sql partitioning parquet