Stack Overflow
Stack Overflow

Questions tagged [partition]

Use this tag for questions about code that partitions data, memory, virtual machines, databases or disks.

In computing, partition may refer to

  • Disk partitioning, the division of a hard disk drive
  • Partition (database), the division of a database
  • Logical partition (virtual computing platform) (LPAR), a subset of a computer's resources, virtualized as a separate computer
  • Memory partition, a subdivision of a computer's memory, usually for use by a single job
  • Binary space partitioning

source: https://en.wikipedia.org/wiki/Partition

Note that non-programming questions about database partitioning are likely to be better received on Database Administrators and disk partitioning on Server Fault.

1547 questions
-1
votes
1 answer

SQL alternative for fetching latest record of each item in a table using partition

Im have been query the database to collectively fetch latest record or each item using PARTITION and ROW_COUNT() which works on MariaDB version 10.4* but i want to query the same on a MySQL version 5.7* database but it doesn't work there. I would…
Mariwa
  • 45
  • 5
-1
votes
1 answer

Spark Dataframe : Missing files when writing a dataframe into CSV after partitionning over a window

I have a Spark dataframe, consisting of let's say 10K ID. Each row of the Dataframe consists on pair of ID and their euclidean distance (each ID represent a Document. The dataframe looks like this: ID_source | ID_destination | Euclidean Distance 1 …
Queezzy
  • 1
  • 2
-1
votes
1 answer

SQL Window function, count the number of events in a 180 day window using each event date as an index

I need to be able to find the minimum date out of a set of dates that fit the following criteria. 3 dates which are within 180 days of each other. The logic which i'm guessing would apply is that each date would be an index from which subsequent…
SQL_Novice
  • 61
  • 1
  • 2
  • 11
-1
votes
1 answer

is it possible to decrease swap partition space in centos7

Some of my friends told me that larger swap partition is very bad like thousands of web hits/min should be possible on my server, The swap space is 16 GB, and i installed centos7 with "CWP" -> Control web panel with enable csf, should i consider…
ahmed zeaad
  • 174
  • 1
  • 4
-1
votes
1 answer

gparted and partition ubuntu server

I want to add the unallocated space to my partition /dev/sda1 but Gparted seems to prevent this how to fix this problem?
rota90
  • 249
  • 1
  • 4
  • 17
-1
votes
1 answer

SQL Rank over partition to C# Linq

I am just starting to code in C# and need some direction with achieving the SQL Rank over partition within C# ( LINQ) I have retrieved the following data from the database and have stored the SQL result in a data table within c#. the column 'Score'…
Priyak Bandyo
  • 9
  • 2
-1
votes
1 answer

Remove LVM partition that overlap with my windows partition

So this happends when I want to setup dual-boot ParrotOS and Windows. When I want to install Parrot, I accidentally select 'use all disk and setup LVM' (not encripted) and I noticed that and click cancel but the LVM already been setup. Can I revert…
Edqe
  • 1
  • 1
  • 3
-1
votes
4 answers

ROW_Number with Custom Group

I am trying to have row_number based on custom grouping but I am not able to produce it. Below is my Query CREATE TABLE mytbl (wid INT, id INT) INSERT INTO mytbl Values(1,1),(2,1),(3,0),(4,2),(5,3) Current Output wid id 1 1 2 1 3 …
Vignesh Kumar A
  • 27,863
  • 13
  • 63
  • 115
-1
votes
1 answer

Divide a String and keep the "limiter / identifier"

On a quick note my friends, how would I reach this result in javascript: We have: www.someurl.com/dynamicallychanging?page=2 so i am able to obtain the www.someurl.com/dynamicallychanging?page and the 2 with this : var number =…
Desory
  • 83
  • 2
  • 11
-1
votes
1 answer

Why is my code running the same list through even though its not even being used?

When I run my code I get a contains GRV-DAL-7777-05/28/2019_23:03:55-PT01 GRV-DAL-7777-05/28/2019_23:03:55-PT01 but expect a contains GRV-DAL-7777-05/28/2019_23:03:55-PT01 DAL-7777-05/28/2019_23:03:55-PT01 What am i…
Christopher Batey
  • 45
  • 8
-1
votes
1 answer

How to implement the Hoare partition scheme in Quickselect?

I try to implement the Hoare partition scheme as a part of a Quickselect algorithm but it seems to give me various answers each time. This is the findKthBest function that finds the Kth largest number in an array given an array (data) and the number…
RedSquare99
  • 23
  • 3
-1
votes
1 answer

Windows MBR Overritten by linux command dd if=/dev/zero of=/dev/sdb bs=512 count1

I know it's a stupid thing what I have done : In a Linux Virtual machine I did dd if=/dev/zero of=/dev/sdb bs=512 count1 to my external hard disk containing windows Now I Cannot detect the external Hard drive in my windows machine. I thing the MBR…
Fahmi Sahnoun
  • 1
-1
votes
1 answer

Immutable partition on Gparted Live

I'm running Gparted Live on a external hard disk so that I can edit the size of a partition on my computer hard disk. When I access Gparted, I find the following scenario: In order to asign the free memory to my extended partition I resize it this…
Luiscri
  • 913
  • 1
  • 13
  • 40
-1
votes
1 answer

File bigger than the size of the partition it's in

I have a server in which there's a file with 30GB inside the partition /, although df -h lists this partition as using 11GB. Why does that happen? [root@APPSERVER21-S1 ~]# ls -l /etc/vinter/logs/ total 2046032 -rw-r--r-- 1 root root 3920496 Sep…
JM Calil
  • 9
  • 5
-1
votes
1 answer

hadoop mapreduce.partition.keypartitioner.options not working

I only want to partition the data where the first field of key is same as the reducer. For example, [ 11 * * * ] data . But it seems keypartitioner does not work, I really don't know why. Environment Hadoop Version The code run.sh is here…
likohank
  • 1
  • 1
1 2 3
…
99
100