Top "Database-partitioning" questions

Database partitioning is the act of splitting a database into separate parts, usually for manageability, performance or availability reasons.

MAX() and MAX() OVER PARTITION BY produces error 3504 in Teradata Query

I am trying to produce a results table with the last completed course date for each course code, as well …

sql aggregate-functions teradata database-partitioning
Oracle Partition - Error ORA14400 - inserted partition key does not map to any partition

I'm trying to insert information in a partition table, but I don't know what I'm doing wrong! Show me this …

oracle database-partitioning
how to convert unix epoch time to date string in hive

I have a log file which contains timestamp column. The timestamp is in unix epoch time format. I want to …

function hive database-partitioning
Database sharding vs partitioning

I have been reading about scalable architectures recently. In that context, two words that keep on showing up with regards …

mysql sharding database-partitioning
How does one do a SQL select over multiple partitions?

Is there a more efficient way than: select * from transactions partition( partition1 ) union all select * from transactions partition( partition2 ) union …

sql oracle database-partitioning
Database partitioning - Horizontal vs Vertical - Difference between Normalization and Row Splitting?

I am trying to grasp the different concepts of Database Partitioning and this is what I understood of it: Horizontal …

database database-design database-performance sharding database-partitioning
how to partition a table by datetime column?

I want to partition a mysql table by datetime column. One day a partition.The create table scripts is like …

mysql datetime hash database-partitioning
How to select rows from partition in MySQL

I made partition my 300MB table and trying to make select query from p0 partition with this command SELECT * FROM …

mysql sql partitioning database-partitioning mysql-5.1
How to set the number of partitions/nodes when importing data into Spark

Problem: I want to import data into Spark EMR from S3 using: data = sqlContext.read.json("s3n://.....") Is there …

sql apache-spark database-partitioning pyspark-sql
how to find partition of record oracle

I have a table and there is a partition on it. There are 16 hash partition which is starting from SUBSCRIBER_01 .. …

database oracle plsql oracle11g database-partitioning