Stack Overflow
Stack Overflow

Questions tagged [analytical]

82 questions
6
votes
1 answer

How to find the smallest N dimensional simplex from a set of points that contains a given point?

I've looked all over google and stack but haven't found an answer to this problem yet. I keep finding results relating to the simplex method or results for finding the smallest arbitrary simplex (i.e. the vertices are not constrained). Neither can I…
gibbled
  • 69
  • 3
6
votes
1 answer

How to use Analytic/Window Functions in Spark Java?

I'm trying to use analytical/window function last_value in Spark Java. Netezza Query: select sno, name, addr1, addr2, run_dt, last_value(addr1 ignore nulls) over (partition by sno, name, addr1, addr2, run_dt order by beg_ts , end_ts rows between…
ND User
  • 139
  • 1
  • 3
  • 8
4
votes
1 answer

How to spread boxes on into another box in non-iterative manner?

So I have boxes of different sizes (squares). I have a Big Box (not a square). I have no guarantee that all of my boxes will fit, yet I need to try to fit as much as possible in a non-iterative manner without overlap. What algorithm allows for such…
DuckQueen
  • 772
  • 10
  • 62
  • 134
3
votes
4 answers

Reconstruct historical table rows, based only on change-log data

I'm working on some complex sales analytics, which is very convoluted ... and boring ... So for this question I'll use a fun, sugary metaphor: vending machines. But my actual tables are structured the same way. (You can assume there's plenty of…
Giffyguy
  • 20,378
  • 34
  • 97
  • 168
3
votes
1 answer

C++: Extracting symbols/variables of an analytical mathematical expression

I have expressions that can be provided by the user, such as: a*sin(w*t) a+b/c x^2+y^2/2 And I would like to just get the list of variables there. I don't need to do any substitutions. So, for the first formula it's gonna be {a,w,t}. For the…
The Quantum Physicist
  • 24,987
  • 19
  • 103
  • 189
3
votes
1 answer

OrientDB and OLAP?

What is the status of OrientDB support for higher level structures such as cube cells, dimensions, OLAP/BI in general? Analytical functions/window functions? These are common in high-end databases (Oracle, MSSQL, Postgres). Thanks.
Hristo Stoyanov
  • 1,508
  • 3
  • 15
  • 24
2
votes
2 answers

Develop multilingual system

This is more of an analytical question. I need to know how best to make a multilingual system, a.k.a. a system where the user can change the language. The language will be stored in a cookie or a database. I've worked in the past with different…
RobinJ
  • 5,022
  • 7
  • 32
  • 61
2
votes
3 answers

Snowflake Analytical Query Design

I have a tricky query design requirement, i have tried different types/different combination of Analytical function to achieve my result from the below data set. My other plan is do write stored proc, however i want to reach out to the expert group…
gopinath kolanchi
  • 141
  • 2
  • 13
2
votes
2 answers

Fast way to find corresponding objects across stereo views

Thanks for taking your time to read this. We have fixed stereo pairs of cameras looking into a closed volume. We know the dimensions of the volume and have the intrinsic and extrinsic calibration values for the camera pairs. The objective being to…
Sak
  • 269
  • 1
  • 4
  • 13
2
votes
0 answers

How install and start Exasol community on DigitalOcean droplet?

one of my projects needs a fast analytical database, now I use memsql, I would like to test Exasol, but I still can’t figure out how to deploy it to DigitalOcean droplet, does anyone have any detailed instructions on how to do this?
Andrey
  • 21
  • 1
2
votes
1 answer

cubejs command not found | After Install I am unable to run command

I install cube.js using this command yarn global add cubejs-cli after executing its shown as done. when I enter the command cubejs terminal said cubejs command not found. I don't know how to move forward. Please help me
ramprakash jagadeesan
  • 218
  • 2
  • 15
2
votes
1 answer

Multiply with Previous Value in Oracle SQL

Its easy to multiply (or sum/divide/etc.) with previous row in Excel spreadsheet, however, I could not do it so far in Oracle SQL. A B C 199901 3.81 51905 199902 -6.09 48743.9855 199903 4.75 51059.32481 199904 6.39 …
SapZ
  • 23
  • 5
2
votes
2 answers

Oracle analytical function

I have similar problem. Can you anyone give me solution. Below is the table value 10 20 30 40 I want output like this 10 10-2 8 20 20-8 12 30 30-12 18 40 40-18 22 Sort by ascending and…
Bala
  • 21
  • 1
2
votes
1 answer

Oracle SQL - Most purchased item in past 6 months for each row

I have data in the following format: date fruit ====================== 1-jan-14 orange 3-jan-14 orange 1-may-14 orange 2-may-14 apple 3-may-14 apple 1-aug-14 pineapple 2-aug-14 apple I want to add a column which will…
AYR
  • 1,139
  • 3
  • 14
  • 24
2
votes
3 answers

SQL - Row Sequencing

I have a table play day with following columns date_played, winner, loser with following values, (Jun-03-14, USA, China) (Jun-05-14, USA, Russia) (Jun-06-14, France, Germany) . . . . (Jun-09-14, USA, Russia) I need to obtain all instances where USA…
paddu
  • 693
  • 1
  • 7
  • 19
1
2 3 4 5 6