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

Error partitioning and formatting USB flash drive in C++

I'm stuck attempting to re-partition and format a USB flash drive using C++, any help would be great! The goal is to re-partition any arbitrary flash drive with a single partition taking the entire space and formatted FAT32 (later options NTFS and…
Matt
  • 391
  • 5
  • 15
0
votes
2 answers

Partitioning the data with respect to values in a column in R

I have a csv file in the following form: rec | year | ing ----|------|----- 1 | 2002 | a 1 | 2002 | b 1 | 2002 | c 2 | 2002 | e . | . | . . | . | . 4 | 2017 | a Now, I want to partition this data by 2-year increments in R. I…
anu
  • 295
  • 2
  • 7
  • 15
0
votes
2 answers

java hashMap Adjacency Lists graph partition

I have a HashMap with: Key,Value A,C B,C C,D E,F This is an Adjacency List. with a graph with two partition, where the first partition contains the nodes {A,B,C,D} and the second partition is {E,F}. Problem: Given a HashMap that represents an…
0
votes
1 answer

TBLPROPERTIES doesn't propagate to table partitions

I create a table in hive and set TBLPROPERTIES. The problem is that when I add partitions - these TBLPROPERTIES doesn't propagate to them. That is the set TBLPROPERTIES doesn't exist in the partitions. Any idea what might help?
Vitali Melamud
  • 1,267
  • 17
  • 40
0
votes
0 answers

WriteFile() function exits successfully but not writing bytes on hard disk

I want to directly read and write on hard disk partitions. I'm using C by accessing the test partition G: (2GB) for this purpose. I have successfully read the bytes sector wise. I want to read the bytes from sector 1 and writem them to sector…
U. Ahmad
  • 76
  • 1
  • 11
0
votes
0 answers

Hive Runtime error while inserting geospatial data into a partitioned table

I am having a problem while loading data into a partitioned table 1) I want to load data from an existing table enodeb into a partitioned table enodebpartition. The schema for enode b is -state string -circle …
0
votes
1 answer

PostgreSQL constraint exclusion not working with subquery SELECT IN

When using partitioning in PostgreSQL, where master is the master partition table CREATE TABLE master ( _id numeric, name character varying ); and having two sub tables partition_1 CREATE TABLE partition_1 ( -- _id numeric, -- name…
baumjamin
  • 3
  • 3
0
votes
0 answers

Spring PartitionHandler reads same file again & again

Using PartitionHandler to read multiple files and run synchronously. I did set 3 filenames in partitionmap after that when the step of item reader starts, It reads the same file again & again. Accessing the same file in Step execution context. do i…
Alekya
  • 31
  • 2
0
votes
0 answers

How does the Boot Indicator field fit inside the MBR partition table?

Apparently the MBR is a 512 Byte data structure. 446 bytes for the BootCode. 64 bytes for The Partition Table 2 bytes for the signature a the very end. The Partition Table structure has four entries of 16 bytes each used to identify the type and…
0
votes
1 answer

Modify partition column value

Can I modify the value of a partitioned table, just by changing the name of the partition directory? The table I now have has year and month as partitions. The values were stored as decimal so the partitions are "2016.0" instead of just "2016" and…
markwusinich
  • 108
  • 7
0
votes
2 answers

row_number() over partition by

I have existing PL/SQL code with formatting for the client process that is doing a cursor with case for a join on multiple tables using row_number () over partition by. It was all fine, till we noticed that if a certain record had multiple contact…
QuickDrawMcgraw
  • 83
  • 1
  • 3
  • 12
0
votes
1 answer

error when creating a partitioned table

I am new to Hive and got an error when I tried to create a partitioned table. here is my script: CREATE TABLE partitionedemp(emp_no int, birth_date string, first_name string, last_name string) Partitioned By(gender string, hire_date string) stored…
mdivk
  • 3,545
  • 8
  • 53
  • 91
0
votes
1 answer

Hive/Imapala - Execute a Delete Clause: `DELETE from [TABLE] WHERE [CONDITION]`

From browsing the web - I understand that DELETE & UPDATE Clauses are not supported on Impala/Hive. I'm trying to find a workaround for this case. I tried to perform it with a INSERT OVERWRITE clause with no success :\ I have a partitioned table…
shayms8
  • 671
  • 6
  • 13
  • 28
0
votes
2 answers

Partition not able to understand

My input data is as follows: 1,srinivas,courtthomas,memphis 2,vindhya,courtthomas,memphis 3,srinivas,courtthomas,kolkata 4,vindhya,courtthomas,memphis And I have created the following queries: create EXTERNAL table seesaw (id int,name…
sri
  • 21
  • 1
0
votes
2 answers

MariaDB partitionning last 3 month

First, I explain my problem: This is a table that will contain approximately 5,000,000 record per year, these records will be kept at least 10 years (it is not yet defined). We talk about events of production machine. I generate a report + a…