Stack Overflow
Stack Overflow

Questions tagged [windowing]

In signal processing windowing allows to work on overlapping segments of the signal.

224 questions
0
votes
2 answers

SQL Server Windowing - 24 Hour Window

I have the following data CREATE TABLE [dbo].[Test]( [CustId] [int] NULL, [Spend] [money] NULL, [TimeOdSpent] [datetime] NULL, [ID] [int] IDENTITY(1,1) NOT NULL ) ON [PRIMARY] GO SET IDENTITY_INSERT [dbo].[Test] ON GO INSERT…
Senevic
  • 1
  • 3
0
votes
1 answer

Apache Flink. Windowing with Water Marks

I'm trying to aggregate 60 seconds data keyed by its minute timestamp with maximum 30 seconds delay. DataStream ohlcAggStream = stockStream.assignTimestampsAndWatermarks(new TimestampExtractor(Time.seconds(30))).map(new…
la_femme_it
  • 632
  • 10
  • 24
0
votes
1 answer

Window function in Spark Dstream results in long pending tasks

We are trying to implement the Window function in spark. Spark is receiving data through Kafka (having 5 partitions) and we are using Spark Java DStream for processing. Once a comma separated data from kafka is mapped to a object in Spark, we then…
kadsank
  • 311
  • 7
  • 20
0
votes
1 answer

Flink (1.2) window is producing more than 1 ouput per window

The question: the problem is that this program is writing to Kafka more than once every window (is creating 2-3 or more lines per window, meanwhile it is supposed to create 1 line per window as with the reduce function it lets only one element). I…
froblesmartin
  • 1,527
  • 18
  • 25
0
votes
1 answer

Last tuple of time window

I have the following situation stream .keyBy(0) .timeWindow(Time.of(10, TimeUnit.SECONDS)) .sum(1) .flatMap(..) .sink() What I am trying to do is calculate a top N for my time window. The top N for each window…
vriesdemichael
  • 914
  • 1
  • 7
  • 19
0
votes
1 answer

SQL Windowing accumulative sum with grouping

I've got a table like this |week_no|value|attribute| ------------------------- | 1 | 3 | a | | 2 | 3 | a | | 3 | 3 | a | | 1 | 4 | b | | 2 | 4 | b | | 3 | 4 | b | I'd like to…
edumike
  • 3,149
  • 7
  • 27
  • 33
0
votes
1 answer

X11 - Setting Cursor Position Not Working

I'm trying to set my X11 cursor position. I tried calling XWarpPointer with the window set to None, root (DefaultRootWindow(display)), to the previously created window (XCreateWindow). The function IS being called, the mouse slows down a bit, but it…
Karim Abdel Hamid
  • 365
  • 3
  • 12
0
votes
1 answer

how do I use windowing functions in sql to persist a record

I have a data set where i'm trying to create a "session id" based on a timestamp where certain event happens (i.e. load) in my case My data: userid event timestamp xyz load '2016-12-01 08:21:13:000' xyz view '2016-12-01…
shecode
  • 1,716
  • 6
  • 32
  • 50
0
votes
2 answers

Function to compute Scallop Loss

I want to make a function that computes the value of the Scallop loss for a Rectangular, Hamming and Blackman window using the Scallop loss formula. I have created a function but it only returns that answer 0, have I made an error? function s_l =…
A. Reid
  • 41
  • 6
0
votes
1 answer

Flink Streaming Windowing - Last event of each window belongs to the next window

I am using Flink 1.2-Snapshot. My data looks like the following: id=25398102, sourceId=1, ts=2016-10-15 00:00:56, user=14, value=919 id=25398185, sourceId=1, ts=2016-10-15 00:01:06, user=14, value=920 id=25398210, sourceId=1, ts=2016-10-15…
user7121867
0
votes
1 answer

Selecting a row after multiple groupings in postgres

i have a table in a postgres DB which has the following structure: id | date | groupme1 | groupme2 | value ---------------------------------------- 1 | 2 | 3 | Now i want to achieve the following: Grouping the table after groupme1 and…
Xlaech
  • 456
  • 3
  • 19
0
votes
1 answer

SQL windowing scope

I am learning how to use windowing functions and came across this SQL statement. select ... sum(ss_ext_sales_price) * 100 / sum(sum(ss_ext_sales_price)) over (partition by i_class) as revenueratio from ... where ... group by …
savx2
  • 1,011
  • 2
  • 10
  • 28
0
votes
1 answer

RapidMiner TimeSeries prediction

I am working with the RapidMiner Windowing operator, in order to forecast the value of a company's revenue in the future. The dataset contains a value per month, so that I used a window size of 12. However, I am not able to know which the values are…
User 23
  • 163
  • 1
  • 14
0
votes
0 answers

Poor performance of multiple aggregations with windowing in Pandas

I need to calculate in Pandas a lot of aggregations by Dataframe index and with taking in mind windowing by time (column MONTH). Something like: # t is my DataFrame grouped=t.groupby(t.index) def f(g): g1=g[g.MONTH<=1] …
sergun
  • 31
  • 1
  • 4
0
votes
0 answers

Fastest method to find the longest palindrome in Ruby

Recently, I have been working on an algorithm to find the longest palindrome in a string (ignoring spaces & case-insensitive). I have been using Ruby, and I have developed this windowing search algorithm . My question is: Is there a faster way to…
Asleepace
  • 3,466
  • 2
  • 23
  • 36
1 2 3
…
14 15