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
0 answers

Creating partition for directories in Lubuntu

I have to mount five of my main directories viz. (/home, /usr, /tmp, /root and /var) for a specific project. I did some googling and found out a set of commands which can be executed to mount a particular directory. The commands were as follows: …
SkRuddy
  • 11
  • 6
0
votes
2 answers

MDX SSAS Rank rownumber function

I have an existing SSRS report out of T-SQL query and I am trying to recreate it using MDX queries on SSAS cube. I am stuck with rewriting Row num and rank logic to MDX. It is written as: SELECT ceil((ROW_NUMBER() OVER (PARTITION BY PRODUCT ORDER BY…
lakshru
  • 41
  • 1
  • 1
  • 5
0
votes
2 answers

SQL Server: how to do 3 months' partition?

I want to count the number of rows in the partition 0-3months. Months are specified by MYMONTH in the format such that 201601 for 2016 January. I am using SQL Server 2014. How can I do the partition over 3 months? SELECT COUNT(*), …
hhh
  • 50,788
  • 62
  • 179
  • 282
0
votes
1 answer

Remove NFS mounted partitions from Icinga2 output?

We have about 10 servers which an NFS partition is mounted on all of them. All hosts on Icinga displays that NFS partition, so when NFS partition threshold is reached 10 mail notifications are sent for that specific error. The question is how can I…
Alireza
  • 6,497
  • 13
  • 59
  • 132
0
votes
2 answers

Trouble trying to join two tables in SQL

This is my first post on this forum so apologies if I am unclear or my question is not formatted correctly. I have the following table, TABLE_MONTHS: | Date | Year_Part | Month_part | 31-01-2016 2016 1 29-02-2016 2016 …
EskiJoe
  • 3
  • 1
0
votes
3 answers

Python- How to form a random partition of 2 lists

Does anyone know how to form a random partition of 2 lists (List1 and List2) in python? The lists do not have to have the same size. For example: S = [1,2,3,4,5,6,7] List1=[3,6,1,2] List2=[5,4,7] or List1 =[3,5] List2=[1,2,4,7,6]
user02
  • 281
  • 3
  • 10
0
votes
1 answer

Partition column equal to current date in Hive

I am trying to load data into a Hive table using partition. The code is as follow: CREATE EXTERNAL TABLE URL(url STRING, clicks INT) COMMENT 'Unique Clicks per URL' PARTITIONED BY(dt STRING) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' LINES…
lorenzotenti
  • 176
  • 2
  • 8
0
votes
1 answer

Partition a table and get first and last records in google big query

From the below table, I am trying to find the starttime and stoptime for each Id1. For example, for Id1 = 103, it started on 2016-11-01 10:50:28 UTC and the stoptime of the vehicle on the same day is on 2016-11-01 11:23:55 UTC. Similary for id1 =…
user3447653
  • 3,968
  • 12
  • 58
  • 100
0
votes
1 answer

Optimal design of Spark job, and ensuring narrow dependencies on pre-partitioned data

Suppose I have activity data for all countries in the world (relationally speaking each record will have a country column), and I want to enrich that with some reference data also available per country and thereafter use this as input to some ML…
Michael-7
  • 1,739
  • 14
  • 17
0
votes
1 answer

Hive - Insert specified values from select statement into table and partition values

I am struggling with inserting only specified values from another table into a partitioned table in Hive as I cannot figure out how to specify the partition columns and the specific columns in the same insert statement. I have read the partition…
James Caddick
  • 1
  • 2
0
votes
1 answer

How can a samza task consume more than one kafka partitioned streams

I have a typical samza task which consumes 2 topics: data and config, and stores messages from config as local state in rocksdb to check if messages from data are OK. This task works fine if each of these two topics has only one partition. Once I…
Aries
  • 211
  • 2
  • 10
0
votes
1 answer

How to modify a partition to add more than one sub Partition to this existing partition?

I am trying to add sub Partitions to an existing partition but i am getting this error: Oracle Error: ORA-14158 Error Description: Too many subpartition descriptions Error Cause: CREATE TABLE or CREATE INDEX contained too many subpartition…
AYUSH SHARMA
  • 1
  • 1
  • 4
0
votes
0 answers

Database slow query in Drupal select count(*) into @discard from `information_schema`.`PARTITIONS`;

One of my page in Drupal is loading very slowly. When I checked with the slow queries list select count(*) into @discard from `information_schema`.`PARTITIONS`; This query is taking too much time to execute. What is the use of this query and how…
Maria Joseph
  • 51
  • 1
  • 9
0
votes
1 answer

MDT 2013 Update 1 Failure 5456

We currently have a working setup of MDT linked to WDS. When I PXE boot, everything works as expected, and the new computer deployment succeeds. However, I am trying to see if we can push the build remotely with PsExec or PDQ Deploy. I've got it…
Sam Lewis
  • 25
  • 2
  • 7
0
votes
2 answers

Do I need to use partition for cleaning old data on a Oracle 10g table?

I have a very simple table, on Oracle 10g, that keeps the log messages from a process. This table generates about 1 GB per day. I would like to keep just 1 week of data. What is the best approach to accomplish this? Create a procedure that…
Rodrick
  • 595
  • 10
  • 27
1 2 3
…
99 100