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

R function to partition data set

can somebody help with debugging a function. It is meant to do dat3 <- c(4,7,5,7,8,4,4,4,4,4,4,7,4,4,8,8,5,5,5,5) myfunc(dat3, chunksize = 8) ## [1] 4 7 5 8 4 4 4 4 4 7 5 8 4 4 5 5 4 partition the data in chunks of a sizer and make sure that…
wery
  • 1
  • 3
0
votes
1 answer

Partition in a sql query, selecting only previous rows without the current one

Let's assume that I have the next table (sales) with the information of sales for a city in a particular month: month 7 8 9 10 city a 10 20 30 40 If I decide to execute the next query: select city, month, avg(sales) over (partition by city order by…
d2907
  • 798
  • 3
  • 15
  • 45
0
votes
2 answers

Unable to format SD-card

I've got a 16G SD-card. The SD-card was working great with my Raspberry PI and contained Rasbian OS. However, when I attempted to format the SD-card in order to swap the OS for another one I got stuck. Now I cannot change anything anymore,…
Alexander Hades
  • 113
  • 9
0
votes
1 answer

not using var partition in a linux web server installation

I know that var partition is used to store variable data, administrative and log data. I believe that if i don't create a var partition, the data in the var directory will belong to root partition. So if i use a root (/) partition with a high size…
Ayoub Info
  • 13
  • 2
0
votes
1 answer

Will enabling row movements on list-partitioned table cause performance problems(oracle 11g r2)

Our incident management system has run for years, and the large quantity of closed incident tickets makes the table rather huge and slows down the search queries. Our database version is oracle 11g r2 enterprise edition(partition option added). The…
wander
  • 937
  • 1
  • 7
  • 15
0
votes
1 answer

SAS DI Error 22-232 in ROW_NUMBER () OVER (PARTITION BY construction

I have 2 SQL Join transforms (one using only SELECT, the other using SELECT and WHERE) and I have syntax error near OVER when submitting the following code: select row_number () over ( partition by t0.A order by t0.B DESC )…
G1N000
  • 3
  • 2
0
votes
1 answer

Hadoop-2.4.1 custom partitioner to balance reducers

As we know, that during the shuffle phase of hadoop, each of the reducer read data from all the mapper's output (intermedia data). Now, we also know that by default Hash-Partitioning is used for reducers. My question is: How do we implement an…
Cloud
  • 199
  • 2
  • 14
0
votes
2 answers

MySQL row_number in group Man-Of-The-Match medals

Our football team has each game 'Man of the match' voting results. Now I want the TOP 3 votings (or TOP 4..5 when equal votes) backgrounded in Gold, Silver, Bronze. I prefer using SQL query instead of php-code to define the medals. My website query…
Joris
  • 3
  • 4
0
votes
1 answer

Limiting access to Hive Partitions

I have a Hive table Person with 50 partitions (one for each state). Is there any way I can limit access to the partitions in Hive? For e.g: I want a user to have access to partition CA and IL only, any way to implement this in Hive. I'm on Hive 0.12…
user3646519
  • 353
  • 5
  • 15
0
votes
1 answer

How to partition a table copied from another schema?

I want to copy a table from one schema into another. Then I want to partition the table. How do I partition a table that I've copied from another schema? From what I understand about partitioning, this should work, but I keep getting the missing…
ShoSom
  • 29
  • 7
0
votes
2 answers

How can i get Partition Serial/ID/Signature?

I want to know the identifier for a partition when checking the disk. It's needed for logging, for instance: If on my computer drive C: is 041d when i plug it to a different computer it will get a different driveletter(D:) but the partition is the…
Shaul
  • 211
  • 1
  • 4
  • 18
0
votes
3 answers

Recursively obtaining kth smallest element in an array

I'm trying to "translate" this algorithm from the pseudocode provided in my textbook. My program keeps crashing though, and I'm not really sure where I went wrong with my implementation. Here's the pseudocode in image with my code right below it:…
user16666322
  • 135
  • 4
  • 9
0
votes
2 answers

Load Hive partition from Hive view

I have a External Hive table with 4 partitions. I also have 4 hive views based on a different Hive table. Every week I want the hive view to overwrite the partitions in the External Hive table. I know I can create an unpartitioned hive table from a…
user3646519
  • 353
  • 5
  • 15
0
votes
2 answers

Copy linux partition on a usb stick

I would like to know how to copy a Linux partition (example: /dev/sda1) on a USB stick, and then boot on the USB stick. I tried to just copy it with the command cp but when I tried to boot on it, it booted on the partition I copied (/dev/sda1) and…
jybateman
  • 303
  • 1
  • 3
  • 11
0
votes
1 answer

Sqoop - Create empty hive partitioned table based on schema of oracle partitioned table

I have an oracle table which has 80 columns and id partitioned on state column. My requirement is to create a hive table with similar schema of oracle table and partitioned on state. I tried using sqoop -create-hive-table option. But keep getting an…
user3646519
  • 353
  • 5
  • 15
1 2 3
…
99 100