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
0
votes
1 answer

How to set up a mixed partitioned sd card (part adoptable, part removable) on android Marshmallow on an HTC One M8?

I followed this guide: http://blog.sam.liddicott.com/2016/02/android-6-semi-adopted-storage.html?showComment=1499351433951#c5567046039565096367 I did everything as explained as this was also exactly the solution I was looking for, however, there is…
babipsylon
  • 325
  • 2
  • 12
0
votes
1 answer

Oracle SQL 'OVER' partition error

I'm trying to use this code on Oracle and it errors out. The 'partition' statement is highlighted. How do I fix this ? select case when b.c_1 = 1 then b.workkey else null end workkey, b.total_value total_value, b.namekey namekey from (select…
user2017716
  • 23
  • 1
  • 9
0
votes
0 answers

how to divided a vector and get the partition num in R?

I'm programming in R.I need to divided a vector into x partitions(eg,x=4),and get the partition number of the vector, something like this... a <- data.frame(x=1:20) a$numofpartition<-ifelse(a$x<6,1,ifelse(a$x<11,2,ifelse(a$x<16,3,4))) As the code,I…
A.hu
  • 27
  • 4
0
votes
3 answers

Partitioning by % of the sample in PL SQL (Oracle)

I have the following data set: Ranking Segment Month 1 1 201501 2 1 201501 3 1 201501 4 1 201501 5 1 201501 6 1 201501 7 1 201501 … 1 201501 567 1 201501 1 2 201501 2 2 201501 3 2 201501 4 2 …
Sammy Merk
  • 21
  • 8
0
votes
1 answer

How to automatically allocate the rest of free space to partition?

I have a question related to the configuration of a partition-table in "Foreman". As you can see in the screenshot below, I allocate 200 GB of free space to the /-Directory. The problem: how can I allocate the rest of free space to this partition?…
FrankTheTank
  • 62
  • 1
  • 11
0
votes
2 answers

How to I partition eMMC ?

We have an development board that has been run Yocto system. and we want it to run android system, we already has compiled android image with Yocto kernel that has android's some patch. We don't know how to flash the android image (such as…
Jam_Hu
  • 15
  • 1
  • 2
  • 5
0
votes
1 answer

Oracle SQL: Case in Select overwrites values instead of adding them

I am new to Oracle and maybe use the wrong approach here. Current result: Expected result: The problem is that in my case the text "Items" appears instead of the first item for each ID instead of above it. My query (simplified): SELECT …
Mike
  • 155
  • 3
  • 14
0
votes
3 answers

Oracle SQL: Sum Over Partition returns error in Select

I have a larger Select statement which works fine until I include the following which returns the below error. Using just the Sum part works too but I only need this for the first row of each AID which is why I used the Row Number here. Can…
Mike
  • 155
  • 3
  • 14
0
votes
2 answers

Used mkfs.ext4 on wrong partiton while installing arch linux

As the title says, while installing arch linux, I accidently used the mkfs.ext4 command on the 'Microsoft Reserved' partition. Windows still runs, but I'm afraid of any future problems. Does this need any fixing, and if yes, how should I go about…
Chalant
  • 11
  • 2
0
votes
2 answers

impala: partition key/value or path whitespace

I want to be able to store a partition for "United Kingdom". I have a folder with "Country=United Kingdom". If I do ALTER TABLE countries ADD PARTITION (Country="United Kingdom") LOCATION "/path/Country=United%20Kingdom" The command does not throw…
mad
  • 3,493
  • 4
  • 23
  • 31
0
votes
0 answers

sqoop export to SQL server - with where clause

I have partition table. I only want to export partition for today. Is there a way you can pass query with variable in export command ?
0
votes
2 answers

Partition Function Count() over

I'm trying to write the following in order to get a running total of WO_Count, like so: I have to keep condition like WO_Count > 1. Could any one help me please? If I keep where WO_Count > 1, I'm getting below error: ORA-00904: "WO_COUNT":…
Shilpi
  • 25
  • 2
  • 12
0
votes
1 answer

Rank and partition query in SQL

I have a table in AS400 as below Type Values Status A 1 Y A 2 N A 3 Y A 4 Y A 5 N B 2 Y B 7 N C 3 Y C 5 N C 4 Y C 6 Y C 7 Y C 1 Y D 3 Y D 5 Y E 7 N E 4 N E 3 Y E 6 N E …
0
votes
2 answers

SQL Server 2104\2016 Instead of reading on ONE partitions, reading on two partitions

I have a problem with partitions Instead of reading on ONE partitions, reading on two partitions I want the reading to take place at necessary partitions sql server version 2014\2016 --create 2 PARTITION First for 0 value, second to 1 value …
GoAnatol
  • 21
  • 2
0
votes
0 answers

Creating partition on u-boot for flashing

As a beginner in kernel, working on embedded project, that requires me to flash the kernel image into emmc partition in u-boot.But when i tried to mount the SD card into one partition of the u-boot, there are no such partition as in complete boot of…